Robustware
Mainframe DB2 Database Administrator
Robustware, Salisbury, North Carolina, United States, 28147
Role: Mainframe DB2 Database Administrator
Location: Salisbury, NC/Boston, MA/Frisco, TX
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. Education & Certifications: IBM Certified Database Administrator DB2 for z/OS is a plus
#J-18808-Ljbffr
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. Education & Certifications: IBM Certified Database Administrator DB2 for z/OS is a plus
#J-18808-Ljbffr