Senior Oracle Developer Consultant

Unlock Employer Cary, NC Contract Live

Required Skills

My Compatibility Score

Choose Match Score option:

Database Developer with Expert knowledge of the Oracle Database technologies as a whole. Experience in working with big volumes of data is a must Solid experience in design and development of enterprise-level database applications using PL/SQL Programming Knowledge of the following Oracle Database features: query optimization (executions plans, hints, indexes, etc.), partitioning, replication, materialized views, analytical functions. Demonstrably solid software engineering skills and willingness to learn new technologies. Basic knowledge of Unix and Shell Scripting Basic knowledge of Java will be an advantage. Knowledge of the financial industry will be an advantage. The successful candidate must be able to work as part of the team. Tasks / Key Responsibilities: 1. Develop new data feeds for internal and external upstream source systems and businesses. 2. Update existing feeds in accordance with latest upstream system changes. 3. Implement data transformation/enrichment logic. 4. Performance optimization. 5. Implement unit tests (SQL, Java) 6. Participate in requirements analysis, design, development and code reviews 7. Provide third level technical support function to assist SL1/SL2 support teams to resolve complex issues Additional Skills: Expert knowledge of the Oracle Database technology as a whole. Knowledge of the following Oracle Database features: query optimization (executions plans, hints, indexes, etc.), partitioning, replication, materialized views, analytical functions. Work experience in design and development of database applications using PL/SQL Programming. Experience working with DWH/ETL/OLAP. Ability to write complex SQL queries involving multiple tables and using sub-queries, analytical functions, hierarchical queries, etc. Ability to investigate complex database issues, identify slow-running SQL and PL/SQL code and optimize it. Excellent oral and written communication skills. Excellent problem analysis and creative solution capabilities. Basic knowledge of Unix and Shell Scripting. Basic knowledge of Java will be an advantage. Ability to work independently, be a self starter and to be a team player. Proven track record of delivery Background in the Financial Services industry Education / Certification (Recommended) Degree level &/or relevant practical experience read more