Sr. Database Administrator (DBA)

” The Job Description”

1.  Administer, maintain, and support PostgreSQL, MySQL, and Microsoft SQL Server databases across production, staging, and development environments.
2.  Perform installation, configuration, upgrades, and patching of RDBMS systems across multiple operating systems (primarily Linux and Windows).
3.  Design and implement high availability (HA) and disaster recovery (DR) strategies including database replication, clustering, and backup validation.
4.   Conduct daily monitoring, performance tuning, query optimization, and capacity planning to ensure database stability and responsiveness.
5.  Execute and validate backup and recovery procedures using Veeam or native database utilities (e.g., pgBackRest, mysqldump, SQL Server Maintenance Plans).
6.   Support database schema design, stored procedures, indexing, partitioning, and normalization in coordination with application and development teams.
7.  Ensure data security, role-based access control, encryption, and auditing are enforced in compliance with corporate and regulatory policies.
8.   Create and maintain comprehensive documentation for database configurations, procedures, standards, and support guides.
9.  Automate repetitive tasks using scripting languages such as Bash, PowerShell, or Python.
10.  Provide incident and problem management support, troubleshoot database-related performance or connectivity issues, and resolve root causes.
11.   Assist in data migrations, replication between environments, and regular refreshes of test databases.
12.   Collaborate with infrastructure, application, and DevOps teams to support seamless integration of databases with business systems and services.
13.   Participate in change management processes and production rollout activities for database changes.
14.  Support integration with OCI-native services, including backup, monitoring, logging, and storage.

Requirements: 

•  Bachelor’s degree in Computer Science, Information Systems, or related technical field.
•  Minimum 5+ years of hands-on experience managing production-grade PostgreSQL, MySQL, and MS SQL Server databases.
•  Proven experience with cloud database administration, preferably on OCI, AWS, or Azure.
•  Strong track record of supporting databases for business applications (CRM, ERP, HRMS, AML, etc.).
•   Advanced skills in PostgreSQL: administration, tuning, WAL archiving, replication (streaming/logical), and backup tools (pgBackRest or Barman).
•   Solid experience with OCI MySQL and MySQL-compatible cloud databases: replication, configuration, and performance tuning.
•    Deep knowledge of MS SQL Server, including Always On Availability Groups, SQL Agent Jobs, backups, and database maintenance plans.
•   Competence in scripting (e.g., Bash, PowerShell, PL/pgSQL) for automation and troubleshooting.
•  Familiarity with OCI services (e.g., Compute, Block Volumes, Monitoring, VCN) and database-related configurations.
•   Strong analytical, troubleshooting, and problem-solving skills.
•   Effective communication and documentation abilities.
•   Ability to manage competing priorities under pressure and meet strict SLAs.

 Certifications (Preferred):

•   PostgreSQL Certified DBA.
•   Oracle Cloud Infrastructure (OCI) Certified Architect / Specialist.
•  Microsoft Certified: Azure Database Administrator Associate / SQL Server DBA.
•   MySQL DBA Certification.

Tagged as: AML, bash, crm., devops, ERP, hrms, mysqldump, oci-native., powershell, python, SQL