Key Responsibilities
Database Administration Operations
- Install, configure, and administer PostgreSQL, MySQL/Percona, and MongoDB databases within test, staging, and production settings.
- Oversee clustering, replication, sharding, high-availability configurations, and failover protocols.
- Conduct regular performance tuning, including query optimization, index maintenance, vacuuming, statistical analysis, and storage efficiency enhancements.
- Manage backup, restoration, and disaster recovery strategies utilizing tools such as Patroni, pgBackRest, Percona XtraBackup, HAProxy, Keepalived, and cloud-native solutions.
- Administer database upgrades, schema migrations, and patching activities with minimal or zero operational downtime.
High Availability Performance
- Design and sustain high-availability and disaster recovery solutions for enterprise systems.
- Monitor and optimize database performance using native utilities, custom scripts, and platforms such as Prometheus, Grafana, ELK, Loki, and pgAdmin.
- Execute capacity planning, memory management, caching approaches, and storage expansion assessments.
Security Compliance
- Enforce authentication, authorization, and role-based access control across all database platforms.
- Implement mTLS, SSL/TLS, PKI, encryption at rest, and secure secret management via Vault, Keycloak, and HSM-integrated workflows.
- Perform periodic audits, vulnerability reviews, and rigorous security hardening in accordance with corporate and regulatory requirements.
- Facilitate secure database deployments in DMZ, offline/air-gapped, and zero-trust environments.
Automation Scripting
- Develop automation scripts for monitoring, backup, provisioning, and health checks using Bash, Python, Ansible, Terraform, and CI/CD pipelines.
- Collaborate with DevOps teams to streamline database operations within containerized infrastructures (Docker, Kubernetes, systemd).
Data Integrity Reporting
- Safeguard data consistency, reliability, referential integrity, and maintain comprehensive audit trails.
- Implement log management, slow-query diagnostics, and active database activity monitoring.
- Produce systematic reports detailing database health, uptime, backup status, performance metrics, and capacity utilization.
Cross-Functional Collaboration
- Partner with application development teams to design scalable schemas, refine queries, and plan for optimal database usage.
- Coordinate with security teams to support compliance reporting and penetration testing initiatives.
- Assist DevOps teams to enhance database performance within microservices and multi-tenant architectures.
Technical Skills
- In-depth knowledge of PostgreSQL, including replication, WAL tuning, partitioning, and extensions such as PostGIS and pgAudit.
- Advanced proficiency in MySQL / PGSQL Percona Server, encompassing clustering, GTID replication, and XtraBackup solutions.
- Direct experience with MongoDB, covering replica sets, sharding, and Ops Manager configuration.
- Comprehensive understanding of Patroni, HAProxy, pgBackRest, Keepalived, and enterprise-scale high-availability architectures.
- Expertise in Linux (Red Hat/Rocky Linux), systemctl/service management, and shell scripting.
- Familiarity with Kubernetes, Docker, and deploying database services in containerized ecosystems.
- Operational knowledge of Terraform, Ansible, and infrastructure automation practices.
- Solid grasp of networking fundamentals, including firewalls, DNS, routing, and load balancing.
- Experience with cloud platforms such as AWS, Azure, and hybrid models.
- Proficient in SSL/TLS, PKI, mTLS, certificate management, and encrypted database environments.
Soft Skills
- Demonstrated sense of ownership and proactive approach to task execution.
- Strong analytical and troubleshooting skills.
- Excellent communication abilities for effective engagement with developers, DevOps, QA, and leadership teams.
- Proven capability to manage multiple environments, prioritize assignments, and perform effectively under pressure.
- Dedication to process standardization, thorough documentation, and ongoing improvement.
