Database Administrator Job at Matlen Silver, Charlotte, NC

b0Z6ZEFacXcyNjFRKzVZcnNjb2hlZis4TkE9PQ==
  • Matlen Silver
  • Charlotte, NC

Job Description

z/OS Mainframe DB2 DBA

Jacksonville, FL | Plano, TX | Charlotte, NC | Hopewell, NJ

18 Month W2 Contract

Hybrid 3 days onsite 2 days remote

$60-$68/hour

Responsibilities include

• develop log scraping 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

Job Tags

Contract work, Remote work,

Similar Jobs

Harper Associates

Personal Assistant Job at Harper Associates

 ...PERSONAL ASSISTANT-NORTHVILLE, MI Executive family is seeking a proactive, detail-oriented Personal Assistant with strong initiative and the ability to think ahead. This primary purpose of the role is to make day-to-day life seamless for the principals. Primary home... 

Denali Water Solutions LLC

Class A Utility Driver - Req. ID: 3663 Job at Denali Water Solutions LLC

About Company: At Denali, we are not just the leading organic recycling company we are innovators in sustainability, dedicated to Replenishing the Earth by Repurposing Waste. Denali operates nationwide , driving environmental and agricultural progress at scale...

Village Flooring Plus

Commercial Flooring Sales Representative Job at Village Flooring Plus

 ...Were Hiring: Commercial Flooring Sales Professionals Village Flooring Plus LLC is expanding in Central Florida and looking for experienced sales pros who want real freedom not corporate limits. Were a direct importer and full-service flooring contractor with... 

Guardian Proservices

Airline Baggage Handler Job at Guardian Proservices

 ...provide safe and courteous baggage handling services to various airline passengers. Making Every Moment Matter for a World on the GO,...  ...Must be at least 18 years of age Authorized to work in the United States Must be able to pass background clearance verification... 

The Roy Group - Team Real Estate

Real Estate Showing Assistant Job at The Roy Group - Team Real Estate

Do you love Real Estate and want to see what it is like to work in this field? We are seeking a personable individual to work with clients...  ...from writing offers to close to ensure client satisfaction Assist the lead agent by showing homes to buyer clients that meet...