SUMMARY:

• Over 8 years of DBA Experience.
• Migrated databases to AWS platform.
• Expertise in managing 10, 11g and 12c Databases.
• Expertise in setting up RAC Clusters
• Expertise in setting up Data Guard.
• Expertise in managing 13c OEM.
• Intermediate expertise in administering SQL Server.
• Expertise in setting up ASM storage.
• Installation of Oracle on Linux.
• Adding and deletion of Node in RAC.
• Build and worked on Oracle Data Guard environment
• Written shell scripts to monitor oracle databases that includes alter log, file system and tablespace.
• Provided technical assistance to vendors in development and implementation of applications.
• Solved difficult performance tuning, troubleshooting and administration issues.
• Involved in database capacity planning
• Provided 24/7 on - call support.
• Migrated database from non-ASM to ASM.
• Worked on migration project
• Managed databases on Exadata
• Applied PSU and bundle patches.
• Worked on DB Links and Materialize Views Server.
• Worked on oracle Security.
• Worked on Transparent Data Encryption.
• Worked on many performance related issue involving SQL Tuning, Instance Tuning and network troubleshooting
• Performed DR exercise using Data Guard
• Designed and developed PL SQL stored procedures to automate dbms jobs.
• Setup backup jobs using RMAN
• Restored and recover databases using RMAN
• Administered replication done via GoldenGate.
• Used export import and Data Pump for refreshing database objects.
• Monitor the database by collecting statistics of instance and files by querying data dictionary views, SQL trace files and TKPROF, STATSPACK to find ways to improve the database's performance.
• Loading data in to the Database using SQL*Loader and scheduled Cronjobs.
• Analyzing the SQL Query using Explain plan.
• Analyze the index if necessary rebuild or Coalesce index to rectify segment fragmentation
• Cloning databases using RMAN duplicate database
• Worked on partitioning tables

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, MI

Responsibilities:-

• Installing and creating 11g and 12c databases on AWS cloud.
• Migrated database to Exadata.
• Build RAC Clusters
• Build and managed Data Guard.
• Installed and configured Oracle 12c, 11g, 10g 64 Bit on Linux for Production, Development and Testing.
• Provided day to day operations support.
• Applied PSU patches.
• Managed databases on Exadata.
• Implemented GoldenGate replication.
• Cloned Databases via RMAN duplicate
• Restored databases from RMAN backup
• Performed point in time recovery.
• Monitoring & Managing the Tablespaces and datafile growth
• Proficient in database design, triggers, snapshot and stored procedures in Oracle 9i,10g and 11G
• Database designing, Database administration.
• Defining backup & recovery plan, Database tuning.
• Worked on oracle TDE and wallet management.
• Tuned instances and SQL queries.
• Worked on Analyzing ASH and AWR reports.
• Data Guard implementation and maintenance for Disaster Recovery.
• Alert Log Checking (Monitoring) and User trace File and Archive log maintenance.
• Creating users, granting roles, Creating and Maintaining snapshot.
• Refreshed database objects using Data Pump.
• Monitoring locks and various sessions.
• Monitored and scheduled jobs via 13c Cloud control.
• Performing Day-to-Day DBA tasks - performance tuning, database design, system security, database installation configuration, patching, technical database support in 24X7 environments.
• Responsible for quarterly patches, /maintaining/Monitoring/Upgrading the Production/Dev/Test and training databases for products.
• Setup/configured oracle RMAN for database backup and recovery. Application of different recovery procedures for complete and incomplete recoveries depending on the type of failure by using export/import & OS scripts like shell & cron job schedule.
• Installation of oracle database and clients on UNIX and windows (Silent installation, GUI installation.

Oracle DBA

Confidential

Responsibilities:-

• Performed core DBA tasks such as Database Administration on Oracle 10g/11g environments, performance tuning, schema creation, maintenance and troubleshooting.
• Developed ad hoc shell scripts and dynamic SQL codes to automate and schedule maintenance jobs.
• Involved in performing Oracle 10g/11g to 12c upgrades on Sun and Linux.
• Designed conversion of non-partitioned to partitioning of very large tables for performance improvement.
• Coordinated with application patches and database upgrade from Oracle 10.2.0.3 to 11g release 2.
• Worked on RAC on RHAS with 4 nodes server side load balancing using Automatic Storage Management.
• Worked with PL/SQL stored procedures, developed SQL scripts and Korn shell scripts to automate tasks.
• Database Cloning & Advanced Queuing Concepts.
• Worked on Shell scripts given by Linux Admin for automating various database tasks in UNIX platform.
• Created and maintained standby databases.
• Created new users and managed roles and privileges.
• Managed Rollback Segments, Redo logs, Control files, and Table spaces.
• Developed and fine-tuned PL/SQL & UNIX that update the data warehouse on their scheduled run.
• Generated reports in Oracle Reports by analyzing the database based on the specific business requirements.
• Involved the Post-migration task (Unit-testing) for every RAC & standalone servers.
• Communicate and coordinate with Oracle using TAR system for major database issues/ problems; apply the required patches, test (unit test/ system test) and roll out and implement the patches into production.
• Involved in disaster recovery planning; detailed out the processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery.
• Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues disasters from happening.
• Successfully configured the databases to switchover, failover and fallback scenarios.
• 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.
• Written shell scripts to automate jobs.
• Worked on performance related issues.
• Build RAC and added node.
• Worked on SQL Server 2005 and SQL Server 2008 instances.

Oracle DBA

Confidential

Responsibilities:-

• Oracle DBA experience includes monitoring table space, indexes, reorganization databases, Backups, Alert files.
• Create new users and manage privileges and monitor user access to the databases.
• Monitoring the Database growth and increase the table space size in production databases.
• Upgraded/migrated the production & development databases from 10g to 11.2.0.1 to 11.2.0.2
• Participated in discussions with the management regarding the advantages/disadvantages and upgrade plans.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Assisted in Database sizing, Capacity Planning.
• Performed Space Management & Troubleshooting the database issues.
• Upgraded OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
• Configured and managed agents to work efficiently with Grid Control.
• Generated ASH, AWR, ADDM reports from Grid Control and command line.
• Set up privileges to create local and remote objects.
• Created materialized views to refresh data at regular intervals.
• Used materialized view logs to reduce the replication time costs for fast refreshes.
• Upgraded/Migrated from Oracle 9i databases to 10g and to 11g.
• Discoverer Administration including the design and administration of Business areas.
• Maintained Oracle Application Server 10g for use with Discoverer, Portal and J2EE deployments.
• Developed PL/SQL based program for loading Data Mart.
• Created and maintained users, roles and privileges.