Database Administrator

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

Required Skills:

• 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:

• PostgreSQL IT IS_AMS_Mainframe_DB2 Administration
• Experience Required: 10 & Above