Sr. Software Engineer

Responsibilities & Qualifications

RESPONSIBILITIES

• Conduct meetings with Stakeholders to clarify and understand business requirements.
• Establish the high-level sprint schedule.
• 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.
• Proficient with software languages, such as HyperText Markup Language (HTML), JAVA, JavaScript, Python, CSS, SQL, NoSQL, C#, Perl or other languages as required.
• Competent to work at a high level for all phases of system/database development/management.
• Sets priorities to meet the needs of users.
• 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; and analysis of hardware/software issues.
• May direct the work of other developers.
• Core Tool Proficiency: Demonstrated experience developing reports and dashboards using:
  • Oracle BI Answers / Analysis Editor: Creating ad-hoc queries, visualizations, prompts, navigation, conditional formatting.
  • Oracle BI Dashboards: Building interactive dashboards, embedding analyses, managing dashboard pages and prompts.
  • BI Publisher: Designing and developing pixel-perfect, highly formatted reports (RTF templates, eText, bursting, scheduling). Must understand data models, layouts, and translation capabilities.
• RPD Modeling (Essential for Senior): Understanding and experience working with the Oracle BI Repository (.rpd file). This includes:
  • Understanding the three layers (Physical, Business Model & Mapping (BMM), Presentation).
  • Experience modifying the RPD (adding columns, creating aliases, basic joins). Advanced RPD skills (complex modeling, security implementation, optimization) are a big plus but basic modification is a minimum for senior report developers who need to understand the source.
• Strong SQL Skills: Ability to write, understand, and troubleshoot complex SQL queries. They need to validate data, understand query performance, and potentially use SQL within BI Publisher data models.
• Data Warehousing Concepts: Solid understanding of dimensional modeling (Star Schema, Snowflake Schema), Fact tables, Dimension tables, Hierarchies, and Slowly Changing Dimensions (SCDs). They need to understand the structures they are reporting against.
• Understanding of Oracle APEX development, including creating, designing, updating, documenting, and implementing logical and physical database changes ensuring data integrity and performance optimization.

REQUIRED QUALIFICATIONS

• DOI Entry on Duty (EOD) background check 
• Eight 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.
• Bachelor’s degree in engineering/computer science or area related to the project’s functional requirement.
• Proficiency in SQL, PL/SQL, and database design principles.
• Competence in Oracle Forms & Reports, Oracle Analytics Publisher and Oracle BI Reports.
• Familiarity of Oracle APEX development and database management.

DESIRED QUALIFICATIONS

• Understanding of database architecture.
• Proficiency in Git for efficient version control and collaboration on application code.
• Familiarity with REST and Web API services for integration, improving application connectivity, and functionality.
• Strong grasp of database architecture, SQL, PL/SQL, and datab