C2C Hiring : PostgreSQL & DB2 Database Admin at San Antonio, TX

Tech Mirrors; San Antonio (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

Tech Mirrors in San Antonio, TX is seeking an experienced PostgreSQL & DB2 Database Administrator for onsite work. The role covers installation, upgrades, migrations, patch management, monitoring, and performance tuning across PostgreSQL and DB2 environments.

Responsibilities include leading data migration efforts, root-cause analysis of production issues, and coordinating backup/recovery and DR solutions. Experience with cloud services and DevOps practices is beneficial.

Qualifications

• Minimum 6+ years of experience in database administration and related roles.
• Administer installation, upgrades, migrations, patch management, repository maintenance, and job monitoring.

Responsibilities

• Monitor database performance and availability, implement backup/recovery and disaster recovery processes.
• Lead data migration initiatives for legacy systems, including validation and post-migration support.
• Perform SQL tuning, execution plan analysis, and troubleshooting across PostgreSQL and DB2 environments.

Tools

PostgreSQL

DB2

SQL Server

Kubernetes

Docker

Git

Jenkins

Linux

Windows server

Shell Scripting

AWS RDS PostgreSQL

Azure PostgreSQL

GitHub Copilot

Microsoft Copilot

Kiro

Job description

Role– PostgreSQL & DB2 Database Admin

Location –San Antonio, TX (Onsite)

Job Type – C2C/W2

Job Description:

• Minimum 6+ years of experience.
• Perform Administration Activities including installation, upgrades, migrations, patch management, repository maintenance, user/group administration, and job monitoring.
• Lead and support Data Migration initiatives involving legacy systems, data transformation, validation, reconciliation, and post-migration support.
• Strong proficiency in SQL and PostgreSQL database troubleshooting, performance tuning, query optimization, and data analysis.
• Experience in troubleshooting production issues through application log analysis, Documentum logs, database logs, and server logs, performing root cause analysis and resolution.

Strong understanding of Load Balancing concepts, high-availability architectures, reverse proxies, traffic routing, session persistence, and performance optimization.

Familiarity with cloud-native architecture principles and modern DevOps practices.

Experience leveraging AI-powered developer productivity tools such as Kiro, GitHub Copilot or similar tools for code generation and solution design.

Database Administration and Performance Management

• Monitor database performance and availability.
• Backup and Recovery manage failover and disaster recovery solutions.
• Ensure business continuity, data protection, configure and maintain replication environments.
• Work with cloud database services such as AWS RDS PostgreSQL or Azure PostgreSQL.
• Execute and monitor DB2 utilities and perform SQL tuning and access path optimization.
• Prepare RCA and incident reports, Managed backup, recovery, and disaster recovery processes.
• Provided production support and resolved database performance issues in z/OS environments.

Database Administration

• SQL Server, PostgreSQL
• Data Migration concepts
• Server Administration and log analysis
• Generative AI Fundamentals
• GitHub Copilot, Microsoft Copilot, AWS Kiro
• Monitoring & Alerting Tools
• Shell Scripting
• SQL Optimization & Execution Plan Analysis
• Change & Release Management
• Mainframe DB2
• Kubernetes, Docker, Git, Jenkins
• Linux, Windows server”