Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
100% Travel
Able to Provide Sponsorship
Skills
RDS
Database Design
Effective communication
Oracle
PowerShell
Python
RDBMS
Collaborate
Computer Science
DBA
Database Administration
Database Administrator
disaster recovery planning
database management systems
database software
SQL
SQL Server
data modeling
database
database management
disaster recovery
health checks
interpersonal
interpersonal skills
optimization
performance
performance - tuning
performance tuning
tuning
planning
problem - solving
relational database
scalability
schemas
stakeholders
Job Details
Job Description:
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 current.
- 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 developing and optimizing 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 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.