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.

Oracle PL-SQL, Oracle PL-SQL, Healthcare, Contract Analysis, SQL (Structured Query Language), Relational Databases (RDBMS), Linux Operating System, Unix Shell Programming, Data Warehousing, Data Processing, * 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.

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 https://sgainc.com/ .