Database Administrator - DB2

Peraton•,

3d•$104,000 - $166,000•Remote

About The Position

Peraton is seeking a motivated and detail-oriented DB2 Database Administrator to support, maintain, and enhance database environments across business applications and platforms. The role covers database administration, development, installation, upgrades, troubleshooting, and production support in AIX and UNIX environments. It is a remote position.

Requirements

U.S. citizenship and the ability to obtain and maintain the required Public Trust clearance.
Must be willing to undergo a pre-employment credit check as required by the customer.
A bachelor's degree and 8 years of experience; an associate degree and 10 years; a master's degree and 6 years; or a high school diploma or equivalent and 12 years.
Experience administering and supporting IBM DB2 environments, including DB2 installation, configuration, upgrades, maintenance, and troubleshooting.
Knowledge of relational database concepts, database structures, and procedural programming.
Working knowledge of SQL, including writing and executing DDL, DML, and SQL statements.
Experience creating, modifying, and maintaining database objects, including tables, constraints, views, indexes, triggers, and stored procedures.
Basic understanding of database development concepts and SQL/PL/SQL programming.
Working knowledge of UNIX or AIX environments, including reading, troubleshooting, modifying, and testing shell scripts.
Ability to perform database administration tasks, including maintenance, troubleshooting, and software installation.
Understanding of database deployment processes and ability to develop and execute deployment scripts across multiple environments.

Nice To Haves

Experience supporting databases in AIX and UNIX operating system environments.
Experience writing and maintaining SQL and PL/SQL scripts for application development and database support.
Experience with database performance monitoring, tuning, and troubleshooting.
Familiarity with database change management, release management, and deployment processes across multiple environments.
Experience supporting production databases in an enterprise environment.
Knowledge of database backup, recovery, high availability, and disaster recovery concepts.
Experience working with application development teams and supporting moderately complex software applications.
Familiarity with enterprise operational procedures, change controls, and risk management practices.

Responsibilities

Perform administration, maintenance, and support for DB2 database environments.
Install, configure, upgrade, and maintain database software across AIX and UNIX environments.
Develop, modify, troubleshoot, and execute SQL, DDL, and DML scripts.
Create and maintain database objects, including tables, constraints, triggers, views, stored procedures, functions, and packages.
Read, troubleshoot, modify, and test UNIX shell scripts for database operations and application support.
Develop and maintain database deployment scripts for changes across development, testing, and production environments.
Coordinate with application development, technical support, configuration management, and database operations teams to implement database changes.
Provide production database support and troubleshoot issues to help ensure availability, stability, and reliability.