Database Administrator – DB2

This is a fully remote position, open to applicants in United States.

📋 Description

• Assist in supporting, maintaining, and improving DB2 database environments across multiple business applications and platforms.

• Conduct database administration, development, installation, upgrades, troubleshooting, and production support within AIX and UNIX environments.

• Provide database administration, maintenance, and support for DB2 database environments.

• Install, configure, upgrade, and sustain database software on AIX and UNIX systems.

• Create, modify, troubleshoot, and execute SQL, DDL, and DML scripts.

• Develop and manage database objects, such as tables, constraints, triggers, views, stored procedures, functions, and packages.

• Read, troubleshoot, modify, and test UNIX shell scripts.

• Create and uphold database deployment scripts across development, testing, and production environments.

• Collaborate with application development, technical support, configuration management, and database operations teams to implement database changes.

• Provide continuous production database support and troubleshooting to help ensure database availability, stability, and reliability.

⛳️ Requirements

• U.S. Citizenship is required.

• Ability to obtain and retain the necessary Public Trust level clearance.

• Must complete a pre-employment credit check as mandated by the Customer.

• Bachelor’s Degree with 8 years of experience; Associate’s Degree with 10 years of experience; Master’s Degree with 6 years of experience; or High School Diploma or equivalent with 12 years of experience.

• Experience in administering and supporting IBM DB2 database environments.

• Proficiency with DB2 database 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 in creating, modifying, and maintaining database objects, including tables, constraints, views, indexes, triggers, stored procedures, and packages.

• Basic understanding of database development concepts and SQL/PL/SQL programming.

• Familiarity with UNIX or AIX environments, including reading, troubleshooting, modifying, and testing shell scripts.

• Capability to perform database administration tasks, including maintenance, troubleshooting, software installation, and configuration.

• Understanding of database deployment processes and ability to develop and run deployment scripts across various environments.

• Preferred: experience in supporting databases within AIX and UNIX operating system environments.

• Preferred: experience in writing and maintaining SQL and PL/SQL scripts.

• Preferred: experience with database performance monitoring, tuning, and troubleshooting.

• Preferred: familiarity with database change management, release management, and deployment processes.

• Preferred: experience supporting production databases in an enterprise setting.

• Preferred: knowledge of database backup, recovery, high availability, and disaster recovery concepts.

• Preferred: experience collaborating with application development teams and supporting moderately complex software applications.

• Preferred: familiarity with enterprise operational procedures, change controls, and risk management practices.

🏝️ Benefits

• Medical insurance.

• Dental insurance.

• Vision insurance.

• Life insurance.

• Health savings account.

• Short-term disability.

• Long-term disability.

• Employee assistance program (EAP).

• Parental leave.

• 401(k).

• Paid time off (PTO) for vacation.

• Company paid holidays.

• Eligible employees may qualify for overtime, shift differential, and a discretionary bonus in addition to base pay.