Onsite_Enterprise PostgreSQL Database Administrator

Role: Enterprise PostgreSQL Database Administrator & 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/" Email me for prompt response.