Work Location: Discovery Center, Ortigas Center
Work Schedule: Shifting Schedule, On-call
As a member of the Database Services team, the SQL DBA (Database Administrator) will be responsible for supporting the operational elements of our customer’s database infrastructure as well as involved project delivery.
The DBA is a member of a national team responsible for the daily management and administration of a variety of database technologies mainly focused on SQL but not limited to it. The Senior DBA's prime role is supporting the operational availability of these systems on a daily basis. The position requires excellent written and interpersonal skills to build relationships with external and internal clients at various levels. While your role is very technical in nature you will be called upon to discuss these matters to business minded individuals inside the customer’s organization.
Responsibilities:
- Complete full cycle SQL instance/database management: software installation/patching; upgrade; configuration and deployment of instance/database; capacity planning; monitoring of capacity, availability, performance of the instance/database; performance analysis and tuning; backup, restore and recovery; setup replication and high availability; architect customized backup solutions; scripting jobs for automation; problem fix; escalation to DB vendor; Security management and auditing; documentation etc
- Interact with customers, application teams and peer support team (DBA, SA, Storage, project management etc.) for project implementation and ongoing support
- Take initiative to improve the performance, efficiency of the database assurance operation
- Being cohesive to standard best practice and collaborate/coordinate with the DBA peers on change management, problem management and work management etc
- Take 24x7 on-call rotation and troubleshooting problem tickets and response to customer requests and change controls
- Support other DBA/project activities; contribution to knowledge and experience sharing
Required Knowledge:
- Install/Setup and maintain SQL database software with updates/patches
- Install/Setup and maintain SQL database Cluster software with updates/patches
- Analyze and performance tune all aspects of databases systems including but not limited to database software, Operating System/VW elements, Storage sub-systems, etc
- Utilize system side performance monitoring tools as well database specific tools such as SQL Enterprise Manager, SQL Tools to tune instance and or session performance problems
- Capacity planning and storage concept on RAID, SAN, NAS, Storage snapshots features
- Develop and maintain accurate documentation of all areas encompassing the database infrastructure
- Database Security – access, authentication, auditing, vulnerability assessment
- Database Replication and High Availability
- Perform migration and upgrade tasks while minimizing downtime
- Perform database backups, restore, and recovery tasks using native backup and restore as well as utilizing storage or VM level snapshots technologies
- Understanding and planning and executing DR planning/testing
- SQL, SSIS package programming
- Application DBA (data modeling, SQL programming/optimization) support role is a definite asset
Required Skills and Abilities:
- Strong Windows environment skills
- Provide 24x7 on-call support
- Assist in help desk calls utilizing Remedy
- Good analytical and problem solving skills
- Strong desire to take in more knowledge
- Good proactive planning skills and multi-tasking skills
- Good communication skills
- Taking initiative and ownership, delivering quality and thorough services to customers
- Excellent team worker and good performer under minimum supervision
- Bi-lingual (English/French) is a definite asset
- Strong SQL database experience
Required Experience:
- 2 years’ experience as a Database Administrator working with SQL in enterprise capacity
- Proven experience working with SQL
Required Language(s)English
