Postgresql DBA

Iris Software is a 35 year old IT Service organization which has been a trusted software engineering partner to several Fortune 500 companies for over three decades. At Iris Software, our vision is to be our clients most trusted technology partner, and the first choice for the industrys top professionals to realize their full potential.

We help clients realize the full potential of technology-enabled transformation by bringing together a unique blend of domain knowledge, best-of-breed technologies, and experience executing essential and critical application development engagements. Our highly-experienced talent and rightsized teams help develop core, complex, and mission-critical applications and solutions for leading enterprises across Capital Markets/Front office operations, Banking, Investment Management, Brokerage, Risk and Compliance, Insurance.

With over 4,300 associates across India, U.S.A, New York and Canada. We help our enterprise clients thrive with Our highly-experienced talent and rightsized teams help to develop core. Our work covers complex, mission-critical applications with the latest technologies, such as high-value complex Application & Product Engineering, Data & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation.

https://www.linkedin.com/company/iris-software-inc./

About the Role:

PostgreSQL DBA
Location- Banaglore
Mode- Hybrid (3 days /week)

Database - Lead

Mandatory Skills:

Performance Tuning & Scalability, PL/SQL (including PL/SQL Packages), PostgreSQL, PostgreSQL internals, backup/restore, Patroni clustering, HA/DR, pgBackRest, PostgreSQL upgrades/patching &Migration, Ansible automation, Bash/Linux, Cloud infrastructure, Monitoring and Alerting, performance tuning.

Additional Skills:

Ansible

Technical capabilities -

• 8+ years PostgreSQL DBA experience.
• Experienced with Patroni clustering.
• Hands on Bash Shell scripting.
• Ansible experience
• Bonus Crunchy PostgreSQL
• Crunchy Automation PostgreSQL experience is a huge bonus
• Hands on experience with Clustered PostgreSQL databases especially knowledge of Patroni.
• Deep understanding of PostgreSQL Infrastructure, clustering, and replication.
• Strong expertise in PostgreSQL administration and Support
• Strong knowledge of Linux/Unix
• Well above average Bash shell scripting
• Proficient in PostgreSQL db backups (pgbackrest), Recovery, BAU Support, performance tuning, PostgreSQL concepts
• Experience supporting DBs in Cloud Environments (AWS, Azure, GCP)
• Contribute to end-to-end automation and database workflows.
• Understanding of Monitoring and Alerting needs for large scale system.

Key Accountabilities -

Overall platform availability, cloud infrastructure provisioning and maintenance in Core banking modernization Domain and Switching Domain, this includes:

• Cloud Infrastructure provisioning: AWS and Azure via automation using Ansible
• Incident Resolution: In the event of incidents, resolving and restoring service as quickly as possible minimising outages. •Vendors and in-house team engagement: Escalating support calls to 3rd party vendor and / or in-house NAB support teams (e.g. database administrator team)
• Ticket/ queue management: - Administration of support tickets and requests. Own and resolve repeated incidents and problems

Documentation: Proficient at writing support documentation for overnight processes for supported applications.

Ad hoc database work: Executing SQL queries to generate ad hoc reports and distributing them to the relevant parties.

Application Administration: Administering system configuration changes or database updates as required by the vendor or business.

If Intersted, kindly share your resume on [email removed]

Notice Period- Max 15 Days.