Pl/Sql Dba

Optimized Technical Solutions•Montgomery, AL

1d•Remote

About The Position

Optimized Technical Solutions (OTS) is seeking a PL/SQL Database Administrator to support ERP CS shared services environments and associated Oracle Cloud Infrastructure (OCI) migration efforts. The role develops, maintains, optimizes, and troubleshoots Oracle database procedures, functions, packages, and scripts to support database operations, application functionality, and migration activities. The DBA works closely with the DBA Lead, Mission Partner DBA team, ERP CS technical teams, and other stakeholders to support database performance, integrity, and operational readiness during migration and post-migration sustainment. The position is contingent upon award and requires U.S. citizenship and an active CompTIA Security+ certification maintained throughout employment. The work environment is an office environment, and occasional business travel may be required.

Requirements

Must be a U.S. citizen.
Must hold an active CompTIA Security+ certification and maintain it throughout employment.
Experience administering and supporting Oracle databases.
Experience configuring, administering, or supporting Oracle Enterprise Manager.
Working knowledge of OCI and database or monitoring-platform migrations.
Understanding of SQL, database performance tuning, backup and recovery, and database security.
Ability to troubleshoot issues and collaborate across technical teams.
Strong technical documentation and communication skills.

Responsibilities

Develop, maintain, and optimize PL/SQL procedures, functions, packages, triggers, and scripts for ERP CS database environments and application requirements.
Work with the DBA Lead and ERP CS technical teams to support database migration activities and associated OCI infrastructure requirements.
Support database migration planning, execution, validation, testing, and post-migration stabilization.
Analyze and troubleshoot PL/SQL code, SQL queries, database performance issues, and application-related database errors.
Support database integration and operational requirements across MilAUDIT, Oracle Enterprise Manager (OEM), and Oracle Single Sign-On (SSO-OAM, OIM, OUD) environments, as applicable.
Execute Oracle-provided tools and database scripts for migration, configuration, and operational activities.
Collaborate with System Integration Testing (SIT) and User Acceptance Testing (UAT) teams to identify, troubleshoot, and resolve database-related defects and support retesting.
Coordinate with Mission Partner teams, infrastructure teams, and product vendors to resolve technical issues and implement approved corrective actions.
Monitor and optimize database queries, stored procedures, and other PL/SQL components to ensure performance, reliability, and data integrity.
Develop and maintain technical documentation, database scripts, standard operating procedures, and operational runbooks for post-migration sustainment.
Communicate clearly, concisely, accurately, and promptly, verbally and in writing, and interact professionally with co-workers, management, and clients.
Undertake occasional business travel if required; only requested and approved expenses will be covered by OTS.