What are the responsibilities and job description for the DB2 Database Administrator position at Central Business Solutions, Inc?
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
