What are the responsibilities and job description for the Oracle SQL Developer position at Beacon Systems, Inc?
Job Details
About Beacon Systems, Inc
Beacon Systems, Inc, delivers Program Management, Science, Engineering, and Technology Solutions to Federal, Commercial State, and Local Agencies. We are a subsidiary of Radiant Digital Services. We have a vast portfolio of clients across the country. Our Technology support to many DoD Agencies, NASA, Voice of America, FDA, and State Agencies such as State of FL, RI, MS, ND, VA, and WV extends our delivery of solutions worldwide.
Position: Oracle SQL Developer
Duration: 4 Months
Location: : Providence, RI (Onsite).
Minimum Qualifications:
Database and Programming Proficiency:
- Minimum of 8 - 10 years of experience with Oracle databases, capable of writing complex SQL queries and developing complex PL/SQL objects, including DML and DDL.
- Strong experience with database and SQL performance tuning.
- Proficient in data modelling and data visualization tools (Preferred Tableau/Power BI)
- Working knowledge of ETL practices (Extract, Transform, and Load) (Preferred - Informatica, Pentaho)
- Excellent understanding of database management systems (DBMS)
- Strong troubleshooting debugging skills with complex DML
- Expert level SQL querying and database manipulation with very large data sets
- Ability to debug and troubleshot logical and functional coding errors
Development Tools and Methodologies:
- Familiarity with code repositories, ideally Git.
- Experience with continuous integration tools, preferably Jenkins.
- Knowledge of relational database designs, ISDM methodologies, database security (role-based), and query tools like TOAD, SQL Developer, or SQL Navigator.
Technical and Analytical Skills:
- Proficiency in Unified Modeling Language (UML) for documenting system architecture.
- Ability to solve complex problems creatively and anticipate issues with software designs or specifications.
- Excellent interpersonal skills to establish effective working relationships, collaborate with team members, and communicate technical concepts clearly.
Preferred Knowledge, Skills & Abilities:
- 5 Years of Integrated Eligibility/Healthcare domain experience. Experience developing reports submitted to federal agencies. (SNAP/TANF/Medicaid)
- Design, Develop, Maintain, and support of various database-driven reporting initiatives
- Strong Data Validation, Quality Assurance, and Referential Integrity skills
- Experience with Enterprise Workflow Management Tools such as JIRA and ServiceNow
- Advanced Understanding to Data Visualization Technologies such as Tableau
Certifications and Agile Practices:
- Oracle certification(s) are a plus.
- Familiarity with Agile methodologies, particularly Scrum, XP, and Kanban.
Web and Front-End Development:
- Experience in XML, CSS, and JavaScript frameworks (such as JQuery, AngularJS, NodeJS, or React) for web development.
Industry Knowledge:
- Experience with environmental regulatory processes is beneficial.
- Understanding of the client's technical environment will be advantageous.
- Bachelor s degree in information technology, Data Analytics, Computer Science with 8 -10 years of relevant experience
Compensation:
Compensation for roles at Beacon Systems Inc depending on a wide array of factors including, but not limited to, the specific office location, role, skill set, and level of experience. As required by applicable law, BeaconGov provides reasonable range of compensation for this role.
EEO Statement:
Beacon Systems is dedicated to fostering an inclusive and diverse work environment. We ensure equal employment opportunities for all individuals, regardless of their race, color, religion, gender, national origin, age, disability, or any other legally protected characteristic. Our commitment to being an equal-opportunity employer extends across all aspects of employment, from recruitment and hiring to promotions and benefits. We firmly believe in treating all employees and applicants fairly, based on their qualifications, skills, and performance.
