Database Administrator

Job Details:-

Job Title: Senior Postgres /DB2 DBA

Location: San Antonio, TX Onsite

Duration: Fulltime Hire

Salary Range: $120,000-$130,000 a year + benefits

Experience :- 6+

Job Description

PostgreSQL/ DB2

PostgreSQL Database Administration (v11 and above)

Installation, configuration, upgrades, and patching

Performance tuning and query optimization

Replication, clustering, and high availability

Backup and recovery strategies

Database monitoring and health checks

PostgreSQL security and access management

PostgreSQL on Linux environments

Experience with AWS RDS PostgreSQL or cloud-hosted databases

IBM DB2 Database Administration

DB2 Performance Monitoring and Tuning

SQL Optimization and Index Management

Database Backup and Recovery

DB2 Security and User Administration

Database Migration and Upgrade Activities

Production Support and Incident Management

Additional Skills

Linux/Unix Administration

Shell Scripting (Bash/KSH)

SQL and Stored Procedure Development

Monitoring Tools and Alert Management

Database Migration and Modernization Projects

Git, Jenkins, CI/CD Concepts

Cloud platforms (AWS preferred)

ITSM and Change Management Processes

Database Administration

Install, configure, upgrade, patch, and administer PostgreSQL and DB2 databases.

Manage database capacity planning, growth forecasting, and storage utilization.

Create and maintain development, QA, UAT, and production database environments.

Performance Management

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.

Backup, Recovery & High Availability

Design and execute database backup and recovery strategies.

Maintain disaster recovery and business continuity solutions.

Configure and support replication, failover, and high-availability architectures.

Conduct regular DR drills and recovery validation exercises.

Production Support

Provide L3 database support for critical production environments.

Perform root cause analysis for incidents and recurring issues.

Participate in on-call support rotations when required.

Prepare RCA documents and operational reports.

Security & Compliance

Implement database security standards and best practices.

Manage user accounts, roles, privileges, and auditing.

Ensure compliance with organizational and regulatory requirements.

Support vulnerability remediation and security audits.

Migration & Modernization

Lead database migration initiatives between environments and platforms.

Support cloud migration and modernization programs.

Ensure minimal downtime and data integrity during migrations.

Collaboration

Work closely with application teams, architects, cloud engineers, and business stakeholders.

Provide technical guidance and mentoring to junior DBAs.

Participate in design reviews and architecture discussions.