Jobs via Dice
Mainframe DB2 Database Administrator
Jobs via Dice, Salisbury, North Carolina, United States, 28147
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 analytic 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
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 analytic 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