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

DOI Background Investigation, Entry on Duty
Bachelor’s degree in Engineering/Computer Science or area related to the project’s functional requirement.
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.

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.

WORK ENVIRONMENT AND PHYSICAL DEMANDS

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of the job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

Location: New Orleans, LA - remote locations may be considered within the United States
Type of environment: Office, Telework may be available
Noise level: (Low-Medium)
Work schedule: Schedule is day shift Monday – Friday. May be requested to work evenings and weekends to meet program and contract needs.
Amount of Travel: Less than 10%