Duties and Responsibilities:
- Create PL/SQL packages, procedures, functions and triggers
- Write complex SQL queries with sub-queries, analytical functions and inline views
- Create technical specifications for junior oracle developers.
- Review and understand the Application Team's work plan.
- Provide status of work to Team Lead.
- Work with Functional Architects to gather and interpret user requirements into design specifications.
- Determine time estimates
- Assist in managing and directing Application Team processes.
- Coordinate work with other software developers on Application Teams.
- Problem solving using the functional and technical programming standards.
- Execute all required process steps.
- Utilize configuration management tools, design tools, debugging tools, and any other environment specific tools necessary to create, test, and implement an application.
- Research problems before approaching the Team Lead or Functional Architect for assistance.
- Follow quality standards and all process steps.
Knowledge and Experience:
- Extensive expertise in PL/SQL.
- Use Collections like variable arrays, nested tables.
- Design, develop and maintain oracle database schemas, tables, standard views, materialized views, synonyms, unique indexes, non-unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors and other database objects.
- Experience in designing backend Oracle modules for Java applications.
- Create PL/SQL packages, procedures, functions and triggers
- Write complex SQL queries with sub-queries, analytical functions and inline views
Required Skills:
- PL/SQL, SQL Plus, SQL Loader - 5 years
- Oracle 12C/11G - 5 years
- System Study & Analysis - 5 years
- Database Object creation (Tables, Views, Synonyms, Procedures, Functions, Triggers) - 5 years
Desired Skills:
- SQL Tuning using Explain PLAN and TKPROF Utilities - 3 yearss
Job Type: Contract
Salary: Up to $50.00 per hour
Experience level:
- 6 years
- 7 years
Schedule:
- 8 hour shift
Work Location: Remote
Please Note :
clarksqn.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, clarksqn.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.