Job Directory Sr. DB2 & Adabas DBA

Sr. DB2 & Adabas DBA
Richardson, TX

Companies like
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.

About

Job Description

Job Description:

This person will be supporting several critical GWIM client facing applications as a Mainframe Db2/ADABAS DBA .

Full life cycle DBA support including design, build, production support and performance and tuning across both infrastructure and applications.

Responsibilities include full life cycle management of DB2 and ADABAS mainframe databases from analysis through decommission. Additionally the Individual will be involved in related z/Os Database software upgrades.

Day to day activities would include:

* Provision of technical consultation to application teams during the design of database solutions in regard to approach, resources, availability and recoverability.
* Translation of business requirements into a physical database for implementation with a focus on a complete understanding of processing requirements (peak times, # trans etc), performance, availability, recoverability, and data access methods
* Consulting with the application teams on both ACF2 and RACF managed database security to ensure appropriate access is provisioned for data access
* Defining and implementing application specific backup and recovery strategies for the production environment.
* Implement, change, remove database owned components ensuring adherence to Enterprise and database standards
* Support of database product upgrades, providing a focal communication point for development teams as well as completing owned DBA remediation activities, executing internal verification processes, conducting assessments of new feature/function and providing recommendations for use.
* Performance tuning support and recommendations for database calls, in cooperation with the application development team.
* Monitoring and addressing items on exception reports to ensure a stable production environment
* Supplying database technical expertise to application developers by assisting in development debugging efforts related to database and providing information on the various database utilities and facilities
* Support DBA production on call rotation including 24X7 SEV1 test support.
* Conduct information sharing meetings with the application teams when requested.
* Support of Self Identified Audits, Control assessments, Database Audits and SOX reviews, ensuring deliverables are complete and correct, and all milestone deliverables dates are met.

Occasional work outside of U.S. business hours for production installs and on call support.

Required:

Expertise in one or more of the following:

* 7 + years of Db2 DBA Experience in Mainframe Db2 environment
* Mainframe skills (JCL/TSO/etc.)
* Strong technical working knowledge of DB2 on Z/OS in a data sharing environment
* Experience in SQL tuning and database design
* Experience with BMC and IBM DB2 utilities
* Ability to work on complex problems where analysis of situations or data requires an in-depth evaluation of various factors relating to Mainframe DB2 Database.
* Proficient in MS office tools - Excel, word, PowerPoint
* Able to communicate effectively with peers, managements & other technical support personnel in a diverse global environment

Desired:

* Experience with ADABAS, Natural and Entirex
* Programming background a plus
* JAVA on Z experience a plus
* Understanding of CICS programming with Db2 a plus
* Experience with BMC Mainframe DB2 tool suite a plus (Change Manager, Catalog Manager, Mainview) preferred.
* Knowledge of ACF2 managed security for DB2 access a plus

Posting Date: 05/13/2019

Location: Charlotte, NC, Gateway Center, 901 W Trade St, Richardson, TX, BUILDING C, 2380 PERFORMANCE DR, - United States

Travel: No

Full / Part-time: Full time

Hours Per Week: 40

Shift: 1st shift

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.