Database Administrator

Job Description Database Administrator (DBA)

Experience: 2–5+ Years
Technology: MySQL, PostgreSQL
Job Type: Full-Time
Department: Software Development / IT Infrastructure

Job Summary

We are looking for a skilled and detail-oriented Database Administrator (DBA) with 2–5+ years of experience in managing, maintaining, securing, and optimizing MySQL and PostgreSQL databases. The candidate will be responsible for database performance tuning, backup and recovery, database security, troubleshooting, high availability, and ensuring the reliability and integrity of enterprise application databases.

The ideal candidate should have hands-on experience supporting production databases, optimizing complex queries, implementing database best practices, and collaborating with developers and DevOps teams.

Key Responsibilities

1. Database Administration

• Install, configure, maintain, and upgrade MySQL and PostgreSQL database servers.
• Manage database schemas, tables, indexes, views, stored procedures, functions, and triggers.
• Perform database creation, user management, access control, and privilege administration.
• Monitor database health, availability, resource utilization, and capacity.

2. Performance Optimization

• Analyze and optimize SQL queries, execution plans, indexes, and database structures.
• Identify and resolve slow queries, locking issues, deadlocks, and performance bottlenecks.
• Perform database tuning to improve application response times and transaction processing.
• Monitor CPU, memory, disk I/O, connections, and database workloads.

3. Backup and Disaster Recovery

• Plan, configure, and monitor automated database backups.
• Implement and test database restoration and recovery procedures.
• Manage point-in-time recovery, transaction logs, and PostgreSQL WAL archiving, as applicable.
• Develop and maintain disaster recovery plans and validate backup integrity.
• Define and support Recovery Time Objective (RTO) and Recovery Point Objective (RPO) requirements.

4. Database Security

• Implement database security policies, role-based access control, and least-privilege permissions.
• Manage database users, authentication, encryption, and secure connections.
• Apply security patches, database updates, and configuration hardening.
• Monitor database logs and investigate unauthorized access or suspicious activities.
• Support compliance, audit requirements, and data protection policies.

5. High Availability and Reliability

• Configure and maintain replication and database high-availability mechanisms.
• Monitor replication lag and troubleshoot replication failures.
• Support failover, recovery, and database availability procedures.
• Assist in database migration, version upgrades, and infrastructure changes.

6. Development and DevOps Support

• Collaborate with PHP and other application development teams on database design and optimization.
• Review SQL scripts, schema changes, and database migration procedures.
• Support development, testing, staging, and production environments.
• Work with DevOps teams to integrate database deployment and maintenance into CI/CD pipelines.
• Automate routine database administration tasks using shell scripts or other suitable scripting tools.

7. Monitoring and Documentation

• Monitor database logs, alerts, availability, and performance metrics.
• Troubleshoot database incidents and provide timely resolution.
• Maintain database architecture documents, operational procedures, and recovery runbooks.
• Prepare periodic reports on database performance, capacity, backup status, and incidents.

Required Technical Skills

• Strong hands-on experience with MySQL and PostgreSQL administration.
• Good knowledge of SQL, advanced queries, joins, indexing, transactions, and query optimization.
• Understanding of database normalization, relational database design, and schema management.
• Experience with database backup, restoration, replication, and recovery.
• Knowledge of database security, authentication, access control, and auditing.
• Familiarity with Linux server administration and command-line operations.
• Experience with database monitoring and performance diagnostic tools.
• Knowledge of database migration, patching, upgrades, and production troubleshooting.
• Basic scripting skills in Bash/Shell or Python.
• Understanding of TCP/IP, database connectivity, connection pooling, and application integration.

Preferred Skills

• Experience with MySQL replication, PostgreSQL streaming replication, and high-availability configurations.
• Familiarity with tools.
• Exposure to cloud database services such as AWS RDS, Amazon Aurora, Azure Database, or Google Cloud SQL.
• Knowledge of Docker, containerized deployments, and CI/CD processes.
• Experience working with large databases and high-transaction-volume applications.
• Familiarity with database encryption, audit logging, and security best practices.Role & responsibilities

Preferred candidate profile

Perks and benefits