Key Responsibilities:
Database Maintenance & Administration:
- Perform routine maintenance tasks includingbackup, recovery, patching, and performance tuning.
- Conductstandard database maintenance and administration taskswith attention to detail.
- Monitor database activity, health, and performance, usingdatabase management system software and toolsto collect performance statistics.
- Optimize database performance, plan for forecast resource needs, and recommend corrective actions.
- Ensure databasehigh availability, replication, failover, and clustering.
- Develop and configure tools toautomate database administration tasks, enhancing efficiency and minimizing downtime.
- Maintain procedures and documentation for databases, ensuring compliance with standards for definition, security, and integrity of database objects.
- Implement disaster recovery strategies and maintain data integrity across environments.
Incident Management & Troubleshooting:
- Handle critical escalations and complex troubleshooting for database issues.Diagnose performance bottlenecks, slow queries, deadlocks, and replication issues.Collaborate with DevOps, infrastructure, and application teams for RCA (Root Cause Analysis).
Backup, Recovery & Disaster Recovery:
- Design and implement backup strategies and disaster recovery plans.Ensure data integrity, redundancy, and compliance with RPO/RTO requirements.
Database Design & Implementation:
- Design and architect scalable, high-performance database systems for enterprise applications.
- Implement database schemas, indexing, and optimization techniques to improve efficiency.
- Manage database configuration, including installing and upgrading software, and maintaining relevant documentation.
Containerization & Orchestration:
- Manage databases usingDocker and Kubernetesto ensure scalability and resilience.
- Optimize containerized database solutions for performance optimization.
- ImplementCI/CD pipelines for automated deployment and maintenanceof databases within containerized environments.
Collaboration & Communication:
- Work closely withapplication teamsto ensure seamless integration and optimal performance by understandingbusiness logic, data models, and query patterns.
- Optimize database schema and queries forapplication performance improvement.
- Provide guidance ondatabase best practicesfor developers and architects.
- Collaborate with team members to address user needs, providing timely issue resolution and guidance.
- Interact with customers, suppliers, and partners to deliver effective database maintenance.
- Make substantive contributions to discussions, planning, and implementation of database management improvements.
Monitoring & Reporting:
- Continuously monitordatabase performance statisticsand generate reports to communicate findings and recommendations.
- Identify and investigate complex issues, proposing effective corrective actions.
- Utilize monitoring tools and frameworks to ensure proactive database management.
- Automatepatching, backups, and deploymentsusing scripts (Bash/Python) and configuration management tools (Ansible, Terraform).
Security & Compliance
- Implementdatabase security best practices, including access controls, encryption, and auditing.
- Ensure compliance withGDPR, HIPAA, SOC2, and other regulatory standards.
Documentation & Reporting:
- Maintain comprehensive documentation of database architectures, processes, maintenance plans, and troubleshooting guides.
- Prepare reports detailing system health, performance metrics, and improvement plans.
Required Skills and Qualifications:
- Database Technologies:Deep knowledge of PostgreSQL, MongoDB, and Redis.
- Containerization & Orchestration:Hands-on experience with Docker and Kubernetes for deploying and managing databases.
- Application & Infrastructure Integration:Strong understanding of application and infrastructure interoperability, microservices, API interactions, and application workflows.
- Performance Tuning & Optimization:Proven experience in performance tuning, query optimization, system monitoring, and caching mechanisms.
- Maintenance Automation:Expertise in scripting and developing tools for automated maintenance tasks.
- Analytical & Problem-Solving Skills:Excellent troubleshooting capabilities with the ability to recommend effective solutions.
- High Availability & Disaster Recovery: Backup, failover, replication, and multi-region deployments.
- Security & Compliance: Database encryption, access controls, auditing, GDPR/HIPAA compliance.
- Collaboration & Communication:Ability to work effectively within cross-functional teams and present technical concepts to non-technical stakeholders.
- Documentation:Strong documentation skills for architectures, procedures, and troubleshooting guides.
