Senior Postgres/DB2 DBA

Responsibilities

• Install, configure, upgrade, patch, and administer PostgreSQL (v11 and above) and IBM DB2 databases.
• Manage database capacity planning, growth forecasting, and storage utilization.
• Create and maintain development, QA, UAT, and production database environments.
• Monitor database performance and availability; analyze and optimize SQL queries, indexes, and execution plans.
• Troubleshoot slow‑running queries and application performance bottlenecks.
• Implement proactive monitoring and alerting mechanisms.
• Design and execute backup and recovery strategies; maintain disaster recovery and business continuity solutions.
• Configure and support replication, clustering, failover, and high‑availability architectures; conduct regular DR drills and recovery validation.
• Provide L3 production support, perform root‑cause analysis, prepare RCA documents, and participate in on‑call rotations.
• Implement database security standards, manage user accounts, roles, privileges, and auditing; support vulnerability remediation and security audits.
• Lead database migration initiatives between environments and platforms, including cloud migration and modernization programs, ensuring minimal downtime and data integrity.
• Collaborate with application teams, architects, cloud engineers, and business stakeholders; provide technical guidance and mentoring to junior DBAs; participate in design reviews and architecture discussions.

Skills

• PostgreSQL administration (installation, configuration, upgrades, patching, performance tuning, query optimization, replication, clustering, high availability, security, backup/recovery) on Linux environments.
• Experience with AWS RDS PostgreSQL or other cloud‑hosted databases.
• IBM DB2 administration (performance monitoring and tuning, SQL optimization, index management, backup/recovery, security, user administration, migration and upgrade activities).
• Linux/Unix system administration and shell scripting (Bash/KSH).
• SQL and stored procedure development.
• Monitoring tools and alert management.
• Version control and CI/CD concepts (Git, Jenkins).
• Cloud platforms, preferably AWS.
• ITSM and change management processes.

Pay

Salary range: $95,000 – $110,000 per year.