SUMMARY

• Around 9 years of Exp in Oracle Database Administration, tuning, development, analysis, design, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, backup and recovery, cloning, troubleshooting and documentation.
• Excellent experience in Oracle database administration on Oracle 12c/ 11g/10g/9i RAC and standalone databases in different environments LINUX, RHEL, OEL, WINDOWS.
• Strong Experience in Installation, configuration, Maintenance, Performance Tuning, Backup & Recovery,
• Cloning of Oracle and SQL Server.
• Experience in Re - Organization of database using export/import and Data Pump.
• Experience in implementing and using Oracle Streams for Replication.
• Experience with Disaster Recovery, Data Guard, RMAN, Real Application Cluster (RAC), OLTP and Data warehousing environments.
• Enforcing Database security by creating and assigning Roles, Profiles and Privileges to various Users (Schemas) on different Objects.
• Implemented Oracle Enterprise Manager (OEM), Automatic Storage Management (ASM) & Automatic Database Diagnostic Monitor (ADDM).
• Proficient in using various database utilities like Export/Import, Expdp/Impdp (Data Pump), SQL * Loader.
• Excellent Knowledge on Golden Gate Installation and Migration.
• 3 years of experience in Goldengate Technology for Replication. Also, experienced in upgrading Goldengate software from 10.2.X version to 11.2.X.
• Extensive experience with RMAN backup, hot backup and cold backup. Performed full backups and incremental backups. Backup and Recovery strategy using hot backup, user managed and RMAN.
• Experience in developing Shell Scripts to manage Oracle databases daily backups and monitoring jobs.
• Migrating and upgrading the databases to higher versions.
• Excellent communication and interpersonal skills.
• Proficient in Verbal and Written Communication skills which enhances my ability to communicate with everyone working around me and the ability to prepare the Documentation with ease to understand.
• A quick learner and an excellent problem solver who can work independently or as part of a team. Skillful in learning new technologies quickly and incorporating them in the existing infrastructure.
• Expertise in maintaining Database Security using auditing.
• Expertise in loading data from flat files using external tables, SQL*Loader.
• Managed streams for data replication, data protection.
• Worked as a team member to provide 24x7 on-call production support
• Functional Expertise
• Supporting a customer base & troubleshooting issues in production environment involving internet technologies
• Exporting & importing data into the databases using Oracle utilities such as exp/ imp and Data pump
• Interfacing with customers, analyzing their needs and providing recommendations on capacity planning, upgrades, migration of database, application architecture
• Accountable for database creation, database tuning/reorganization, SQL statement tuning, backup/recovery, general troubleshooting, developer/integrator relations, script development, documentation and DBA training
• Creating table spaces, rollback segments, user maintenance, database security imposition by creation and granting of roles & privileges, performance tuning, backups, tuning of SQL statements and support for oracle toolsets and utilities
• Monitoring database System and optimal performance
• Preparing & maintaining servers, documentation & procedures, addressing performance bottlenecks
• Ensuring that goals of the process are achieved, restoring normal service as soon as possible based on customer perspective and within defined SLA

TECHNICAL SKILLS

Databases: Oracle 9i, 10g,11g, 12c, MS SQL Server 2000.

Middleware: Oracle Application Server 10g

Hardware & OS: Linux, UNIX, Solaris 9, 10, Windows 2000/2003.

Programming: Basic Shell Scripts.

NetWare: TCP/IP, FTP, Telnet, Netscape, and Internet

Tools: & Utilities: RMAN, Data Pump, Dataguard, OEM, Grid Control. Oracle Export/Import, SQL Navigator

Oracle Tools: SQL*LOADER, Oracle SQL Navigator, TOAD

ERP Modules: Oracle Applications R12/11

Others: VMware, Net Backup, Toad

PROFESSIONAL EXPERIENCE

Confidential, Milpitas, CA

Senior DBA Consultant

Responsibilities:

• Installation, Configuration and Administration of Oracle RAC 10g/11g/12c Databases.
• 24x7 Oracle Production Database Application support.
• Performed Oracle Schema level and Table level data migrations using Datapump EXPDP/IMPDP.
• Performed cross platform database migrations using Transportable tablespaces.
• Applying Oracle recommended patches.
• Created Standby Databases using Data Guard for Disaster Recovery.
• Involved in development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, Query tuning and providing support to developers.
• Monitoring of tablespaces, memory structures, rollback segments, logs, and alerts.
• Loaded multiple NOSQL databases including MongoDB, PostgreSQL, Couchbase, HBase and Cassandra.
• Maintained and administered Couchbase No-SQL database system.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Coordinated efforts between in-house and outsourced teams, data center managers New Jersey, Chicago, Santa Clara and major vendors Oracle, Sun, several other hosting providers such as Savvis, SunGuard
• Maintain and support Sunguard police dispatch system.
• Actively involved in Switchover/ failover processes.
• Installed, configured and maintained Oracle Databases and Applications.
• Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.
• Configuring and scheduling of RMAN database backup and performed RMAN Duplications.
• Monitored the various database activities such as Backup, Error Logs, Space, Object, Performance, User and Session monitoring to ensure proper Capacity and Availability.
• Involved in User Management and Database Security by granting appropriate Roles, Privileges, and Profiles.
• Monitoring the availability of system, listener, database, alter log file, trace file.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Environment: Oracle 10g/11g/12c databases, GoldenGate 12c Oracle Data guard, performance tuning,
• ASM, RAC, RMAN, Data pump, Import Export,

Confidential, Plano, TX  

Senior DBA Consultant

Responsibilities:

• 24x7 Oracle Production Database Administrations.
• Installed, configured and maintained Golden Gate on Oracle Databases.
• Implemented both unidirectional replication as well as bi-directional replicate using Golden Gate.
• Building Databases, Standby databases on Oracle 12c.
• Assisted in troubleshooting the Production support problems, which are related with Teradata database.
• Monitoring/aborting bad queries using Teradata Viewpoint, looking for blocked sessions and working with development teams to resolve the same.
• Created new users, Roles, Profiles and assigning the required privileges to the users.
• Experience using Export/Import and Data pump for migration of databases.
• Table Partitioning, Creating Locally managed Table spaces.
• Applying Oracle recommended patches.
• Created Standby Databases using Data Guard for Disaster Recovery.
• An online performance monitor examines information as transactions are processed, and immediately points to trouble spots using OEM Grid Control.
• Proficient in using Oracle utilities i.e. export/import, Data Pump, Data Guard, ASM and OEM.
• Actively involved in Switchover/ failover processes.
• Installed, configured and maintained Oracle Databases and Applications.
• Used Diagnostic & tuning packs along with AWR & ADDM reports.
• Creating and maintaining Views on Database objects.
• Tuning heavy data loads. Monitoring and Performance tuning.
• Upgraded Dev and Test instances to 11g.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Performing day-to -day DBA activities like Patching, Performance Tuning, Space Management, Backup and Recovery, Users and Security Management, Query Optimization, testing, implementation and Shell scripting.
• Application of patches and security patches downloaded from Oracle Metalink in lower environments before going to Production.
• Solid discipline in providing end-users timely updates on their problems. Installing server software.
• Configured and managed agents to work efficiently with Grid Control.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Proactive monitoring of Oracle Database & Applications, which include Space management, Standard services availability check, quickly identify and resolve database and application level error

Environment: Oracle 12C, 11g, OEM (Grid Control), Oracle Data guard, Sun Solaris, performance tuning, ASM, RAC, RMAN, Data pump, HP-UX, and Red Hat.

Confidential, Tampa, FL

Senior DBA Consultant

Responsibilities:

• Installed and Upgraded Oracle Grid binaries 11.2.0.4/3/2/1 and applied PSU patches for RAC, RAC One Node and Standalone databases on Super Cluster and Exadata machines.
• Created and Upgraded Standalone, RAC One Node, RAC database for SDLC and Production databases with Physical Standby and Active Dataguard databases.
• Experienced in Creating HAWC environments with Cascading and Non Cascading Active Dataguard databases.
• Experienced in creating Physical Standby, Logical Standby and Active Dataguard databases through OEM and manual process along with Dataguard Broker setup and administration.
• Participated in Quarterly Bubble testing for DR Databases and also well experienced in Switchover databases in between sites as per Application demand and Failover scenarios.
• Worked in Migration and Upgrade Projects to move standalone databases from file system to ASM on various Operating systems.
• Worked closely with Compliance Team and Auditing teams to maintain databases under our LOB to meet compliance standards.
• Experienced in Upgrading RAC cluster and databases from lower versions 9i, 10g, 11gR1, and 11gR2 to higher release 11.2.0.4 and applied PSU patches.
• Experienced in converting RAC one Node databases to RAC and vice-versa.
• Installed, Configured and complete setup of Goldengate Bi- directional replication for TIVOLI Middleware Application production database to support Application can split the data and write into various sites and get replicated.
• Implemented Uni directional/ one way replication of Goldengate for Production databases migrations/move to new hardware for minimizing Application downtime.
• Participated in quarterly Bubble testing for DR exercise and experienced in Converting Physical standby or Active Dataguard databases to READ-Write Mode based on Application demand.
• Migrated RAC, RAC One Node and standalone databases onto SuperCluster.
• Worked on migrating P0 Application databases to Exadata machines.
• Performed performance tuning for critical applications, work with application teams and developers to tune application generated sql and generated AWR, ADDM reports and did complete analysis and generated Explain plans to help in re-writing sql’s.
• Created Monthly and quarterly range partitioning on Schema tables to tune Mobius Middleware and Tivoli business Applications.
• Worked with Oracle Support and submitted SR tickets on necessary.
• Experienced in using monitoring tools like OEM 12c, TOAD, SQL developer, Shell scripting for maintenance and administration.
• Experienced in Data refreshes using export/import Data pump and normal export, refreshing Standby databases with Incremental production backup.

Environment: Oracle 10g/11g,12c with Data GuardNetApp 3050, SQL*Plus, 11g RAC, Data pump

Confidential

Staff DBA

Responsibilities:

• Add new nodes to RAC 11g Cluster to distribute the load.
• Upgraded Databases from 10g to 11g and applied patches as per requirement.
• Worked extensively on data center migrations on multiple database versions. i.e, 9i, 10g and 11g.
• Responsible for installing and configuring Golden Gate on Oracle Servers.
• Database migration from 9i to 10g to 11g.
• 24x7x365 administrative support staff.
• Configured Data Guard to provide high availability by implementing Physical stand by database.
• Used RMAN duplicate database feature to move/clone databases on Linux, AIX and Solaris.
• Cluster Installation and Configuration, Administering databases in RAC for high availability.
• Installation, Configure, setup of 11g RAC on Linux.
• Designed, configured and maintained backup and recovery policies including RMAN backups.
• SQL, PL/SQL Tuning and Monitoring.
• Compared and contrasted multiple snapshots using AWR.
• Responsible for setting up Oracle Golden Gate to help in propagating information between databases.
• Recovered databases and clone applications Using RMAN.
• Proactive performance monitoring, and capacity planning for future database and server growth.
• Performed Import and Export using Oracle Data pump utilities
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, trouble-shooting, back-up and recovery, installations and configurations on an as needed basis.
• Used external tables and SQL*Loader to import data from flat files.
• Monitored database space requirements and adjusted for future needs.
• Performed version upgrades and patch installs.
• Designed and implemented database backup/restore methodologies, responsible for Troubleshooting performance and networking issues. Basic OS system administration.
• Strict adherence to policies and procedures - specifically in regard to change management.
• Perform database administration tasks as part of a scheduled change management task.

Environment: Oracle 11g databases, Data Guard, 11g RAC, Data pump, Data Pump, 12c CloudControlOffshore Team, 24/7 on-call support

Confidential

Staff DBA

Responsibilities:

• Extensive experience in database design, Installing, configuring, managing and maintaining Oracle servers 10g/11g.
• Performing database upgrades, Installing database and security patches.
• Assisting application developers, and troubleshooting and resolving problems.
• Performing database backup and recovery, performance tuning, SQL tuning, space management, disaster recovery, data replication and database refresh.
• Migration of Oracle databases from 9i/10g to 11g in HP, SUN and Windows environments.
• Create tables, views, functions, procedures, packages, and database triggers to meet system requirements and functionality.
• Designing and implementing load balancing and failover environments.
• Performing routine database maintenance and administrative functions, including index maintenance and updating of various tables.
• Provides support to end users and Development and QA staff on all database issues.
• Implementation of database schema level objects to support logical/physical model.
• Install, configure and tune the High Availability (HA) features using Oracle Real Application Clusters (RAC).
• Designs, implements, and maintains databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation, and statistical methods.
• Develop and maintain expertise in use of automated tools for database maintenance and implementation. Develop, maintain and document shell and sql scripts and batch processes
• Possess strong working knowledge of High Availability, Backup and Recovery options and help to implement solutions and automate routine database support tasks.
• Defines and administers database organization, standards, controls, procedures, and documentation. Provides experienced technical consulting in the definition, design, and creation of a database environment.
• Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions and upgrades.
• Deliver strong Performance trouble-shooting and tuning, UNIX scripting and PL/SQL scripting support for Invest projects and critical production issues
• Install and configure the OEM Grid Control and deploy agent on the server individually to manage databases from one single point.
• Ensures economic and efficient availability of data within adequate safeguards.
• Set up and maintain oracle disaster recovery site using DataGuard.
• Install 11g golden gate for the database replication.
• Configure golden gate manager, extract and replicate.

Environment: UNIX 32/64-bit, LINUX, Tivoli, PERL, Oracle 9i, 10gR2, 11gR2, Oracle OEM, ORAC, VMWare, RMAN /DataGuard.

Confidential

Staff DBA

Responsibilities:

• Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
• Performing Hot/Cold backups of the database through RMAN or User Managed method.
• Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database.
• Perform database cloning/exp/imp to set up identical databases in the production and development environments.
• Discoverer Administration including the design and administration of Business areas.
• Maintained Oracle Application Server 10g for use with Discoverer, Portal and J2EE deployments.
• Developed PL/SQL based program for loading Data Mart.
• Oracle Applications server including OID. Implementation of Oracle Applications Server for use with Portal, Custom Forms and Reports and Discoverer 6i.
• Create and maintain users, roles and privileges.
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Involved in Database sizing, Capacity Planning.
• Perform Space Management & Troubleshooting the database issues.
• Upgrading OEMRepository and InstallingOEM 10Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Lead coordinator between technical operations team (DBA) and applications users /information systems/processing specialists
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Setting up privileges to create local and remote objects
• Create materialized views to refresh data at regular intervals.
• Using materialized view logs to reduce the replication time costs for fast refreshes.
• Installing of quarterly security patches on all non-production and production servers.
• Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.

Environment: UNIX, Oracle 10g/11g, Oracle, Sun Solaris, Veritas Net Backup

Confidential

Associate DBA

Responsibilities:

• Develop weekly reports to monitor the new objects created in the database
• Monitoring cronjobs from different databases and making sure there is no error
• Managing primary and standby databases to make sure they are sync
• Troubleshooting any production database problems, including performance, minimizing system downtime, and developing a permanent solution
• Organize the different timings based on the activity on the system to take the standby into read-only to run necessary jobs
• Proactive monitoring of all production and QA databases to ensure sufficient database resources for all production jobs including capacity planning
• Make cold backups of different instances, important owners and keep the dumps in a location from where it can be copied to the tape
• Writing shell scripts to automate the cold backups and other necessary jobs to be run overnight
• Upgrade/Migrated the production and development databases from 9i to 10.2.0.1 to 10.2.0.2
• Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans
• Created development database for testing environment and by coordinating with senior dba refreshing it from the primary database using an automated script.
• Using SQL Loader to upload data into certain tables from a flat file given by the development team
• Using different single row date functions to extract data from database
• Writing queries and sub queries involving single and aggregate functions
• Writing multiple table queries and joining tables with different joins e.g. simple, Complex or Natural Joins
• Inserting, Merging, Updating or Deleting data from the table using different DML Locks
• Creating and managing roles and assigning Object and System privileges
• Creating a Database and setting the parameter file i.e. PFILE or SPFILE
• Multiplexing control files and redo log files
• Creating different types of Tablespaces and Data files
• Querying views dynamic performance views to view the performance of database
• Creating undo table space and monitoring index usage using V$Object usage
• Managing passwords using different parameters such as FAILED LOGIN ATTEMPTS
• Managing users by assigning tablespaces, space quota and profiles
• Complying with license terms by using parameters such as LICENSE MAX SESSIONS, LICENSE SESSIONS WARNING

Environment: Oracle9i, 10g,11g, PL/SQL, Windows 2000, Linux, Solaris Toad.