Enterprise Database Administrator (PostgreSQL & DB2 Mainframe) || ONSITE- San Antonio, TX
Why This Role Stands Out
You'll have the opportunity to significantly impact enterprise-level database operations, gaining valuable experience with both PostgreSQL and DB2 Mainframe technologies. This role is ideal for a skilled database administrator eager to tackle complex data migration and performance tuning challenges in a collaborative, onsite environment. Apply today to advance your career in a critical technology infrastructure role.
Quick Overview
Job Description
Role: Enterprise Database Administrator (PostgreSQL & DB2 Mainframe)
Location: ONSITE- San Antonio, TX
Duration: 6 months
Descriptions:
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.
Requirements
- 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"
Skills: PostgreSQL, IT IS_AMS_Mainframe_DB2 Administration Experience Required: 10 & Above
Similar jobs
- PD
Systems Engineer 4 with Security Clearance
NewPDS Defense Inc.
Seal Beach, CA🇺🇸Hybrid20 hours agoAgileHTTPHTTPS+1Technology - RA
Systems Administrator (VDI / Citrix / Hyper-V) with Security Clearance
NewRazor
Jacksonville, FL🇺🇸On-site20 hours agoTechnology - PI
Senior Appian Lead Developer with Security Clearance
NewPingWind Inc.
Quantico, VA🇺🇸$95k - $132k/yrHybrid20 hours agoMariaDBOracleSQL+1Technology - OT
Senior Systems Engineer Requirements & Systems Architecture (In with Security Clearance
NewOteemo Inc
Moorestown, NJ🇺🇸Hybrid20 hours agoGenerative AITechnology - PI
Intermediate Systems Administrator with Security Clearance
NewPingWind Inc.
Quantico, VA🇺🇸$68k - $94k/yrHybrid20 hours agoTechnology - DN
Agile Developer 3 [D.26.0192] with Security Clearance
NewDover Networks LLC
Southern Md Facility, MD🇺🇸$213k - $233k/yrHybrid20 hours agoDockerSpringSpring Boot+7Technology