IrvineRecruiter Since 2001
the smart solution for Irvine jobs

DB2 z/OS Mainframe DBA

Company: The Judge Group, Inc.
Location: Irvine
Posted on: March 27, 2020

Job Description:

Location Irvine, CA Description Company LargeGlobal company Position DB2 DBA Duration Full-timePermanent position NOTE For a quick response, please apply direct to ckellyjudge.com and put "DB2" on the subject line. Thank you!! DB2 zOS Mainframe DBA Roles and Responsibilities Database Design Reviews Description Review database design proposals and provide evaluation and alternatives. Confirm that the design is functionally feasible. Establish and confirm user expectations in terms of responsiveness, performance, and capacity. Provide a forum for technical discussion. Identify areas of further investigation. Measurement Schedule meetings and perform the design reviews. Provide written summaries, communications and collaborate on all enhancements. Logical Physical Database Design Description Translate detailed requirements specified by the business and application developers into physical objects in a database. Develop logical models in coordination with application developeraposs needs as new corporate projects are approved for implementation. Design databases, tables, primary keys, logical relationships. Evolve existing models as new requirements develop and enhancements are requested. Create objects according to internal standards including standardized attribute names. Measurement Create schema definitions and alterations. Adhere to standards. Developer Support SQL Code Review Description Review all new and updated SQL prior to production implementation. Generate EXPLAINs and analyze SQL statement cost assessments. Review column matching for optimal index access and create or modify indexes when necessary. Recommend SQL modifications and improvements when required. Check SQL for SELECT vs CURSOR, ensure DCLGENs are correctly used. Ensure error handling has been specified and error SQL codes are being checked according to standard programming practices. Check for missing NULL indicators where applicable. Explain SQL and review predicted costs for optimal index access. Prepare production BIND and EXPLAIN JCL. Measurement Ensure all SQL is being reviewed prior to production implementation. Advise and mentor developers. Physical Database Implementation - Development Description Support the application development process by timely implementation of all database schema additions and or modifications in the development environment. Create and or modify the following objects - databases, tablespaces, tables, primary keys, indexes, check constraints, RI constraints, partitioning schemes. Support multiple prototypes when required and rapid implementation of schema change as the design is tested and evolves through iterations. Develop prototypes of processes that will extract from production and re-load into dev such that these can be handed over to developers and run independently. Measurement Assist developers. Implement and maintain development schemas. Document project milestones and completions Performance Tuning of the Application during Development Description Support the application development process from a performance and tuning perspective. Check SQL efficiency using predictive tools like EXPLAIN analysis. Monitor SQL efficiency using operational tracing tools like Platinum Insight. Coordinate with developers and perform measurements and tracing when necessary. Ensure indexes that are appropriate have been created. Provide recommendations for modification improvement as needed. Measurement Document performance of the developed applications. Production Deployment Support Description Create RFCs to deploy all schema changes in production including tablespaces, tables, primary key, indexes, constraints, RI, compression, and column additions. Assign a CTASK to the ATOS DBA and transfer model DDL as guidance. Coordinate timing of the change with respect to acceptable outage windows and represent the change to the Change Control Board. Monitor ATOS progress and review all JCL and DDL for the schema changes. Ensure a back out strategy is in place and be prepared to execute it. Monitor the deployment and review the changes as they are made to ensure that the request has been successfully completed. Provide timely communication on the status of the deployment. Monitor the change post-deployment for any abends or unexpected results. Measurement Create the RFCs, obtain all approvals, monitor deployment, and communicate status upon completion. Distributed Access Support Description Assist with andor install, configure, implement, monitor, and maintain all distributed methods of connecting to the DB2 subsystem. Provide developers with connection details for distributed access. Provide guidance for acquisition and use of RACF credentials. Configure DB2 Connect Gateway, distribute the Client Connection software. Install and configure the HIT Driver Type 4 JDBC driver. Assist with debug and diagnose of remote connection issues including gather traces and interfacing with product vendor support interfaces where applicable. Measurement Keep all distributed access mechanisms up to date with respect to version, release, modification levels. Production Rationalization Description Collaborate with developers and ATOS DBA with rationalization efforts to optimize the DB2 environment. Identify long running processes that are inefficiently consuming DB2 resources. Engage in subsystem performance and tuning efforts, query optimization, using performance monitors, SQL profilers and other related monitoring and troubleshooting tools. Determine reasonable strategies for running RUNSTATS reorgs on an as-required basis. Collaborate on efficient and effective use of computing resources. Measurement Optimize the production environment by reducing consumption of DB2 resources. Backup Recovery - Database Integrity Description Collaborate with ATOS DBAs to ensure that all production data is secured and backed up by jobs that run on a scheduled basis. Identify frequency and guaranteed recovery (quiesce) points. Determine appropriate backup methodology, SHRLEVEL CHANGE (online updates permitted) or SHRLEVEL REFERENCE (read only). Review grouped quiesce points to ensure consistent recovery of referentially related objects. Measurement Review and update documentation that identifies all backup schedules and recovery procedures. Problem Resolution - Development Description Assist developers with diagnosis of database related issues including unexpected SQL codes, referential integrity violations, bind setup, consistency token errors, missing synonyms, missing grants, unavailable resource, deadlocks, timeouts, load utility failures, etc. Measurement Respond to requests for assistance and track requests via emails. Contact ckellyjudge.com mailtockellyjudge.com?subject20DB220z2FOS20Mainframe20DBA This job and many more are available through The Judge Group. Find us on the web at www.judge.com httpwww.judge.com

Keywords: The Judge Group, Inc., Irvine , DB2 z/OS Mainframe DBA, IT / Software / Systems , Irvine, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Data Science Platform Engineer (Python, Data Science; AWS))
Description: Kelly IT Resources is helping its client, a well-known automotive company, finding a Data Science Platform Engineer.It's a long-term contract. br br Data Science Platform Engineer br br Location: (more...)
Company: Kelly Services
Location: Torrance
Posted on: 04/7/2020

Request a Mobile Signing Notary!
Description: Request a Mobile Signing Notary Certified Mobile Notary Service is our priority is in ensuring your success. There simply is no better choice for a loan signing company Certified Mobile Notary Services (more...)
Company: Certified Mobile Notary Service
Location: Escondido
Posted on: 04/7/2020

SAP Variant Configuration - Manager (Customer)
Description: Are you looking for a career trajectory that few other organizations can offer in SAP What about access to a high-quality portfolio of businesses and clients with opportunities to work across capabilities, (more...)
Company: Deloitte
Location: Costa Mesa
Posted on: 04/7/2020


Request A Mobile Signing Notary!
Description: Certified Mobile Notary Service is our priority in ensuring your success. There simply is no better choice for a loan signing company Certified Mobile Notary Services provides signing agents throughout (more...)
Company: Mommy Jobs Online
Location: Torrance
Posted on: 04/7/2020

Java Developer - Entry Level
Description: At Revature, we hire emerging technology talent to innovate the future of tomorrow. In the next 4 weeks, we will hire over 300 new Entry Level Java Developers.--One day someone is going to ask you where (more...)
Company: Revature
Location: Pomona
Posted on: 04/7/2020

System Administrator
Description: Eurofins Scientific is an international life sciences company which provides a unique range of analytical testing services to clients across multiple industries. The Group believes it is the world leader (more...)
Company: Eurofins
Location: Burbank
Posted on: 04/7/2020

SAP Variant Configuration - Senior Manager (Customer)
Description: Are you looking for a career trajectory that few other organizations can offer in SAP What about access to a high-quality portfolio of businesses and clients with opportunities to work across capabilities, (more...)
Company: Deloitte
Location: Costa Mesa
Posted on: 04/7/2020

SAP Technical/Solution Architect - Manager (Technology
Description: At Deloitte you'll have the opportunity to help clients get the most from their SAP investments-and help position businesses for the evolving digital economy. Ready to reimagine your career possibilities (more...)
Company: Deloitte
Location: Costa Mesa
Posted on: 04/7/2020

Request A Mobile Notary!
Description: Certified Mobile Notary Service is a mobile notary service available in all 50
Company: Mommy Jobs Online
Location: Oceanside
Posted on: 04/7/2020

Technical Consultant
Description: The Technical Consultant participates in all stages of the implementation lifecycle for exports discovery, configuration, testing, deployment, post go-live support , under the direction of the Project (more...)
Company: Ceridian
Location: Fountain Valley
Posted on: 04/7/2020

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Irvine RSS job feeds