Why This Role Stands Out
This hybrid PostgreSQL DBA role offers a fantastic opportunity to enhance your skills in a dynamic environment, supporting critical databases across multiple platforms and cloud services. If you excel at performance tuning, troubleshooting, and ensuring data integrity, you'll thrive here while enjoying the flexibility of a hybrid work arrangement. Apply today to join a team dedicated to robust database management and innovation.
Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
San Antonio, TX, United States
Posted
22 hours ago
SQLShellAWSLoad BalancingAzureGenerative AIPostgreSQL
Job Description
Job Title: PostgreSQL DBA
Location: San Antonio, TX
Employment Type: Contract
Description
Location: San Antonio, TX
Employment Type: Contract
Description
- Perform database administration activities including:
- Database installation, configuration, upgrades, and migrations
- Patch management and repository maintenance
- User and group administration
- Job monitoring and database maintenance
- Administer and support PostgreSQL and Mainframe DB2 environments.
- Monitor database performance, availability, capacity, and health.
- Perform SQL tuning, query optimization, execution plan analysis, and access path optimization.
- Execute and monitor DB2 utilities in z/OS environments.
- Troubleshoot complex production database issues and perform Root Cause Analysis (RCA).
- Analyze application logs, Documentum logs, database logs, and server logs to identify and resolve production issues.
- Support data migration initiatives involving:
- Legacy systems
- Data transformation
- Data validation
- Data reconciliation
- Post-migration support
- Manage database backup, recovery, failover, replication, and disaster recovery solutions.
- Ensure database environments meet business continuity and data protection requirements.
- Configure and maintain database replication environments.
- Work with cloud database services including AWS RDS PostgreSQL and/or Azure PostgreSQL.
- Understand and support load balancing, high availability, reverse proxy, traffic routing, session persistence, and performance optimization.
- Support database environments running on Linux, Windows, and z/OS.
- Develop and maintain Shell scripts for database administration and operational activities.
- Collaborate with application, infrastructure, DevOps, and engineering teams.
- Follow Change Management and Release Management processes.
- Utilize monitoring and alerting tools to proactively identify database issues.
- Apply Generative AI and AI-powered developer productivity tools such as GitHub Copilot, Microsoft Copilot, AWS Kiro, or similar tools for code generation, troubleshooting, and solution design.
- Support modern cloud-native architecture and DevOps practices.
- Prepare detailed incident reports, RCA documentation, and operational documentation.
Similar jobs
- ST
Data Engineer- Golang - W2 Contract
NewSDVS Technologies LLC
United States🇺🇸Hybrid22 hours agoETLAgileGit+2Technology - MT
Azure Data Engineer
NewMaintec Technologies Inc
Weehawken Township, NJ🇺🇸On-site22 hours agoSQLSQL ServerAzure+1Technology - VE
W2// Data Engineer
NewVensIT Corp
Blue Bell, PA🇺🇸Remote22 hours agoSAFeOracleSQL+9Technology - CD
Lead Data Engineer
NewCosmic-I LLC DBA Northern Base
Jersey City, NJ🇺🇸Hybrid22 hours agoAWSETLSnowflake+1Technology - HB
Sr AI Data Engineer
NewHigh Bridge Consulting
United States🇺🇸Hybrid22 hours agoAWSAzureDatabricks+5Technology - AC
Data Engineer
NewAPN Consulting Inc
United States🇺🇸Remote22 hours agoSQLAWSETL+5Technology