Database Administrator

  • location: Richardson, TX
  • type: Contract
  • salary: $46 - $56 per hour

job description

Database Administrator

job summary:
Description:

  • Responsibilities include full life cycle management of DB2 mainframe databases from analysis through decommission. Additionally the Individual will be involved in DB2 related z/Os Database software upgrades, including DB2 Database, DB2 Connect, BMC and Shadow products.
Day to day activities would include:

  • Provision of technical consultation to application teams during the design of database solutions in regard to approach, resources, availability and recoverability.
  • 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.
  • Implement, change, remove database owned components ensuring adherence to Enterprise and database standards
  • Support of product upgrades related to DB2 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
  • Supplying database technical expertise to application developers by assisting in development debugging efforts related to database and providing information on the various database utilities and facilities
  • 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.
Top 3 Must Have Skillsets Required :

  • Position requires in-depth Mainframe DB2 DBA knowledge with a focus on performance and DB2 internals.
  • 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.
  • In depth working knowledge of 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
  • In-depth understanding of DB2 Explain and ability to identify less than optimal access paths
  • 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
  • Understanding of Data Dictionaries including Brownstone.
  • Background in database design for 24x7 availability.
  • Level of Experience Needed (highlight)
  • Minimum of 7-9 years of DB2 DBA experience on z/Os
 
location: RICHARDSON, Texas
job type: Contract
salary: $46 - 56 per hour
work hours: 9am to 5pm
education: Bachelors
 
responsibilities:
  • Provision of technical consultation to application teams during the design of database solutions in regard to approach, resources, availability and recoverability.
  • 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.
  • Implement, change, remove database owned components ensuring adherence to Enterprise and database standards
  • Support of product upgrades related to DB2 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.
 
qualifications:
  • Experience level: Experienced
  • Minimum 10 years of experience
  • Education: Bachelors
 
skills:
  • DBA
  • SQL Server

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.

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    Sybase DBA

  • location: Plano, TX
  • job type: Temp to Perm
  • salary: $36 - $46 per hour
  • date posted: 2/18/2021

    Sr. Database Manager

  • location: Dallas, TX
  • job type: Permanent
  • salary: $132,000 - $138,000 per year
  • date posted: 1/5/2021

    Inventory Administrator

  • location: Irving, TX
  • job type: Temp to Perm
  • salary: $21 - $22 per hour
  • date posted: 2/12/2021