DATABASE ADMINISTRATOR

A Mainframe DB2 DBA is responsible for the design, maintenance, and high availability of Db2 databases on IBM z/OS systems. Responsibilities include performance tuning, executing database utilities such as RUNSTATS and REORG, managing backups, and supporting development teams with SQL optimization. Core Job Responsibilities: Database Administration: Maintain Db2 for z/OS environments, including tablespaces, indexes, and database storage allocation. Performance Tuning: Monitor system health, analyze SQL query access paths, and perform performance optimization using tools such as EXPLAIN and SPUFI. Backup & Recovery: Develop and maintain disaster recovery strategies, manage database logs, and execute restores. Utilities Management: Run and schedule routine Db2 utilities such as REORG, RUNSTATS, COPY, LOAD, and UNLOAD. Security & Compliance: Manage user access controls, maintain system security (RACF), and conduct audit compliance checks. Collaboration & Support: Provide 24/7 on-call Tier-3 production support and assist application developers with schema changes, DDL/DML deployments, and stored procedure tuning.

• Mainframe architecture, z/OS, JCL, TSO/ISPF, and SDSF.
• IBM and third-party database tools/utilities such as PLATINUM, IBM DB2 Admin, SPUFI, QMF, BMC, and CA Technologies.
• Strong SQL skills (Static and Dynamic) and familiarity with COBOL used in mainframe integrations.

Salary: $101,500/Year Leaders in Digital Transformation Innovation at the Core, Excellence Inspired, Success Engineered