Mainframe DB2 Database Administrator

  • New York, NY

Compensation

: $94,330.00 - $148,460.00 /year *

Employment Type

: Full-Time

Industry

: Information Technology



Loading some great jobs for you...





Job Title: Mainframe DB2 Data Administrator
New York, NY
12 months contract minimum


The mainframe DB2 Database Administrator will be part of a team of experienced DB2 DBAs who provide critical support services for DB2 on z/OS including database design, processing requests for database maintenance and migrations, application performance, troubleshooting, disaster recovery, scheduled database maintenance in addition to Production support.

Responsibilities:
- The DB2 DBA will be a member of the global technology team working on database projects and requested workload.
- Provide complete database life cycle support for mission critical databases using various DB2 tools and techniques.
- Participate in regular database capacity planning related to database growth and system utilization, trend analysis and predicting future database resource requirements
- Understanding of regulatory, legal and compliances issues for SOX and audit functions
- Provide proper guidance and standards to application development teams
- Interface with senior management

Qualifications Required
- Minimum 7 Years' experience administering Db2 for z/OS databases in an enterprise environment
- Experience with DB2 for z/OS, version 11 or higher
- Experience supporting a multi-terabyte environment
- Experience supporting high throughput OLTP applications
- Experience supporting applications within a DB2 data sharing environment
- Knowledge and conceptual understanding of a System Development Life Cycle (SDLC)
- Logical and physical database design skills
- Proficiency in application related performance and tuning, including extensive SQL coding tuning
- Extensive Mainframe JCL experience and REXX coding
- Detailed experience with DB2 DDL, DB2 utilities, DB2 Security and database maintenance processing
- Ability to resolve Production DB2 issues quickly and effectively
- Working knowledge of Word, Excel and PowerPoint for management reporting purposes
- Excellent analytical and troubleshooting skills
- Clear, concise and effective written and verbal communication skills
- Exhibit good time management skills, independent thinking and decision making capabilities
- Off-hours on-call support

Desired Experience with Computer Associates database tool suite
- Experience with IBM Infosphere Data Replication and MQ
- Experience working with Java, distributed platforms and applications


Associated topics: data analytic, data engineer, data management, data scientist, database, database administrator, etl, hbase, mongo database administrator, sql

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...