SUMMARY

• I have over 6 years of experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Expertise in Oracle's Data protection, high availability, and performance technologies such as Oracle RAC, Oracle Dataguard, ASM, and Oracle goldengate.
• Experience in administration and tuning of Oracle databases running on Windows and all types of UNIX platforms.
• Experience in Data guard for different types of Standby Databases such as Active for reporting, Physical, Logical, and Snapshot standby on implementation, administration, & performance tuning.
• Experience in implementation, configuration, troubleshooting, and performance tuning of Oracle Goldengate replication between Unidirectional, bidirectional, and cascaded Oracle Databases.
• Experience in Performance Tuning Oracle Databases with respect to all aspects of IT Infrastructure such as Network, OS, Storage, and Application.
• Experience in using various performance tools or utilities like EXPLAIN PLAN, STATSPACK, AWR, ASH, and ADDM, and analyzing reports for tuning recommendations.
• Experience in implementing Oracle Enterprise Manager Grid Control (11g) and Cloud Control (12c) for database monitoring/performance/diagnostics.
• Experience in implementing desired database backup solutions based on environment, affordability, and other key IT Infrastructure aspects. Experience with Oracle RMAN backup utility and in traditional hot (online/cold (offline) backups, Experience in logical backups and Database migration tools such as DATA PUMP, Export/Import, and Transportable Tablespaces.
• Experience in upgrading Oracle Databases from 10g & 11g, to 11g & 12c.
• Knowledge and experience on managing very large Data Warehouse databases.
• Experience in implementing Oracle Flash-Back Technology and utilizing it for various rollback purposes such as Critical Application bug fixes, Load Testing, and QA Testing.
• Oracle GoldenGate experience with Installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
• Experience in Performance tuning of Oracle GoldenGate Processes to achieve zero lag times.
• Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.
• Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.
• Experience in SQL Tuning using tools like Explain Plan, and OEM.
• Effective troubleshooting of Database Performance and tuning using ASH, AWR, ADDM.
• Performed data migration from flat files into an Oracle database using SQL*Loader.
• Experience in performing Cloning and Refresh using RMAN and Datapump.
• Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modeling.
• Experience in defining Users, Roles, Privileges, Auditing to ensure database Security.
• Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
• Experience in upgrading Oracle Binaries and databases from 10g to 11g and 11g to 12c

TECHNICAL SKILLS

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, Oracle SQL Developer, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

RDBMS: Oracle 10g, 11g and 12c

Operating Systems: HP-UX 10.x, 11.x, 12c, Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

• DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration and database sizes range from 4GB to 2TB (in ODS & EDW environments).
• Supported 400+ databases including RAC production database, a Data warehouse database and a lot of Development and Test databases and upgraded from 11g to 12c.
• Performed conversion of Single Node Instance to multi node RAC with ASM, and adding instance to existing RAC.
• Installed and configured 6 node oracle 11gR2 RAC for production environment.
• Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
• Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate EXTRACT and REPLICATE issues.
• Implemented Data Pump, Export and Import on day to day basis as per development and test servers.
• Monitoring database performance and database operation to prevent downtime and slowness of the services.
• Worked closely with the system operations team on database deployment processes and database capacity planning.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Expertise in configuring and managing the Concurrent Managers, Workflow Notification Mailers and monitoring their operation
• Strong experience in Space and User Management, Capacity planning, standby setup, Backup & recovery (Import/Export, Datapump, RMAN)
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, AWR and ADDM.
• Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Maintained DATA GUARD to provide high availability by implementing physical stand-by database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and Automatic Storage Management (ASM).
• Troubleshooting Space Management & User accounts and privilege issues while coordinating with UNIX and application teams.
• Performed proactive database maintenance procedures to ensure optimal performance and uptime and implemented shell scripts for automation of day to day activities.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and interact with the development team to see if these queries can be fine-tuned further.
• Regular Security Patching and Critical patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bug fixes on database products.
• Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle Management Server for maintenance and monitoring of production databases.
• Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
• Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers, Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day operations.

Confidential - Bellevue, WA

Oracle Database Administrator

Responsibilities:

• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Responsible for continuous Monitoring of CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance.
• Responsible for all database activities such as User management, space management, database security management.
• Implemented the resizing the online redo logs in production and in standby database.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.
• Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
• Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
• Maintained the data integrity and security using integrity constraints and database triggers.
• Provided 24X7 support for all the production and development databases.