Noor Staffing Group · 2 months ago
Mainframe DB2 Database Administrator
United States
Full-time
Remote
Senior Level, Lead/Staff
$140K/yr - $155K/yr
4+ years expNoor Staffing Group is a well-established IT firm seeking an experienced Mainframe DB2 Database Administrator to support their largest enterprise client. The role involves installing, customizing, upgrading, maintaining, and tuning a massive DB2 database environment, along with providing senior-level guidance and mentorship.
Staffing Agency
No H1B
Responsibilities
Act as a Principal/Lead DBA for complex DB2 environments on both z/OS and Distributed (LUW - Linux, Unix, Windows) platforms, providing senior-level guidance and mentorship
DB2 database design, configuration, review, and administration
Maintain and operate DB2 software, and tools
Diagnose and resolve DB2 reason codes and SQL errors
Design, implement, and manage DB2 Connect configurations to enable seamless communication between distributed applications and the mainframe DB2 subsystem
Perform advanced, end-to-end performance tuning across application, database, and system levels, including detailed SQL query optimization and access path analysis (using tools like EXPLAIN)
Provide on-call break/fix database support and respond within the agreed SLA
Support Disaster Recovery exercises
Manage changes within standard control processes and mechanisms using ITIL/ITSM practices
Produce clear technical documentation and conform to any audit requirements
Qualification
Required
Must have 4 years of progressive experience as a mainframe DB2 DBA
Extensive, demonstrable experience in the administration and architecture of DB2 for LUW (Linux, Unix, Windows) environments, complementing the z/OS experience
Proven expertise in using DB2 performance monitoring and tuning tools (both IBM and third-party) to manage buffer pools, I/O operations, locking mechanisms, and run time statistics
Deep understanding of DB2 Data Sharing principles, setup, and maintenance for high availability and scalability
Functional knowledge of DB2 internals, tools, and their usage
Functional knowledge of database interfaces (connection/batch/CICS/DB2/MQ/distributed)
Functional knowledge of z/OS systems
Operating system general knowledge for Windows/Unix/Linux
Benefits
Great benefits
Company
Noor Staffing Group
Noor Staffing Group is a NY based staffing firm.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Daniel Nadruz
Managing Partner, Client & Talent Solutions
Company data provided by crunchbase