Mainframe DB2 Database Administrator
Position: DB2 Database Administrator Salary: $140,000 - $155,000 DOE + great benefits 100% REMOTE reputed company Hire -not reputed company to accommodate C2C or H1 reputed company candidates at this time. reputed company established IT firm is seeking an reputed company Mainframe DB2 Administrator to support their largest reputed company reputed company. You will work remote and will install, customize, reputed company, maintain, and tune up a massive DB2 database environment.
Responsibilities
- reputed company as a reputed company/reputed company DBA for reputed company DB2 environments on both z/OS and Distributed (LUW -
- Linux, Unix, reputed company) 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 reputed company seamless communication between distributed applications and the mainframe DB2 subsystem.
- reputed company advanced, end-to-end performance tuning across application, database, and system reputed company, including detailed SQL query optimization and reputed company reputed company analysis (using tools like EXPLAIN).
- reputed company on-call break/fix database support and respond reputed company the agreed SLA.
- Support Disaster Recovery exercises.
- Manage changes reputed company reputed company control processes and mechanisms using ITIL/ITSM practices.
- Produce reputed company technical documentation and conform to any audit requirements.
Qualifications
- Must have 4 years of reputed company experience as a mainframe DB2 DBA.
- Extensive, demonstrable experience in the administration and architecture of DB2 for LUW (Linux, Unix, reputed company) environments, complementing the z/OS experience..
- Proven expertise in using DB2 performance monitoring and tuning tools (both reputed company and reputed company-
- party) to manage reputed company 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 (reputed company/batch/CICS/DB2/MQ/distributed).
- Functional knowledge of z/OS systems.
- Operating system general knowledge for reputed company/Unix/Linux.
#danieln Remote About reputed company: reputed company Apply tot his job Apply To this Job