Sr. PL/SQL Developer supporting Analytics

Software Guidance & Assistance, Inc., (SGA), is searching for a Sr. PL/SQL Developer supporting Analytics for a contract assignment with one of our premier Healthcare services clients in Jacksonville, FL. (Hybrid schedule, requires 3 days in office)
Top Skills Needed:
Advanced/Complex SQL to support ELT development in RDBMS.
Strong Unix/Linux Shell scripting experience.
Extensive understanding of data warehousing concepts/features and extremely large volume batch data processing
Experience building stored procedures using complex SQL and PL/SQL required
Responsibilities :
Responsible for the development, programming, and coding of Information Technology solutions. They will engage in all phases of the software development lifecycle which include: gathering and analyzing user/business system requirements, responding to outages and creating application system models.
As an Oracle PL/SQL Developer, you will be a key member of the Database Group responsible for providing overall database support with concentration in back-end programming. The PL/SQL Developer will be responsible to properly maintain source code sets and necessary technical documentation and assist the DBA's in overall database maintenance. In this role, you'll leverage your knowledge of Oracle database development and be instrumental in the successful implementation of our browser-based, enterprise software product.

• Will work as a part of the SQL Development team by designing schema, tables, views, indexed views, developing stored procedures.
• Create complex queries, SSIS jobs and SSRS / Power BI Reports.
• Will be well versed with the latest T-SQL language features and have experience dealing with large volumes of data.

Required Skills:

• Related Bachelor's degree or related work experience.
• 5+ years related work experience, Professional experience with technical design and coding in the IT industry.
• Advanced/Complex SQL to support ELT development in RDBMS.
• Strong Unix/Linux Shell scripting experience.
• Extensive understanding of data warehousing concepts/features and extremely large volume batch data processing.
• Experience building stored procedures using complex SQL and PL/SQL required.
• Must possess expert programming and troubleshooting skills.
• Must possess expert performance tuning skills and dynamic SQL skills.
• Must be willing to jump into anyone's code at any time to solve the problem.
• Must be able to reverse engineer anyone else's code and be able to modify it to solve the problem in a better or more efficient way.
• Experience with Oracle Version 10g, 11g, 12c
• Strong experience with oracle functions, procedures, triggers, packages & performance tuning.
• Proficiency using versioning tools like Git.
• Ability to communicate technical information clearly and articulately.
• Ability to adapt to a rapidly changing environment.
• Experience with complex indexing strategies including column store indexing.

By applying for a job with SGA, you agree to allow SGA to process your application for this and future opportunities in accordance with our Privacy Policy. Also, to ensure timely processing, you agree to be contacted by our AI recruiter via email, text, or phone. Message frequency varies and data rates may apply, but you can reply STOP to any SMS message to opt-out of texts and may contact SGA at to opt-out of AI communications. The choice not to engage with AI will not adversely impact your consideration for placement. AI is not used to make any hiring determinations.
SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at .
SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company to request an accommodation or assistance regarding our policy.