Key Responsibilities:
- Install, configure, and maintain MySQL, PostgreSQL, Oracle, Microsoft SQL Server, and MongoDB databases across development, staging, and production environments.
- Implement High Availability (HA) and Disaster Recovery (DR) solutions using technologies such as MySQL InnoDB Cluster, Group Replication, Oracle Data Guard, PostgreSQL Patroni or EFM, and SQL Server Always On.
- Manage and support cloud-hosted databases on platforms such as AWS RDS, Azure SQL Database, Oracle Cloud Database, or Google Cloud SQL.
- Perform database backup and recovery, ensuring zero data loss and minimal downtime (RPO/RTO objectives).
- Optimize database performance through query tuning, indexing strategies, memory optimization, and workload balancing.
- Manage transactional and analytical workloads (OLTP and OLAP) efficiently across distributed and hybrid environments.
- Participate in database migrations and data unification projects (e.g., MSSQL → MySQL, MariaDB → MySQL).
- Collaborate with application and infrastructure teams to design robust database architectures that meet business performance goals.
- Implement monitoring and alerting systems for proactive database health management.
- Ensure security, auditing, and compliance across all database platforms.
- Create technical documentation, SOPs, and architecture diagrams for database deployments.
Required Experience & Qualifications:
- 5 years of experience in database administration.
- Strong expertise in MySQL, PostgreSQL, Oracle, and Microsoft SQL Server.
- Hands-on experience with HA/DR implementation, replication, and clustered environments.
- Experience managing cloud-based databases (AWS RDS, Azure SQL, Oracle Cloud, GCP SQL).
- Proficiency in SQL, performance tuning, and query optimization.
- Experience with Linux systems (Red Hat, Oracle Linux, CentOS, SUSE) and Windows Server for SQL Server environments.
- Familiarity with shell scripting, automation, and monitoring tools.
- Understanding of data modeling, partitioning, and storage optimization.
- Experience in data warehouse management and real-time replication (e.g., Oracle GoldenGate, SQL Server Replication).
Preferred Qualifications:
- Certifications in Oracle (OCP / Autonomous Database) and MySQL administration.
- Experience working with cloud database services (AWS, Azure, or Oracle Cloud).
Soft Skills:
- Strong problem-solving and analytical mindset.
- Excellent communication and teamwork skills.
- Ability to manage priorities in fast-paced production environments.
- Self-motivated, detail-oriented, and proactive in issue resolution.
Pakistan
EG, PK + 1 more
AS, AU + 51 more