SUMMARY

• Over 8+ years of professional experience as an Oracle Database Administrator having hands on experience in database administration production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, database security, cloning, migration, shell scripting and documentation, Setting up and configuring Data - guard, Replications using golden gate on Sun Solaris, Red Hat Linux, HP-UX, AIX, and Windows Platform.
• Experience with very large scale database environments and mission critical OLTP and OLAP systems in high-availability environments.
• Providing DBA support to MultipleCluster, Non-cluster and ASM Database in production, development and Testing Servers on UNIX, Linux and Solaris Environments.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU) in various environment ranging from 9i/10g/11g/12c.
• Excellent experience in Installation, administration and troubleshooting of Oracle 12c/11g/10g/9i for OLTP (multiple instances)/ OLAP environment on Very Large or Highly Transactional Databases.
• Having Hands on experience working in both Application and Production support environment.
• ERPand Other Software Implementation Experience in multisite, multicurrency.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c.
• Configuration and Management of Data Guard 10g/11g on RHEL, OEL and Sun-Solaris for Disaster Recovery.
• Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3 Node RAC on 10g/11g/12c.
• Worked on Exadata Database Machine X2-2 Half Rack, X3-2
• Migrated Databases into Exadata Machine with minimal downtime using Dataguard.
• Installed and maintained Oracle 12c/11g/10g RAC with ASM & OCFS2 File systems.
• Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate Extract and Replicate issues.
• Created Oracle Apex Application from Scratch
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• Performed Upgradation of databases from lower version (9i/10g) to higher version (11g).
• Implemented RMAN Backup and Recovery, Incomplete Recovery and disaster recovery using Data Guard.
• Experienced in Data migration using Amazon DMS service.
• Experienced in creating AWS EC2 instances.
• Experienced in using AWS RDS.
• Worked on disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, Cold and Hot backup, Full backup, Incremental, Cumulative backup and implementing backup and recovery strategies.
• System administration, Oracle Problem analysis & resolution and active cloning of databases between servers.
• Testing and implementing different physical (hot/cold), logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
• Knowledge of various storage solutions (SAN, NAS).
• Database refresh from production to QA, development and testing environments.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Extensive knowledge and experience on managing very large Data Warehouse databases.
• Developed both database and OS-level security policies for data protection and having good experience in Working with Oracle security, Transparent Data Encryption, Oracle Wallet Management and Oracle Identity management.
• Experience in SQL Tuning, SQL Optimization, Cost based optimization and Hints.
• Set and tune System Parameters for MongoDB.
• Optimizing MongoDB CRUD Operations.
• Add / remove replica and shard nodes in MongoDB Cluster as needed.
• Setting up MongoDB Profiling to get slow queries.
• Proficient in raising TAR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.
• Working on ORACLE EBS with service desk experience of Oracle EBS R12 functional supporter in financial module.
• Extensively used BMC Remedy, Pac 2000 ticketing systems.
• Worked proactively and gave 24/7 on-call production support and Weekend support for maintenance and server level patching.
• Good analytical and problem solving skills with ability to work independently and in a team environment.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL 3.x, 4.x, 5.x, 6.x, HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2, Exadata X3-2, X2-2, X2-8

Data Bases: Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC), ASM, MySQL, SQL SERVER 2008/2012/2014 , Mongo DB, AWS.

Languages: SQL, PL/SQL, UNIX Shell Scripting

Tools: / Utilities: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET, ODBC, Export/Import, Data pump, Data-Guard, Erwin, OEL, Log-miner, APEX, MS Visio, VERITAS Net Backup, BMC remedy, Pac 2000, VMware, Crontab.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Emulation: Putty, Telnet, FTP, TOAD

Ticketing Tools: BMC Remedy, GIRA, Service Now, HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential, DALLAS, TX

Oracle SME/Sr. Oracle Database Administrator

Responsibilities:

• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure / Clusterware, Oracle 12c two node RAC for the database tier.
• Planning and implementing DR & high availability solutions using Oracle 11g /12c Standby Database using Dataguard.
• Configured Data Guard Broker and used for switchover and stopping and Starting Media recovery process.
• Created ASM volumes using asmca and Created ACFS for GoldenGate v12.
• Installed GoldenGate on 12c RAC ACFS Configured Integrated Extract and Replicat on Multitenant database 12.1.0.2.
• Performed Cross platform migration and used Oracle GoldenGate to migrate database from IBM-AIX 6.1 to OEL 6.1.
• Configured Extract and Replicate pumps for GoldenGate replication 11g/12c and Troubleshooting issues in GoldenGate Environment.
• Used Logdump Utility to Investigate data on the trail and defgen to create definition files used for replication.
• Integration of ERPto Financial Systems. Lead Continuous Technical Efforts for Integration by Developing Integration tools from Syteline ERP to Hyperion Providing One platform for Financial View.
• Hands on experience to support Oracle Exadata V2/X2/X3 and ODA machines of 11g databases with 3-node RAC up to 100TB Size.
• Performed Zero-Down Time migration from Hp-Unix to Oracle Enterprise Linux using Expdp and GoldenGate.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Manage Mongo DB upgrades, including hardware migrations.
• Used OEM 11g/12c and Administering Oracle Database 10g, 11g and 12c databases and masking sensitive data in production databases.
• Experience in creating physical and logical database design Data Models using Erwin Tool.
• Generation of DDL scripts using Erwin Tools.
• Patching & upgrades on Oracle 12c database (whilst minimizing or eliminating the impact to live services, i.e. using rolling node patching).
• Created Oracle Apex Application from Scratch.
• Developed and maintained operational and system level documentation. Developed applications using Oracle Application Express (APEX).
• Created documentation, design and implemented rich user interfaces using Oracle Apex.
• Have Designed a monitoring Dashboard which is projected on the wall for operation team to monitor, It’s a 24*7 rotational reports using Apex 4.0.2
• Upgraded databases from 11.2.0.4 to 12c in QA and Prod environments.
• Worked on Oracle Enterprise Manager Express for Oracle 12c RAC standard.
• Working with logical backup using Data pump and Exports/Imports Utility.
• Database Load and Transformation Techniques (SQL Loader, External Tables).
• Created scripts and scheduled backups in Autosys for RMAN database backups and recoveries and Cloned databases using RMAN Utility.
• Performed various tasks in RAC Cluster: Pinning nodes, used ocrconfig to backup OCR, OLR and voting files, creating services using Srvctl, changing scan port number, Multiplex Voting files, Mirroring OCR on different ASM diskgroups, Tuning Node Evictions by setting disktimeout, reboottime, misscount, Creating New VIP to manage high availability, Configured TAF and ACFS.
• Installation and use of Oracle ASM (as well as traditional file system storage).
• Monitored DR (Data Guard) implementations regarding connectivity issues and "log shipping" to failover site.
• Manage and maintain Mongo DB servers across multiple environments.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Responsible for all database activities such as User management, space management, database security management, rollback segments & creation of DB links between oracle servers.
• Expertise in optimizing SQL queries by reading Explain Plan Statistics, developed backend interfaces using PL/SQL Packages, Stored Procedures, Collections
• Utilized AWS Cloud watch to monitor environment for operational and performance metrics during load testing.
• Implemented Amazon EC2 setting up the instances and Leveraged AWS Cloud services such as EC2, Auto Scaling and VPC.
• Installed and configured Oracle 12c WebLogic server and Oracle 12c HTTP servers for the application tier and web tier.
• Working with the Oracle Support Mechanisms; My Oracle Support (Metalink), Raising Service Requests.

Environment: Oracle 12c, RHEL 5/6, OEM, RMAN, Grid, Dataguard, ACFS, RAC, ASM, GoldenGate, TOAD, APEX, SQL*LOADER, Performance Tuning, Data pumps, Exports/Imports, Explain-Plan, SQL-T, SQL-HC, Oracle-Wallet-Management, WebLogic server, Fusion Middleware, PL/SQL Tuning, WebSphere, TOAD 11.6

Confidential, Boston, MA

Sr. Oracle Database Administrator/GoldenGate Admin

Responsibilities:

• Worked on maintenance of Oracle 10g/11g RAC databases on Linux and Configured 2 Node RAC on Grid Infrastructure.
• Administered and monitored over 120 databases both on 10g/11g on prod/test/dev environments.
• Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 10TB.
• Migrated databases from File-system to Automatic Storage Management (ASM).
• Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert.
• Up-gradation of single instance databases from 11.2.0.1 to 11.2.0.3 on Linux.
• Responsible for using Flashback querymechanism along with automatic undo management.
• Experience in Creating Physical and logical database design Data Models using ER Studio.
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.
• Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQLLoader.
• Worked on Active data guard, Fail over and Switch over cases.
• Hands on Experience in SQL Tuning and SQL Optimization.
• Created Oracle Tables, Table Partitions, Views, and Materialized Views.
• Worked on database security, Transparent Data Encryption, Created tables with Encrypted Columns and Managed Encryption Keys
• Implemented the TDE column encryption to encrypt sensitive data stored in Tables for Security Remediation.
• Configured Oracle Wallet for Encryption functions and involved in setting up Transparent Data Encryption for protecting sensitive data in the database.
• Creation of Users and granting them the required Roles and Privileges accordingly
• Cloned schemas, objects and data on new server using Data pump utility
• Decreased Contention by reducing the Wait Events as a part of Performance Tuning
• Implemented Backup and Recovery Strategies using RMAN and used Recovery advisor to repair data block corruptions& data dictionary corruptions
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Ability to work effectively and can liaise as a part of team monitoring proactively Involved in 24x7 production database maintenance and on-call support.

Environment: Oracle 10g, 11g, RHEL 5/6, SOLARIS, IBM AIX, OEM, RMAN, Grid, RAC, ASM, Data-guard, Golden Gate, TOAD, TDE, SQL*LOADER, Performance Tuning, AWR, ADDM, ASH, Data pumps, Exports/Imports, WebLogic Sever, Web Sphere, Defgen, Logdump, WebLogic Console, Auditing, Encryption, HP-UX 7.x/11.xTFA, Exadata x3-2, x2-8, CellCLI, IORM.

Confidential, Burlington, NC

Sr. Oracle DBA/Production Support

Responsibilities:

• Extensively involved in analyzing the functional requirements for the Database Access Profiles.
• Managed and monitored the Oracle Real Application Cluster (11GR2 2, 3 node RAC) running on VERITAS storage.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Extensive experience in RMAN recovery in RAC and standalone database.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Performed Upgrades, Enhancements, and regular maintenance to system by researching, planning, as well as applying patches to databases and E-Business suite to keep them up-to-date.
• Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data.
• Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.
• Supported more than 130 production and development databases.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Implemented data transfer using Data Pumps and Export/Import utilities.
• Taking the RMAN incremental and cumulative backups and Scheduling the databases backup using Crontab.
• Implemented DRP (Disaster recovery plan) for critical databases using Streams.
• Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Responsible for capacity planning, recovery planning and installing patches.
• Developed stored procedures using PL/SQL. Used Hints, Indexes, Explain Plan, Sql Trace and Tkprof for effective retrieval and processing of queries used for retrieving current details and also history of changes made for a version.

Environment: Oracle 11g/10g, Sun Solaris 9, AIX, Redhat Linux, OEM, SQL, PL/SQL, SQL Plus, Unix, Erwin Data Modeler, OEM 10G/11G, RAC, Dataguard, ASM, EBS, Expdp, Impdp, RMAN, Toad, Putty.

Confidential, Los Angeles, CA

Oracle Database Administrator

Responsibilities:

• Involved with installation and maintenance of Oracle 3 node RAC for high availability.
• Involved in change control process and Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Worked extensively onmonitoring 10g/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control.
• Involved in Migrating applications fromsingle instance databases to Exadata.
• Maintained 10g/11g RAC environment and troubleshooting issues.
• Responsible for implementing Load Balancing in RAC Database.
• Performed health checks in RAC instances using Crsctl and Srvctl utility.
• Having good experience in Migrating Single Instance database to RAC Environment.
• Performed Capacity Planning, Undo segments and Health check reviews in RAC.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Scheduling the databases backup using Crontab and VERITAS net backup.
• Involvement in space management, rectification of lock problems, managed quotas.
• Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Experience in Creating Physical Design Data Models using Erwin Tool.
• Generation of DDL scripts using Erwin Tools.
• Created, monitoring database objects like Indexes, Views, Users, and DB Links.
• Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQLtuning advisor.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDMfor Generating reports.
• Created Partition’s estimated stats on one partition1 and copied the stats to remaining partitions using DBMS STATS.
• Worked with DW team on problem resolution and implemented change requests. - Performance tuning on DW such as Data extraction from production to Data warehouse.
• Install, maintain and monitor Web Logic server as part of OEM Grid Control setup.
• Involved in 24x7 production database maintenance and on-call support.
• Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 10g/11g, RAC on Sun Solaris, Linux, RMAN, Data Guard, Golden-Gate, Toad, Exadata, OEM, ASM, Exadata x3-2, x2-8, CellCLI, IORM, Migration, TKPROF, AWR, ADDM, ASH, RMAN, Datapump, DB Links, OPatch, oakcli, Materialized views, Database Appliance.

Confidential

Oracle DBA/MS SQL Production Support

Responsibilities:

• Installed and configured Oracle Products on Linux and Windows Environments.
• Involved in Installation and customization of Databases (10g&9i) in Linux and Solaris environments.
• Supported databases on AIX, UNIX and Linux.
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN.
• Manage users, privileges, profiles and schemas.
• Experience in using automatic monitoring and management processes such as batch processing using Crontab for processes like import/export, backups & alerts of databases.
• Involved in Schema management, Table space Management, User Creation.
• Monitoring the alert logs and trace files regularly.
• Storage management, sizing the database objects, monitoring Disk usage.
• Involved in writing UNIX shell scripting for automating the jobs.
• UNIX shell scripting to automate different processes such as data loading and data analyze
• Experience with SQL query tuning, SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• Architecture reviews, Change management meetings and Team meetings.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Disaster recovery planning and testing, on site recovery.
• Experienced in Tuning SQL statements using Explain Plan, Profiler and TkProf.
• Setup various automation scripts process in crontab on Various Servers to automate tasks like Analyze the Tables, Indexes and Monitor the Object growth.
• Maintained 24X7 Web based Production database with ODBC/JDBC environment
• 24/7 on-call production database support..

Environment: Oracle 10g/9i, HP-Ux10.2, HP-UX, Windows, Explain Plan, Profiler, TkProf, Java, and UNIX, REDGATE, FOGLIGHT, PL/SQL.

Confidential

Oracle Database Administrator

Responsibilities:

• Worked in Build and Support Teams and Installed Oracle RDBMS software on RHEL 4 Servers and Installed and configured databases
• Tuning the database parameters to improve the performance of databases
• Installed 10.2.0.4 agent and involved in registering of databases in OEM
• Involved in UP-GRADATION of databases from 10.2.0.2 to 10.2.0.4 on RHEL and Solaris
• Worked extensively on monitoring 10g grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Collected ADDM recommendations using OEM 10g/11g to tune the TOP running SQL Query's.
• Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes.
• Grant and Revoked user privileges and roles as per requirement and killed blocking session.
• Hands on experience in installing and configuring SQL Server 2005/2008.
• Dealt with tempdb issues, log space issues, online indexing and fragmentation of indexes.
• Hands on experience in using profiler, perfmon counters, foglight and Redgate
• Performed Auditing on user activities on request and per organization policies.
• Configured Recovery Manager (RMAN) and Performed Hot, Cold and Incremental backups forproduction databases using RMAN.
• Performed Cloning and Refresh of Database from production environment to test environmentusing RMAN Duplicate database and Data pump import export.
• Worked on Writing script to monitor the database with shell and PL/SQL code or SQL code such as procedure, function and package.
• Developed strategies for data extraction using Datapump from various source systems, transformation and loading into data warehouse target systems.

Environment: Oracle 9i/10g, Red Hat Linux, SQL, RMAN, ASM, TKPROF, STATSPACK, OEM, Windows Server 2003, SQL Server 2005/2008, REDGATE, FOGLIGHT, PL/SQL