DB2 Database Administrator

DB2 Database AdministratorLocation: Alpharetta, GA (HYBRID)Client: ATOSAs 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.