SUMMARY

• 7 plus years of experience with Oracle 12c/11g/10g/9i/8i Installation on Linux/Unix, Sun Solaris, IBM AIX, HP - UX and Windows NT/2000/2003, Administration, Monitoring, Performance Tuning, Database Backup and Recovery.
• Excellent track record in providing 24/7 on-call support for both production and development databases in result-oriented, time-critical environments.
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability
• Excellent experience in Installation and configuration of Oracle 8i, 9i, 10g,11g and 12c in UNIX/LINUX and Windows environment. Particularly installation of 11g and 12c RAC on ASM.
• Planned and implemented DR & high availability solutions using OEL 10g Standby Database using Oracle Data Guard, 11g and 10g RAC.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool. Supported a large number of Development Databases.
• Proficiency with Installation and maintenance of replication tool Golden Gate 11 and 12c Versions by creating extract process, extract pump, and replicate.
• Implemented Golden Gate for data recovery and data migration for Oracle 11gR2 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.
• 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.
• Experienced in using 11g features Data Pump, Mean Time to recover (MTTR), AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
• Experience in building Standby databases. Implementing FSFO (Fast start failover) on databases and configuring disaster recovery site using Datagaurd. Also proficient with 11g features such as Active Datagaurd and Snapshot standby database.
• Proficient in administration activities like Installation, Configuration, Upgrades, Patches, TAR support, Cloning, Capacity Planning, script development and documentation.
• Experience in Upgradation of Database from 9i to 10g, 10g to 11g,11g to 12c
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, data Migrations using export/import, benchmarking using load testing tools.
• Hands on experience in SQL, PL/SQL, Partitioning, Data modeling, OLAP, Logical and Physical Database Design.
• Experienced in Tuning: Used Explain plan and TKPROF for SQL/PLSQL tuning; Used STATSPACK performance tuning i.e. tuning SGA, I/O distribution using STATSPACK.
• Performance tuning expertise, specializing in OS tuning, SQL tuning, Database/Instance tuning.
• Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzed SQL trace dumps for 9i/10g/11g.
• Extensively used advanced queuing to process the on line jobs.
• Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.
• Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools.
• Experience in utilities RDA, Hand Analyze, Truss, Pstack, ADDM, Symantec I-3, AWR
• Extensive experience on OEM,TOAD (Tools for Oracle Application Developers), SQL*Plus and SQL*Loader as well as traditional UNIX command that requires for Oracle DBA
• Configured and Maintained Physical Data Guard for High Availability and offline reporting.
• Designing and Building Relational Databases architecture in OLTP, OLAP, client/server.
• Experience in Data Compression, Table Compression, OLTP Compression, Health Check Monitoring, Flashback Data Archive, CRS and ASM
• Installed, configured, and resolved issues with the Oracle Streams utility, and with the Oracle Change Data Capture utility (CDC).
• Experienced with installing, configuring and administering SQL server 2000/2005/2008/2012 databases including migration from MS SQL server to oracle.
• Good experience in MSSQL Server 2000/2005/2008/2012 , T- SQL with knowledge of Server Clustering, SQL Profiler, Execution plan, Log Shipping, and Database Mirroring.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i/8i

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10, AIX 5.1, 5.2, 5.3, 5.4, Linux RHEL 2.1, 3.x, 4.x,5.x,6.x MS SQL Server 2000/2005/2008/2012 , Windows NT,XP

Languages: SQL, PL/SQL, C, C++, Perl, Korn, UNIX Shell Scripting.

Networking: ISO 8583, TCP/IP, UDP, SCI, SPI, PCI, NFS, DHCP, LAN

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, expdp, impdp, TOAD,Sql developer, Sqlplus

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.

Other Tools: Streams, Golden Gate EMC, NetApp, ETL, Veritas NetBackup, HTML, Java Script

PROFESSIONAL EXPERIENCE

Confidential, Cambridge, MA

Senior Oracle DBA

Responsibilities:

• Implemented Oracle GoldenGate HA RAC environment to several downstream databases which are acting as offload databases by application teams.
• Implemented Oracle Goldengate as a part of Migration and Upgrade project.
• Migrated OLAP databases close to 2TB in size from AIX single instance to LINUX three node RAC with minimal downtime using GoldenGate and verified data integrity using Goldengate Veridata tool.
• DDL replication with GoldenGate was provided for databases where heavy loads were run by BATCH jobs.
• Upgraded the transactional Oracle Databases from Oracle 11.2.0.4 to Oracle 12.1.0.2 in Production and lower environments and applied PSU (July 2015)
• Working on JIRA tickets fulfilling developer, ETL and several team’s requests.
• GoldenGate 12.1.2.1 Upgrade from 11.2.1.0.22 version and handled FORMAT RELEASE changes for local and remote trail files in Extract and Pump processes.
• Configured Goldengate for DDL and DML replication
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption) using RMAN and Oracle Flashback.
• Coordinated with UNIX team on gathering the requirements to allocate new resources for building new hosts required as a part of migration.
• Coordinated with the storage team to gather additional storage required on the servers and new mount points setup on the databases.
• Configured RMAN backups in OEM and cron for development databases along with scheduling weekly Full Backups, Daily Incrementals and Archivelog Backups.
• Working on daily tickets which involved password resets, account unlocks, users creation and tickets reported by developers having issues with any database.
• Cloned environments to create patch test, development and QA environments
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.
• Run SQL tuning advisor to compare execution plans and analyze them before enforcing the SQL profiles for optimizer to pick up best execution plan.
• Troubleshooting resource intensive SQLs by enforcing optimal plans using SQL plan management.
• Experience in key data warehouse concepts such as Dimensional Modeling, Slowly changing dimensions, Star and Snowflake schemas, Master and Metadata Management.
• 24 x7 databases support for the customer-facing and servicing environments as a part of Goldengate migration project to make sure that no performance issues are impacting the applications in this critical environments.
• Operational DBA support for all environments on daily shift basis and On Call rotation to support production systems.

Confidential, Des Moines, IA

Senior Oracle DBA

Responsibilities:

• Worked on Installation and maintenance of Oracle 11g RAC databases including Golden gate, ASM and CRS.
• Worked on 10g/11g and 12c versions of Oracle databases.
• Involved in installation and maintenance of oracle 11g and 12c databases.
• Responsible for installation of Oracle Clusterware (CRS ) also referred as Grid Infrastructure from 11g and creating the RAC and Standalone databases.
• Upgraded the RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2 and 11.2.0.3 and 11.2.0.4) as part of performance improvement by utilizing the new features .
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Installed Oracle 12c database with a single instance on a Linux in a test environment.
• Worked on Oracle GOLDEN GATE for transferring data between 10g and 11g
• Performed Initial load, extract, replicat, trial files and exporting data onto Repository Database using Golden Gate tool.
• Worked on Debugging and trouble-shooting replication issues in Golden Gate 11gR2
• Handled large volume transaction loads in various replication scenarios and fast resolution of issues.
• Worked on Golden Gate patching, upgrade and solutions for compressed and encrypted tables and table spaces.
• Worked on Troubleshooting complex Golden Gate production issues including latency optimization and conflict resolution.
• Worked on Database Wallet and TDE (Transparent Data Encryption) for Encrypting the Sensitive data using column encryption and tablespace encryption.
• Applied the Clusterware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using opatch .
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Worked on installing CPU patches manually and also using enterprise manager grid control.
• Worked on installing the Rollover patches for RAC databases.
• Applied PSU (Jan 2015 & April 2015) patches
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade, 24x7 production support.
• Worked on database administrative tasks include monitoring, performance tuning, trouble-shooting, backup and recovery, installations and configurations on as needed basis as well as applying patches and upgrades.
• Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp.
• Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.
• Implemented archive and Purge strategy for archiving the inactive data and purging the archived data from the primary/OLTP database as a part of performance improvisation with minimal downtime using online redefinition.
• Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.
• Adding the required User Logins, Groups and Users, Granting and Revoking Permission to/from the users. Co-coordinating with on-site counterpart as well as clients and understanding requirements
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Designed and developed Database structures (Database triggers, Procedures, Functions to implement business Rules). Loaded data into Database using external tables. Exposure to Oracle Utilities and Tools like OEM, Import-Export, Auditing, RMAN.
• Monitored Goldengate using 12c Goldengate Plugin and also Goldengate Director and shell scripts for alerting GG process down alerts.
• Worked on scheduling the automated jobs via OEM grid control, cron and autosys (using jil file).
• Responsible for optimizing sql queries and tuning the long running queries as a part of performance improvisation.
• Providing the Go-live and Post - golive Support for the database performance related issues and Ensure that all the work is documented for future reference. Generating Statspack reports and AWR and ADDM reports for Database for Application tuning and also database Partitioning. Collected performance statistics memory usage, data storage.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Working with Server Admin to resolve the server level issues.
• Installed and administered SQL server 2000/2005/2008/2012 databases including migration from MS SQL server to oracle & MS SQL Server 20 .

Confidential, San Jose, CA

Senior Oracle DBA

Responsibilities:

• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g Release 2(11.2.0.2,11.2.0.3) install and upgrade on all the environments (in a procedural approach Dev, Test, Stage and Production) also Planning of back out procedures like downgrades/building parallel environments and also working on proof of concept for Oracle 11gR2 upgrades.
• Checking Backup and Restore validity periodically on databases about 12TB in size, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups
• Responsible for installing, supporting the oracle stand alone, RAC(2node) and RAC(2node) with Dataguard databases of the version 11g, 10g and 9i on AIX 6.1/5.3/5.2, Sun Solaris 10, and Windows 2008.
• Used Vertias Cluster File System (VCFS), ASM file system and SCAN LISTENER in installing Oracle 11g RAC and also installed oracle grid agents on standalone and RAC databases.
• Worked with maintaining the OCR and VOTING DISK in normal and external redundancies and also worked with cluster ready services (CRS) and used CRSCTL for maintaining CRS.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN. Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2.
• Worked on installing the data guard on RAC databases for disaster recovery and setup the dataguard broker.
• Tested the dataguard switchover on the RAC databases manually and also using dataguard broker.
• Worked on resolving the gap between primary and standby databases in dataguard by registering the missing archive logs in the standby database of about 8TB
• Worked on setting up the flashback and restore point on the databases and also flashbacked the databases to restore point when required.
• Created Cluster-database, Cloning of Cluster database on Linux, start and stop Cluster database services.
• Worked with different utilities like dataguard broker (DGMGRL), SRVCTL, CRSCTL and CLUVFY.
• Configured OEM 12c Grid control to monitor database performance, SQL query tuning, create monitor block, and deployed plugins.
• Implemented and administered Oracle Golden Gate (v10) for Database Replication between production and reporting node.
• Performed Initial load, extract, replica, trial files and exporting data onto Repository Database using Golden Gate tool.
• Experienced with SRVCTL, OCR and Voting Disk of 10g, 11g RAC.
• Database Maintenance, Data warehousing, and Data Modeling using Erwin.
• Involved & performed Production Change Requests for PRD major DB changes. New DB creation, Existing DB deletion, various DB Housekeeping activities.
• Kept tracking the database performance using oracle enterprise manager and checking the users sessions consuming more CPU and taken the necessary steps to reduce the CPU usage.
• Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp.
• Refreshed the databases from PROD to UAT, QA, and DEV using RMAN.
• Performance tuning of oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor.
• Worked on DR tests using dataguard and VVR, resolved the issues during switch over and switch back.
• Migrated the databases from 9i and 10g to 11g from SunOS to AIX.
• Upgraded the databases from 9i and 10g to 11g and resolving the issues during upgrade.
• Worked on RMAN backup and recovery. Recovered the databases (full recovery) during database upgrade and point in time recovery as per the user request using RMAN.
• Created the dblinks (private and public), synonyms (private and public) and views. Validated the views and compiled the views which are invalid.
• Have used different tools like DBArtisan (8.7.2), EXPLAIN PLAN, TKprof, STATSPACK to solve the performance issues.
• Helped developer in installing Oracle Client, troubleshoot and establish the connection to Oracle database through JDBC.
• Responsible for monitoring RMAN backup jobs and analyze tables and indexes of Oracle database periodically for better performance.
• Responsible for monitoring the daily jobs and resolving and finding reasons for failed jobs.
• Perform production system problem analysis and recommend corrective measures in a timely manner.
• Responsible for creating the sizing documents for databases as per storage provided by application team. Documented all the necessary work for future reference

Confidential, Los Angeles, California

Senior Oracle DBA

Responsibilities:

• Experience in setting up high availability solutions including physical and logical standby Databases using Data Guard and replication using Oracle Streams.
• Provided design and installation techniques for Clustering and Performance Tuning.
• Responsible for Installation, Configuration and Administration of Oracle 10g RAC databases.
• Implemented Version upgrade of 10g RAC Databases by applying Patches as per requirement.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities
• Migrated single instance databases to multi node 10g RAC environment for high availability and load balancing.
• Applied critical patch updates (CPU) released by oracle quarterly.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and ‘rewind’ entire database to a particular time respectively.
• Optimized data access and performance by tuning indexes.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Administrated all database objects, including tables, clusters, indexes, views, packages and procedures.
• Experience in configuring Data Guard 10g R2 for physical standby database.
• Experienced in managing Data Guard configuration using DGMCRL tool.
• Planning, Implementing and Validating various versions of Oracle Databases to 10g Release 2( 10.2.0.2 and 10.2.0.4)& 11g Release 1(11.1.0.6,11.1.0.7) upgrades on all the environments
• Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to Non-Production environment, Creation Duplicate Databases using RMAN Backups.
• Experience with Replication concepts and used Golden Gate Software to do the replication.
• Implemented backup policy using oracle RMAN.
• Tune, optimize and monitor the database clusters and instances to achieve optimal performance in meeting defined SLAs (Service Level Agreements).
• Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables.
• Prepared test environments for backup/recovery using RMAN and Recovering Databases when there is any physical or Logical Corruption.
• Created routines for Daily, Weekly & Monthly partitioning of tables. Created/Altered Partitioned tables for large customer related data.
• Detected locks and resolving in-doubt transactions manually.
• Extensive Experience with Change Board Meetings and Change Control Management for all database changes.
• Handled Vendor applications and interacted with vendors regularly to understand and optimize the database operations.
• Actively participated on war room bridges during major releases and escalated to dba management as needed.
• Participated in database audits and following compliance rules and regulations always.
• Worked with HP service guard on top of oracle 10g databases.
• Participated in requirements gathering meetings with customer while building out new db environments.
• Effectively communicating with PM'S while working on project related tasks.
• Prioritizing db related tasks on daily basis and completing most of them before end of every business day
• Worked with offshore team and co-ordinated with them always for any database changes by means of email/phone communication.
• Always uploaded the common share point repository with all updated work related documents for sharing purpose.

Confidential, Mclean, VA

Senior Oracle DBA

Responsibilities:

• Involved in installation, configuration and support of Oracle 10g RAC.
• Providing 24x7 on call support for the business critical production real application cluster (RAC) databases.
• Managing two nodes Real Application Cluster databases on Red hat Linux advanced server 2.1.
• Performed Database upgrade/migration from Oracle 9.2.0. To 10.1.0.3.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating users and database links, snap shots on production and development servers.
• Schedule cronjobs and monitoring application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.
• Performance tuning for optimized results using Explain Plan, SQL*Trace, TKPROF and Stats pack.
• Created scripts to query performance views in an effort to reduce parse times and tune memory structures such as the database buffer cache, shared pool, library cache and PGA for a shared server configuration.
• Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data modelling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Implementation of High Availability solutions with Oracle 10g RAC, Standby Database Data Guard, Replication.
• Created physical standby database (for disaster recovery) from hot backup of primary database.
• Resolved gaps between primary and standby databases (Gap Resolution).
• Write monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Was involved in developing a disaster recovery (DR) plan.
• Expertise in Replication of Oracle Databases using Logical Standby and Streams and Shareplex.
• Performing Backup/Recovery of all the Oracle databases using RMAN.
• Scripts for Health Check of Databases.
• Expert scripting experience in Perl and all UNIX shell scripting variations.
• Reading Alert Logs and User trace Files and Diagnosing the Problem.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• OS level activities like space monitoring of Mount points.

Confidential

Junior Oracle DBA

Responsibilities:

• Involved in the installation of Oracle products (9i) on Windows NT and Linux.
• Cloning the databases for different environments.
• Creating primary database storage structures (table spaces, rollback segments, etc).
• Applied patches, keeping applications software bug free, and improving data integrity.
• Execute Hot, Cold and RMAN backups and recoveries.
• Tuning the Database and Analyzing the Database.
• Participated in Disaster Recovery Drills, documented database and application validation steps
• Applied High priority, security patches downloaded from Metalink.
• Coding PL/SQL & Shell Scripts, Design/Code reviews.
• Installation of the Databases, Environment Building to OFA compliancy.
• Recovery Manager (RMAN) Implementation and strategies, Various Database Recovery scenarios verification in advance.
• Altering the Database objects and files during maintenance.
• Database Maintenance, Data warehousing. Data Modeling using Erwin.
• Software design of medium/large business applications, Design methodologies.
• Database (SQL) design, E-R Modeling, Design and Development Of database design.
• Jobs Scheduling, Exports/ Imports, Space Management.
• Hot and Cold Database Backups and recovery, Shell Scripting, Restoration Tuning Memory.
• SGA, I/O, OTIMIZATION, SQL- tuning, Security Management.
• Managing the network and service changes on the network of the databases.
• STANDBY Database implementation and Automation of the process (KSH, LOADER, PL-SQL scripting combination) of ftp download of files to proper load and update on tables.
• Writing shell scripts, Loading data into the database from the flat files with SQL*Loader.
• Installation, configuration and upgrading of Oracle server software and related products.
• Responsible for setting and managing user accounts, Granting required privileges to users.