SUMMARY

• 9 years of IT experience in Oracle (19C/18C/12C/11g/10g/9i) as Database Administrator having hands - on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting, and documentation.
• Hands-on experience in working on various platforms like SUN SOLARIS, AIX, Red Hat/SuSE Linux and Windows (NT/98/2000/XP/vista).
• Quarterly Full Stack Download Patch (QFSDP) application on Exadata engineered systems X6-2, X7-2, X8-2 machines
• Database experience usingOracle 19c/18c/12c/11g/10g/9i, SQL, PL/SQL, SQL LOADER, Stored Procedures, TOAD, Explain Plan, TKPROF FUNCTIONS, Materialized Views, Database links, and streams.
• Hands-on experience in various stages of the System Development Life Cycle (SDLC).
• Excellent hands on experience in working, coordinating on end to end installation for oracle engineered system Oracle Exadata database machine X6-2, X7-2, X8-2.
• Experience in OracleGolden Gate installation, configuration, troubleshooting GG issues
• Experience in Oracle Database Administration activities such as L3 production support, Database design, Installation, Configuration, Upgrades, Patches.
• Experience in configuring Automatic Storage Management (ASM) to administer the oracle related files. Upgrading and Migrating of the Databases.
• Good experience in Oracle Clustering services, VERITAS Cluster Services (Quick I/O file systems) and High Availability features.
• Implement Oracle RMAN backup and restore procedures (Full, Incremental and Archive) using datadomain, HP Catalyst, Zero Data Loss Recovery Appliance (ZDLRA).
• Experience in using features Data pump, Flash-Back Recovery, AWR, ADDM, Grid Monitoring, and Recycle Bin.
• Experience in implementing TDE (Transparent Data Encryption) to secure data at rest and documenting the process.
• Strong experience in using SQL Developer, SQL*Loader, Exp, Imp, Datapump (Expdp, Impdp), Putty, TOAD, Oracle Enterprise Manager (OEM), SQL*Plus tools.
• Strong Knowledge of creating Tables, Indexes, Views, Materialized views, Synonyms, Dblinks, Packages, Procedures, Functions, Cursors, Triggers.
• Hands-on experience in SQL server installations in Windows 2003, Windows 2000.
• Scheduling jobs through Oracle Job Scheduler, Crontab (Unix), Scheduled Tasks (Windows) CTRL-M Jobs and Maestro (Job Scheduling Tool).
• Proactive Monitoring, identifying areas that need to be improved in the application and database using 12CR1-R3 OEM Grid Monitoring. Involved in Unit Testing, System Testing, and supported User Acceptance Testing.
• Good experience in Data Migration using export/import.
• Hands-on experience in various stages of the System Development Life Cycle (SDLC).
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Good Shell scripting, Ansible automation experience. Python scripting knowledge for day-to-day database administration tasks that include various Cron jobs for alert logs and performance, Backups, Restores and Recoverability.
• Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.
• Strong ability to handle multiple projects simultaneously through completion and ability to work independently or in a team environment and the ability to function successfully in a highly stressful environment.

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris 2.6/8/9/10, Red Hat Linux and IBM AIX 4.x, 5L, 7 Windows NT/00/XP/Vista

RDBMS: Oracle-19c/18c/12c/11g/10g/9i, 12C-R2 Microsoft SQL Server

Database Servers: HP 700 Series, HP Superdome, Sun 3500, 3800, 6800, Sun Enterprise 450, Oracle Application Server 10g, Sun Fire V1280, Dell PowerEdge T100, Sun fire 4800

Cloud Technology’s: Oracle, Azure, AWS

Languages: SQL, PL/SQL, Java, C, C++, UNIX Shell Scripting

Tools: RMAN, OEM, SQL*Loader, SQL Developer, SQL Navigator, Toad, Data Pump, Golden Gate, Oracle Streams, TOAD, Shareplex, SSAS, SSIS, SSRS

Others: EMC, NetApp, Veritas NetBackup, HP OMNI back-up, Actifio, Liquibase

PROFESSIONAL EXPERIENCE

Confidential, San Antonio TX

Sr ORACLE DBA

Responsibilities:

• 24x7Oracle Production Database Administration including Oracle12c/18C/19CRAC.
• Installed, configured, and maintained Oracle Databases.
• Installed and configured OEM GridControl.
• Install and configure Oracle GoldenGate.
• Worked and Migrated large volume database up to 10 Tb data from 12C to 19 C using GG
• Establishing standards, policies, and procedures forGoldengatereplication administration.
• Responsible for installing and configuringGoldenGate 19 on Oracle Servers
• Managing, troubleshootingand resolving oracle database, RACand applications issues.
• Involved inUpgrade/Migrationof the oracle databases from Oracle12C to Oracle 19C and Sun Solaris to OEL (Oracle Enterprise Linux).
• OEM Grid control to monitor all databases.
• Implementation of High Availability solutions withOracle 19C RAC,Physical and Logical StandbyDatabases(Data Guard)andReplication using Golden Gate.
• Developed back-end logic for business applications, e.g.views, procedures/functions, triggers.
• Developedscripts and reportsusing SQL, PL/SQL andPerl.
• Designed and implemented OracleReal Application Clusters (RAC)on Solaris withEMC Storagefor anOLTP applicationwithTransaction Application Failoverandhigh transaction volume.
• Established best practices and best procedures for database administration. Responsible for Software life-cycle support to include migrationof all custom application changes through four different instances to production.
• Standby Database (Data Guard)setup and configuringDB links.
• Developed 2 node RAC environments for a 1TB database and Implementing Data guard on this RAC environment with another RAC Standby Database.
• Monitored/managed2 node RACenvironments, databases using OEM Grid control, and RMAN database backup and recovery.
• Working alongside programmers and contributing to the development process; Enabling and analyzingtrace files
• Performing monitoring and performancetuning.
• Defining and Settingbackup and recoveryprocedures.
• Performed and tuned using AWR, OEM Grid and tkprof etc Oracle Databases.
• Tuningthe database usingstatspackand custom scripts
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Tuningand balancing I/O by monitoring file system and tablespace I/O statistics.
• Experienced inTuning SQLstatements usingExplain Plan, SQL Trace, TKPROF and STATSPACK
• WritingShell Scriptsfor managing day-to-day activities andautomation of backup.
• Optimal Space utilizationin tablespace by avoidingfragmentation.
• Usage ofPartitionsto improve the queryperformance and manageability.
• Installation ofOracle RDBMSserver software andversion upgrades.
• Backup of Database(Making Backup Schedules depending upon Business Strategy: DailyBackup, weeklyBackupetc.)
• SQL and PL/SQL Programming.
• Installation and configurationof Oracle Client software and Tools.
• Analyzed the user requirements anddesigned partitioned tablesfor improving the performance of Data marts.
• Analyzed the user requirements andDesigned views using STAR schemafor improving the performance of Data marts.
• Performedpartition maintenanceand automated the process ofcreating new partitionsas and when required.
• Automated the process of analyzing tablespaces every night.

Confidential, Charlotte, NC

Sr. ORACLE DBA

Responsibilities:

• Installed ORACLE 19c/18c software’s on Windows and Unix Platforms.
• Deploy Oracle Exadata engineered systems X6, X7, X8 at WellPoint data centers
• Working on the in-place upgrade from 12c/18c to 19C
• Worked on performance tuning on SWIFT Database size up to 50 TB
• Architecting, planning, designing, developing, deploying and supporting19C/18C12C/11g Oracle RAC, Exadata, Golden Gate, Streams, DataGaurdandASMenvironments.
• Performing the cloning activity’s on weekly basis for the App team testing
• Setting up Goldengate replication from primary to standby
• Experienced in performing Point-in-Time Recovery.
• Drive the team for compliance related to patching and upgrades, maintaining database from compliance free as wells standard compliance policy
• Maintained and supported the large volume databases up to size of 80T
• Performed performance tuning and created the sql profile as required
• Supporting the app team on deployment and monitored the database health
• Supported 24/7 production support for critical applications on code fix’s and performance issues
• Worked on the Oracle RAC half node and Full node rack in X8 machines
• Worked on the performance tinning and instance tuning.
• Hands on experience in Fog light
• Working on the Migration from 12 C legacy database to 19 C database using Golden gate
• Build and support Oracle RDS, EC2 instances on Amazon cloud
• Performing the table de-fragmentation and rebuild index for app performance issues
• Supporting the application team bi-weekly code release in prod database
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms and hands-on experience in implementing security policies at a user level and database objects level.
• Experience in Golden Gate 19c replication solutions to facilitate data flow between oracle environments.
• Guard rail the AWS environments using Teraform and secrets manager utilities
• Worked on Exadata X8, X7machines.
• Implemented supplementary monitoring for users
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Working on 30T data migration from my sql to Oracle 19 C
• Worked as a primary DBA for 9 PROD databases.
• Create postgres RDS instances on AWS
• Work with Oracle for various ASR’s generated by platinum gateway for various hardware issues (Grid disk, flash card) related to Exadata, ZDLRA
• Setup and Upgraded ORACLE 18C databases to ORACLE 19c databases.
• Installed OGG in VM machines and configured Golden Gate for replication.
• Applied various patches and bug-fix’s/one -off on a regular basis to oracle software homes.
• Hand’s on experience on Toad 13.2.
• Created schedule jobs for incremental stats gather in prod database on weekly basis
• Implementation and Configuration OEM for maintenance and monitoring.
• Generated AWR/ADDM reports from ORACLE 19C/18C/12C database and analyzed the reports for Oracle wait events, time-consuming SQL queries, tablespace growth, and database growth.
• Setup backup procedures for various PRODUCTION databases based upon SLA.
• Performing all the Database Administration activity like space management in the database, user and roles administration, schema management, checking the alert log to see the databases issues reported.
• Database Cloning to create Test/Dev databases from Production systems.
• Created Clone and Duplicate databases for load testing, Acceptance testing, etc using RMAN.
• Create Mapping of Active Directory with Oracle Schemas using OUD.
• Monitoring the databases locks and blocking sessions using OEM or SQL Scripts.
• Worked as schedule ON-CALL DBA.
• 24/7 production support

Confidential, Eagan, MN

Sr. ORACLE DBA

RESPONSIBILITIES:

• Created Databases dev, Si, Prod/standby & DR with delta standards.
• Created and migrated from Oracle 12 c to 18c.
• Involved with the installation and maintenance of ORACLE 12c RAC/ORACLE Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Applied PSU and one-off patches to databases.
• Installed, configured, and maintained Oracle 12CR1 and 18C.
• Implemented Oracle database backup & recovery solutions using RMAN and manual methods.
• Migrated DELTA.com database from 11g to 19 C using GG AA replication
• Install, configure POSTGRES 8, 9 database software on Azure Linux machines
• Performed block recovery using RMAN.
• Migrated data between databases using Golden Gate replication.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Working on Exadata X2, X3 and X6 machines which included Half Rack and Full Rack.
• Migrated multiple databases up to 10TB of size with minimal to no downtime using OGG.
• Installed OGG in VM machines and configured Golden Gate for replication.
• Partitioned large tables for better performance and manageability.
• Responsible in configuring and backing up the database using RMAN, Hot backups, Cold backups, and Logical backups.
• Implemented and used Exadata Hybrid Columnar Compression (HCC) for large objects in a Multi-Terabyte Databases
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers.
• Worked with Data Pump to take the logical backups of databases.
• Experienced in performing Point-in-Time Recovery.
• Performed Capacity Planning and Bench Marking
• Load and Transform data using SQL*Loader and External Tables
• Logical and Physical Database Design
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Performed capacity planning, Extracting, Transforming and Loading (ETL) data using SQL*Loader and External Tables.

Confidential, Saint Louis, MO

Sr. ORACLE DBA

Responsibilities:

• Database Administrator for PROD,UAT,SI,QA & DEV databases and provided on-call production database support.
• Configured Data guard disaster recovery procedure using Physical Standby Databases.
• Monitored Standby Databases and performed switchover and failover mechanisms of Data guard.
• Worked on DATA MIGRATION from db2 to ORACLE.
• Development experience with stored procedures, views, and application support for DB2
• Hand’s on experience on FOGLIGHT.
• Hand’s on experience on Toad 12.8.
• Worked on the large-scale databases up to 80 T.
• Worked on plug unplug PDB’s from Container created testbeds for performance.
• Worked as a primary DBA for 6 PROD databases.
• Supporting 40 T application and worked on performance tuning.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installed ORACLE 11g/12c software’s on Windows and Unix Platforms.
• Setup and Upgraded ORACLE 11g databases to ORACLE 12c databases.
• Performed cross-platform migrations (Oracle 11g - 12c) from multiple databases’ using Oracle Golden Gate.
• Ensuring SQL Server Databases compliance as per the organization standard policies.
• Consults with Business and Development teams on high impact database issues.
• Support to complete Critical ETL jobs in agreed SLA time.
• Performed database migrations in multiple environments right from scratch.
• Setup backup procedures for various PRODUCTION databases based upon SLA.
• Worked on Exadata X-6 machines.
• Applied various patches on a regular basis to oracle software homes.
• Involved with the installation and maintenance of ORACLE 12c RAC and Standby Databases (Oracle Data Guard) for High Availability and Disaster Recovery purpose.
• Used Oracle Enterprise Manager (OEM) 13C for administering several databases.
• Monitored Alert log and wrote scripts in SQL for quick health check of the databases.
• Monitored database’s using Enterprise Manager and resolved issues based upon severity level.
• Created Clone and Duplicate databases for load testing, Acceptance testing, etc using RMAN.
• Created Materialized Views/Materialized Views Logs for data replications.
• Performance Tuning, Backup and Recovery, Cloning, Oracle Streams, Space Management, Database Security, Auditing, Troubleshooting.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms and hands-on experience in implementing security policies at a user level and database objects level.
• Generated AWR reports from ORACLE 12c database and analyzed the reports for Oracle wait events, time-consuming SQL queries, tablespace growth, and database growth.
• Performing all the Database Administration activity like space management in the database, user and roles administration, schema management, checking the alert log of all the databases using OEM.
• Maintain Oracle 12c Grid Control running WebLogic Server 12c Enterprise Edition.
• Created user assigned Profiles-Resource limits, maintained Security with Roles/Privileges granting and revoking upon requirements.
• Monitored and tuned rollback segment, temporary Tablespaces, redo log buffer, sort area size.
• Managed and resolved design issues during the development stage. Worked closely with developers.
• Worked as schedule ON-CALL DBA.
• 24/7 production support

Confidential, Edison, Nj

Oracle DBA

Responsibilities:

• Responsible for administration and supporting ORACLE 12c, 11g and 10g databases in DEV, QA, UAT and Prod environments.
• Managing Security, User groups and Users by using roles, grants, privileges, and Profiles.
• Installation of Oracle databases on standalone and RAC nodes on HP UX, Linux, AIX and Solaris environments.
• Installed and configured ORACLE 12c, 11g on Linux for Production, Development, and Testing.
• Planned and implemented Disaster Recovery (DR)& high availability solutions using Standby Databases, 9i, 10g, 11g & 12c Oracle Data Guard.
• Design and implement database backup and recovery procedures using RMAN.
• Upgradation and migration of databases.
• Applying PSU patches in a rolling upgrade manner in RAC environment.
• Configures Data Domain Backups on Exadata Machines.
• Raise SR to Oracle Support for Exadata related Issues and works accordingly.
• Good understanding of RAC architecture, CRS, OCR, OLR, Gpnp (Grid Plug n Play), etc.
• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages, and Database issues.
• Upgradation of databases from Oracle 10g to Oracle 11g using RMAN backup.
• Upgrading Oracle RAC clusters.
• Experience in Golden Gate 11g replication solutions to facilitate data flow between oracle environments.
• Manage all Oracle 12c, 11g, and 10g database management systems running on UNIX and RedHat Linux operating systems.
• Responsible for design, implementation, and support for DB2 Database environment to include performance, security, and integrity.
• Monitor and develop scheduled jobs, monitor disk space on database and storage for DB2 Database.
• Interact in database enhancement, verification, and architecture related to HA, DR & BCP
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve the response of queries.
• Used Explain Plan to monitor the query execution and views to make sure the operations run without any issues.
• Implementation and configuration of OEM Grid, Oracle Management Server for maintenance and monitoring data.
• Worked on performing switchover activities for database maintenance.
• Installed and Implemented Backup & Recovery procedures.
• Worked on Tablespace reorganization, space management, Database refreshes, storage management.
• Resolving log gaps between primary and standby databases.
• Implemented Oracle Grid and RDMS installation and setup using features like scan listener and ASM.
• Resolved issues associated with replication using golden gate.
• Resolved application slowness and other performance related issues using Oracle tools and latest features available.

Confidential 

Oracle DBA

Responsibilities:

• Involved in the analysis, design, build, and testing phase of the life cycle for the project.
• Developed PL/SQL packages to capture the end of day transactions.
• Latest features of Merge/Multiple Table Insert/Loading and logging errors in a single statement/Grouping sets, Cube, Rollup have been used to improve the performance and reduce IO.
• Installed OEM 11g and configured all RAC nodes, primary and standby databases and set up various monitoring alerts.
• Created Tables, Views, Synonyms, Sequences, and Indexes.
• Review of Database logical and Physical design.
• Creating and managing users, roles, privileges, profiles, schemas.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Oracle Security Patches Installation on Oracle 10g R2.
• Write and modify UNIX shell scripts to manage Oracle environment
• SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, STATSPACK, EXPLAIN PLAN.
• Troubleshooting expdp/impdp errors in a RAC environment, configuring storage accordingly.