Oracle Apex Software Engineer

BOEM and BSEE are responsible for managing the nations 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 reusable and portable.
• Modify or write new online 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 welldocumented 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 offtheshelf (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.
• Bachelors degree in Engineering/Computer Science or area related to the projects 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 hightech 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 fulltime employees a competitive benefits package to include health dental vision 401K life insurance shortterm and longterm disability plans vacation time and holidays.

Visit us at www.TekSynap.

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 COVID19 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.

COMPETENCIES

• Establish Focus
• Change Management
• Develop Others
• Oral Communication
• Written Communication
• Interpersonal Awareness
• Build Relationships
• Analytical Thinking
• Conceptual Thinking
• Strategic Thinking
• Technical Expertise
• Initiative
• Foster Innovation
• Results Oriented
• Teamwork
• Customer Service

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
• Type of environment: Office Telework may be available
• Noise level: (LowMedium)
• 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

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job the employee is regularly required to use hands to handle feel touch; reach with hands and arms; talk and hear. The employee is regularly required to stand; walk; sit; climb or balance; and stoop kneel crouch or crawl. The employee is regularly required to lift up to 10 pounds. The employee is frequently required to lift up to 25 pounds; and up to 50 pounds. The vision requirements include close vision distance vision peripheral vision depth perception and ability to adjust focus.

WORK AUTHORIZATION/SECURITY CLEARANCE

Positions require a DOI Entrance on Duty (EOD)

OTHER DUTIES

Please note this job description is not designed to cover or contain a comprehensive listing of activities duties or responsibilities that are required of the employee for this job. Duties responsibilities and activities may change at any time with or without notice.

EQUAL EMPLOYMENT OPPORTUNITY

In order to provide equal employment and advancement opportunities to all individuals employment decisions will be based on merit qualifications and abilities. TekSynap does not discriminate against any person because of race color creed religion sex national origin disability age genetic information or any other characteristic protected by law (referred to as protected status). This nondiscrimination policy extends to all terms conditions and privileges of employment as well as the use of all company facilities participation in all companysponsored activities and all employment actions such as promotions compensation benefits and termination of employment.