SUMMARY:

• More than 10 years of solid experience in Oracle Database Administration and around 3 years in MS Sql server administration encompassing Installation, Configuration, Data Guard, Grid Control, Oracle Streams, Migrations, Upgrades, Patches apply, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance tuning, Data Modelling and Data Warehousing.
• Lustrous, yet aspirational career with a gamut of constantly emerging role pays under the belt like Infrastructure, development, Applications, Production, migrations DBA speaks more about my passion towards the databases. Aim is to be a successful data architect with the days to come
• Installation, configuration and administration of Oracle 12c, 11g, 10g RAC, RAC standby and non - RAC databases with ASM, Netapp shared file systems, ACFS and OCFS file systems on multi node systems for VLDB size 10 - 50TB for various operating systems like Windows, Unix and Sun Solaris in OLTP and Data Warehouse environments respectively
• Lead database upgrade Project for gazillion databases from Oracle 10g and 9i to 11gr2 and 12c and the respective Oracle Security Suite implementation
• Lead datacenter move
• Achieved optimal database performance through database tuning, system tuning, application tuning and SQL tuning using OEM and manual SQLT methods for more than 5 years
• Extensive experience in installing and upgrading OEM 12c grid control from 12cR1 to 12cR2 and the agents on the respective database servers
• Successfully implemented different backup strategies including user managed, physical (RMAN), logical, Online/Offline, snapshot using Netapp old storage, C-Mode filer and ZFS systems, Bcv backups and recovery methods including point in time, media recovery, full/partial, datapump export/import.
• Achieved database migration from a Normal file system to ASM file system for both RAC and Non-RAC database instances respectively
• Resilient experience with NoSQL database - Cassandra Db installation, configuring and Administration
• Experience in implementing and debugging data replication using some technologies like Oracle Streams, Oracle Golden Gate and Quest Shareplex
• Proficient in writing PL/SQL Stored procedures, Functions and Triggers.
• 24*7 on-call production database support and maintenance including remote database support
• Experience in migrating from MS SQL server to Oracle using Oracle Gateway
• Achieved database Consolidation through cross platform migration from AIX to Linux and Solaris to Linux and Windows to Linux

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Database Systems Engineer

Roles / Responsibilities:

• Extensively worked on 12C Grid upgrades for both SAP and Non-SAP from 11.2.0.4 to 12.1.0.2 and followed by post-upgrade activities like seeting up OS watcher and HUGE pages
• Extensively worked on adding storage to databases / ASM diskgroups on needed bases by working with respective capacity / VM teams by communicating the iscsi ports
• Successively handled a lots of disk swapping either to make space or to change the tier for the associated ASM diskgroups
• Administered OMS management, changing DBSNMP user password, adding users to OEM 12C and disabling gcNotify ticket generation notification to GSM ticketing system in case of any false alert and followed by mass close of duplicated flooded tickets
• Extensively worked on OEM agent installs, uninstalls, adding and removing Databases from OEM, blacking out an OEM agent, resecure an OEM agent, debugging and fixing agents suffering from COLL DISABLE, fixing incorrectly configured DB or listener targets in OEM, debugging when OEM agent is down or unreachable
• Mastered OEM 12C agent installs on Exadata boxes
• Performed Oracle Client installs on Windows servers by gathering all the requirements as needed from customer

Confidential - Texas

Technical Database Architect

Roles / Responsibilities:

• Provided production support assistance for prestigious OCE (Order Capture Engine) project in both Unlock and Non-Unlock modules by always staying on top of db sever performance in successfully keeping the load average to less than 1
• Successfully provided extensive database performance / SQL performance in identifying culprit sql’s and tuning the SQL’s else ruling them out of the Prod DB on not needed bases
• Handled the space crunch with an exponential growth in the Audit log prod DB by using partition swap in making the space available for DB, since we were short on the Disk
• Moved some write queries from Oracle to Cassandra DB since upserts/merge was taking a lot of time causing cpu waits on the DB
• Extensively worked on translating logical modelling into physical data models or RDBMS tables by identifying fact tables and dimension tables and vice versa as required by the Agile team for Oracle Data Store (ODS)
• Participated in DB Modelling using ERWIN and Toad Modeler version
• Model the databases in ERWIN for large transactional and Warehouse systems
• Reduced the response times by creating required composite index for the Getnext application from 9 secs to 1 sec and there by reduced hogging threads - never ending situation for Unlock application by identifying the trouble causing queries out there impacting functionality
• Migrated some reporting applications like OCE Inform and EDM to oracle 11gR2 RAC databases to separate and work for the performance
• Provided client side and Run time failover and Runtime load balancing for the RAC database instances
• Nailed down Goldengate errors for the abended and failed jobs
• Improved performance for the cassandra 2.0 version DB by keeping fewer SSTables and by maintaining proper memory sizes and compaction strategy
• Also laid hands in tuning some more features like Gossip setting for internode communication and failure detection and Snitches and Partitions, etc

Environment: Oracle 11gR2 RAC, OEM 12C, cassandra 2.0, ccm opcenter, ccm devcenter, Oracle GG, ATG, BRMS, FUSE, INFORM REPORTING, ACTIVEOS, etc

Confidential, Plano Texas

Oracle Exadata Architect

Roles / Responsibilities:

• Administered Oracle Exadata 3-2 appliance - compute nodes and storage nodes
• Architect the data replication using a third party data replicating software named Attunity to pull data from the source Oracle Exadata databases through Attunity application platform and dump it into the target APS MS SQL server database for OLAP / Data warehousing
• Extensively worked on performance tuning for the source Oracle Exadata by creating partitioning tables to reduce the I/O levels and the cpu utilization levels
• Managed Multi-terabyte instances and their respective applications for both Oracle and MsSQL systems and Oracle system management in addition
• Helped setup OEM 12C cloud control on the newly built server for storing repository database and installed agents on all the respective servers for the functioning of the OEM
• Performed quarterly patching for the whole quarter node exadata rack servers
• Helped setup backup strategy and continuous patching for the Exadata environment
• Successfully migrated all the robust 11g databases into 12C version and make use of most of the 12c features like Multitenancy
• Extensively used RAT in determining last ‘n; number of queries within the shared memory algorithm to review the response times for the customer and compare them versus after upgrade process and helped them further by digging into details by running explain plans
• Integrated the whole system end to end and made the systems automated for the Toll Perks project using Linux Shell scripting and Oracle PLSql procedures
• Liaison BI team and the stake holders in smoothly transitioning the business requirements into technical requirements and meet the project deadlines

Environment: Oracle Exadata 3-2 appliance version 12.1.2.2.0, Oracle MS SQL server 2012, 2014, MS SQL server APS appliance on Dell hardware, Attunity replicate software, Oracle Golden Gate, Oracle Active Standby database 11gR2, Linux, Windows, Toad 11.6, Oracle 12C RAC/

Confidential, Morisville - NC

Sr. Application DBA / Lead data Migration and consolidation

Roles/Responsibilities:

• Installation, Configuration and Maintenance of Oracle RDBMS and Client software
• Involved in cross platform migration of IDF data factory Project consolidating SDH data from multiple source databases from heterogeneous environment into a single target database on target database on Linux platform
• Used Transportable tablespace feature when using datapump utility for pulling logical export for the LOB segments
• Pulled Netapp snapshot backups both hot and cold for old Netapp/ New (C-mode filer) Netapp file systems and ZFS file systems
• Upgraded OEM cloud control from the version, 12.1.0.1.0 to 12.1.0.5.0
• Investigated and constantly improved instance performance problems by locating and tuning SQL statements by deploying SQL trace trap and by setting appropriate events
• Used sql base line information using the dynamic view ‘dba sql plan baselines’ - A new feature from oracle 11g to associate the hinted sql handle to non-hinted sql for optimal query performance without needing to every time passing the hints resulting in a code change,etc. Adopted Carlo Sierra’s SQLT techniques for sql tuning
• Configuring the execution plan for optimizer in production environment for several applications matching it up to the one in testing environments as required
• Migrated from Zfs shared storage to EMC XIO storage servers to achieve high performance by eliminating any kind of CPU contention or IO problems
• Performance tuning on Exadata appliance administration tasks for Exadata X3-2 and Exadata storage server tuning features
• Good understanding of Exadata features like smart scans, HCC, flash cache etc
• Analyzed for the under-estimated /over-estimated rows, skewed columns - need for histograms, etc as returned after pulling the execution plan
• Used new features like AUTO SQL TUNE, extended statistics, INCREMENTAL, CONCURRENT, DB QUEUE PROCESSES and in setting them globally especially where required for non-partitions/ partitions, etc
• Reduced the longer wait times of the dba /non-dba jobs from 3 days to 5 hours using some new features introduced in 11gR2 version of the database
• Weekly Data Refresh from Production to Dev and then to Test and DIT environments using datapump export/import utility and recreating databases with different names from the existing databases using snapshot backups and user managed backup methodologies respectively
• Implementing physical standby with active dataguard setup and then changed to logical standby setup with the changing customer requirements for the Outcome application – for a 4-Node RAC database
• Identified the defragmentation in some Oracle tables causing high response times and performed reorg online to free the unused data blocks
• Extensive experience in migrating/ upgrading largest 12C Oracle databases both from source 11g standalone to 12C non-container and from 11g standalone/RAC to 12C container databases respectively
• Performed Real Application Testing (RAT) feature to make sure the last 150 queries in the shared pool have no change in the response times after the migration / upgrade
• Extensively involved in capacity planning and worked with storage team in coordinating the requirements for the LUNS addition for the required diskgroups by keeping a good understanding of Storage for Unix/Linux
• Good knowledge of Oracle 12c RAC database infrastructure and functioning. Explored most of the new features with the new Oracle 12C rac database

Environment: Oracle 11gR2, SQL, PL/SQL, Oracle Enterprise Manager Grid Control 12C, TOAD, Unix – Linux, Solaris, Netbackup backup systems old and New, ZFS file systems, BCV and RMAN automatic backups, RAC, Golden Gate, Orion monitoring, dbspi monitoring, Oracle database gateway for SQL server 10g and 11g, Oracle Active Dataguard standby 11gr2, Oracle Database Vault, Oracle Security Suite, Oracle 12C RAC/ Non- RAC

Confidential

Sr.DBA / Data Architect

Roles/Responsibilities:

• Installation, Configuration and Maintenance of Oracle RDBMS and Client software
• Creating and Maintenance of the Oracle database builds and design for various Business projects
• Expertise in Designing Star schemas, snow flake schemas, conceptual modelling, logical modelling in 1st, 2nd and 3 N normal forms and Physical or Relational Data modelling techniques for Data Warehousing or OLAP purposes
• Model OLTP and DSS databases (both LDM and PDM levels) to meeting application requirements using ER/Studio Data architect
• Achieved optimal disk space for all the lower tier database servers by transitioning user managed backups using Control-M jobs to Rman+Netbackup jobs and implemented cold backups across all the databases servers for non-prod environments
• Extensive experience with shell / Perl scripting (K-Shell) in scheduling Rman+Netbackup cold backups in all the lower environments for both non-VCS and VCS database servers
• Lead the migration activity for physical standby dataguard databases for 2 major applications across data centers, i.e., from HQ data center to Weckdrive data center as a part of HQ migration project
• Lead in 3 major data center migrations – Red, Orange and Purple moves from RDC to DDC data center
• Implemented database rolling upgrades method to cut down the downtime which would be paramount to the switchover time
• Installation, configuration, Implementation and maintenance of physical standby for many lower environments with maximum availability mode
• Experience in setting up BCV backups following the SOP in the organization in terms of understanding the establish and release of the Control-M jobs to do a mirror copy of the existing production database by putting the datafiles in the hotbackup mode while the duration of establish and pulling it into the Data domain
• Extensively worked on converting logical data models to physical data models and vice versa
• Performed decommissioning for many lower version databases lower than 11gR1 rdbms
• Performance tuning by conducting AWR analysis i.e., by top 5 wait events
• Query tuning using 11g R2 Grid control and developing some scripts to trigger an alert to the DBA in case of change in hash value and fixed it by outer plan
• Loaded data from CSV file sets into Oracle tables using SQL *Loader
• Identified the xml file processing to be difficult in oracle 10g when working with a developer and figured it to be a bug and so as a resolution upgraded the database to 11gR2 version, which is much supported for xml processing
• Used I/O stat and vmstat at the OS level, AIX to monitor the performance
• Experience with databases on the VCS (Veritas clustered systems) and maintained them using VCS Production Manager client
• Worked with Tivoli Admin to define the situations for the databases as needed and especially when there was no alert generated for the oncall person when there were atleast 2000 logs lagging behind for the dataguard configuration
• Provided support assistance to prestigious Siebel application performance during Siebel upgrade project’s pre and post golive
• Actively monitored the DDL, DML changes in the database in order to keep track of the changes in the database.
• Lead the team in migrating databases across datacenters
• Assisted with DR testing.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 11g/10g
• Used IBM Optim tool as APD solution for huge databases in the environment
• Managing, troubleshooting and resolving oracle database and application issues
• Provided 24*7 Oncall DBA support on rotational bases

Environment: Oracle 12C, Oracle 11g, SQL, PL/SQL, Oracle Enterprise Manager Grid Control 11g, TOAD, Unix AIX 5.6, 6.0, Tivoli Manager 6.0, Mongo db, Oracle Active Dataguard standby 11gr2, MS SQL server 2000, 2005, 2008, 2008r2, 2012 and 2014 windows server 2000/2005/2008, fog light, spot light, HP service center, Oracle Database Vault, Oracle Security suite

Confidential, Raleigh

Sr Oracle DBA/ Data Modeler

Roles/Responsibilities:

• Installation, Configuration and Maintenance of Oracle RDBMS and Client software
• Participated in oracle database design and capacity planning
• Monitored all the 11g databases on Unix and Windows environments and their respective organic growth and the performance by using OEM 11g grid control
• Deploying all the application releases on the Web server and manually starting the Tomcat Manager using Apache Tomcat server for every release
• Achieved results in tuning mission critical applications their shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Weekly Data Refresh from Production to Test environments using datapump export/import utility
• Managing Database Locks and blocking sessions
• Daily incremental backup and weekly full backup of databases using RMAN
• Daily health checkup of the database using TKPROF, AWR, ADDM, Explain plan
• Defragmentation of tables and indexes for improved performance and efficiency
• Loading data into database tables using SQL *Loader
• Data refresh from Production to Test and Development environments using RMAN duplicate database
• Accomplished team work in migrating some application related databases from MS SQL server to Oracle database 11gR2
• Performing day-to-day activities such as creating users, roles, schemas, tables, views, indexes and running scripts given by the clients
• Managing, troubleshooting and resolving oracle database and application issues.

Environment: Oracle 12C, Oracle 11g, SQL, PL/SQL, Oracle Enterprise Manager Grid Control 11g, Ignite, TOAD, SQL Developer, Red Hat Enterprise Linux 5.5.,5.6 and 5.7, Windows Server 2003/2008, replication, XML, Apache Tomcat Webserver, Curam software Business suite 6.0. Erwin Data Modeler, Toad Data Modeler

Confidential

Sr. Oracle DBA

Roles/Responsibilities:

• Worked in a very high paced environment by providing production support for Tier1, Tier2 and Tier3 database applications, which included Siebel, Tibco, Java, Dataware house, Data mart and SAP related databases with 4 nodes and 3 node RAC, RON, Stage, Standalone and DR databases
• Monitored all the 11g and 10g databases, their respective organic growth and the performance by using OEM Grid Control 11g and Ignite
• Monitoring the Production and DR databases synchronization on a daily basis and maintained the Sync report.
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software
• Migration of databases from 11g to 10g with a backward compatibility version option using datapump export/import utility
• Performed bouncing for the databases in a rolling fashion on RAC environment for bug fixing for SIEBEL application
• Weekly Data Refresh from Production to Stage and then to Development and Test environments using datapump export/import utility
• Daily incremental level1 backup and weekly full backup for DR databases using RMAN
• Extensive experience in capacity planning, worked with storage team in coordinating the requirements for the LUNS addition to respective diskgroups in the appropriate ASM instances
• Performed day-to-day activities such as creating user’s management, tablespace management and schema management
• Monitoring for performance and constant tuning of the in-built application for good results
• Managing, troubleshooting and resolving oracle database and application issues both in OLTP and OLAP specific environments.
• Interacted and Worked with Oracle Support (SR) whenever we faced production issues by meeting the required SLA’s without any breaches
• Daily health checkup of the database using TKPROF, AWR, ADDM, Explain plan
• Managing Database Locks and blocking sessions
• Defragmentation of tables and indexes for improved performance and efficiency.

Environment: Oracle 9i, 10g, 11g, 12C SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Grid Control 11g, Ignite, TOAD, SQL Developer, Red Hat Enterprise Linux 5.5.,5.6

Confidential, MD

Oracle DBA

Responsibilities:

• Upgrades of Grid Infrastructure and Oracle Databases from 11.2.0.1 to 11.2.0.2 on 3 node RAC environment
• Oracle Grid Control 11g Installation and Configuration.
• Supported EDGE & EQUITY EDGE APPS
• Configuration of Physical Standby database for maximum performance mode – Oracle Data Guard
• Installation, Configuration and Maintenance of Oracle RDBMS and Client software
• Cross platform database – O/S migration from AIX to Linux, Windows to Linux and HP-Unix to AIX
• Migration of databases from 9i, 10g to 11g using export/import and datapump export/import utilities
• Performed rolling patch upgrades on RAC environment for bug fixing
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
• Weekly Data Refresh from Production to Development and Test environments using datapump export/import
• Daily incremental backup and weekly full backup of databases using RMAN
• Assisted in client application migrations or hot fixes
• Achieved POC in implementing unidirectional replication of table data using Oracle GoldenGate in a homogeneous environment
• Implemented Materialized views, database links
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Tablespace monitoring, Performance monitoring and tuning for performance improvement
• Maintenance and setup of Oracle Virtual Directory in various environments including Production
• Defragmentation / Re-org of tables and indexes to achieve optimal performance

Environment: Oracle 9i, 10g, 11g, 12c, SQL, PL/SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, IBM DB2, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM, JAVA, HTML

Confidential

DBA/Developer

Responsibilities:

• Implemented 2 node Oracle 10g RAC on RHEL 4.
• Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC
• Responsible for maintaining ORACLE 10.1.0.2 using SRVCTL, OEM, maintaining Oracle Cluster ware using CRSCTL.
• Setup Active standby database via Data Guard for database disaster recovery.
• Created and managed both system level and object level roles and privileges for various users.
• Creation and maintenance of control files, redo log files and data files.
• Creation and maintenance of table spaces, rollback segments and data objects.
• Tuned SGA, Rollback segments, Latch contention issues, Optimize sort operations.
• Deploying database objects from development/testing environment to production environment
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment.

Environment: UNIX, Oracle 9i/10g, PL/SQL, Maestro, Shell Scripting, Java, HTML, Oracle forms and reports 6i/9i, Oracle BI Publisher, Oracle Performance Pack