TekSynap is seeking a Software Engineer to support the DOI BSEE TIMS contract in New Orleans, LA. The role involves managing offshore energy, minerals, and natural resources, promoting safety, protecting the environment, and conserving resources through regulatory oversight and enforcement. The company aims to leverage technology to meet the business needs of Federal Government customers.
Requirements
- 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-Sharp, Perl or other languages.
- Competent to work at a high level for all phases of system/database development.
- 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.
Responsibilities
- 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.
- 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.
Other
- Conduct meetings with Stakeholders to clarify and understand business requirements
- 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.
- Bachelor’s degree in Engineering/Computer Science or area related to the project’s functional requirement.
- DOI Background Investigation, Entry on Duty
