SUMMARY:

• An Oracle Database Administrator with over 5 years of experience which includes Installation, Configuration, Migration, Database Backup & Recovery, data guard implementation, Tuning at Instance level and SQL level, Cloning, Space Management, Database Security, Auditing, Troubleshooting, Managing Oracle 10g /11g R2/12c databases and documentation in heterogeneous environments. Worked on various Oracle versions like 10g, 11g, 12c Databases across various platforms such as Solaris, AIX, UNIX, Linux, HP and Windows.
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Installed RAC 11g on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 11g cluster database.
• Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
• Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA)
• Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
• Experience in Multitenant Databases (Oracle 12c Container and pluggable databases)
• Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc
• Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.
• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
• Expertise in maintaining Database Security using auditing.
• Experience in Data Migrations.
• Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS:

Databases: Oracle 12c, Oracle 11g, Oracle 10g Oracle Database tools SQL*Loader, TKPROF, Toad, OEM, Toad, TKPROF, EXPLAIN PLAN,STATSPACK, AWR, ADDM, ASH, SQL, Developer, Grid Control

Operating Systems: Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.X, OEL, HP UX 11i, Windows 2000/2003 server

PROFESSIONAL EXPERIENCE:

Confidential - Webster, NY

Oracle Database Administrator

Responsibilities:

• Installed, configured, and maintained Oracle 10g, 11g R2 and 12c on Linux and also Upgraded from Oracle 10g to 11g and 12c.
• Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.
• Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,
• Performed Database refresh from Production RAC environment to TEST RAC environment.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.
• Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
• Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
• Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM.
• Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.
• Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.
• Implemented physical standby database for maximum availability using Oracle Data Guard 11g with Oracle Enterprise Manager (OEM) 12C cloud Control.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g, 11g and 12c environments.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Responsible for configuring datagaurd physical and standby database setup for high availability and handling synchronization issues between primary and standby.
• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Done migration of non ASM database to ASM database.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
• Working as a primary DBA on a critical application and managing 30TB of databases.
• Managing two node Oracle 11g R2 RAC with grid infrastructure and set up Dataguard for them.
• Managing stand alone database with ASM devices.
• Set up failover for oracle clusterware with HACMP clusterware for 11g r2 database with ASM. configuring and maintaining Physical standby data guard for RAC and non RAC databases on 11g r2.
• Monitoring, Troubleshooting RAC cluster using SRVCTL and TAF.
• Performed multiple cross platform migration from regular file system to ASM for 15TB of databases.
• Experience in Upgrading databases. (10gR2 to 11g, 11gR1 to 11gR2).
• Performed SAN migration from one diskgroup to other diskgroup using asm copy command and used rename diskgroup. Also used RMAN copy. worked on QC of the database before it go live.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and datapump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers.
• Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Diagnosed Oracle bugs and coordinating with Oracle support through metalink to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Have installed and setup Oracle 12c databases on test servers to test the multitenancy
• Refreshed multiple databases for Development and Testing upon short request.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on10g and on 11g using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Perform Backup and Recovery using RMAN.
• Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.

Confidential - Schaumburg, IL

Oracle Database Administrator

Responsibilities:

• Analyzed and tuned the Database to identify potential database issues such as response delay, locking contention, even server down time by using tools like STATSPACK, EXPLAIN PLAN, and TKPROF.
• Implemented Data Guard on Oracle 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Involved in the replication of source database using Golden Gate.
• Monitoring several databases varying Terra byte sizes using Oracle Enterprise Manager Grid Control.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Used TOAD for database management.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).
• Documented the Standard Processes for peers to follow.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Worked closely with project managers, programmers, and testers to ensure the database integrity and security and generated test data and tested new database consistency with existing databases to meet the functionalities requirements
• Involved in query optimization and using rule based optimizers and cost based optimizers.
• Performed database performance tuning, STATSPACK reports automation, stress test on production copy for scalability, resolving production performance issues.

Environment: Oracle 10.1.0.4/10.2.0.4/11 gR2, RHEL 5 and 6, Oracle Enterprise Manager Grid Control,OEM Database control, PL/SQL, Shell Scripting,, TOAD.

Confidential - Culver City, CA

Junior Oracle Database Administrator

Responsibilities:

• Conducted meetings with user groups to get functional requirements.
• Creation and maintaining Production and Development databases.
• Monitoring databases, which include basic health checks, growth of objects, and performance of the databases.
• Scheduling batch jobs for tablespace and datafile capacity management, partitioning performance tuning, statistics gathering.
• Checking alert log and trace files on daily basis.
• Managing resources, Users, Privileges and Roles .
• Moving of objects across databases using Data pump, Export and Import .
• Partitioning of tables for performance.
• Data refresh from production to test and development.
• Configuring Listeners and troubleshoot connectivity issues.
• Performed Hot and Cold Backups using shell scripts.
• Collecting database objects statistics regularly for to improve database performance
• Written nightly scripts and scheduled using CRONTAB.
• Administration of ASM - addition, dropping disks rebalancing....
• Perform backups and recovery using RMAN .
• Testing RMAN backups every quarterly.
• Creating the duplication database using RMAN backups
• Installing, upgrading and applying patches to various versions of oracle
• Raising Oracle SR support to deal with bugs and issues associated.

Environment: Microsoft Visio, Lotus Notes, Microsoft Excel, Microsoft Word