Job Description
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 five primary areas: software development and IT-related consulting; cyber security, 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 “Building Trust”, “Showing Up”, “Owning It”, “Getting Better”, and “Serving Others” are central to everything we do at Macalogic. 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 and administration for the Air Force’s Job Order Cost Accounting System (JOCAS) and the Comptroller Financial Information System (CFIS) at Patrick AFB, FLA and Vandenburg AFB, CA. The successful candidate will have a deep understanding and level of expertise with Oracle 12 and 19c; provide database management and technical support to address system, database, and data issues that inhibit production processing; perform Oracle database installations and patching; provide knowledge and expertise surrounding product configuration; and perform troubleshooting across multiple instantiations.
Duties and Responsibilities: The successful candidate will support multiple production environments. This includes monitoring daily operations, performing critical Oracle patching, supporting/performing operating system patching, and providing daily troubleshooting to ensure high availability of the databases and associated applications. The candidate will also develop and execute PL/SQL scripts, perform data modeling and evaluate database changes based on functionality updates, and recommend and perform updates to the configuration and design of multiple databases. 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, ensure proper data loading from external target systems, monitor databases and application performance, and perform tuning of the application and database as necessary.
Specialized Knowledge: - Experience and expertise performing in a technical environment that includes web-based applications, Oracle Databases, Windows servers, and UNIX servers.
- Hands-on experience in Oracle EBS database management systems with emphasis on Oracle R12c and above.
- Knowledge and experience providing operations and management support for Oracle Servers which includes installation, patches, backups, modifying scripts for data and performance testing.
- Expertise in Oracle Critical upgrades, Operating System upgrades, quarterly patches, and application upgrades.
- Expertise in the extraction, loading, and verification of data to target databases.
- Knowledge and expertise in emergency system service outage troubleshooting.
- Support database configuration, monitoring, and tuning.
- Knowledge of PKI Certificates and implementation.
- Experience with database backup and recovery.
- Demonstrated experience in engineering performance and availability of solutions.
- Demonstrated experience with Air Force/DoW Comptroller Financial Management processes/procedures and data.
- Knowledge and experience with maintaining LOUIS II and Oracle scripts, loading data, and testing and making data corrections as necessary.
- Supporting ad hoc queries and maintaining queries on a regular basis.
- Experience with ensuring the integrity of data inputs, performing research, and providing answers to questions asked by users concerning production data.
- Experience performing research and resolving data discrepancies between source and target systems.
Education: Bachelor’s degree in computer science, management information systems, Engineering, or related field .
Professional Certifications: An active CompTIA Security+ or equivalent certification is required.
Clearance: Must either possess or be able to obtain a secret security clearance.
Experience: 3+ years as an Oracle DBA, supporting R12c or higher. In addition, experience with Air Force/DoW financial management data is a plus.
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 have excellent analysis and problem-solving skills. Must also have excellent time-management skills as well as excellent oral, written, organizational, documentation, and communication skills. Must be able to work in a team environment with members that include personnel from other companies, Government program management and administrative personnel, and technical staff members.
Working Conditions, Including Location: On-site.
Client duty hours are Monday through Friday, with the potential need to provide surge support during year-end financial processing.
Salary: 120 – 130K
Job Tags
Full time, Monday to Friday