PROFESSIONAL SUMMARY:

Over 6 years of professional experience with Oracle Database 9i, 10g and 11g.
Installed, configured, created and upgraded Oracle environments on Red Hat Linux and Solaris environments. Upgraded database from 10g to 11g.
Exposure to Real Application Cluster (RAC) environment with Auto Storage

• Management (ASM) on Oracle 11g.
• Database performance optimization and Application performance tuning using AWR, TKPROF, Explain Plan, SQL Profiles.
• Experience in taking logical backups of data using oracle data pump utilities Datapump, to move Oracle data from a database or schema to another.
• Successfully implemented advanced High Availability technologies including

DATAGUARD (physical standby) .

• Cloned database from Production to Test and Development and from Development to Production using RMAN.
• Performed trouble shooting of database errors and resolving database performance issues.
• Good team player and can work efficiently in multiple team environments and multiple products. Easily adaptable to the new systems and environments and a quick learner.

EDUCATION/CERTIFICATIONS:

• Bachelors of Telecommunications.
• Certification OCA (11g).

TECHNICAL SKILLS:

Oracle 9i, 10g, 11g

DB Utilities:

SQL*Loader, Export/Import, Data pump, RMAN, OPatch,TKPROF, AWR, ADDM

Languages:

SQL, PL/SQL, Shell Scripting (Bash)

Tools:

OEM, SQLplus, Oracle Developer, RMAN, Putty.

Reporting tools:

Oracle reports 6i, Crystal Reports 8.5/9

Operation systems:

RHEL, Sun Solaris, Windows 2003, Windows XP.

PROFESSIONAL EXPERIENCE:

Confidential,Newark, NJ 02/2013 – present
Oracle DBA

Confidential,is a public research university located in the University Heights neighborhood of Newark, New Jersey, United States. NJIT is the science and technology university of the state of New Jersey.

Responsibilities:

• Monitored the performance of the database and also during stress testing from OEM (Oracle Enterprise Manager). Monitoring of queries with high response time and high disk reads per execution i.e, Top SQL using OEM and tuning the same using Explain Plan.
• Refreshed database schemas across servers of same application as per requests from development team using Data pump export/import.
• Physical Database Creation (Tables, /partitions, indexes, materialized views, clusters, tablespaces/data files, rollbacks, primary keys and foreign Keys and Other Constraints) on the development Databases.
• Taking the Backup everyday, week and monthly using stored procedures in Disk as per business rules.

ENVIRONMENT: Oracle 11.2.0.2/11.2.0.1, RHEL 5.7, bash shell scripts, TOAD 9.1.

Confidential,Richmond, VA 03/2012 – 01/13
Oracle DBA

Confidential,is a financial security company that specializes in life and long term care insurance, wealth management, mortgage insurance, lifestyle protection insurance and annuities.

Responsibilities:

• Performed upgrade of oracle database from 10g to Oracle 11g in development, test and production environment. Patched Oracle Database Server 11g using Opatch utility.
• Perform Daily Monitoring of Oracle instances using Oracle Enterprise Manager Grid Control, TOAD to monitor users, tablespaces, memory structures, rollback segments, logs, and alerts.
• Performed following Data migrations, migrated spreadsheet data/CSV/flat file data into Oracle tables using SQL Loader.
• Managed different database users, roles and security administration.
• Created Partitioned tables using Range, hash, list partitioning to improve performance and manageability.
• Developed automated scripts for database creation and validated through the implementation on the test database.
• Monitored database Performance using AWR, ADDM, TKPROF, SQL Tuning Advisor, Explain plan and tuning parameters for optimization of system performance.
• Supported Real Application Cluster (RAC) on Oracle 11g using automatic storage management (ASM).
• Worked on oracle Flashback feature for Point in Time (PIT) Recovery for minor errors.
• Analyzing the alert log file in case of maintaining and finding the problems of sudden alerts and errors of the respective databases.

ENVIRONMENT: Oracle 10.2.0.2, 11.2.0.1/2, RHEL 5.7, TOAD 9.1, OEM.

Confidential,Panama City, FL 08/2011 – 02/2012
Oracle DBA

Confidential,is financial structure with locations in Alabama in Ashford, Clayton, Dothan, Eufaula, Auburn and in Panama City, Florida.

Responsibilities:

• Worked extensively as Production DBA in a 24x7 environment.
• Created database backup plans and scheduling them as and when required.Monitoring of these jobs on a daily basis.
• Took logical backups of datawarehouse objects by using Datapump.
• Application tuning of database by identifying the suitable indexes.
• Implemented table partitioning and sub-partitioning to improve performance and data management.
• Gathered of cost-based optimizer (CBO) statistics for tables with stale statistics.
• Responsible for Oracle database security and patching, Oracle database capacity analysis and planning. Creating of test schemas.
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.
• Strong experience with Unix and a strong ability with Unix shell scripting.

ENVIRONMENT: Oracle 11.2.0.1/2, RHEL 5.7, SQL*Plus, TOAD 9.1, OEM.

Confidential,New York, NY 7/2010 – 8/2011
Oracle DBA

Confidential, is a provider of IT products and services including hardware, software, networking, business solutions. It has offices more than 100 countries in Europe, the Middle East and Africa, serving large-, medium- and small-sized companies as well as consumers.

Responsibilities:

• Structure, implement, maintain, document and control the overall production database in a multi location environment. Database reorganization & partitioning of tables. Application development support.
• Was responsible for taking logical backups of data using exp/imp, expdp/impdp in RAC and standalone environments.
• Planed and implemented the backup and recovery procedures for the Oracle applications systems.
• Maintained standby databases using replication utility named Data Guard.
• Troubleshoot database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Generated stats for database/Schemas/Tables to improve the performance.
• Developed and implemented utilities/scripts, which automated several DBA functions like full/part of database backup process and Stats collection process.
• Responsible for all production patching, maintenance and support activity.

ENVIRONMENT: Oracle 10.2.0.1/2, 11.2.0.2, Solaris 5.10, RHEL 5.4, Toad 9.1, OEM

Confidential,Kiev, Ukraine 10/2008 – 6/2010
Oracle database analyst

Ukrainian of Department of Czech Republic based Telecommunication Company. They have offices and representatives in 33 countries of Europe.

Responsibilities:

• Successfully implemented new systems and expansion projects for wireless customers worldwide, including systems for MTS Telecom (Ukraine, Russia).
• Developed the scripts to load log data to database, and process the data to hourly and daily tables by using stored procedure.
• Structured and maintained database. Monitored database space usage and system sizing. Analyzed oracle database performance. Troubleshoot and supported data system.
• Exported and imported database for development and QA. Uploaded database per request.
• Used to do HOT backup every day and COLD backup once in on the application database techniques using RMAN and conducted disaster recovery drills.
• Designed database. Managed database space usage. Created database users and managed database security to ensure for the continued accuracy, reliability and integrity of the data systems.
• Tuned oracle SQL statement by tracing.

ENVIRONMENT: Oracle 10.2.0.1/2, 11.2.0.1, SQL, PLSQL, RHEL 5.1, Sun Solaris 5.9, Oracle reports 6i, Crystal reports 9, Oracle Enterprise Manager, Toad 8.6, File loader, Alarm Monitor 3.0.

Confidential,Kiev, Ukraine 04/2006 – 9/2008
Oracle database/telecommunication analyst

Telecommunication Company which provided billing and transport services to MTS, one of the biggest wireless service providers in Ukraine.

Responsibilities:

• Worked in team that developed the SS7 service.
• Involved in requirement analysis and design documentation.
• Designed and developed database tables necessary along with the necessary constraints to enforce business rules.
• Created and modified several Database Triggers, especially for Audit and Security purposes.
• Created users, roles with privileges, grant the appropriate roles.
• Developed Stored Procedures, Packages, and Cursors and involved in the

performance tuning of PL/SQL.

ENVIRONMENT: Oracle 9.2.0, 10.2.0.1, Crystal Reports 8.5, Toad 8.5, Windows 2000/NT, RHEL 4.7, File loader, Alarm Monitor 3.0.