Oracle PL/SQL Consultant w/ OFSAA

Back to job search
  • Location:

    Forest Acres

  • Job type:

    Contract

  • Job ref:

    373255

  • Published:

    about 1 month ago

  • Duration:

    12 months plus

  • Expiration date:

    06/25/2022

  • Start date:

    ASAP

Job Summary:

Signature Consultants is seeking a Oracle PL/SQL Developer with an opportunity with a client located in Charlotte, NC.


Responsibilities, and Requirements:

  • Involve in creating and managing tables, indexes, db links and privileges
  • Coordinate with DBA in creating and managing tables, indexes, table spaces, auditing and data quality checks
  • Used subversion tools, SVN version management to manage various versions of the procedures and functions of the application
  • Coordinate with the team of java developers to accomplish complex financial calculations
  • Schedule jobs to automate different database relate activities including backup, monitoring database health, disk space, backup verification
  • Work on the oracle SQL queries and PL/SQL objects like functions, procedures, packages, triggers, views, cursors
  • Implement procedures to install and deploy large numbers of Linux / Unix servers
  • Create database tables, create various db queries and assist in data mapping/testing activities in support of project
  • Modify and develop new scripts in LINUX to provide the same functionality as that are provided in UNIX
  • Develop Perl and shell scripts for parsing the incoming file's data and loading them into the database
  • Develop and optimize database structures, store procedures, dynamic management views, DDL triggers and user define functions
  • Develop complex PL/SQL packages, procedures, functions for the application, according to business requirements in UNIX and windows environments
  • Modify, maintain and develop PL/SQL codes for new customer requirements which involve cursors, functions, procedures triggers and collections
  • Develop load processes and data warehouse integration ETL procedures
  • Perform data modeling and create/maintain and modify complex database triggers and data migration scripts



Required Skills:

  • PL/SQL Oracle Developer- needs to be able to do performance tuning
  • Ideally will have OFSAA tool experience (Oracle Financial Services Analytical Applications) - ex BASAL
  • Strong Communication Skills
  • Financial experience is a must have for this role

Desired:

  • Agile experience so that is helpful to have

About Signature Consultants, LLC

Headquartered in Fort Lauderdale, Florida, Signature Consultants was established in 1997 with a singular focus: to provide clients and consultants with superior staffing solutions. For the ninth consecutive year, Signature was voted as one of the "Best Staffing Firms to Work For" and is now the 14th largest IT staffing firm in the United States (source: Staffing Industry Analysts). With 28 locations throughout North America, Signature annually deploys thousands of consultants to support, run, and manage their clients' technology needs. Signature offers IT staffing, consulting, managed solutions, and direct placement services. For more information on the company, please visit www.sigconsult.com. Signature Consultants is the parent company to Hunter Hollis and Madison Gunn.

EEO Employer

Signature Consultants is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Signature will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or 888.838.1020.