Senior Database Developer

SQL / PLSQL:

Should have developed Complex SQL Queries, Sub-Queries, Correlated Sub-Queries, and Dynamic SQL and understanding of SQL processing.

Created SQL scripts to migrate the data from SQL Loader into the database tables as per the data model and requirements.

Used tools like SQL *Loader to load the data into the database tables from flat files and excel sheets.

Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.

Created new tables, views, Indexes, constraints, synonym, DB link, queries, PL/SQL Function, packages, procedures for new enhancement in the application.

Should have worked on collections.

Should have worked on Oracle Database 19c.

Should be aware of new features in Oracle Database 19c and upcoming Oracle 23AI database.

Performance:

Should have Oracle architecture understanding, data dictionary views / catalog views.

Identifying bottlenecks that affect the performance and should have worked on performance tuning issues for SQL queries and Database.

Working knowledge on performance monitoring and reporting utilities. (STATSPACK,AWR,ADDM,SQL Monitoring)

Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, SQL Monitoring etc.

Tuned SQL queries using indexes, table partitioning, partition swapping.

Involved in optimizing database performance by analyzing database objects, creating indexes, creating materialized views etc.

Should be well versed with the concept of bucketing and should have worked on it.

Should be well versed with scheduling jobs in Oracle Database and troubleshooting the same.

Move data between different database environments using Import/Export.

Career Level - IC3

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.

When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.

We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first with flexible medical, life insurance and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by calling +1 888 404 2494, option one.

Disclaimer:

Oracle is an Equal Employment Opportunity Employer*. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

* Which includes being a United States Affirmative Action Employer