Database Administrator (Sql/Mysql)

About the Role

We are seeking a highly skilled and experienced Database Administrator (DBA) to join our team.

Key Responsibilities

1. Database Administration

• Install, configure, upgrade, and maintain multiple database systems.
• Perform schema design, object creation, user management, and permission control.
• Manage and optimize database objects such as tables, views, indexes, stored procedures, triggers, and functions.
• Ensure adherence to best practices for all relational database environments.

2. Backup, Restore & Disaster Recovery

• Develop, implement, and monitor incremental and full backup strategies.
• Configure and maintain replication, clustering, mirroring, and other HA/DR solutions.
• Conduct routine restore tests to ensure business continuity and minimal downtime.

3. Performance Monitoring & Optimization

• Monitor database health using monitoring tools; identify and resolve performance bottlenecks.
• Optimize slow queries, indexes, caching, and server configurations.
• Provide recommendations to improve database and application performance.

4. Maintenance & Automation

• Schedule and automate regular maintenance tasks including reindexing, vacuuming, consistency checks, and log cleanup.
• Develop automation scripts using Bash, PowerShell, or Python to reduce manual workloads.

5. Data Management & ETL

• Execute data extraction, transformation, and loading (ETL) processes.
• Handle database version upgrades and data migrations with integrity and minimal downtime.
• Ensure secure, auditable handling of sensitive data.

6. Security & Compliance

• Implement and maintain database security policies including authentication, authorization, encryption, and auditing.
• Identify vulnerabilities and apply patches/fixes.
• Ensure compliance with internal data governance and regulatory requirements.

7. Research & Development (R&D)

• Research new database technologies, tools, and performance strategies.
• Conduct POCs on monitoring tools, database features, or scaling architectures.
• Document findings and implement improvements to the database environment.

8. Cross-Functional Support

• Collaborate closely with DevOps, Cloud, Development, and Security teams.
• Support application deployments, migrations, and performance incident troubleshooting.
• Participate in an on-call rotation to support critical database-related incidents.

Requirements & Qualifications

Must-Have Skills

• 4+ years of DBA experience in MySQL, MariaDB, SQL Server, and PostgreSQL.
• Strong expertise in:
• Backup & recovery strategies
• Replication, clustering, and HA/DR
• Performance tuning and query optimization
• Authentication, security, and access control
• Hands-on experience with database tools:

SSMS, SQLYog, MySQL Workbench, pgAdmin, Toad, etc.

• Strong understanding of Linux and Windows Server environments.
• Experience with monitoring tools like Prometheus, Grafana, CloudWatch, Zabbix, SolarWinds, etc.
• Scripting experience in Bash, PowerShell, or Python.

Education

• Bachelor’s Degree in Computer Science, Computer Engineering, Information Technology, or a related field.

Job Type: Full-time

Pay: Rs250,000.00 - Rs350,000.00 per month

Work Location: In person