Db Developer (Oracle & Postgres)

Bob Title: DB Developer (Oracle & Postgres)

Location: Scottsdale, AZ and Bloomfield, CT (On-Site)

Duration: 12 Month Contract

Start Date: ASAP

Job Details-

Responsibilities:

‒ Analyze business requirements, propose, design and implement technical solutions

‒ Responsible for design and development of data architecture and ETL dataflows 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

Required Qualifications:

‒ 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