Oracle DBA Application Database Administrator

Rockville, MD

About the position

Savantage Solutions is seeking an Oracle Application Database Administrator (DBA) to join our high-quality team that delivers innovative solutions to our federal clients. The Oracle DBA maintains our proprietary Oracle-based financial software product, Altimate®. The position will support software maintenance of the database and application servers including installation, upgrades, and patching as well as support all Altimate application-related aspects of development, unit testing, integration testing, and production deployment.

Responsibilities

• Perform installation, configuration, upgrade, and patching of Oracle Fusion Middleware software including Java, WebLogic 12c, WebLogic 14c, Forms/Reports, OID, OAM, ORDS and Oracle HTTP Server.
• Perform installation, configuration, upgrade, and patching for Oracle Database software including ORDS and APEX.
• Perform application file system and database backup, restore, recovery, replication, and cloning.
• Monitor and proactively tune-up database and application performance.
• Perform root cause analysis for issues, develop resolution strategies, and address issues timely.
• Contribute to analysis on objectives such as capacity, availability, scalability, security, data migration, and disaster recovery planning.
• Collaborate with other teams, vendors, and customers to ensure project goals and milestones are achieved.
• Create and maintain Windows and Linux shell scripts.
• Create and maintain standard operation procedure documentation.
• Prepare timely Status Reports.

Requirements

• 5+ years of experience in database development and support.
• 3+ years of experience in Oracle Fusion Middleware Administration.
• Strong working knowledge of Oracle 19c Database Management System (DBMS) including Multitenant, ORDS and APEX management.
• Experience with Oracle APEX application deployment methods.
• Experience with Oracle Forms/Reports 12c Administration and deployment.
• Experience with Oracle Reports, APEX, OID and OAM SSO configuration.
• Experience with APEX application performance tuning and debugging.
• Experience with Oracle WebLogic server and HTTP server administration.
• Experience WebLogic application High Availability configuration.
• Experience using PL/SQL, SQL*Plus, SQLC and SQL-Developer tools etc.
• Experience with Data Pump, SQL*Loader and backup and recovery tools and methods such as RMAN utility.
• Monitor and tune database performance-related issues.
• Strong analytical and problem-solving skills.
• Able to work independently and within a collaborative team-oriented environment using sound judgment and decision-making.
• Excellent communication skills, both verbal and written.
• Must be a United States (U.S.) Citizen.
• Must be able to obtain a Public Trust Clearance.

Nice-to-haves

• Experience with Windows 2016, Windows 2019, Oracle Enterprise Linux, Red Hat Linux etc.
• Experience with Web application development using Oracle APEX.
• Experience with Oracle Enterprise Management tools.
• Oracle Fusion Middleware Forms and Reports server administration.
• Experience with Cloud Technologies such as Oracle Cloud (OCI) or Amazon Cloud (AWS).
• Experience DevOps, CI/CD methodologies and tools like Terraform and Git.
• Understanding OAM SSO Federation with Microsoft ADFS using SAML is a plus.
• Experience with Oracle OBIEE/Analytics and BI Publisher.
• Experience Oracle Financials E-Business Suite (EBS) 12.