Current Openings

Oracle PL/SQL Developer

Bloomfield, CONNECTICUT |
Post Date: 02/03/21
Job ID: 21-00108
Job Type:

Job Description

 

Job Responsibilities:

 

  • Analyze business requirements, propose, design and implement technical solutions
  • Responsible for design and development of data architecture and ETL data-flows in support of enterprise risk management, analytics and reporting
  • Work effectively with the DBA teams to ensure that all approved development and deployment procedures are followed.
  • Provide production support from development teams for existing systems, troubleshoot data and/or system issues
  • Identify root causes and resolve data related issues
  • Review and optimize query performance

 

 

Skills and Experience Required:

 

Required

  • Extensive experience with database development tools (Oracle, Toad), ETL and integration technologies
  • Experience developing large scale systems
  • Experience developing interfaces to Oracle or other SQL-based databases
  • Experience working in controlled development, testing and production environments
  • Experience in Data Modeling, Data Warehousing, PL/SQL, ETL processing
  • Familiarity with development toolkits & source repositories SVN/GIT etc.
  • Sound understanding of RDBMS
  • Strong written and oral communication skills
  • Excellent problem-solving and quantitative skills
  • Aptitude for debugging problems in complex, unfamiliar code
  • Demonstrated ability to work as part of a team
  • Solid work ethic, self-driven with the ability to work with minimal supervision
  • Implement and maintain the database design
  • Create database objects (tables, indexes, etc.)
  • Write database PLSQL Packages, procedures, functions and triggers
  • Assist team members (Developers/QA/devops) with database activities
  • Tune database queries
  • Monitor application related jobs and data replication activities