SUMMARY:

• 8+ years astute Oracle DBA experience in Production, Testing and development environments spanning several industries: Financial, Health care and Insurance.
• Experience in variety of hardware and software platforms like Unix/Linux, Sun Solaris, and AIX & RHEL.
• Maintained database disaster recovery procedures to ensure continuous availability and speedy recovery using Oracle Active Data Guard.
• Implemented unidirectional replication for heavy transactional system using Oracle Golden Gate and resolved performance bottlenecks.
• Implemented and maintained Oracle Advanced security products like Transparent Data Encryption (TDE), network and data encryption.
• Successfully migrated few of our databases from our old hardware to EXADATA machines.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Provided technical assistance for designing, installation and upgrading of existing Oracle database
• Good knowledge in multitenant architecture and other Oracle 12c new features.
• Implemented various backup strategies for Large / Medium sized databases using RMAN.
• Worked extensively on Cloning /Duplicate of databases using RMAN.
• Expert in delivering Oracle Database performance - tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Experience in applying PSU, CPU, one-off database patches.
• Expertise in loading data from flat files using external tables, SQL* Loader.
• Knowledge in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database.
• Migrated databases from Non-ASM file system to ASM file system using RMAN.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using AWR, ASH, ADDM, Index monitoring and Grid Control.
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, VERITAS Net Backup.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
• Installation, Configuration, Performance tuning and administration of Golden Gate for real time data replication.
• Good experience in Real Application Cluster(RAC) administration, Configuration and Patching.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$ and DBA views
• Installed and configured oracle Grid control.
• Expert in Oracle flashback features and implemented Guaranteed restore point to support various development and Testing phases.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Upgrading and Migration of Oracle database to higher version and other platforms using manual method, DBUA and traditional Export/Import, datapump & Transportable Tablespace (TTS).
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
• Expertise in working with SQL Server Management studio of 2008 and 2012, upgrading and SP patching.
• Good Knowledge on SQL, PL/SQL, UNIX Scripting.

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i, SQL Server 2012/2008

Operating Systems: Sun Solaris, Red Hat Linux, AIX, HP-UX, Windows

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: OEM, SQL Loader, EXP, IMP, EXPDP, IMPDP, TOAD, RMAN

Tuning Utilities: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH

Data Replication: Oracle Golden Gate

Other: VERITAS Net Backup, Remedy

PROFESSIONAL EXPERIENCE:

Confidential, Dublin, OH

Oracle Database Administrator

Responsibilities:

• Administrated and Monitored several oracle databases.
• Supported data centre migration and successfully migrated several databases in new datacentre.
• Performed Schema as well as Table level Replication using Oracle Golden Gate.
• Applied Oracle Patches (PSU and CPU patches) periodically and worked closely with Oracle to apply all recent released patches.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
• Scheduling the Physical backups in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Installed and configured Golden Gate in a prod and non-prod env, configured extract, data pump and replicate.
• Configured Active Data guard for Disaster recovery and monitored DR sync up speed.
• Involved in Annual DR testing activities in our organization.
• SQL tuning and Database tuning has been done based on reports generated by Run time sql execution plans, AWR Reports, ASH reports and Explain Plans.
• Configured and monitored 2-node RAC database.
• Extensively worked on setting up auditing in many databases we supported.
• Involved in Business Requirements, System analysis and Design of the Data warehouse application.
• Budgeting and capacity planning, as well as systems performance and uptime management.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.
• Assisted in management and database administration of Oracle database applications on Exadata platforms.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Several flat files loaded into database by using SQL*Loader utility.
• Worked on transparent data encryption (TDE), configured wallet, standard auditing, fine grain auditing (FGA) and data masking.
• Wrote various shell scripts and RMAN scripts to automate both weekly and daily RMAN incremental backups.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Debugging and fixing any replication issues.
• Managed multiple applications or service areas and projects simultaneously to ensure on-time response, quality delivery and resolutions.
• 24x7 production database support.

Environment: Oracle 12c, 11g, 10g, Solaris, Red Hat Linux, Windows, RAC, ASM, Golden Gate, AWR, ASH, ADDM, RMAN, Explain Plan, SQL Trace, Data Guard, Expdp and Impdp, SQL Loader, Remedy, SQL Server, Toad, VERITAS Net Backup, Shell Scripting and Grid Control

Confidential, Minneapolis, MN

Oracle DBA

Responsibilities:

• Experience with designing, installing & maintaining RAC, Data Guard components of Oracle.
• Migrating Single Node architecture to Multi RAC node architecture.
• Modify init parameters in RAC and manage ASM instance for RAC environments.
• Responsible for logical and physical database design, implementation, transforming logical data models into physical databases, and defining strategies for database implementation, high performance, Load balancing, replication & failover.
• Responsible for online and offline backups of the oracle database.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Involved in the process of tuning and refining various queries of various applications.
• Generated Statistics using DBMS.STATS Pack at Schema level, Table Level and for Indexes.
• Creation and maintenance of standby database by using oracle high availability method and Oracle Data Guard.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Worked on RAC pre-installation tasks, like hardware requirements, software requirements, and environment configuration.
• Configured monitor tools to identify golden gate latency.
• Refresh/Cloning of database from production environment to test environment.
• Strong ability with UNIX shell scripting to automate tasks.
• Hands on experience working with Oracle Grid Control Environment.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• On call 24X7 Production Support.
• Performing Backup of Oracle databases using RMAN and Restoration and Recovery as and when required. Setup RMAN catalog for all the Oracle databases.
• Experienced with Software Development life cycle (SDLC) methods and critical business applications.
• Knowledge in writing Shell Scripts for automating backups and restoration.
• Partitioned large tables to enhance query performance.
• Extensively used SQL*Loader for large data load using direct path and parallel loading.

Environment: Oracle 12c,11g, 10g, Linux, Solaris 5.10, Windows, Golden Gate, Shell scripting, RMAN, Data guard, SQL*Loader, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, RAC, ASM.

Confidential

Oracle Database Administrator

Responsibilities:

• Supported 24*7 production databases on multiple platforms.
• Reviewing of database design document, providing conceptual and logical data model and translating into physical database.
• Installation and creation of Oracle databases on Production and Test Solaris servers. Responsible for upgrade & migrating databases and applying patches.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Export and Import of User, Tables and database using exp/imp and Data Pump.
• Managing Space, Tablespace, Segments and Extents, Rollback Segments.
• Providing solutions to database related trouble tickets.
• Performance tuning using STATSPACK, EXPLAIN PLAN, SQL TRACE, TKPROF.
• Managing Tablespace, Datafiles, Redo Logs, Rollback Segments and other database objects.
• Managing Users, Privileges and Roles.
• Worked with developers to develop and manage code for the Application.
• Automated monitoring the databases, performance parameters, and backup /recovery activities by RMAN, running Cron jobs and write UNIX shells scripts for job automation.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and Point in Time recovery for recovering the master data when the tables are dropped by user error.
• Tuning the Shared pool and buffer cache to have better performance.
• Estimating and properly sizing data, index and rollback segments and improving the performance by avoiding dynamic allocation and shrinking of extents.
• Writing UNIX shell scripts for backup and recovery, Import and export procedures
• Database Sizing, Tablespace Management and Rollback Tablespace Management, Transaction Management, Security Administration
• Assigning work requests to team members

Environment: Sun Solaris, UNIX, Windows, Oracle 11g/10g/9i, OEM, RMAN, DBCA, Putty, WebLogic, Java, XML, SQL*Loader, TOAD, Erwin, AWR, ASH.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Responsible for administering and supporting production and development databases from offshore.
• Installing, upgrade and configuring the Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Managing user accounts, Granting required privileges and profiles to users.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Applied patches, keeping applications software bug free, and improving data integrity.
• Developing, Testing and Implementing Sound Backup and Recovery Strategy.
• Establish and Document Backup and Recovery strategies and procedures after evaluating various options including RMAN
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Tuning the databases for optimal performance.
• Partitioning Tables by determining the suitable methodology to improve performance and manageability.
• Maintained all documents of Oracle Database operations. Prepared documentation of database backup and recovery standards.
• Monitoring the Database storage and Day to Day activities.
• Configured scripts to monitor activity with database.
• Cloned Environments to create Patch Test, Development and QA Environments.
• Partitioned large tables to increase the performance.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Participated in Disaster Recovery Drills, documented database and application validation steps.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Data masking in dev, test and stage while refreshing from production DB.

Environment: Oracle 10g/9i, Sun Solaris, HP-UX, Windows, RMAN, Data guard, SQL/PL-SQL, HTML, STATSPACK, Shell Scripting, exp/imp, Data Pump