Team Leader, Database Administrator (PostgreSQL)

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