DB2 Database Administrator – DBA
Job Description:
- Install, configure, administer, patch, upgrade, and maintain IBM DB2 databases
- Monitor database health, availability, performance, capacity, and resource utilization
- Perform database and SQL performance tuning
- Analyze SQL execution plans and identify performance bottlenecks
- Optimize tables, indexes, queries, memory, storage, and database configurations
- Implement and manage database backup and recovery procedures
- Perform database restoration and recovery when required
- Design and maintain high-availability and disaster-recovery configurations
- Perform database capacity planning and storage management
- Manage database users, roles, privileges, and access controls
- Implement database security, encryption, and auditing requirements
- Monitor database logs, jobs, utilities, and scheduled processes
- Troubleshoot database failures, locking, deadlocks, connectivity, and performance issues
- Perform root-cause analysis of production database incidents
- Support database migrations, upgrades, refreshes, and environment cloning
- Develop scripts and utilities to automate routine DBA activities
- Support application releases and production deployments from a database perspective
- Maintain database configuration documentation, SOPs, recovery procedures, and operational runbooks
- Participate in production incident, change, and problem-management processes
Requirements:
- 10+ years of hands-on IBM DB2 DBA experience
- Strong experience with DB2 LUW administration
- Strong SQL skills
- Strong experience with database performance tuning
- Experience with DB2 backup and recovery
- Experience with high availability and disaster recovery
- Experience with database security, access control, and auditing
- Strong Linux/Unix skills
- Experience supporting large enterprise production databases
- Strong troubleshooting and root-cause-analysis capabilities
- Experience with database monitoring and performance-management tools
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical discipline, or equivalent professional experience
- Must be a US Citizen
- IBM DB2 certification preferred
Benefits:
- Cutting-edge technology, training, and career guidance
- Opportunities to work with leading multinational clients
- Established methodologies, processes, and mentoring
- Opportunities to work with specialized services and advanced IT solutions
- Continuous learning
- Engagements involving agile development principles, methodical planning, and creative thinking
- Opportunities through a growing R&D division exploring the latest technological developments