What are the responsibilities and job description for the Sr. PL/SQL Developer supporting Analytics position at Software Guidance & Assistance?
Job Details
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.
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.
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.
- 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 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
