Role: Enterprise Database Administrator (PostgreSQL & DB2 Mainframe)
Descriptions:
Perform Administration Activities including installation, upgrades, migrations, patch management, repository maintenance, usergroup 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 zOS 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
Skills: PostgreSQLIT IS_AMS_Mainframe_DB2 Administration
Experience Required: 10 & Above
Never miss an opportunity! Create an alert based on the job you applied for.