TECHNICAL SKILLS

RDBMS: Oracle 18c,12c,11g, 10g, SQL Server

OS: Windows, Linux, AIX, Solaris

Tools: OEM, TOAD, SQL Developer, Erwin, DBCA, Data guard, ASM, crsctl, srvctl

DB Utilities: SQL * Loader, Exp/Imp, Data pump Utilities, RMAN, tkproof

Language: SQL, PL/SQL for Oracle, Shell programming

Shell script: Shell Script (Bourne shell & Korn Shell)

Cloud: AWS

High Availability: RAC, Data Guard

PROFESSIONAL EXPERIENCE

Confidential, San Jose, California

Oracle DBA

Responsibilities:

• Provided day to day operation to support production and non - prod databases
• Maintained databases on Exadata.
• Build 4 node RAC clusters
• Setup Data Guard from standalone and RAC clusters.
• Experience in tablespace and user management
• Experience in Management ASM disks and ASM diskgroups
• Provided support to application and development team.
• Automated tasks using shell scripts
• Worked with storage team for ASM disk layout.
• Applied Quarterly patches.
• Working knowledge on Golden Gate tasks.
• Installed Databases on VMWare.
• Involved in 24x7 support for production RAC databases with on-call pager
• Installation of 11g and 12c clients/databases on Solaris and Linux.
• Worked with Storage team to allocated SAN to RAC
• Worked with offshore team.
• Managed database on Amazon Cloud (AWS).
• Worked on 13c cloud control.
• Worked on monitoring shell scripts.
• Configured and installed with SQL Server Performance Dashboard.
• Migrated 12c to 18c.
• Managed Goldengate replication.
• Migrated standalone to RAC
• Migrated databases to Exadata
• Helped application team troubleshooting performance related issues.
• Very familiar with Oracle internals.
• Worked closely with developers on performance issues.
• Familiar with ASH, AWR and ADDM reports.
• Experienced with Space Management and Security.
• Experienced with GUI and CLI to manage database farmhouse.
• Rebuilding of Indexes for better performance and maintenance of Oracle Database.
• Configured and Maintenance of SQL Server databases
• Experience in Oracle Partitioning.
• Importing data from flat files into database using SQL loader and External Tables
• Written shell scripts to automate the tasks
• Comfortable supporting physical and logical database design of RDBMS
• Database sizing, Capacity Planning.
• Worked on relational modeling using ERWIN.
• Worked very closely with development team
• Perform capacity planning required to create and maintain database environments.
• Supported 24/7 on-call pager support for mission critical financial databases.
• Performed administrative maintenance, monitoring on Oracle database systems in a global
• Involved in gathering requirements from end users.

Confidential, Detroit, MI

Oracle DBA

Responsibilities:

• Installed 11g and 12c databases.
• Upgrade databases to 12c
• Expertise in designing the table structure using Visio by creating ER diagram and normalized all the tables from the scratch according to the specifications provided.
• Performed Database Refresh from Production to Development databases.
• Used PL/SQL (stored Procedures, triggers, packages), SQL* PLUS, SQL* LOADER of oracle database.
• Used TOAD, SQL Loader and Grid Control to managed database
• Worked on many SQL scripts to pull data from Oracle Dictionaries.
• Performed installation and configuration of Oracle 10g/11g/12c RAC databases on Linux.
• Applied CPU/PSU patches.
• Build RAC clusters
• Installed RAC on Oracle 11g and worked on ASM feature of Oracle.
• Worked closely with Developers during deployments and building indexes.
• Good experience in Performance tuning of large databases.
• Data Guard administration and maintenance.
• Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.
• Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.
• Taking the RMAN incremental and cumulative backups.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Perform Logical backup using full/partial export/import and data pump.
• Managed Tablespaces
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Worked on Performance tuning of SQL, instance and databases.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, managed quotas.
• Implemented advanced features of Oracle 11g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Configuration of Listener and Net Service names using NETCA and NETMGR.
• Cloned schemas, objects and data on new server using Data pump.
• Managing databases on multiple servers.
• Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Cloned databases
• Worked with offshore team on deployments
• Provided 24/7 support.