SUMMARY:

• 8 +years of experience in Oracle DBA
• Build, configured and administered 2 node RAC
• Worked extensively with ASM builds and disk group management.
• Implemented proactive monitoring scripts for production databases.
• Troubleshoot performance issues using ASH, AWR and ADDM
• Worked on Data Migration project.
• Implemented Various RMAN backup methods.
• Worked on Data Movement using Export Import and Data Pump
• Build Data Guard for disaster recovery site.
• Worked on Materialize Views
• Strong Administrative skills on Linux
• Worked on SQL Server Database Management.
• Vast experience on Linux , AIX , HPUX, Solaris and Windows.
• Build and configure 12c standalone databases.
• Familiar with container and pluggable databases concept.
• Database Upgrade
• Restored and recovered the databases using RMAN
• Experience in installing patches for upgrades and for various problems.
• Experience working with 24x7 on - call production support.
• Good knowledge of Oracle internals and architecture.
• Experience in installing, configuring and maintaining Standalone and RAC databases
• Creating roles, profiles, privileges and assigning roles to users.
• Extensively worked on monitoring and optimizing the database by performance tuning
• Familiarity with Oracle cloud and AWS
• Worked heavily with OEM / 13 cloud control.
• Troubleshooting of networking issues.
• Good understanding of Indexes and statistics, Dictionary tables and views.
• Analyzed Tables, Indexes periodically to optimize the SQL queries.
• Managed databases on Exadata .
• Worked on GoldenGate replication
• Applied one off, CPU and PSU patches .

TECHNICAL SKILLS:

OS & Administration: Linux, Windows, Solaris,

Expertise: Oracle 10g, 11g, 12c / SQL Server 2005, 2008 / Exadata / RAC / ASM / Golden Gate / Patching / Upgrades

EXPERIENCE:

Confidential, Iowa

Oracle DBA

Environment: Oracle 12c RAC, Exadata, ASM, Linux, Solaris, Data Guard

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.
• Worked on 12c cloud control.
• Worked on monitoring shell scripts.
• Configured and installed with SQL Server Performance Dashboard.
• Migrated 11g database to 12c R2
• 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 farm house.
• 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
• Provided 24x7 operational environments.
• Involved in gathering requirements from end users.

Confidential, Iowa

Oracle DBA

Environment: Oracle 10g, 11g RAC, ASM, Linux, Solaris, Data Guard, GoldenGate

Responsibilities:

• Managed databases on RAC Clusters
• Managed standby databases
• Resolved Gaps
• 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 DDL DML, PL/SQL, and SQL to transform data between source staging area to target staging area
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required.
• Created users, roles and granted privileges per the business requirements.
• Skilled with stats pack, AWR, ADDM, SAR to check health of database & hardware.
• Used Performance tuning tools such as tkprof, explain plans, oradebug and trace files to tune SQL Queries.
• Restored and Recovered SQL Server Databases.
• Configured and installed with SQL Server Performance Dashboard
• 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.
• Worked on DB Monitoring scripts
• Configured Alerts using 12c Cloud Control.
• Index management for better performance, maintenance of Oracle Database
• Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and standalone instances.
• Responsible for administration and supporting oracle 11g and10gdatabases
• Created, upgraded, and cloned Oracle databases for Development and testing databases.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc
• Worked in Tuning OS, Shared Pool, Buffer Cache, and Redo Log Buffer.
• 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
• Data Modeling, Database Design and creation using Erwin.
• Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
• Automated the replication process using materialized views for reporting databases.
• Plan and acquire the new technologies for and implementation, suitable for the applications in regard to the specific future requirements of the company's business projections and growth.
• Worked with offshore team members.
• Tune SQL Queries.

Confidential, Chicago, IL

Jr. Oracle DBA

Environment: Oracle 10g, 11g RAC, ASM, Linux, Solaris, Data Guard, GoldenGate

Responsibilities:

• Create connection strings
• Run scripts
• Create databases using dbca
• Aided in connectivity issues.
• Tablespace management
• User Management
• Managed OEM Agents
• Refresh schemas using exp import / Data Pump
• Backup databases
• Run shell scripts
• Restore and recover databases.
• Load data using SQL Loader
• Install Oracle software.
• Patch databases.
• Worked on RAC Databases
• Worked on DR Site Databases.