DB2 Database Administrator

Job Description: DB2 Database Administrator
Location: Alpharetta, GA (HYBRID)
Cliet: ATOS

As a Mid-Senior Level DB2 DBA, you will be responsible for the following:

1. Database Administration and Management:

   • Design, configure, and maintain DB2 database environments, ensuring optimal performance and data integrity.
   • Install, upgrade, and patch DB2 database software to keep systems up to date.
   • Monitor and optimize database performance by analyzing resource utilization and implementing performance tuning techniques.
   • Manage database security, access controls, and user permissions.
   • Troubleshoot and resolve database-related issues, including performance bottlenecks, data corruption, and system failures.
   • Implement and maintain backup and recovery strategies to ensure data availability and disaster recovery.

2. Database Design and Development Support:

   • Collaborate with application developers and system analysts to design and implement efficient database structures and schemas.
   • Assist in the development and optimization of SQL queries, stored procedures, and database triggers.
   • Perform data modeling and capacity planning to ensure scalability and performance.

3. Database Monitoring and Support:

   • Monitor database systems proactively to identify and resolve issues before they impact performance or availability.
   • Respond to database-related incidents and service requests, providing timely resolution and troubleshooting expertise.
   • Perform regular database health checks and performance assessments to identify areas for improvement.
   • Collaborate with cross-functional teams to implement system upgrades, migrations, and data conversions.

4. Documentation and Reporting:

   • Maintain accurate and up-to-date documentation of database configurations, procedures, and standards.
   • Prepare and present reports on database performance, capacity, and system health to management and stakeholders.
   • Contribute to the development of best practices, guidelines, and standards for database administration.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).
• Minimum of 5 years of hands-on experience as a DB2 DBA, managing large-scale production database systems.
• In-depth knowledge of IBM DB2 database administration, including installation, configuration, maintenance, and troubleshooting.
• Proficiency in SQL programming and query optimization.
• Strong understanding of database performance tuning and optimization techniques.
• Experience in implementing and managing database security controls.
• Familiarity with backup and recovery strategies, including point-in-time recovery and disaster recovery planning.
• Ability to work independently as well as collaboratively in a team environment.
• Excellent problem-solving, analytical thinking, and troubleshooting skills.
• Effective communication and interpersonal skills.

Preferred Qualifications:

• IBM Certified Database Administrator - DB2 certification.
• Experience with other relational database management systems (RDBMS) such as Oracle or SQL Server.
• Knowledge of data replication and high availability solutions for DB2 databases.
• Familiarity with cloud-based database services (e.g., AWS RDS, Azure Database).
• Understanding of database automation and scripting using tools like PowerShell or Python.

-- 
Sincerely yours,
Nikhil Chandrakar
Central Business Solution (CBSInfosys)
37600 Central Ct Suite 214
Newark, CA, 94560
Direct: (510) 431-8644
LinkedIn: