Required Strong working knowledge in Oracle RDBMS, PL/SQL and SQL.
Required Strong knowledge on Performance tuning, explain plan, TKPROF and Hints.
Required Strong working knowledge on Procedures, triggers, functions, packages and other database objects
Required - Experience in writing complex SQL queries.
Required Working knowledge on Oracle collections, Record type and bulk processing.
Job Responsibilities
Provide production support for the exchange and medical partner business troubleshooting, review logs, review existing stored procedures, make modifications to handle different situations as necessary
Develop, enhance PL/SQL programs and complex SQL queries for large scale applications.
Review and optimize applications/query performance.
Review and analyze production data and write necessary scripts for data manipulation.
Debugging the existing interface jobs and providing necessary support.
Work with the technical team members to perform design/code reviews, follow change control processes to take quality code to production
Be disciplined about maintaining source code control and versioning; adhere to strict process to check-in/checkout, regardless of the dynamic nature of the environment
Work with Offshore teams to provide/clarify requirements, support code development offshore, participate in and contribute to best practices, appropriately support the implementation of developed software
Skills:
Required Strong working knowledge in Oracle RDBMS, PL/SQL and SQL.
Required Strong knowledge on Performance tuning, explain plan, TKPROF and Hints.
Required Strong working knowledge on Procedures, triggers, functions, packages and other database objects
Required - Working knowledge on table partitioning, materialized views and analytical functions.
Required - Experience in writing complex SQL queries.
Required - Able to debug and understand existing stored procedures and make necessary changes.
Required Working knowledge on Oracle collections, Record type and bulk processing.
Preferred Knowledge in UNIX shell scripting
Preferred experience in SQL Loader and External Tables.
Preferred knowledge in SQL Developer and Toad.
Experience with developing large volume file based processing, high volume data loads
Team player, work with different teams in the organization in a seamless manner
Multi-tasking, capable of handling multiple projects and priorities at the same time