- Must Have hand on experience in Database clustering and replication technologies including EDB Enterprise Failover Manager (EFM) & PGD and CitusData.
- PostgreSQL & Cassandra DB Administration: Expert in installing, configuring, and maintaining PostgreSQL & Cassandra instances in production, staging, and development environments.
- Database Performance Optimization: Advanced skills in query optimization, indexing, partitioning, and caching strategies to boost database performance & Optimize database stability and performance throughout the migration lifecycle.
- High Availability & Disaster Recovery: Skilled in setting up replication (synchronous & asynchronous), failover mechanisms, and backup strategies to ensure maximum uptime and data protection.
- Scalability & Load Balancing: Experience in implementing horizontal and vertical scaling techniques, managing large datasets, and balancing loads to improve performance.
- Database Security: Ensuring database security through access control, encryption, and regular audits to protect sensitive data and comply with industry standards.
- SQL & PL/pgSQL Development: In-depth knowledge of writing complex SQL queries, stored procedures, functions, and triggers for both transactional and analytical applications.
- Data Migration & ETL: Expertise in migrating large volumes of data across different PostgreSQL instances and performing ETL operations.
- Infrastructure: Experience in deploying and managing PostgreSQL databases on different platforms.
- DevOps & Automation: Familiarity with infrastructure as code (IaC), CI/CD pipelines, and automation tools like Ansible, Docker, and Kubernetes for seamless PostgreSQL deployment and management.
- Execute migration of Oracle and SQL Server databases to PostgreSQL environments.
- Ensure all migration activities comply with the Change Advisory Board (CAB) process, coordinating pre-production and production releases.
- Implement and enforce the principle of least privilege across all database users and roles.
- Configure and enable Transparent Data Encryption (TDE) with minimal impact on production environments.
- Conduct daily operational health checks to ensure optimal database performance.
- Provide timely business and application support to resolve database-related issues.\
- Perform patching and minor version upgrades while minimizing system downtime.
- Document all database activities, procedures, and incidents comprehensively.
- Redis database experience.
- hands on experience in Database clustering and replication technologies including EDB Enterprise Failover Manager (EFM) & PGD and CitusData.
Requirements
- +3 Years in similar role, experienced in managing and supporting PostgreSQL (version 14 and above) on both Linux and Windows platform.
- Hands on experience in Database clustering and replication technologies including EDB Enterprise Failover Manager (EFM) & PGD and CitusData
- Database administration certifications
- Experience with MS SQL Server, and Cassandra DB.
- Proven experience as a Database Administrator with strong knowledge of database management systems (e.g., Oracle, MySQL, SQL Server).
- Experience in database security and data protection measures.
- Familiarity with backup and recovery processes.