Database Administrator_DB2 DBA

A client of Innova Solutions is immediately hiring for a Senior DB2 DBA

Position Type: Full time, Hybrid Onsite Contract (3 days onsite and 2 days remote work in a week!!!)
Duration: 12+ Months
Location: Hybrid Onsite in Plano, TX

As a Senior DB2 DBA you will:

Key Skills:

• DB2
• Z/oS
• Rexx
• Endevor
• IBM and BMC Tools
• ACF2 and RACF
• ACF2 and RACF2
• SMF data and reporting
• Splunk
• Python
• Production Support

Job Description:
Role: DB2 DBA
Responsibilities include:
• develop log scrapring strategies to limit CPU, memory usage and staging space while log scraping.
• Build Splunk dashboards to monitor the DB2 environment
• Work with other DB2 teams in setting up log retention policies to cover for extended period of outages
• Translation of business requirements into a physical model for implementation with a focus on a clear 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.
• Support of product upgrades related to DB2 replication 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
• 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.

Position requires in-dpeth Mainframe DB2 DBA (DB2 on Z/oS) knowledge with a focus on performance tuning.
Individual should have minimum of 7-9 years of DB2 DBA experience on z/Os at a single large financial institution.
Job stability is a key requirement.
experience with DB2 Utilities including IBM and BMC
Working knowledge of BMC tools including change manager, catalog manager, Mainview, and SQL performance.
Solid understanding of DB2 recovery options
Broad understanding of ACF2 and RACF2 managed security for DB2 Access.
Working knowledge of Endevor
Working knowledge of ITSM Processes and tools including BMC Remedy
In depth understanding of Db2 zOS, JCL, COBOL, SQL IBM Utilities and BMC Utilities.
Understanding of SMF data and reporting.
Knowledge of Splunk, Python

Must Have Technical Skills:

• DB2
• REXX
• Python

Qualified candidates should APPLY NOW for immediate consideration!
This position is only open to applicants who can be engaged on a W-2 basis.


Please hit APPLY to provide the required information, and we will be back in touch as soon as possible.
We are currently interviewing to fill this and other similar positions. If this role is not a fit for you, we do offer a referral bonus program for referrals that we successfully place with our clients, subject to program guidelines. ASK ME HOW.

Thank you!
Sunil Nanda
Innova Solutions Inc.
Tel: (+1) 585-625-4173
Email ID: sunil.nanda@innovasolutions.com

PAY RANGE AND BENEFITS:
Hourly Pay Rate Range*: Between $65.00/hr - $68.00/hr
*Pay range offered to a successful candidate will be based on several factors, including the candidate's education, work experience, work location, specific job duties, certifications, etc.

Benefits: Innova Solutions offers benefits( based on eligibility) that include the following: Medical & pharmacy coverage, Dental/vision insurance, 401(k), Health saving account (HSA) and Flexible spending account (FSA), Life Insurance, Pet Insurance, Short term and Long term Disability, Accident & Critical illness coverage, Pre-paid legal & ID theft protection, Sick time, and other types of paid leaves (as required by law), Employee Assistance Program (EAP).

ABOUT INNOVA SOLUTIONS: Founded in 1998 and headquartered in Atlanta, Georgia, Innova Solutions employs approximately 50,000 professionals worldwide and reports an annual revenue approaching $3 Billion. Through our global delivery centers across North America, Asia, and Europe, we deliver strategic technology and business transformation solutions to our clients, enabling them to operate as leaders within their fields.

Recent Recognitions:
Named One of America’s Best Employers for New Grads by Forbes (2024
Named One of the Best Companies to Work For by U.S. News & World Report (Private Companies List, 2024-2025)
One of the Largest IT Staffing Firms in the US – Ranked #3 by Staffing Industry Analysts (SIA, 2024)
One of the Largest Staffing Firms in the US – Ranked #13 by Staffing Industry Analysts (SIA, 2024; includes Innova Solutions, Volt, & HireGenics)
Named One of the Top Ten Private Companies in Atlanta by the Atlanta Business Chronicle (2023)
One of the Largest Certified Minority Business Enterprises (MBEs) in the United States (NMSDC, 2024)
AWS Advanced Tier Services Partner with 100+ certifications