Senior PostgreSQL DBA/Lead with IaaS/PaaS Patroni

• *About Infinite:** Infinite is a global leader in digital engineering and IT services, with over 20 years of experience driving digital transformation. We partner with leading Fortune 1000 companies to deliver innovative, scalable technology solutions that accelerate business outcomes. With deep expertise in telecommunications, healthcare, banking, and finance, Infinite helps organizations optimize and modernize their technology landscapes to achieve long-term growth and efficiency. We are looking for a SME working on PostgreSQL database environments. This includes design, implementation, maintenance, advanced tuning and migration from MSSQL.

• *Key Responsibilities:
• *Database Architecture & Design:

Leads the design and implementation of database architectures that support business requirements, ensuring scalability, high performance, availability, and security.

• *Migration to MSSQL:**

Leads and executes the migration from and to MSSQL in efficient and automated manner, perform post migration checks for accuracy of migration

• *Performance Tuning & Optimization:**

Conducts advanced performance analysis and tuning, including query optimization, indexing strategies, and adjusting database configurations for optimal efficiency.

• *High Availability & Disaster Recovery:**

Implements and manages solutions for high availability per client requirement and develops/implements backup, recovery, and failover procedures.

• *Installation, Upgrades & Patching:**

Conduct the installation, configuration, and maintenance of PostgreSQL instances, including minor and major version upgrades and security patching.

• *Monitoring & Troubleshooting:**

Proactively monitors database health, performance, and capacity and leads the troubleshooting and resolution of complex production issues.

• *Security & Compliance:**

Implements and manages database security controls, including access management (RBAC), encryption, and authentication (LDAP), to ensure compliance with client defined staandards

• *Collaboration & Mentorship:**

Works closely with development, QA, and application teams on schema design, code reviews, and best practices. Mentors junior DBAs and provides technical guidance to other IT staff.

• *Automation & Scripting:**

Automates routine database operations, deployments, and monitoring tasks using scripting languages (e.g., Bash, Python, Perl) and tools like Ansible or Terraform.

• *Documentation:**

Creates and maintains detailed documentation regarding database configurations, architectures, processes, and standards.

• *Key Qualifications and Skills:
• *Experience:

Typically requires a minimum of 8+ years of hands-on database administration experience, with significant experience in PostgreSQL in an enterprise environment.

• *PostgreSQL in IaaS and PaaS, Linux experience, Petroni/ETCD/Encryption setup &configuration and Azure/AWS/GCP) and private networking (Basic knowledge)
• *Technical Knowledge:

Deep expertise in PostgreSQL architecture, performance tuning, high availability concepts, and the Linux operating system.

• *Problem-Solving:**

Excellent analytical, problem-solving, and troubleshooting abilities, with the capacity to resolve complex issues quickly.

• *Communication:**

Strong verbal and written communication skills to collaborate effectively with technical and non-technical stakeholders.

• *Education:**

A bachelor's degree in Computer Science, Information Technology, or a related field is often required. On-Call Support: Must be available for a flexible work schedule, including on-call rotation for 24x7 operations. Apply tot his job Apply To this Job