Oracle Apex Software Engineer

BOEM and BSEE are responsible for managing the nation’s offshore energy, minerals, and natural resources on the Federal Outer Continental Shelf (OCS). BSEE promotes safety, protects the environment, and conserves resources offshore through vigorous regulatory oversight and enforcement. BOEM manages the responsible exploration and development of offshore energy and marine mineral resources on the OCS. OCS production accounts for about 18 percent of domestic crude oil and four percent of domestic natural gas supply.


RESPONSIBILITIES

Conduct meetings with Stakeholders to clarify and understand business requirements
Create, design, update, document and implement logical and physical database changes.
Design and implement design solutions based on industry best practices.
Utilize existing SOA services where feasible. build new SOA services, APIs and microservices when applicable and ensure the code is modular, re-usable, and portable.
Modify or write new on-line programs, unit test cases, batch programs, interfaces, configuration changes, and reports. Build unit tests and integration tests as necessary.
Ensure proper exception handling and appropriate logging.
Identify and resolve information assurance weaknesses and vulnerabilities.
Perform peer code reviews and ensure automation build failures resulting from code issues are resolved.
Collaborate closely with end users and administrators to gain an understanding of their data needs, proactively optimize database performance, and uphold data quality standards.
Document database architecture, configurations, and processes to ensure that knowledge is well-documented and can be easily transferred to other team members.
Develop and maintain Extract, Transform, Load (ETL) processes to move, transform, and load data from various sources into the database, ensuring data consistency and quality.
Formulates/defines system scope and objectives.
Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations.
Prepares detailed specifications from which programs will be written.
Designs, codes, tests, debugs, and documents programs.
Participates in related areas, such as such as design, implementation, integration, management, and maintenance of complex databases, with respect to the operating system, access methods, access time, device allocation, validation checks, organization, protection and security, documentation, guidelines, and statistical methods
Evaluation of commercial off-the-shelf (COTS) products
Analysis of hardware/software issues.
May provide guidance to other developers.

REQUIRED QUALIFICATIONS

Five years of technical experience in applications software development, three of which are in systems analysis, and 1 year of which is acting as technical lead.
Knowledge of software languages such as APEX, HTML, Python, PL/SQL, SQL, C#, Perl or other languages.
Competent to work at a high level for all phases of system/database development.
Bachelor’s degree in Engineering/Computer Science or area related to the project’s functional requirement.
DOI Background Investigation, Entry on Duty

DESIRED QUALIFICATIONS

Use of proven, efficient methodologies to support the Oracle and Structured Query Language (SQL) databases
Experience with PL/SQL package and stored procedures
Experience in design and development of comprehensive database schemas, encompassing tables, views, indexes, triggers, stored procedures, functions, and other essential objects.
Experience optimizing SQL queries and integrating data across various systems and applications.
Experience developing and maintaining Extract, Transform, Load (ETL) processes to move, transform, and load data from various sources into the database, ensuring data consistency and quality.

We are seeking a Software Engineer to join our team supporting DOI BSEE TIMS contract in New Orleans, LA.

TekSynap is a fast growing high-tech company that understands both the pace of technology today and the need to have a comprehensive well planned information management environment. “Technology moving at the speed of thought” embodies these principles – the need to nimbly utilize the best that information technology offers to meet the business needs of our Federal Government customers.


We offer our full-time employees a competitive benefits package to include health, dental, vision, 401K, life insurance, short-term and long-term disability plans, vacation time and holidays.

Visit us at www.TekSynap.com.

Apply now to explore jobs with us!

The safety and health of our employees is of the upmost importance. Employees are required to comply with any contractually mandated Federal COVID-1+ requirements. More information can be found here.

By applying to a role at TekSynap you are providing consent to receive text messages regarding your interview and employment status. If at any time you would like to opt out of text messaging, respond "STOP".