Resume

Sign in

Oracle Database Developer

Location:
Frisco, Texas, United States
Salary:
60000
Posted:
May 07, 2019

Contact this candidate

Resume:

HETAL PATHAK

***** ******* ****, ****** *****, Texas USA

Phone: 469-***-****

Email: ac9bmb@r.postjobfree.com

OBJECTIVE : Seeking a position as Oracle Database Developer in a highly reputed and professional organization.

Core Qualifications –

Analyzed data requirements and developed data logical models.

Participated in writing Database Procedures, Functions, Views, Packages and Database Triggers using Oracle tools like PL/SQL developer.

Developed scripts for various reports base on end user requirements

Improved response time to queries up to 40 percent by reviewing and improving indexes, partitioning tables, and fixing coding issues for the Integrated Management System

Documenting database design using visualization tools

Strong technical background covering Oracle PL/SQL programing

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.

Good Knowledge of advance oracle TDS functionalities and RMAN

Excellent communications skills

Solid knowledge of DBMS optimizer and performance tuning techniques

Created partitioned tables and partitioned indexes to improve the performance of the applications.

Technical Skills:

Databases: Oracle 10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008

Reporting Tools: Crystal Reports, Oracle Reports 2.5, SAP Crystal Reports

Operating Systems: Windows NT/98/95/2000 & Windows XP.

Languages/Utilities: SQL

Education Qualifications:

MS IN Computer Science

Boston University metropolitan, Boston, USA (Graduated in March-2019 (GPA-3.06/4)

BE IN Computer Science

Rajiv Gandhi Proudyogiki Vishwavidyalaya, MP, India (Graduated in May-2007 (GPA-3.45/4))

Master’s Degree Project -

Project Name – Payroll Management system with advance oracle TDS functionalities

Role – Data base developer

Duration – 6 weeks

Description –

The payroll management system is design in way to organize all the employee tasks for example, calculate the employee salary, employee taxes, leave and other allowances. Payroll software track of hour, calculating wages, taxes and deduction.

Payroll system is working with some financial aspects for this reason include advance oracle TDS functionalities.

It is design in a way to organize all the employee tasks for example, calculate the employee salary, employee taxes, leave and other allowances. Payroll software track of hour, calculating wages, taxes and deduction.

Project Name – Netflix

Role – Data base developer

Duration – 6 weeks

Description –

Creating Procedures using cursors.

Creating long term history table using triggers

Creating triggers in Netflix schema

Build the whole Netflix scenario.

Project Name – Disaster Recovery using oracle Data guard

Role – Data base developer

Duration – 6 weeks

Description –

Data guard provides one of the most efficient ways to recover data and it provides excellent disaster recovery options. It is one of the best practices to get High availability of data.

Database, Data Guard, RMAN, User Managed Backup and Recovery, Primary database, Standby database, Availability, failover, switch over

One of the useful tools for DBA’S as using this they can transfer necessary or unnecessary load over to standby and it will increase the performance of primary database.

Using switch over facility we can transfer roles at any time, i.e. primary can act as standby and standby can act primary.



Contact this candidate