TECHNICAL SKILLS:

Tools: OEM Grid Control, Erwin, Sql Developer, Toad, VNC, Putty, Winscp, Rundeck, PVCS Version Manager, Service Now.

Utilities: Rman, Datapump, Opatch, SQL Loader, Transportable Table Space, Statspack, AWR, ASH, ADDM, Explain Plan, TKprof, RAC, ASM, VMware, DBUA

Languages: UNIX Shell, bash, korn Scripting, PERL, SQL, PL/SQL

OS: RHEL 5.9, 6.0. Linux Enterprise Server 9, 10HP - UX 10.x, 11.x. AIX 5.3, 6.1, Windows 95/98/2000.

PROFESSIONAL EXPERIENCE

Confidential, Grand Rapids, Michigan

Oracle Production DBA

Responsibilities:

• Production Support creating users, granting access to users, unlocking application and database accounts, resolving locks, tickets using service now.
• Applying quarterly patches and system Upgrades from 11.2.0.4 to 12C 
• Converting database from non plugable to plugable in a container in 12c
• Database Maintenance and monitoring such as blocking sessions, top activities adding tablespace when needed and making sure there is enough space in file system,
• Review and tune Developers’ codes using SERENA PVCS version manager
• Take part in ON - call rotations refreshing Dev, Sit and UAT environments with Prod.
• Scheduled   UNIX   scripts in Cron jobs to automate daily tasks like backups, monitoring the alert logs, cleaning old archive logs, old log files.
• Establish baselines and use AWR, ASH, Explain plan, SQL Tuning Advisor, SQL performance analyzer to evaluate and analyze statistics for performance improvements.
• Designed and implemented disaster recovery strategies such as Active dataguard, Rman Incremental backups and also perform DR simulations to test backups.
• Ensuring database integrity and security by performing health checks, setting triggers, constrains, transparent data encryption, Oracle Wallet and Auditing.
• Designed/monitor daily, weekly Backup/Recovery procedures for prod and non- prod databases using RMAN, and logical backup through schema dumps.
• Monitoring Data-guard setup with regard to connectivity log shipping and D R Switch Over testing  
• Responsible for troubleshooting query, application database performance bottlenecks and implement fixes such as creating and rebuilding indexes, hints, views, materialized views, gathering statistics.
• Refresh the test environments with Production data using RMAN duplicate & Datapump.
• Monitor Deployments to Update Management Agents Using “Agent Gold Image Console” (OEM Cloud Control 12/13c).
• Technical documentation of all configurations, installations, implementations, monitoring and testing projects for future reference.
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database.
• Take part in capacity planning meetings, documentation and POC presentations.
• 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.
• Used applications such as Service now and Remedy to acknowledge, create and escalate tickets.
• Provide weekly metrics to team lead for documentation on the health of Oracle databases.
• Create Service Requests, administer and execute Change Requests (CR) for Oracle Database Production support
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity. 
• Unix shell scripting, bash, Korn and Perl to automate tasks.
• Highly experienced in Performance Tuning, Monitoring /Troubleshooting using AWR, ADDM, EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. 

Confidential, Jacksonville, Florida

Oracle Database Administrator

Responsibilities:

• Routinely   restored   databases   using   RMAN   Catalog/Restore, Point-In-Time Recovery and Flashback Recycle bin Technologies. 
• Installed Oracle software and applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading.
• Implemented Range, List, Hash and various Sub Partitions, Create and schedule refresh for materialized views, functions, and triggers. 
• Refreshed/cloned databases using datapump and RMAN utility.
• Implemented Golden Gate replication in consolidation mode for data warehouse reporting.
•   Scheduled daily Exports/Imports to serve as temporary backups. Installed ASM environment and migrated databases from NON-ASM to ASM.
• Created   users   and   tablespaces,   allocating   appropriate   privileges,   roles and quotas necessary for Oracle databases and capacity planning.
• Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
• In-depth understanding on oracle utilities SQL Trace, Explain Plan, TKPROF, AWR and DBMS STATS in Performance Tuning.
• Creating roles, profiles, privileges and assigning roles to users on both Windows, Linux, AIX platforms.
• Extensively worked on monitoring and optimizing the database by performance tuning
• Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM)
• Worked with development and operations staff in resolving problems quickly and efficiently 
• Installed, configured and maintained Active standby, Physical, Logical databases supported by Data guard on Oracle 11g, for disaster recovery procedures.
• Development, testing, staging, production RAC and standby databases for OLTP and Data Warehousing using customized scripts.
• Installation and Configuration of Oracle 12c, 11g and 10g Real Application Clusters (RAC ) on multi - node with Automatic Storage Management (ASM).  
• Proficient Full and Incremental Backup & Recovery, Cloning of databases using RMAN, OEM Grid Control 12c, Net Backup, UNIX Shell Programming, PL/SQL and experience on windows 2008, 2010, 2012, AIX, Solaris.
• Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems. 
• Install and implement Oracle Golden Gate for real time data replication
• Golden gate setup to achieve unidirectional replication and Golden gate database user with necessary privileges.
• Performed data replication, transformation and delivery of database transactions using Golden gate replication tool.
• Develop and implement high availability, scalability and disaster recovery solutions dataguard, replication, streaming & golden gate as per the application's business needs to meet the required SLAs. 
• Installed ASM environment, partition disk groups and migrated databases from NON-ASM to ASM.
• Configuration and documentation of Oracle golden gate for replication and reporting.
• Upgraded from Oracle 11g (11.2.0.4) to 12C using DBUA, Transportable table spaces and scripts .
• Led a team in the migration of over 10TB legacy databases and redesigned their RMAN backup Strategy.
• Automate most routine tasks with bash, Korn, Shell, Perl scripts improving on efficiency.
• Design database in compliance with OFA standards, business needs and best practice.
• Configured Oracle Enterprise Manager Cloud Control (12) on CDB and PDB installation  
• Conversion of single instance database to RAC database using DBCA.
• Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters.
•   Performed database migrations from AIX to Linux using Oracle Golden Gate
• Upgrading and migrating Oracle 11gR2 RAC Databases running on legacy infrastructure to Oracle
• Experience in using Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Laid hands on tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Design and Implementation of Oracle Disaster Recovery Solutions using Oracle Data Guard and Storage based replication technologies.
• Experience in Database Security by implementing Data Encryption(TDE) and SSL Setup over insecure networks.
• Performance tuning and system troubleshooting at the level of instance, database and application
• Proficient in logical backups Export/Import and Datapump. Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g).
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Implementation of Oracle Flash cache and different host based caching technologies like Dell Fluid Cache/Fusion IO to improve Oracle database performance.