DB2 Database Administrator (DBA)
Share
Job Location:
Salisbury, DE - USA
Monthly Salary:
Not Disclosed
Posted on:
11 hours ago
Vacancies:
1 Vacancy
Job Summary
Role :- DB2 Database Administrator (DBA)
Location :- Salisbury NC/Boston MA/Frisco TX
Job Description:
Role Summary:
- The DB2 DBA on z/OS is responsible for the administration performance tuning and maintenance of IBM DB2 databases running on the z/OS mainframe platform. This role ensures data integrity availability and security across mission-critical systems and collaborates with cross-functional teams to support business applications.
Key Responsibilities:
Database Installation & Configuration:
- Set up and manage DB2 subsystems buffer pools and storage groups.
Performance Tuning & Optimization:
- Monitor database performance and implement tuning measures
- Optimize SQL queries and indexing strategies.
- Analyze workload and adjust system parameters for efficiency.
Backup Recovery & Disaster Planning:
- Implement and manage backup and recovery procedures.
- Develop and test disaster recovery strategies
Security & Compliance:
- Manage user access controls and database security policies.
- Ensure compliance with data governance and audit requirements
Automation & Monitoring:
- Automate routine DBA tasks using scripting (e.g. REXX Shell Python).
- Use monitoring tools to proactively detect and resolve issues
Collaboration & Support:
- Work closely with application developers system programmers and infrastructure teams.
- Provide support during deployments upgrades and troubleshooting
Documentation & Standards:
- Maintain documentation for configurations procedures and standards.
- Define and enforce database standards and best practices.
Required Skills & Qualifications:
Technical Expertise:
- Strong experience with DB2 for z/OS (versions 10 through 12).
- Proficiency in JCL TSO/ISPF VSAM and DB2 utilities.
- Familiarity with SMP/E RACF and IBM mainframe tools.
- Knowledge of IBM MQ for z/OS IMS or CICS connectivity with DB2.
- Experience with DB2 DDF (Distributed Data Facility) and remote connectivity.
Experience:
- 5 years of hands-on experience in DB2 database administration on z/OS.
- Experience with performance tuning disaster recovery and automation.
Soft Skills:
- Excellent problem-solving and analytical skills.
- Strong communication and collaboration abilities.
- Ability to work independently and in a team environment.
Educaion & Certifications:
- IBM Certified Database Administrator DB2 for z/OS is a plus
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
