Database Administrator

Overview

On Site
USD58 - USD68
Contract - W2

Skills

Database Administrator

Job Details

job summary:


  • 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



location: Plano, Texas

job type: Contract

salary: $58.32 - 68.32 per hour

work hours: 8am to 5pm

education: Bachelors



responsibilities:


  • 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


qualifications:


  • 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-depth 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.


skills:

  • experience with DB2 Utilities including IBM and BMC
  • Working knowledge of BMC tools including change manager, catalog manager, Main view, and SQL performance.
  • Solid understanding of DB2 recovery options
  • Broad understanding of ACF2 and RACF2 managed security for DB2 Access.
  • Working knowledge of Endeavor
  • 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




Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact

Pay 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. In addition, Randstad Digital offers a comprehensive benefits package, including: medical, prescription, dental, vision, AD&D, and life insurance offerings, short-term disability, and a 401K plan (all benefits are based on eligibility).

This posting is open for thirty (30) days.


Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.