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:
•
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.
•
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.
•
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.
•
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: www.linkedin.com/in/nikhilchandrakar