Database Administrator

Job Details

• Install, configure, maintain and upgrade database management systems.
• Monitor database performance, availability and reliability.
• Perform database performance tuning, query optimization and index management.
• Configure and maintain database backup and disaster recovery procedures.
• Troubleshoot database issues and perform root cause analysis.
• Manage database users, roles, access permissions and security controls.
• Implement database security policies and support data privacy requirements.
• Design and optimize database schemas for performance and scalability.
• Configure and maintain database replication, clustering and high-availability solutions.
• Perform database upgrades, patches and compatibility assessments.
• Support failover mechanisms including clustering, mirroring and Availability Groups.
• Conduct disaster recovery exercises for mission-critical databases.
• Work with developers and project teams on database design and performance improvements.
• Support SSRS reporting and SSIS/ETL activities.
• Maintain database documentation, standards and operational procedures.
• Support MongoDB administration and optimization where required.

Requirements

• Bachelor's degree in Computer Science, Information Technology or a related field.
• Relevant experience in database administration.
• Strong knowledge of SQL Server and/or Oracle database administration.
• Strong understanding of database security and access management.
• Hands-on experience with database performance tuning and optimization.
• Experience with database schema design, partitioning and physical data organization.
• Experience implementing and maintaining database high-availability and failover solutions.
• Experience with disaster recovery planning and exercises for critical databases.
• Strong experience with SSRS and SSIS/ETL.
• Experience with MongoDB is an advantage.

EA Number: 11C4879