Senior DB2 LUW and Postgres Database Administrator

Senior DB2 LUW and Postgres Database Administrator

Requirements

• More than 5 years of experience in Db2 LUW Database administration
• More than 2 years of experience in PostgreSQL Database administration (AWS RDS/EDB/ Open-Source PostgreSQL)
• More than 2 years of experience in Database migration from Oracle/MSSQL/Db2 LUW to PostgreSQL
• Maintain the database using different utilities. This includes using pg_ctl, pgdump, pgbackrest, BARMAN, psql, etc.
• Solid understanding of Database technology
• Extensive Database performance tuning experience
• Expertise in implementing and maintaining High Availability and disaster Recovery configurations like Streaming/Multi-master Replication, EFM, BDR, Logical replication, RDS Global
• Database Deep knowledge of industry-standard, enterprise-class best practices for a large database environment
• Good understanding of AIX and Intel platforms
• Deep understanding of HADR Database and storage technologies like Data replication, TSM, etc.
• Experience implementing, supporting and auditing database security
• Experience with Unix/Linux OS platform and Unix Shell scripting and automation
• Knowledge of administering advanced Db2 database functions including High Availability (HADR), Q-Replication and SQL replication (capture and apply, both continuous and non-continuous)

Responsibilities

• Primary role will be to support our existing key client.
• Work with clients on issues, requests related to Projects.
• Work proactively and review high level project requirements and deliverables.
• Participate in an on-call rotation for 24×7 support for incidents and outages.
• Automate DBA best practices.
• Design and enhance, upgrade, or build new client Db2 LUW and EDB PostgreSQL environments.
• Work closely with clients daily on projects, troubleshooting, or consultations.
• Perform software installations, upgrades, and patches to Db2 LUW, PostgreSQL instances and servers.
• Define and maintain Db2 LUW & PostgreSQL standards and governance.
• Utilize industry standard technologies & methods to ensure the integrity & recoverability of Db2 LUW & PostgreSQL applications.
• Perform Database Upgrades from Oracle or DB2 LUW to PostgreSQL.
• Serve as technical resource to business analysts, solutions development, and other groups responsible for Db2 LUW & PostgreSQL application development standards, system design and integration.
• Ensure Db2 LUW & PostgreSQL systems remain at operational excellence during infrastructure improvements (hardware/software upgrades server migrations/consolidations, application deployment, etc.).
• Assist in creating new or maintaining documentation, runbooks, knowledge articles and diagrams.
• Assist with major issues, technical challenges, and troubleshooting.
• Facilitate open communication and collaboration between our ops DBA team and the client, ensuring alignment and effective problem-solving.

Preferred Qualifications

• Automation skills in Shell Scripts/Python/Ansible/Terraform (cloud) to automate routine maintenance activities.
• Knowledge of the ITIL framework
• Ability to work independently, analyze the requirement, and provide solutions.
• A ‘client centric’ approach
• Excellent demonstrable English written and verbal communication skills
• Able to communicate in groups with confidence and conviction
• Ability to multi-task and work well under pressure
• Excellent team collaboration skills are essential
• Strong organizational and analytical skills
• Ability to document processes and procedures in a clear, concise, and logical manner
• Self-starter with the capability to work independently and produce positive results that will keep migration timelines on schedule