Junior Senior Database Administrator

Job description / Role

Description

Must have hands-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 and 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 and 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.

Requirements

• 3+ years in a similar role, experienced in managing and supporting PostgreSQL (version 14 and above) on both Linux and Windows platforms.
• 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.