Oracle Database Developer

What are we looking for in our Oracle Database Developer?

Contract: 6 months with strong possibility of extension

Pay-rate: $60-65/hour on W2

This is a Hybrid/ Onsite role

Job Description:

Client is seeking a talented professional with a proven track record of engineering and operationalizing a next generation analytics solution suite using Oracle PL/SQL, Cloud (AWS), and Big Data Technologies. The ideal candidate will leverage deep technical expertise and strong communication skills to deliver both invest and maintenance projects within the Enterprise portfolio.

Responsibilities include but are not limited to:

• Ability to create, troubleshoot, enhance complex ETL like Oracle PL/SQL code packages
• Ability to lead and operate in cloud environment involving AWS, Snowflake and migrate data assets to cloud
• Data integration and experience in distributed data systems – expert to effectively linking, transforming and transferring of data between multiple applications on Prem or Cloud-based
• Formulates logical statements of business problems and devises, tests and implements efficient, cost effective application program solutions (e.g., codes and/or reuses existing code through the use of program development software alternatives and/or integrates purchased solutions)
• Analyzes existing system and programming logic to provide more efficient machine operations or to identify difficulties, and revises the logic and procedures involved as necessary
• Possesses functional knowledge and skills reflective of a competent practitioner with the ability to deliver on work of highest technical complexity
• Researches and evaluates alternative solutions and recommends the most efficient and cost effective solution for the systems design
• Support and quickly respond to Production issues and requirements clarifications
• Coordinate as needed between multiple disciplines such as, Architects, Business Analysts, Scrum Masters, and Developers to get technical clarity leading to design, develop and implementation of business solution.
• Oversight of quality and completeness of detailed technical specifications, solution designs, and code reviews as well as adherence to the non-functional requirements.

Qualifications:

• Bachelor’s degree in Computer Science or a related discipline and 7 or more years’ experience in IT systems analysis and application program development, or an equivalent combination of education and work experience
• 6+ years strong Database Developer experience using Oracle PL/SQL – stored procedures, packages, functions, querying, testing, and deploying
• 1-3 years experience of migrating assets to cloud - AWS and Snowflake environment
• 5+ years of data analysis, manipulation and development
• 1+ years of experience in the insurance or investment industry
• Strong SQL skills
• Knowledge of Oracle, Unix/Linux Shell scripting, Autosys scheduling tool, Sub-Version, and Github /Jenkins (CI/CD) version control Tools
• Strong data warehouse applications knowledge in financial/insurance domain
• Knowledge of Data Modeling and Database design is key to this role
• Ability to design, implement, and oversee ETL processes
• Familiarity with emerging data centric technologies such as data virtualization
• Ability to choose and effectively utilize data wrangling technologies
• Exposure to cloud, Python/ Pyspark, Shell Scripting (e.g. AWS, S3, UNIX, Python, Snowflake, etc.) and learning/adapting to future technologies is preferred but not required.

Benefits Info

Russell Tobin offers eligible employee’s comprehensive healthcare coverage (medical, dental, and vision plans), supplemental coverage (accident insurance, critical illness insurance and hospital indemnity), 401(k)-retirement savings, life & disability insurance, an employee assistance program, legal support, auto, home insurance, pet insurance and employee discounts with preferred vendors.

#LI-GB1
#CB

Rate/Salary: $60-65/hour on W2