SUMMARY:

• I have over 5+ years of hands - on experience as an Oracle Database Administrator.
• I possess complete database life cycle knowledge including Installations and production support.
• I have Worked on Oracle 10G, 11G, 12c, 18c and most recently19c versions.
• I am involved in production support as well as individual and group projects.
• Excellent knowledge in server as well as database installations and configuration. DataGuard configuration and management, golden gate configuration and troubleshooting, RAC, ASM, GRID control installations and configurations as well as troubleshooting.
• Database upgrades and tool Upgrades (for example, upgrading OEM), Patching, Migration, Backup and Recovery, Performance tuning, Cloning, space management, Data Pump, traditional import/export, User management and security.
• I am also experienced in managing AWS EC2 and RDs instances. Creating/modifying volumes, restoring databases and schemas from snapshots, creating AWS databases from AMIs, managing security groups, managing S3 bucket storage, availability zones, etc
• I am also familiar with postgresql, working with version 9.6 and most recently, working with version 10.14 installations, and management of the postgres database.
• Excellent knowledge on performance tuning, incident management, as well as incident report handling.
• I also have good mastering on database monitoring and auditing.

TECHNICAL PROFICIENCIES:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x..6.x and 7.x . Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

RDBMS: Oracle 9i, 10g, 11g, 12c,19c

Languages: SQL, PL/SQL, UNIX Shell and bash Scripting.

Tools: SQL*Plus, Oracle Enterprise Manager Grid Control 12 and 13c, Toad, Putty, TKPROF, EXPLAIN PLAN, STATPACK, AWR, ADDM, ASH, NX client, WinSCP, Remote Desktop Connection, Team Viewer, EMCLI (oracle Enterprise manager command line), SQL Trace, SQL Developer, Amazon S3 Bucket, Service Now, JIRA, Password GEN.

Database Utilities: RCONFIG, ADRCI, DBVERIFY, DG Broker, ASMCMD, SRVCTL, CRSCTL, LSNRCTL, SQL, DBNEWID, Transportable Tablespaces, SQL*Loader, RMAN, traditional imp/exp, DataPump, Log Miner, DG observer, RMANSoftware: Oracle, Postgres, AWS

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr Oracle DBA

Environment: Oracle 10g/11g/12c/18c/19c RAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, Linux, UNIX, HP environments.
• Managed databases sizes ranging from 50G up to 40TB Databases.
• Configured Dataguard, Implemented switchovers and failovers from primary to physical standby databases and have also converted physical standby to snapshot database as a part of planned maintenance activities. Also converted dataguard standby from read only to active mode.
• Implemented Failover to physical standby database as part of disaster recovery strategy by installing and configuring a dataguard observer with broker, used to monitor the DG configurations in my environment, and initiates an automatic failover whenever primary database goes down..
• Creating, Rebuilding Indexes and gather statistics on tables/schemas/ databases on different databases on a regular basis to gain database performance using DBMS STATS package
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
• Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM. Monitoring database resource usage like CPU, memory, load ave etc
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g and 12C and 13C Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i, 10g, 11g, 12c, 18c, 19c environments.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.Also experience with snapshot backups.
• Manage database Users and Schemas by creating and granting them appropriate profiles and privileges for database security and development.
• Applying upgrade patch, maintenance, bug fixes and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g, 12c, 18c, 19c on Linux platform using ASM.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Successful in Upgrading RDBMS Databases from version 10g to 11g,12c to 18c and 18c to for improving the security and functionality of the databases.
• Efficiently performed installation, setup and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Also performed installation of 2 node RAC databases on oracle 12C.
• Installation of AWS oracle 12c and 19C servers and databases.
• Maintenance of Oracle 11gR2, 12C,18c,and 19C Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11G, 12C and 19C.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Confidential, Dallas, Texas

Sr Oracle DBA

Environment: Oracle 10g/11g/12c/18c RAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, Linux, UNIX, HP environments.
• Managed databases sizes ranging from 50G up to 40TB Databases.
• Configured Dataguard, Implemented switchovers and failovers from primary to physical standby databases and have also converted physical standby to snapshot database as a part of planned maintenance activities. Also converted dataguard standby from read only to active mode.
• Implemented Failover to physical standby database as part of disaster recovery strategy by installing and configuring a dataguard observer with broker, used to monitor the DG configurations in my environment, and initiates an automatic failover whenever primary database goes down..
• Creating, Rebuilding Indexes and gather statistics on tables/schemas/ databases on different databases on a regular basis to gain database performance using DBMS STATS package
• Tuning the Databases for optimization using AWR, ASH, ADDM, STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Utilizing Enterprise manager to monitor alerts, schedule jobs, monitor SQL loads, generate AWR reports
• Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM. Monitoring database resource usage like CPU, memory, load ave etc
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g and 12C and 13C Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i, 10g, 11g, 12c, 18c, 19c environments.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.Also experience with snapshot backups.
• Manage database Users and Schemas by creating and granting them appropriate profiles and privileges for database security and development.
• Applying upgrade patch, maintenance, bug fixes and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g, 12c, 18c, 19c on Linux platform using ASM.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Successful in Upgrading RDBMS Databases from version 10g to 11g,12c to 18c and 18c to for improving the security and functionality of the databases.
• Efficiently performed installation, setup and creation of three node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Also performed installation of 2 node RAC databases on oracle 12C.
• Installation of AWS oracle 12c and 19C servers and databases.
• Maintenance of Oracle 11gR2, 12C, 19C Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11G, 12C and 19C.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Confidential, Albuquerque, NM

Sr Oracle DBA

Environment: Oracle 10g/11g/12cRAC, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

Responsibilities:

• Implemented proactive Performance Monitoring Tuning and Troubleshooting - Tuning involved; I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using these Oracle's regular performance tuning tools like; Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH, SQL tuning advisor etc.And also Cluster InterConnect Tuning (RAC).
• Supported 24x7 mission critical applications which include different versions Oracle 10g/11gR1/11gR2/12c for Standalone and RAC Databases.
• Database monitoring/maintenance, replication process and performance tuning done using OEM (Oracle Enterprise Manager) 12C.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), hot and cold backup, and Database Flashback using PITR (Point in time recovery) and Export and Import (Datapump and Normal) for restoring the specific objects at the database level.
• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog. Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing.
• Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g/11g/12c environments.
• Supporting multiple database for and staging purposes on DEV,INT1,STAGING and PROD red hat enterprise Linux, HP-UIX UNIX, AIX windows and Solaris.
• Migration of Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Configured and implemented Oracle 11g ACTIVE DATAGUARD for Database Disaster Recovery by using DATA GUARD broker (DGMDRL).
• Installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Refreshing DEV and Staging instance with data from production on a regular basis and also when QA need to test an application and requires a refresh from me.
• Made optimal use of Meta link in resolving the SRs.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Applying patches, maintaining an interim (opatch) patches on the database. Successful in applying RDBMS patches, security patches for improving the security and functionality of the database.
• Upgrade databases from 10G,11.2.0.2,11.2.0.3 and 11.2.0.4 to 12c as part of performance improvement by utilizing the new features.
• Efficiently performed installation, setup and creation of a 2 node Oracle 11g RAC cluster using GRID infrastructure for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC with ASM file system.
• Used PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts created by developers to manage/monitor databases.
• Implemented and monitored ASM on RAC and stand-alone databases, managing disks groups with ASM in oracle 11g environment.
• Automate the process of monitoring free space in tablespaces at regular intervals.
• Production support database on 10g, 11g and 12c versions with standalone and RAC environment
• Set up user profiles and roles as per the access level of user for the data and application security.
• Installation and configuration of Oracle Golden gate.
• Re-wrote the shell scripts to monitor Golden Gate processes various states (like STOPPED/ABENDED/LAG/HUNG) to reduce number of alerts by grouping them together by environment.
• Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.
• Configured deployed and administered 3 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 6.0, using ASM and Raw Devices on Oracle 11gR2.
• Table created with Daily Range partition, indexes and script automated which add/remove partition as per client requirement.
• Capacity planning: Allocate system storage and plan future storage requirements.
• Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
• Involve in 24x7 on-call support for 38 databases of about 60GB to 7.5TB,3 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification.
• Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting and revoking required privileges to users.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Developed compliance reports and performed auditing at higher levels.
• Resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
• Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
• Upgrade and Migration of Database from 11.2.0.2to 12.2.0.2 and applying patches whenever required.
• Efficiently performed installation, setup and creation of 3 node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5. Installed and configured 3 node server side load balancing Oracle RAC 11g, 12c databases on Linux with ASM and DataGuard.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Performing monthly and annual performance reports for trend analysis and capacity planning.
• Worked on both VMS and UNIX environments.
• Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
• Writing UNIX/SHELL scripts for providing the reports.
• Backup of Archive Logs, Control Files and SPFILE on Tapes to Ensure Complete Recovery can be achieved.
• Worked closely with Performance testing team in providing Database support for all the application releases in reaching the required SLA standards.
• Involved in engaging different people bringing them on-board whenever a triage needs to be opened.
• Supported Oracle applications such as E-business suite 2008 R2, and Siebel.
• Upgraded E-business suite from .
• Experience with managing Database Vault, Autodesk vault server.
• Contacting Oracle Support for technical assistance in resolving problems in a timely fashion.
• Ensuring Database security by virtually separating databases and using VPD (Virtual Private Database) in RAC environment to support two different set of application users by making data non-transparent to each other.
• Participate on project team as a database administrator, supporting and ensuring that databases are appropriate modified to support new business applications and requirements.

Environment: Oracle 10g11g/12c RAC and standalone, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.