Oracle Database Developer
Resume:
HETAL PATHAK
***** ******* ****, ****** *****, Texas USA
Phone: 469-***-****
Email: *****.********@*****.***
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