Search jobs > Oklahoma City, OK > Database administrator

DB2 Database Administrator

AP Recruiters & Associates
Oklahoma City, OK, United States
Full-time
Quick Apply

DB2 Database Administrator

Kansas City, Denver, Oklahoma City, Omaha

Estimated Duration : 12 Months

Wage : Hourly / W2

Employee Type : Contractor

Requires US Citizenship

Key Activities

  • Performs application and system operational duties. Implements solutions to Critical and High Incidents to solve problems and eliminate future recurrence.
  • Tunes databases, software, and operating system environments.
  • Collaborates with architects and product teams to ensure that the designed solution responds to non-functional requirements such as availability, performance, security, and maintainability.
  • Performs Database Management System design using data modeling tools. Creates database
  • objects such as tables, views, stored procedures, triggers, sequences, constraints, and rules.
  • Troubleshoots problems and provides resolution, including SQL tuning, solving performance and / or connectivity issues, fixing corrupt indexes, restoring corrupt databases from backup, and assisting developers with repairing corrupted data.
  • Identifies tasks and estimates as appropriate for business line support.
  • Creates documentation for standards, design, support, implementation, and troubleshooting of databases and database management systems.

Required Technical Skills

  • Database Administrator experience with DB2 on Linux (RHEL).
  • Work with application development team to design and create database objects.
  • Performance tuning skills : monitoring and optimizing database performance.
  • Experience coding and explaining complex SQLs.
  • Backup and Recovery : Implementing and testing backup and recovery procedures.
  • Good problem-solving, analytical and critical thinking skills.
  • In-depth knowledge and understanding of tools (DB2PD, DB2TOP, etc.).
  • Programming experience with Unix / Linux Shell script.

Preferred Technical Skills

  • Database Administrator experience with Db2 on z / OS and PostgreSQL.
  • Maintain Erwin data model.
  • Ability to learn new technologies.
  • 16 hours ago
Related jobs
Promoted
AP Recruiters & Associates
Oklahoma City, Oklahoma

Database Administrator experience with DB2 on Linux (RHEL). Database Administrator experience with Db2 on z/OS and PostgreSQL. Creates documentation for standards, design, support, implementation, and troubleshooting of databases and database management systems. In-depth knowledge and understanding ...

AP Recruiters & Associates
Oklahoma City, Oklahoma

DB2 Database Administrator</b></div> <div> </div> <div> <div><b>Kansas City, Denver, Oklahoma City, Omaha </b></div> <div> <div> <div> <div><b>Estimated Duration:</b> 12 Months<br /> <b>Wage: &...

Promoted
PMI (Project Management Institute)
Oklahoma City, Oklahoma

JobPosting","title":"Data Engineer II","datePosted":"2024-04-15T00:00:00","validThrough":null,"description":"Data Engineer II (Multiple Openings), Project Management Institute, Inc. Data Engineer II (Multiple Openings), Project Management Institute, Inc. The position requires a minimum of a Bachelor...

Promoted
Oklahoma Farm Bureau Insurance Company
Oklahoma City, Oklahoma

Database Management Systems (DBMS): Proficient in administering various database systems, including Microsoft SQL Server and other DBMS; Experience with database design, optimization, and maintenance; Knowledge of database security, backup, and recovery procedures. Assists Database Administrator 2 /...

Promoted
Wolters Kluwer
Oklahoma City, Oklahoma

The intent of the role is a SQL developer that will write/review/tune queries to support the teams developing the web application, as well as design schema for the OLTP and reporting databases and provide guidance and support as subject matter expert in SQL. Implement queries, procedures and databas...

Promoted
GovCIO
Oklahoma City, Oklahoma

GovCIO is currently hiring for a Database Developer to support the Pension Benefit Guaranty Corporation (PBGC) on addressing critical challenges in our application infrastructure by upgrading Oracle databases to version 19c, migrating databases to the Azure Cloud, and supporting the overall strategi...

Promoted
SMX Corporation
Oklahoma City, Oklahoma

Cloud Database Administrator (3559) (Secret)at SMX(View all jobs) ()United StatesSMX is seeking a Cloud Database Administrator to join our team. We are seeking a highly skilled and experienced Cloud Database Administrator (DBA) to join our team. Security + Minimum 5 years of experience as a Database...

Promoted
American Express Global Business Travel
Oklahoma City, Oklahoma

Proficient in using Excel databases, creating pivots and generally manipulating large data sets. Are you ready for the next step within GBT? This is an excellent opportunity to expand your knowledge and skills in the area of revenue optimization for our air and ground transportation content and work...

Promoted
ApTask
Oklahoma City, Oklahoma

Oracle/PostgreSQL/Aurora MySQL/ Aurora PostgreSQL Database on AWS. Candidate should possess hands-on experience in working on some of the relational and non-relational databases (Oracle/SQL Server/DB2/PostgreSQL/MySQL/Golden Gate/Data Guard) on AWS and/or on-prem infrastructure. Oracle experience in...

Promoted
ISN
Oklahoma City, Oklahoma

ISN is seeking a Database Administrator to support the Department of Housing and Urban Development with its Single Family - Data Analysis and Reporting Tool. SF-DART) in the development, installation, configuration, upgrading, administration, monitoring, maintenance, and security of databases and pe...