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