Database Administrator

Database Administrator with at least five (5) years of experience in managing and maintaining at least one (1) type of enterprise-level database systems. The candidate should possess in-depth knowledge and hands-on experience with the following database management systems:

1. Oracle:

2. Proficient in Oracle Database installation, configuration, and maintenance

   Experience with Oracle Real Application Clusters (RAC) and Data Guard

   Skilled in performance tuning, query optimization, and indexing strategies

   Familiarity with Oracle Enterprise Manager for database administration

1. Microsoft SQL Server:

2. Expertise in SQL Server installation, configuration, and maintenance

   Experience with SQL Server Always On Availability Groups

   Proficient in T-SQL programming and query optimization

   Skilled in using SQL Server Management Studio and related tools

1. PostgreSQL:

2. Proficient in PostgreSQL installation, configuration, and maintenance

   Experience with PostgreSQL replication and high availability solutions

   Skilled in PL/pgSQL programming and query optimization

   Familiarity with pgAdmin and other PostgreSQL management tools

1. MySQL:

2. Expertise in MySQL installation, configuration, and maintenance

   Experience with MySQL replication and clustering (e.g., MySQL Group Replication)

   Proficient in SQL programming and query optimization for MySQL

   Skilled in using MySQL Workbench and related administration tools

1. General skills and responsibilities across all supported databases:

2. Database Design and Modeling:

   Proficient in designing efficient database schemas and data models

   Experience in normalisation and denormalisation techniques

1. Backup and Recovery:

2. Implementing and managing backup strategies for all supported databases

   Experience in point-in-time recovery and disaster recovery planning

1. Security and Access Control:

2. Implementing and managing database security measures

   Proficient in user access management and auditing

1. Performance Monitoring and Tuning:

2. Using monitoring tools to track database performance

   Skilled in identifying and resolving performance bottlenecks

1. Capacity Planning:

2. Experience in database capacity planning and resource allocation

   Proficient in forecasting storage and performance requirements

1. High Availability and Disaster Recovery:

2. Implementing and managing high availability solutions for all supported databases

   Experience in setting up and testing disaster recovery procedures

1. Data Migration:

2. Skilled in planning and executing data migrations between different database systems

   Experience with ETL tools and processes

1. Automation and Scripting:

2. Proficient in scripting for database administration tasks (e.g., Python, PowerShell, Bash)

   Experience with database automation tools

1. Cloud Database Services:

2. Familiarity with cloud-based database services (e.g., Amazon RDS, Azure SQL Database, Google Cloud SQL)

   Experience in migrating on-premises databases to cloud platform

Regret to inform that only shortlisted candidates will be notified.

CEI: R1988671

EA License: 14C7275