SUMMARY

• Over 6+years of experience in Oracle Developer/Administration in planning, installation, configuration and upgrades of Oracle 11gR2 databases, Experience includes managing Oracle 11gR1, 11gR2 RAC environments using the OEM Grid Control tools. Experience includes Oracle Utilities Data Guard, Data Pump, Flashback and RMAN. SQL.
• Good experience of setup & configuration, implementation of (Oracle 11gR2 RAC two - node on Linux with ASM).
• Extensive knowledge on database administration for Oracle 11g,12c and with experience within very large-scale database environment and mission critical large OLTP and OLAP systems.
• Engineering, implemented, documented and support builds of new clusters to use Oracle 11g/12c RAC on HP-UX, Solaris, IBX-AIX and Unix/Linux. Including installing cluster ware, ASM (and shared disks) and creating new databases.
• Expertise in upgrading the databases from Oracle 10g, Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
• 24*7 production database support with Support to developers & end-users.
• Experienced in Installation of high availability RAC environment and upgraded standalone databases to 11g RAC environment.
• Expertise in Configuring, maintenance of Data guard in RAC environment and standalone environments.
• Managed very large database (VLDB) of maximum size 32TB.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing Environments.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, CBO, TKPROF, EXPLAIN PLAN and SQLT.
• Good with concepts of Database Links, Materialized views, Flashback Technology, Partitioning Tables to improve Performance and Manageability.
• Hands on experience in Data Archiving
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Experienced in using Oracle's Transportable Table space (TTS) feature allows users to quickly move a user table space across Oracle databases.
• Good experience in applying Patches (Patching), Critical Patch Update(CPU)/Patch Set Update(PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of a Oracle server to higher version available.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Prepared DBA work plans, Documented Client site’s “Site specific work procedures”, Change Management and control, Best Practices and did Capacity planning for clients.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Expertise in using OEM, SQL Developer and third-party tools like TOAD.
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.

PROFESSIONAL EXPERIENCE

Confidential, Greenville, NC

SQL Developer/Oracle Devloper

Responsibilities:

• Analyzing the existing system to perform the migration from Oracle 12c to Oracle Exadata 19c and compare them with the current system, logging defects and tracking them to the closure.
• Analyzing database procedures and business reports to automate or improve the system capabilities, workflow and scheduling limitations.
• Involving in performance tuning of the system by creating partitions on Tables, Indexes, Hints and Materialized views.
• Analyzing the data processing during extract, load and transformation with the help of reusable systems from various sources of data from across multiple database platforms.
• Coordinating and creating functional and technical design documentation and test cases of the system.
• Involving in Transformation of data and document the specifications.
• Used SQL Loader to retrieve the data into the database tables from flat files and comma separated files (CSV).
• Created Tables, Constraints, Views, and Indexes in coordination with the application development team.
• Used TOAD, SQL Developer tools for faster application design and make the development environment flexible.
• Developed database objects including Indexes, views, sequences, packages, triggers, functions and procedures to troubleshoot any of the database problems.
• Develop routines to convert Extract Transform Load (ETL) from core systems to target systems.
• Prepared Test scenarios for various functionalities developed and assisted the testing team in creation of test scripts that are used in testing oracle stored procedures.

Confidential, Boston, MA

PLSQL Developer/Oracle Developer

Responsibilities:

• Created PL/SQL Packages, Procedures and Functions that suits Business Requirements for loading the data into the database tables.
• Created Dynamic SQL, Composite data types & Global Temporary Tables.
• Worked on Materialized Views and partitioning tables for performance reasons.
• Worked on packages, forms and reports using dbms output, Forms debugger and Explain plan.
• Worked on UNIX Shell scripts to generate and report the status of the automated and incremental backups, file manipulation and archive files.
• Used SQL Loader to retrieve the data into the database tables from flat files and comma separated files (CSV).
• Created Tables, Constraints, Views, and Indexes in coordination with the application development team.
• Used TOAD, SQL Developer tools for faster application design and make the development environment flexible.
• Developed database objects including Indexes, views, sequences, packages, triggers, functions and procedures to troubleshoot any of the database problems.
• Develop routines to convert Extract Transform Load (ETL) from core systems to target systems.
• Prepared Test scenarios for various functionalities developed and assisted the testing team in creation of test scripts that are used in testing oracle stored procedures.
• Expertise in solving complex queries and improves the performance of application by performance tuning.
• Provided support for 3 Oracle Exadata machines - Prod, DR, QA - to be used for mission critical applications.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Worked on requirement analysis for Change requests and fixed the defects raised by the user community and other stakeholders.
• Incasing data file size when table space got full.
• Giving grants to users based on requirement.

Environment: Oracle 12c, Toad, MS Excel, Microsoft Office suite, XP, Business Object Info View, Linux, Informatica.

Confidential, NJ

Oracle DBA/ Oracle Developer

Responsibilities:

• Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.
• Design Evaluation and Analysis of physical and logical model.
• Involved in Installation and customization of Databases (11g&12c) in Windows, Linux and Solaris environments.
• Involved in Schema management, Tablespace Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required on 11g,12c.
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL&PHYSICAL i.e. Export & import and having experience with EXPDP&IMPDP.
• Implemented Consistent exports using SCN.
• Good experience with recovery managed backups i.e. RMAN.
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Documented the complete project including all pre-installation, post installation and database configuration steps.
• Manage users, privileges, profiles, schemas, involved in writing UNIX shell scripting for automating the jobs.
• Experience in using automatic monitoring and management processes like batch processing using CRONTAB for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Experience with SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• Tuning Oracle 10g database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.
• Experience in setting up Golden Gate for CDC extraction of files for ETL.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Experience in Implement and maintain monitoring tools for Golden Gate components.

Confidential, FL

Oracle DBA

Responsibilities:

• Worked on refreshing production databases on sandbox for application testing using export/imports and RMAN active duplicate.
• Performing Backup/Restore of all the Oracle databases using RMAN.
• Provided on call support for every 3 weeks and provided support on weekends.
• Worked on Real application testing to have access the workload before migrating and upgrading production databases.
• Supported mission critical databases and extensively involved in resolving the performance issues.
• Worked on implementing standard RMAN backup policies and successfully was able to restore huge database when required.
• Provided support for 3 Oracle Exadata machines - Prod, DR, QA - to be used for mission critical applications.
• Managed and resolved RAC (10g, 11g), ASM and cluster ware issues.
• Management of schemas, objects partitioning the tables & indexes.
• Worked on refreshing the QA databases with PRODUCTION backups.
• Developed scripts for monitoring Tablespace sizes, alert log files, Tablespace growth and implemented Crontab job to alert if the tablespace size exceeds above 80%.
• Responsible for taking backup of schemas, tables and table spaces using Oracle 11g Data pump.
• Experienced in developing shell scripts for deleting old file.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Expertise in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate issues
• Experience in setting up Golden Gate for CDC extraction of files for ETL.
• Upgrade and character set conversion of RAC databases with the aid of Oracle Golden Gate utility.
• Experience in Implement and maintain monitoring tools for Golden Gate components.
• Worked on database upgrade from 11.2.0.3 to 11.2.0.4.
• Experienced in performance tuning on long running query’s in database.
• Very good experience in using performance tuning tolls like SQLT, SQLHC.
• Experienced in backups, restores, indexes, key structures and data loading.
• Worked on data blocks corruption issue, index & table rebuild.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Configuration management has worked along with day to activities
• Handled supervisory duty more than 20 DBA's along with process management.
• Oracle security experience both banking domain projects.
• Worked on Oracle A udit vault for security encryption data.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• Strong knowledge of Oracle internals, tools including DBMS jobs, RMAN, SQLPlus, export/import, Toad, Oracle Enterprise Manager (OEM).
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.

Environment: Oracle 11.2.0.3/11.2.0.4 , Exadata X4/X5 Quarter/Half/Full RACK, OEM 12c, LINUX, IBM AIX TOAD, SQL Developer.

Confidential

Oracle Developer/DBA

Responsibilities:

• Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.
• Created Tables, Constraints, Views, and Indexes in coordination with the application development team.
• Used TOAD, SQL Developer tools for faster application design and make the development environment flexible.
• Developed database objects including Indexes, views, sequences, packages, triggers, functions and procedures to troubleshoot any of the database problems.
• Design Evaluation and Analysis of physical and logical model.
• Involved in Installation and customization of Databases (9i&10g) in Windows, Linux and Solaris environments.
• Involved in Schema management, Tablespace Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required on 10g,9i
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL&PHYSICAL i.e. Export & import and having experience with EXPDP&IMPDP.
• Implemented Consistent exports using SCN.
• Good experience with recovery managed backups i.e. RMAN.
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Documented the complete project including all pre-installation, post installation and database configuration steps.
• Manage users, privileges, profiles, schemas, involved in writing UNIX shell scripting for automating the jobs.
• Experience in using automatic monitoring and management processes like batch processing using CRONTAB for processes like import, export databases
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.