Database Administrator - DB2
Description
Peraton Overview
Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can’t be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we’re keeping people around the world safe and secure.
Responsibilities
Peraton is seeking a motivated and detail-oriented DB2 Database Administrator to join our Team. This person will be responsible for supporting, maintaining, and enhancing database environments across various business applications and platforms. This role involves performing database administration, development, installation, upgrades, troubleshooting, and production support within AIX and UNIX environments.
Work Location: This is a remote position
What You Will do:
- Perform database administration, maintenance, and support for DB2 database environments across various business
- Install, configure, upgrade, and maintain database software across AIX and UNIX
- Develop, modify, troubleshoot, and execute SQL, DDL, and DML scripts to support moderately complex
- Create and maintain database objects, including tables, constraints, triggers, views, stored procedures, functions, packages, and other database
- Read, troubleshoot, modify, and test UNIX shell scripts to support database operations and application
- Develop and maintain database deployment scripts to support changes across development, testing, and production
- Coordinate with application development, technical support, configuration management, and database operations teams to implement database changes and
- Provide ongoing production database support, troubleshooting issues, and helping ensure database availability, stability, and reliability.
Qualifications
Basic Qualifications
- U.S. Citizenship required with the ability to obtain and maintain the required Public Trust level clearance.
- Must be willing to undergo a pre-employment credit check as required by the Customer.
- Bachelors Degree and 8 years of experience; an Associates Degree and 10 years of experience, a Masters Degree and 6 years of experience, or a High School Diploma or equivalent and 12 years of experience
- Experience administering and supporting IBM DB2 database environments as well as DB2 database installation, configuration, upgrades, maintenance, and troubleshooting.
- Knowledge and understanding of relational database concepts, database structures, and procedural
- Working knowledge of SQL, including the ability to write and execute DDL, DML, and SQL statements to support application
- Experience creating, modifying, and maintaining database objects, including tables, constraints, views, indexes, triggers, stored procedures, and
- Basic understanding of database development concepts and SQL/PL/SQL programming
- Working knowledge of UNIX or AIX environments, including the ability to read, troubleshoot, modify,and test shell
- Ability to perform database administration tasks, including database maintenance, troubleshooting, software installation, and
- Understanding of database deployment processes and the ability to develop and execute deployment scripts across multiple
Preferred Qualifications:
- Experience supporting databases within 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.
Target Salary Range
$104,000 - $166,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual’s experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.Benefits Statement
Peraton offers eligible employees a variety of benefits including medical, dental, vision, life, health savings account, short/long term disability, EAP, parental leave, 401(k), paid time off (PTO) for vacation, and company paid holidays. A full listing of available benefits can be viewed at https://www.careers.peraton.com/benefits.