Oracle Database Expert

Company Overview:
Macalogic is a company with broad competencies based on over a decade of experience working in the federal arena. We are a Woman-Owned SBA-certified Small Business and an Economically Disadvantaged Woman-Owned Small Business (EDWOSB). We provide business consulting services to government clients in four primary areas: software development and IT-related consulting; program support; federal enterprise architecture; and compliance. In the commercial, Business-to-Business (B2B) arena, we provide management support services, including hardware, software, and network installation, troubleshooting, and management.
Our core values of accountability, collaboration, value, and respect are central to everything we do at Macalogic. As such, we are always open to talking to self-motivated and responsible team players who are focused on contributing to the success of our clients. We offer a generous benefits package and compensation commensurate with your experience and skill set.
General Description
The successful candidate will provide Oracle database expertise to the Air Force’s Program and Budget Enterprise System (PBES), supporting the program’s Sustainment Help Desk, software development, and sustainment efforts. The successful candidate will assist with the Sustainment Help Desk and support daily system operation of various components of Oracle’s EPM software solution, providing technical support to address system and data issues that inhibit production processing; perform and/or direct the performance of Oracle database and overall software installation, configuration, and troubleshooting across multiple instantiations, with direct focus on the databases and products of Oracle’s Hyperion Financial Management/EPM software solution, as well as business intelligence solutions using Oracle’s OBIEE data warehouse solution. In addition, the candidate will provide Oracle database expertise to the sustainment of the PBES Development and Test environments in AWS. Other activities will include performing data analysis and evaluation, developing data update strategies, performing data cleansing activities, performing data extraction, and performing data refreshes. Responsibilities further include performing and troubleshooting data migration, monitoring production database performance, and recommending and executing database performance tuning.
Duties and responsibilities
The successful candidate will support the Sustainment Help Desk, accepting user calls, performing root cause analysis, and both recommending and implementing data and technical solutions to address user issues. This includes developing and executing PL/SQL scripts, recommending and performing updates to the configuration and design of multiple databases associated with the Oracle EPM solution (DRM, Hyperion’s Oracle implementation, and OBIEE), performing maintenance, and patching of Oracle databases, and providing monitoring support to ensure that the production, test, and development environments are fully available. The candidate will be responsible for the quality control and auditing of databases to ensure accurate and appropriate use of data. They will consult with and advise users on access to various databases and work directly with users to resolve data conflicts and inappropriate data usage.
Specialized Knowledge

• Hands-on experience in upgrading Oracle database instances to Release 19c.
• Strong understanding of Oracle RDBMS architecture.
• Detailed understanding of relational database concepts.
• Experienced with Oracle software implementations and upgrades.
• Hands-on experience in database platform migration.
• Hands-on experience with scripting tools like Bash shell scripts, PL/SQL, and SQL.
• Experience with applying database security patches.
• Experience with automating database administration and maintenance activities.
• General understanding of the Linux operating system, security concepts, storage technologies, and networking.
• Experience with database performance tuning.
• Experience with database backup and recovery.
• Demonstrated experience in engineering performance and availability of solutions.
• Demonstrated ability to take initiative and manage problems independently.
• Demonstrated ability to manage and prioritize multiple tasks.

Education
Bachelor’s degree in computer science, management information systems, or related field.
Professional Certifications
An active CompTIA Security+ certification is required.
Clearance
An active U.S. Secret Security Clearance or the ability to obtain said clearance is required.
Experience
10 years as an Oracle DBA with production support experience, including Oracle 12c and 19c and Golden Gate 12.X, 18.x 19. x. In addition, a minimum of 7 years of experience with Oracle RAC, MySQL, Oracle PL/SQL, PostgreSQL, and Amazon RDS administration including installations and configurations.
U.S. Citizen or Similar
Must be a U.S. Citizen
Skills and Abilities
Experience with database management of Oracle databases.
Other Characteristics (e.g., Personal or Language)
Must be a self-starter with the ability to manage work efforts with minimal leadership oversight. Must also have excellent time-management skills as well as excellent oral, written, organizational, documentation, and communication skills. Must have the ability to provide accurate and realistic effort estimates, commit, and deliver accordingly. Must be able to work in a team environment with personnel from other companies, government program management and administrative personnel, and technical staff members.
Working conditions, including location
The Pentagon, Washington DC with occasional ability to work remotely.
Client duty hours are Monday through Friday.