TTI of USA
DB2 z/OS DBA - Non Exempt
PayCompetitive
LocationOwings Mills/Maryland
Employment typeFull-Time
This job is now closed
Job Description
- Req#: 24-00765
- Provide database and system on-site support of the IBM DB2 mainframe z/OS environments
- Support numerous IBM application environments & teams leveraging DB2 z/OS databases
- Monitor, collect statistical information, and provide reporting on capacity and system performance
- Based on statistics, make recommendations to maintain and improve capacity and system performance
- Monitor the system, and act upon system and application automated alerts
- Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
- Plan and perform software installation, configuration, upgrade and patching
- Plan and perform database configuration, maintenance, upgrade and patching
- Perform and manage system and database backups
- Perform manual switch to redundant system / database components, in case of system failures
- Participate fully in 24x7x365 oncall rotations for production support
- Bachelor's degree in a technical field such as computer science, computer engineering or related field required
- 6+ years’ experience required including use of all IBM Utilities and Commands in an administration and architecture role
- Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution
- Strong knowledge of SQL and tuning
- Knowledge of IBM Data Studio, Broadcom/CA database administration tools, TMON monitoring
- Understanding of Help Desk tools and trouble ticket tracking processes
- Understanding of support agreements and their implied service levels
- Proven ability to write excellent technical documentation
- Excellent written and verbal skills
- Ability to express complex technical concepts effectively
- Ability to work well with people partnering and collaborating on solutions from many difference disciplines.
- Ability to work well with people from many different disciplines with varying degrees of technical experience
- Ability to work independently and as part of a team
- Ability to mentor others
- Action and results oriented
- Ability to exercise good judgement while under stress
- Knowledge of mainframe database products including CA DB2 tools, TMON monitoring, Data Studio is preferred.
- Certification as Database Administrator in DB2 z/OS at V11 through current.
- Working experience with mainframe DBA tools from Broadcom/CA required– including:
- RC/Merger
- RC/Query
- RC/Migrator
- Detector
- Subsystem Analyzer
- Strong knowledge of SQL and performance tuning.
- Participation in 24x7x365 oncall rotation required.
- Tools from Rocket Software including ASG-TMON/MVS, TMON/DB2, IBM – DataStudio are Preferable.
Job Description:
Focus:
This position will be focused primarily on the Mainframe z/OS platform. Demonstrated experience as Database Administrator in DB2 on z/OS 2.4 or higher, and DB2 z/OS V12.
Summary:
The main function of a Database Administrator is to provide database support on a variety of hardware and software platforms and peripherals.
Job Responsibilities:
Qualifications:
Preferred:About the company
TTI is recognized as a certified WBENC staffing provider and has developed a solid reputation providing a suite of services to the most prestigious and re