Sr. SQL PL/SQL Developer (with BPM experience)

California  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

Job Description:
The senior database developer will be responsible for database design, data modelling, Oracle PL/SQL development including stored procedures, triggers, views etc., and SQL performance tuning. The individual will hold the primary responsibility for all database development work, interfacing with the DBA team, and working closely with the other developers, QA and the project manager.

Responsibilities/Duties:
§ Understand business requirements and work with other members of the team to model, design and implement new data models and make improvements to existing data models
§ Develop SQL, PL/SQL programs, and scripts to support various data operations required by applications.
§ Optimize performance by analysing query patterns and building appropriate indexing and partition mechanisms.
§ Manage database artifacts in source code management system and deploy to DEV, QA, and Production environments.
§ Analyze issues & fix defects during SDLC, troubleshoot production issues, and respond to business users data inquiries.
§ Produce database design documents, test plans, and system requirements.
Competencies:
§ Minimum 8 years intensive hands-on data modelling and database design experience for enterprise applications.
§ Minimum 8 years of intensive SQL and PL/SQL programming experience.
§ Minimum 4 years experience with performance turning - query optimization, indexing, partitioning etc.
§ Familiar with UNIX and Windows development environments and various Scripting languages eg PERL and Autosys.
§ Familiar with source code management and deployment tools such as SVN, CVS, ANT.
§ Familiar with IT SDLC methodology and best practices.
§ Prior financial services and investment management experience is a plus.
§ Familiarity with Business Process Management (BPM) systems is a plus.
§ Highly self-motivated, results oriented, and capable of independent and critical thinking and problem solving

Academic Qualifications (minimum requirements):
§ B.S. or equivalent education in computer science or engineering is required. Advanced degree is preferred.
§ Oracle Certification is a plus

Start date
ASAP
Duration
12 months
From
Generic Network
Published at
17.11.2011
Project ID:
269287
Contract type
Freelance
To apply to this project you must log in.
Register