Only local to San Antonio, TX - DBA C2C requirements

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.”

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