SUMMARY:

• I am an Oracle Database Administrator with 7+ years of experience, including extensive technical background in UNIX/Red Hat Linux.
• Strong knowledge of Oracle Architecture, schema, and Transaction management, as well as experience administering Data Guard, RAC, RMAN, and OEM .
• Experienced in System Development Lifecycle (SDLC) and database reengineering process in Agile
• Provide a strong logical, technical skillset with excellent problem - solving abilities.
• Provides expert support for Production Application databases with respect to availability, reliability, and integrity.
• Experience in Design, Development, Implementation and support of RDBMS in Production, pre-prod, Development, and Test environments using Oracle Tools in a multi-terabyte environment.
• Sound knowledge of Oracle real application testing feature.

SKILL:

• Database Upgrade, patching and Migration
• Oracle Virtual Machine (OVM) & Remote Support using VPN
• Backup and recovery using RMAN & DATAPUMP
• Monitoring using OEM/Grid & 12C & 13c Control
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “ opatch ”.
• Experience in SDLC Methodologies
• High Availability involving Oracle RAC, ASM and DataGuard.
• Data Guard implementation for DR
• Grid Infrastructure installation and maintenance
• Flashback transaction, Flashback Database, Flashback Table, flashback dro p
• Experienced in Oracle 9i/10g/11g, 12C db
• Installed, configured and maintained Physical, Active and Snapshot standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
• Creating & dropping Guaranteed Restore Points (GRP) for application code deployment support.
• Configuration of Database Flash Back for Recovery Purposes
• Experience with Oracle 10g, 11g and 12Cn RAC, AS
• A very good team player, self-motivated, dedicated in any work environment
• Familiarity with multiple terabytes of OLTP, DSS including Managing databases ranging from 50G up to 10TB Databases.
• Proficiency managing and troubleshooting RMAN backups and recoveries, including Designing and implementation of backup and recovery strategies based on SLAs. Also setting up RMAN daily, weekly, and archive backups jobs using OEM with scripts & UNIX shell scripts for hot backups,
• Experienced installing and managing OEM 10g and 11g and 12C
• Experienced with servers such Windows, Solaris, and Exadata on Linux/UNIX based operating systems. Oracle/RedHat Linux and AIX as it pertains to managing RDBMS
• Experience implementing FGAC& FGA for database security and integrity.
• Extensive knowledge of User management such as db Security Management, granting user access, allocating tablespace quotas to users, creating user profiles to control db resource usage.
• Experienced in creating and Managing Tablespaces and adding datafiles to accommodate space issues using command line, Toad & OEM 12c & 13c.
• Performance Tuning using tools like AWR, ADDM, SQL TUNING ADVISOR, EXPLAN PLAN , STATSPACK and TKPROF, Table & Index Partitioning for optimal system performance
• Experience with Import/Export, data pump
• Experienced in SQL query optimization using EXPLAIN PLAN, AWR & REAL TIME ADDM recommendation reports, gathering statistics, running scripts, pinning the objects, BASELINE
• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 12c, 11g, 10g) for migration and logical backup of database.
• Experience in installation, upgrades, and patches and also applying one-off patches
• Strong knowledge of healthcare industry, supplemented by hands-on experience in enrollment processes, Patients, premium, Providers, Payers, Medicaid and Medicare (CMS) programs including HMOs, PPO and CHIP for all HIPAA compliancy. Experienced in the and ICD 9 to ICD 10 transactions.
• Highly motivated and strong interpersonal, responsible, reliable and good communication skill.
• Excellent team player, enthusiastic with strong initiative and quick learner of new technologies skills

EXPERIENCE:

Confidential, Houston, Tx

Sr Oracle DBA

Responsibilities:

• Perform schema level, tablespace level and whole database export and import using data pump utility for refresh purposes
• Build new databases, set up and configure new and existing database parameters for optimal performance
• Creating and managing tablespaces by adding datafiles to accommodate space issues
• Create database roles, database tables and other schemas as requested by the app Team.
• Upgrade and patch servers and OMS agents as recommended by oracle
• Configuration of database parameters for optimal performance as db workload increases.
• Creating and multiplexing control files and redo log files as recommended by oracle for recovery purposes.
• 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 10TB Databases.
• Implemented switchovers from primary to physical standby databases and have also converted physical standby to snapshot database as a part of planned maintenance activities.
• Implemented Failover to physical standby database as part of disaster recovery strategy.
• Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.
• Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.
• Implemented Golden Gate Installation and configuration for Data Replication for my databases. Also manage and maintain Golden Gate databases.
• Rebuilding Indexes and gather statistics on tables 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,
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g and 12C & 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 and 12c environments.
• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
• Manage database Users and Schemas by creating and granting them appropriate profiles and privileges for database security and development.
• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
• Refreshing Dev and Test instances with data from Production on a regular basis.
• Thorough knowledge in setting up infrastructure for databases in huge datacenters.
• Installed Oracle 11g and 12c 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 and from 11203 t0 11204 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.
• 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.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.4, 11.2.0.3.
• 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).
• Configured the necessary parameters for Flashback database settings and Fast Recovery Area (FRA), then using RMAN to issue Flash Recovery Commands
• Administering and monitoring RAC databases using both OEM and command line
• Configuring Rac databases for Fail over using srvctl utility, Adding services to Rac databases
• Starting up and stopping of cluster and local services such as listeners ASM instances, databases instances using the SRVCTL utility.
• Supporting off hours application and code deployments
• Creating & dropping Guaranteed Restore Points (GRP) for application code deployment support
• Provided 24*7 support and report to the Operations Manager and the VP of Operations
• Setup target (database) matrixes from OEM 12c/13c.
• Setup warning and critical thresholds for target databases using OEM 12c/13c cloud control.

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

Confidential, Dallas, Tx

Oracle DBA

Responsibilities:

• Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis, Design, Test and Implementation through the phases of System Development Life Cycle
• Ensured daily RMAN backups are completed and valid for restore and recovery
• Configured the necessary parameters for Flashback database settings and Flash Recovery Area, then using RMAN to issue Flash Recovery Commands
• Experience performing different types of database flashback such as Flashback transaction, Flashback Database, Flashback Table, flashback drop Etc
• Performed daily database administration on production environments
• Managing databases and instances using DataGuard, RAC in a real time production, testing, and Development environment
• Provided 24*7 support and reported to the Operations Manager and the VP of Operations.
• Implementing Oracle ASM and resolving ASM related issues
• Provided performance tuning, maintaining, and troubleshoot database problems
• Configured and maintained data loads in huge Data warehousing systems using the Informatica Power Center ETL tool. Supported data warehousing and databases
• Upgraded Oracle database using DBUA or Data Pump Export/Import
• Implemented database Refresh (cloning) using full export for table level and full database defragmentation, resulting in improved performance and effective space management
• Implemented database Refresh (cloning) using full export for table level and full database
• Tuning the SGA components for better performance and optimization
• Implemented Migration Strategies based on cost, time, and platforms requirements
• Advanced troubleshooting using trace files, alert log, and external links (Metalink or Oracle Support)
• Decommission databases and services per request from change management team.
• Generated Reports and preparing memo to communicate progress and providing early alerts for major updates
• Analyzing performance issues and providing recommendation based on testing results using Oracle's tools like AWR, ASH, AWR & Data Recovery advisor.
• Performing database patching, upgrade and migration as necessary
• Proactively diagnosing and resolving problems affecting the database using ASH.
• Maintaining database configurations in compliance with release management and change management
• Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
• Implemented database Refresh (cloning) using full export for table level and full database defragmentation, resulting in improved performance and effective space management.

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

Confidential, Pittsburgh, PA

Oracle DBA

Responsibilities:

• Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, Linux, UNIX, HP and Windows environments.
• Managed databases sizes ranging from 50G up to 6TB Databases.
• Implemented switchovers from primary to physical standby databases and have also converted physical standby to snapshot database as a part of planned maintenance activities.
• Implemented Failover to physical standby database as part of disaster recovery strategy.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance using DBMS STATS package
• Successfully migrated 12c Non CDB databases to pluggable databases.
• Successfully setup 3 node Primary RAC with 3 node physical standby for new application in 11GR2. 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
• Configured Oracle Data Guard to ensure disaster recovery, high availability and data protection.
• Database monitoring and performance tuning using OEM GC, AWR and ADDM, ASH, SQLT, TRCA, SQL Access Advisor, SPM,
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g and 12C 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 and 12c environments.
• Applying upgrade patch, maintenance 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 and 12c on Linux platform using ASM.
• Successful in applying RDBMS patches, security patches 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.
• 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.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.4, 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Performed database, schemas and tables refresh using Data Pump and transportable Tablespaces (TTS)
• Controlled database resource access through user profiles, Database Resource Manager and data access control FGA and principle of least privileges implementation
• Provided 24x7 remote support and on call Database support (rotatory weekly backup DBA from 8am Monday to 8am next Monday
• 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).
• Performed pre-installation server validation checks using RDA-HCVE
• Installed and configured Oracle 10g and 11g software on SOLARIS / UNIX /LINUX operating systems
• Golden 12C implementation starting with installation of the software
• Configuration of Golden processes for 12C container database for bi-directional, unidirectional replication

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

Confidential, Gaithersburg, MD

Jr Oracle DBA

Responsibilities:

• Establish a backup and recovery strategy using daily hot backups, RMAN and weekly full backup
• Setup both one-way and active-active data replication system and design the conflict detection solutions
• Performed hot and cold backup using RMAN
• Performed DataGuard switchover as required for maintenance
• Facilitated RMAN incremental backups by using Block Change Tracking algorithm
• Recovered data from logical failures using flashback and point in time recovery
• Performed physical and logical database design in accordance with Oracle's best practices
• Managed database security by creating and assigning appropriate roles and privileges to users depending on the user activity using
• Conferred with staff, users, and management to establish requirements for new systems or modifications
• Ensured daily RMAN backups are completed and valid for restore and recovery
• Performed hot and cold backup using RMAN
• Provided 24*7 support and report to the Operations Manager and the VP of Operations
• Provided performance tuning, maintaining, and troubleshooting database problems
• Configured and maintained data guard
• Upgraded Oracle database using DBUA or Data Pump Export/Import
• Implemented Migration Strategies based on cost, time, and platforms requirements
• Advanced troubleshooting using trace files, alert log, and external links (Metalink or Oracle Support)
• Generated Reports and preparing memo to communicate progress and providing early alerts for major updates
• Analyzing performance issues and providing recommendation based on testing results
• Performing database patching, upgrade and migration as necessary
• Proactively diagnosing and resolving problems affecting the database
• Maintaining database configurations in compliance with release management and change management
• Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity)

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, Suse Linux, RAC, ASM, SQL* Plus, SQL*Loader, OEM, HP-UX, Windows, Oracle 8i, 10g, SQL, PL/SQL, SQL plus, TOAD