Source description
About the role
Key ResponsibilitiesDatabase Administration - Install, configure, upgrade, patch, and maintain PostgreSQL and/or MongoDB environments. - Manage database health, availability, performance, and capacity planning. - Perform database migrations, refreshes, and environment provisioning. - Administer database users, roles, permissions, and security policies. - Ensure compliance with organizational security and audit requirements. High Availability & Disaster Recovery - Configure and manage replication technologies. - Manage clustering, failover, and disaster recovery solutions. - Perform backup and recovery operations and conduct recovery drills. - Ensure database resiliency and business continuity. Performance & Optimization - Monitor and optimize database performance. - Analyze query execution plans and recommend tuning strategies. - Optimize indexes, database objects, and configurations. - Troubleshoot database bottlenecks and production incidents. Monitoring & Automation - Implement and maintain monitoring, alerting, and reporting solutions. - Automate routine DBA tasks using scripts and tools. - Develop operational runbooks and standard procedures. Production Support - Provide L2 support for production environments. - Participate in on-call support and incident management. - Ensure SLA adherence and timely issue resolution. Mandatory SkillsPostgreSQL Administration - Strong experience in PostgreSQL administration. - Expertise in - Replication (Streaming, Logical Replication) - Backup and Recovery (pgBackRest, WAL management) - Performance Tuning - Partitioning - HA solutions such as EDB EFM, Patroni, Pgpool-II, etc. - Experience with Linux operating systems. MongoDB administration(optional) - Strong experience in MongoDB administration. - Expertise in - Replica Sets - Sharding - Backup and Recovery - Query and Index Optimization - Security and Authentication - Performance Monitoring and Troubleshooting - Experience with YugabyteDB administration. - Understanding of distributed SQL architecture. - Cluster deployment, scaling, replication, and troubleshooting. SQL Development (Optional) - Solid SQL and query optimization skills. - Experience in developing stored procedures, functions, and database scripts. DevOps & Automation (Optional) - Experience with: - CI/CD pipelines - Git/GitHub/GitLab - Jenkins, Azure DevOps - Ansible or Terraform - Infrastructure automation and configuration management. Programming/Scripting (Optional)Knowledge of one or more: - Python - Shell Scripting - PowerShell Desired Skills - Strong analytical and troubleshooting abilities. - Experience managing databases in cloud environments (AWS/Azure/GCP). - Knowledge of container technologies (Docker/Kubernetes) is a plus. - Excellent communication and stakeholder management skills. - Ability to work in a fast-paced production environment. .
More at KFIN TECHNOLOGIES