DB2 Database Administrator
New York, NY

Job Description

Job Title: Mainframe DB2 Data Administrator

Location: New York City, NY

Contract: 1 year contract to start ? extensions are likely!!

Financial Industry

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