Perform database administration activities including:
Database installation, configuration, upgrades, and migrations
Patch management and repository maintenance
User and group administration
Job monitoring and database maintenance
Administer and support PostgreSQL and Mainframe DB2 environments.
Monitor database performance, availability, capacity, and health.
Perform SQL tuning, query optimization, execution plan analysis, and access path optimization.
Execute and monitor DB2 utilities in z/OS environments.
Troubleshoot complex production database issues and perform Root Cause Analysis (RCA).
Analyze application logs, Documentum logs, database logs, and server logs to identify and resolve production issues.
Support data migration initiatives involving:
Legacy systems
Data transformation
Data validation
Data reconciliation
Post-migration support
Manage database backup, recovery, failover, replication, and disaster recovery solutions.
Ensure database environments meet business continuity and data protection requirements.
Configure and maintain database replication environments.
Work with cloud database services including AWS RDS PostgreSQL and/or Azure PostgreSQL.
Understand and support load balancing, high availability, reverse proxy, traffic routing, session persistence, and performance optimization.
Support database environments running on Linux, Windows, and z/OS.
Develop and maintain Shell scripts for database administration and operational activities.
Collaborate with application, infrastructure, DevOps, and engineering teams.
Follow Change Management and Release Management processes.
Utilize monitoring and alerting tools to proactively identify database issues.
Apply Generative AI and AI-powered developer productivity tools such as GitHub Copilot, Microsoft Copilot, AWS Kiro, or similar tools for code generation, troubleshooting, and solution design.
Support modern cloud-native architecture and DevOps practices.
Prepare detailed incident reports, RCA documentation, and operational documentation.
Never miss an opportunity! Create an alert based on the job you applied for.