Role: Enterprise Database Administrator (PostgreSQL & DB2 Mainframe)
Location: ONSITE- San Antonio
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."
" 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"