Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Db2/Dba/Zos System Programmer

Expired Job

Adpi, Llc.. Windsor , CT 06006

Posted 5 months ago

DB2/DBA/zOS System Programmer CC8198113
Contract Position
Windsor, CT
NO C2C, NO STEM OPT EAD, WE WILL TRANSFER A VALID H1-B
Product Engineer role requires supporting Db2 for zOS and related database products in both Development and Production environments. The Engineer works with Application Solution Groups and Business teams to determine requirements, modifications and schedules. Represent the Engineering team as liaison with software vendors and technical support teams on issues such as software upgrades, problems and potential solutions. Ability to adapt, learn and support multiple DBMS technology interfacing to Db2 technology. The Engineer will have exceptional documentation skills and ability to communicate with developers and business resources. Subject matter expert in the mainframe technology, terminology, and 3rd party technology that interfaces with zSystems.

Product Engineering requires 24x7 pager support, working with delivery teams to coordinate implementation activities and assist in monitoring.

DBA role requires the ability to design logical and physical databases, schemas, create and implement complex databases structure including access methods, device allocations, validation checks and security. Work with architects, data modelers, and application developers in the creation and support of Db2 databases from physical design through all phases of application testing.

The DBA works with Application Solution Groups and Business teams to determine requirements, modifications and schedules. Db2 performance tuning is a significant component of the position.

The responsibilities of the position are:
Manage the SMPE process for Db2 zOS and related IBM and Third Party products.
Manage the installation, upgrade, maintenance and support of the Db2 zOS in both Data Sharing and non-Data Sharing environments.
Manage the installation, upgrade, maintenance and technical support of Db2 products for z/OS. Includes IBM data replication in addition to basic knowledge of target non-mainframe DBMSs such as Db2 LUW, Oracle, Db2 i.
Monitor Db2 environment for performance concerns and proactively address.
Thorough knowledge of Db2 zOS security. Identify and remediate any security exposures.
Support Disaster Recovery exercises in a mirrored environment.
Work projects simultaneously spanning multiple applications/releases
Work with application teams to design, implement and migrate Db2 objects through multiple test environments.
Support tuning Db2 databases and application code. This requires understanding of SQL, application architecture, Db2 performance tuning, and Db2 architecture
Weekend support for monthly Product maintenance and Application Releases required.
Work with peers to develop and improve controls, stream-line procedures through automation, update documentation and implement new Db2 functionality
Work with application teams to design Db2 database objects that meet business requirements and production standards. This requires obtaining application knowledge while working with architects, data modelers, and application developers

Technical Qualifications
8 + years Db2 zOS experience including experience as a DBA as well as Systems Programmer
7+ years Db2 DBA experience which includes implementing and maintaining Db2 database objects (DDL) along with performance tuning SQL
Following products a plus: IDAA (IBM DB2 Analytic Accelerator), BMC utilities, IIDR (Infosphere Data Replication) - both Change Data Capture and SQL Replication, IBM Data Administration Tool, IBM DB2 Automation Tool, CA RC/Secure, Omegamon for DB2PE, STROBE, Erwin, Compuware File-aid for DB2, QMF, DB2 Data Server Client.
Demonstrated skills in performance tuning, design and troubleshooting
Maintains vendor software on the mainframe utilizing vendor and other tools as required.
Detailed knowledge of the software management process (design, install, test, maintain)
Knowledge and experience dealing with software and hardware vendors.
Ability to design mainframe infrastructure hardware and software architecture.
Technical knowledge of non-mainframe applications and products that interface with Db2 on the mainframe.
Experience supporting production and non-production databases
Experience with most ZOS mainframe tools such as DFDSS, IDCAMS, JCL. Familiar with scheduling tools such as CA ESP.
Exposure to REXX, CLISTS programming are a plus.

Competencies
Effectively communicates complex technology concepts and solutions to all levels of the corporation from entry level to senior management.
Communicates and influences technical staff within the mainframe domain at varying levels of complexity.
Viewed as an internal expert, able to influence management and the technical community within the mainframe domain.
Experience engaging various vendors for technical support while working to determine root cause and resolution. Ability to open tickets, provide diagnostics to the vendor and clearly document issues.

Skills:
ZOS mainframe tools such as DFDSS, IDCAMS, JCL. Familiar with scheduling tools such as CA ESP.IDAA (IBM DB2 Analytic Accelerator), BMC utilities, IIDR (Infosphere Data Replication) - both Change Data
Contract



upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
MS SQL DBA

Cognizant Technology Solutions

Posted 2 weeks ago

VIEW JOBS 1/2/2019 12:00:00 AM 2019-04-02T00:00 We are looking for MS SQL DBA for an immediate need.This is a client facing role & the candidate will have regular interactions with various client managers. Responsibilities * SQL DB admin. good knowledge on new setup and also migration from existing DB. * Should be able to work indviually. Should be quick starter and should be able cope up with the pressure of the big migration efforts. * Have prevsious knowledge on setting up large DC SQl servers. * Good knowledge on Azure cloud desirable We are looking for applicants who have a flair for technology and are willing to take up challenging assignments. * Cognizant is recognized as a Military Friendly Employer and is a coalition member of the Veteran Jobs Mission. Our Cognizant Veterans Network assists Veterans in building and growing a career at Cognizant that allows them to leverage the leadership, loyalty, integrity, and commitment to excellence instilled in them through participation in military service. Applicants are required to be eligible to lawfully work in the U.S. immediately; employer will not sponsor applicants for U.S. work authorization (such as an H-1B visa) for this opportunity. Cognizant Technology Solutions Windsor CT

Db2/Dba/Zos System Programmer

Expired Job

Adpi, Llc..