SUMMARY

• Proficient in maintaining 10g, 11g, 12c,18c and 19c databases
• Data Guard (Standby Databases)
• Real Application Cluster (RAC)
• Automatic Storage Management (ASM)
• Exadata x7
• Golden Gate Replication
• MS SQL Server
• Backup and restore/recovery using RMAN
• Administration of Oracle 10g, 11g, 12c to18c to 19c RDBMS
• Cloning / Refreshing database objects using Data Pump and RMAN
• OEM / SQL Developer / TOAD
• Patching, PSU, RU, One - off patches, CRU Bundle patches
• Performance Tuning / ASH / AWR / ADDM / SGA / Tracing / Wait events
• Database Migration
• Database Upgrades
• Shell Scripts
• Automating jobs
• Cloud AWS (Amazon Web Services) / EC2 instances
• Intermediate Linux Administration.
• Good understanding of OS Windows, Linux, AIX, Solaris
• Installation, Configuration, Upgrading, Migration and Maintenance.
• Configure, maintain and deploy the Data Guard and grid control.
• Installing and maintaining Oracle GRID CONTROL
• Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.
• Worked extensively on Oracle Streams.
• Troubleshoot OCFS2 install issues and working with Enterprise Manager.
• Design and implement Auditing and other security features for the existing Production systems.
• Raised SR and TAR with Oracle Support.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Backup of database Logical and Physical (hot and cold) procedures and using RMAN.
• Migration from Linux to Solaris and 32 bit to 64 bit.
• Restore and Recovery of database in case of database crash, disk/media failure.
• Applying patches and works closely with Oracle to make Application environment up to date.
• Monitored databases using 13c cloud control and via shell scripts
• Backups & Recovery Maintenance, Databases Performance Tuning.
• Typically involved in database Designing, creation and maintenance.
• Good working knowledge of SQL, PL/SQL, and shell scripting.
• Created users and grant privileges according to the requirements.
• Working knowledge on UNIX administration on AIX server.
• Provided System support for both development and 24*7 production environments.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.
• Involved in designing logical and physical data models using Erwin.
• Good experience in 24/7 Production Environment Support.
• Provided 24/7 on-call support.
• Worked with offshore DBAs

TECHNICAL SKILLS

OS: RHEL, AIX, Windows, HP-UX, Solaris

RDBMS: Oracle 19c/18c/12c/11g/10g/9i, SQL Server 2005 / 2008

High Availability: RAC, Data Guard, ASM, GoldenGate, Materialize Views, Active Data Guard, Exadata, AWS

Languages: SQL, PL/SQL, UNIX Shell scripting, T-SQL

Tools: RMAN, OEM, sqlldr, exp, imp, expdp, impdp, ERWIN, TOAD, dbconsole

Tuning Tools: SPA, ASH, AWR, ADDM, SQL Tuning Sets, tkprof, Explain Plan, Statspack, SQL Advisor, performance analyzer, Invisible Indexes.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential - Austin, TX

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager
• Administered databases on Exadata
• Performed database cloning to setup test and development database
• Maintaining schemas and partitioning tables
• Monitored databases using 13c cloud control and via shell scripts
• Developed RMAN scripts for database backup and recovery
• Tablespace management Performed Silent installation on Exadata.
• Applied patches on computer nodes, Exadata home and storage cells.
• Migrated standalone databases to Exadata
• Implement disaster recovery with use of Exadata Setup and managed replication using Oracle Golden Gate
• Worked on Data Migration project.
• Migrated databases from Windows platform to Linux
• Expertise in User and profile management
• Database performance analysis using ASH, AWR and ADDM reports
• Refreshed database using export import and Data Pump
• Adding a New Node to RAC cluster and Installed Oracle RDBMS software on a new node of the cluster, Created ASM Volume using ASMCA and Created ACFS for GoldenGate 12c.
• Configured Physical Standby databases using data guard for maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c,18c and 19c.
• Configured Active Data Guard 11g Troubleshooting Out of sync issues in Data Guard environment and Configured Data Guard Broker, fast-start failover and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing.
• Configured SLA for Query’s accessing standby database and managed Active Data Guard.
• Worked with VMWARE team in building new servers, performed Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation,
• Resolved DB performance issues.
• Worked as primary on-call DBA.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.
• Applied various patches which includes quarterly critical patch.
• Upgraded oracle clients as per application needs.
• Applied DST patches on multiple platforms.
• Expertise in grants, permissions, roles and privileges
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Resolved gaps on standby databases
• Worked with offshore DBAs
• Written Shell scripts to automate jobs
• Written Technical documents
• Applied PSU patches on RDBMS homes
• Perform Backup and Recovery thru RMAN
• Full fill developers request to refresh schemas daily
• Resolved DB performance issues
• Worked as primary on-call DB
• Used TOAD for various database Administration tasks
• Used SRVCTL utility for managing multiple instances and nodes
• Worked with Real Application Cluster (RAC) databases

Oracle DBA

Confidential - Brookfield, WI

Responsibilities:

• Involved in 24x7 support for production RAC databases with on-call pager
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 12c and 18c clients/databases on RHEL and OEL
• Complete Build of 4-node 12g RAC Cluster on OEL 7 from scratch.
• Migrated 11g databases to 12c to 18c
• Skilled with stats pack, AWR, ADDM, SAR to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and tracing
• Administered databases on Exadata x7
• Performed database cloning to setup test and development database.
• Migrated databases to different data datacenter.
• Handled RAC Node hangs and node eviction issues.
• Maintaining schemas and partitioning tables.
• Migrated databases to AWS
• Setup DR using Oracle Standby on Amazon cloud.
• Monitored databases using 13c cloud control and via shell scripts.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery
• Responsible for administration and supporting oracle 11g, 10g and 9i databases
• Created, upgraded, and cloned Oracle databases for Development and testing databases.
• Tablespace management
• Expertise in User and profile management
• Build Data Guard using Maximum Performance Mode.
• Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Performed administrative maintenance, monitoring on Oracle database systems in a global
• Provided 24x7 operational support.
• Involved in gathering requirements from end users.
• Experience in performance tuning using different tools and methods.
• Install databases using silent install and via scripts.
• Database performance analysis using ASH, AWR and ADDM reports
• SQL Trace and Execution Plan.
• Database cloning using RMAN
• Refreshed database using export import and Data Pump

Oracle DBA

Confidential, Madison, WI

Responsibilities:

• Installing ASM environment and migrating database from NON-ASM to ASM.
• Configure and manage tablespaces, tables, and users for custom applications.
• Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
• Performed various user management tasks.
• Expertise in managing user profiles
• Expertise in grants, permissions, roles and privileges.
• Experienced with Space Management and Security.
• Experienced with GUI and CLI to manage database farm house.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Tuning high - resource queries introducing hints and creating indexes/parturitions
• Configured and Maintenance of SQL Server databases
• Implemented and managed 11g Data Guard
• Resolved gaps on standby databases.
• Worked with offshore DBAs.
• Written Shell scripts to automate jobs
• Written Technical documents.
• Helped development team in optimizing queries
• Applied PSU patches on grid and RDBMS homes.
• Troubleshoot networking issues between primary and standby site.
• Implemented Oracle high availability solution using oracle RAC, Physical Standby
• Importing data from flat files into database using SQL loader and External Tables
• Written shell scripts to automate the tasks
• Physical and Logical database design.
• Database sizing, Capacity Planning.
• Worked on relational modeling using ERWIN.
• Worked very closely with development and application team
• Worked with offshore DBA team in India
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
• Created users, roles and granted privileges according to the business requirements.
• Data Modeling, Database Design and creation using Erwin.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM
• Automated the replication process using materialized views for reporting databases.
• Applied latest patches as per evaluation requirement.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Performed large batch jobs and tuning of SQL queries and database systems.
• Created indexes to facilitate easy user interface implementation and tuning.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic
• Perform Backup and Recovery thru RMAN.
• Full fill developers request to refresh schemas daily.
• Resolved DB performance issues.
• Worked as primary on-call DBA.
• Used TOAD for various database Administration tasks.
• Used SQL*Loader to move data from flat files into an Oracle database.
• Used SRVCTL utility for managing multiple instances and nodes.
• Worked with Real Application Cluster (RAC) databases.

Oracle DBA

Confidential, Menomonee Falls, WI

Responsibilities:

• Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
• Maintaining databases from all the environments from all pre-production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.
• Experienced in ORACLE 10g installation, configuration, and upgrading.
• Experience with rolling upgrade to Oracle 11G RAC.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
• Worked with lead DBAs for preparing cluster, configuring, installing Cluster ware and Oracle
• 10g RAC on AIX and HACMP.
• Installation, Configuration, Upgrading, Migration and Maintenance.
• Configure, maintain and deploy the Data Guard and grid control.
• Installing and maintaining Oracle GRID CONTROL
• Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.
• Worked extensively on Oracle Streams.
• Troubleshoot OCFS2 install issues and working with Enterprise Manager.
• Design and implement Auditing and other security features for the existing Production systems.
• Raised SR and TAR with Oracle Support.
• Used Oracle Enterprise Manager (OEM) for administering several databases
• Backup of database Logical and Physical (hot and cold) procedures and using RMAN.
• Migration from Linux to Solaris and 32 bit to 64 bit.
• Restore and Recovery of database in case of database crash, disk/media failure.
• Applying patches and works closely with Oracle to make Application environment up to date.
• Backups & Recovery Maintenance, Databases Performance Tuning.
• Typically involved in database Designing, creation and maintenance.
• Good working knowledge of SQL, PL/SQL, and shell scripting.
• Created users and grant privileges according to the requirements.
• Working knowledge on UNIX administration on AIX server.
• Provided System support for both development and 24*7 production environments.
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.
• Involved in designing logical and physical data models using Erwin.