SUMMARY

• Over six years of hands - on experience in the daily administration of Oracle 10g, 11g, 12c databases.
• I have wide experience supporting production and project work in Oracle Database versions running on different OS platforms including Linux, Windows, Solaris and AIX.
• I am skilled at working autonomously and collaboratively, resolve issues timely and accurately to help the team meet expected metrics and SLAs.
• I also possess excellent communication, documentation, multi-tasking skills, aptitude to troubleshoot and resolve technical issues.
• I have a strong desire to learn and work in extremely fast paced and challenging environments.
• Installation of oracle software versions 10g, 11g, 12c.
• Configuration of standard and enterprise database versions on Virtual and physical database servers.
• Data replication technology/Golden Gate configuration and administration.
• Real Application Cluster (RAC) configuration and administration 10g, 11g and 12c.
• Real Application Testing(RAT)
• Oracle Dataguard configuration and administration.
• Database Monitoring and Performance tuning/troubleshooting.
• Migration across platform (using transportable tablespaces).
• Database and schema refreshes (using RMAN duplicate and datapump).
• Database Upgrade (manually using scripts and DBUA).
• Database Patching using Opatch and Datapatch
• Backup and recovery (using RMAN, flashback and data pump).
• Auditing and Security (Oracle Advanced Security)
• Oracle Exadata machine support and Oracle Database Appliance ETL, FTP, SCP, SFTP
• Database administration local filesystems and ASM
• Oracle Audit Vault and oracle Database vault.
• Microsoft Sql Server and Management Studio.
• Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) systems.
• DBvisit Standby for Disaster Recovery in Oracle Standard Edition.

TECHNICAL SKILLS

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

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. IBM-AIX 5.1, 5.2, 5.3, 6.1, Windows 95/98/NT/2000, RHL Linux and SUSE Linux Enterprise Servers.

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

Tools: Oracle OEM, TKPROF, ASH, EXPLAIN PLAN, Sql Tuning Advisor, OEM cloud, STATSPACK/AWR, Oracle OS Watcher, SQL TRACE, Top, ETL, DBCA, DBUA, ADDM, TOAD, Spotlight, Putty, NX client, WinSCP, Remote Desktop Connection, VNC, Microsoft, LogMeIn and Cisco VPN Client, UltraEdit, SS Management Studio.

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, Informatica, Erwin, RMAN, Opatch, OEM Grid Control, DBVERIFY, Datapump, Export, Import, Dataguard, Golden gate, SolarWinds Database Performance Analyser, NetBackup-Veritas.

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

Oracle Database Administrator

Responsibilities:

• Installed 12c oracle binaries and configured databases on RHEL OS Versions and Windows.
• Implementation of oracle advanced security involving TDE, Data Masking and managed Oracle Wallets.
• Day to day administration of Dataguard environment.
• Supported major project of upgrading oracle databases from 11g to 12c (11.2.0.4.0 to 12.2.0.1.0 ).
• Database migration project from local disk/SAN to ASM.
• Applying oracle patches using Opatch and datapatch.
• Day-to-day usage of Oracle 11gR2 features - Real Application Testing (SQL Performance Analyzer and Database Replay), automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup.
• Oracle 11gR2 features like Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Plan Management, SQL Tuning Automation, Flashback Database techniques and several others.
• Database and schema refreshes to lower environments using Datapump and RMAN duplicate.
• 12c Features like FAR-SYNC Instance, Cascade Redo Transport Destination, allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file etc.
• Created & Managed Database Structures, Table/Index segments, Undo management, Constraints, Database Access, Roles, Privileges and Profiles.
• Supporting RAC and stand-alone databases on ASM in training and production environments.
• Troubleshooting RAC issues, Node Eviction, OCR, relocating the switched over services.
• Used SQLT (SQLTXPLAIN) to diagnose SQL statements that are performing poorly.
• Project Deployment - worked with assigned project leads, completed assigned tasks within defined scope and timeline to ensure the successful deployment of projects.
• Improving query runtime using Hints, partitions, indexes, materialized views, bind variables, Sql profile and Sql plan baselines.
• Worked on monitoring and improving Database and query performance using Solar Winds Database Performance Analyser, TOAD for oracle Xpert Edition 12.12 and SQL Developer.
• Used OS scripts to identify blocking sessions, tablespace sizing, export files and key mount points issues and resolved same accordingly.
• Code migration, database change and data management through various stages (development life cycle).
• Modifying and testing Unix scripts for daily monitoring and maintenance
• Troubleshooting RMAN operations and Monitoring of events and audit logs in Oracle Audit Vault.
• Configure flashback and restore from GUARANTEE restore point.
• Implemented Database security using Oracle Database Vault.
• Implemented Database Security through Auditing and Advanced Oracle Security (TDE, Data redaction)
• Used Expdp utility to export Data from physical standby Database to lower environments.
• Performed dailybackup monitoring and tuning, alert Log monitoring, object and user management.
• Professionally documented and updated database projects documentation on Confluence.
• Contacting Confidential for technical support (METALINK).
• Capacity planning and Monitor Release reports, documentation of new or updated services.
• Tracking projects task and incidents through JIRA.
• Participating in night, weekend and holiday on-call rotation.

Confidential, Portland, OR

Oracle DBA

Responsibilities:

• Installation of Oracle 11g and 12c oracle binaries and created databases.
• Participated in major Project of upgrading databases from 11g to 12c.
• Supported oracle databases migration to oracle exadata machine.
• Involved with Oracle Enterprise Manager Cloud Control 12c and deployed 12c agents on target hosts.
• Worked actively in configuring and maintaining Oracle Physical Standby and Active Data Guard Database oracle 11g and 12c.
• Configured DG Broker for easy Failover/Switchover and Converted physical to Snapshot standby during DR test.
• Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM
• Worked on setting up/installation and configuration of 11g R2 RAC with ASM on IBM AIX 6.1.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• ASM administration and troubleshooting.
• Table restore using 12c feature.
• Applying patches for various bug fixes for Single Instance, Dataguard and RAC environments.
• Using EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• DBA involved in production support and major projects involving migration through the SDLC (DEV, TEST, UAT, PRE-PROD and to PROD environments).
• Troubleshooting out of syncproduction database and Physical Standby databases manually or RMAN incremental backup.
• Partitioned and re-organized tables and indexes to optimize database performance.
• Support development team in identifying SQL queries that are consuming high resources and tuned these queries to enhance performance.
• Implement and test data backup and recovery procedures to prevent data loss and failures using RMAN.
• Documented, planned, and tested Disaster Recovery procedures.
• Worked closely with the system operations team on database deployment processes.
• Upon request Refreshed Dev and test databases with data from Production on a regular basis.
• Troubleshooting Space Management, user accounts and privilege issues.
• Troubleshooting and monitored Health checks of OCR, VOTING DISKS & Private interconnect.
• Optimizing performance and troubleshooting in a RAC environment (11GR2).
• AppliedOraclepatches in RAC rolling fashion and Upgraded OracleRACDatabases to 12c.
• Managed ASM disk failures & replace failed ASM disk with a new disk.
• Troubleshooting ASM related issues with the help of ASM alert log files.
• ImplementedDatabaseWallet forOracle11g (keystone in 12c) and TDE for encrypting Sensitive data.
• Move Datafile from File System to ASM Disk and added data files to existing disk groups.
• Performance Monitoring and analysis on standalone and RAC 11g with AWR reports and ASH.
• Administered 12c multitenant architecture (container and pluggable databases).
• Converted non-container databases to pluggable databases, patched, cloned, backed up CDB and pluggables.
• Supported Enterprise Manager (OEM) Grid/Cloud Control config for the purpose of monitoring multiple target databases.
• Identifying performance bottlenecks on high volume transaction systems.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Used Oracle OEM Data Masking Pack to protect sensitive data.
• Tuning I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Database recovery using User-Managed, RMAN-Managed Recovery and FLASHBACK features to handle efficient database recovery.
• Used Oracle Logminer Utility to analysis contents of archived redo logs, recovery and Auditing.
• Good understanding of Cyber Ark.
• Perform capacity planning (proactively monitor database usage trends for stroage, Cpu, io, etc.) and report on those trends.
• Involved in Cloning Oracledatabases periodically and on demand using RMAN.
• Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisors, SQL tuning and Metrics on command line, TOAD and OEM cloud.
• Involved in tuning and troubleshootingdatabaseissues both on UNIX command line, SQL*Plus, OEM client,oracleGrid Control and 3rd-party tools (TOAD, spotlight, SQL Developer).
• Implemented shell scripts for automation of day to day activities such as growing table sizes, extent allocation, free space, used space, fragmentation and backups result, alert log.
• 24/7 On-call rotation and day to day customer service for assigned databases.

Confidential - Charleston, IL

Oracle Database Administrator

Responsibilities:

• Involved in the Migration & Upgrade to 11g R2 and 12c versions using SQL command (scripts) and Database Upgrade Assistant.
• Supported ERP Banner application with different modules.
• Remote administration and support of Oracle production and development Databases on major Operating Systems.
• Major project involving the Installation, setting up of unidirectional and bidirectional (Active-Active) for Real time data replication in a heterogeneous environment.
• Monitoring and troubleshooting data synchronization between source and target databases.
• Applying Oracle Golden gate patch sets.
• Major project support involving the installation, configuration of a 3 node RAC database.
• PerformedDatabaseupgrade fromOracle10g to11g and from 11.2.0.3 to12.1.0.2 RACdatabase.
• Involved in applying Grid Infrastructure System Patch (GI PSU) to Oracle RAC 12c.
• Successfully applied RDBMS patches.
• Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
• Database reorganizations Cloned/refreshed/Migrated databases using RMAN, Transportable Tablespace and Data Pump.
• Involved RMAN backups with VERITAS Net Backup.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace, TKPROF and EXPLAIN PLAN.
• Proficient in using DBMS packages for database tuning and recovery purposes.
• Used Oracle performance related features such as Query Optimizer, Indexes, Hints, bind variables and Sql Plan Baselines to optimize database performance.
• Supported multiple databases from Dev to production on Linux, AIX and Windows environments.
• Involved in query analysing and Performance Tuning for long running SQL queries, resources consuming SQLs, Wait events, Locks, blockers.
• Troubleshooting Golden gate errors and replication failures using GGSERR.LOG and logdump utility.
• Monitored Goldengate using 12c Goldengate Plugin, Goldengate Director and shell scripts for alerting GG failed processes.
• Database monitoring, maintenance and performance tuning using OEM such as setting thresholds on tablespaces, user privileges, profiles schemas and sql optimization.
• Implementing partitioning methodologies on tables and indexes for high performance.
• Edited shell scripts to automat tasks and monitored database services, resources and jobs.
• RMAN Backup and Recovery (dropped objects, data files, and Block Corruption) 10g, 11g and 12c.
• Developed RMAN scripts for database backup and recovery including- hot and cold backups.
• Used TOAD, Scripts and OEM Grid Control 11g and 12c for database monitoring and management.
• Promoting application code through the full lifecycle, including development, test, UAT to production.
• Keep Dev and test environment up for developers.
• Creating tablespaces adding, resize and renaming datafiles.
• Maintained data integrity and security using integrity constraints and database triggers.
• Provided 24 X 7 Production & Development database support and administration.
• Worked with Developers to run and troubleshoot PL/SQL (Triggers, procedures and functions)
• Developed compliance reports and performed Database auditing at higher levels.
• Scheduling Backups, gathering schema statistics, clean-up and report scripts using crontab.
• User management, security and database object creation and re-organization.

Confidential - Peapack, NJ

Junior, Oracle Database Administration

Responsibilities:

• Involved in identifying and troubleshooting blocking sessions, wait events and lock processes, releasing locks to improve database performance.
• Managing archived redo files, creating DB-links and Partitioned large database objects.
• Managing Tablespace space by adding datafiles on command line, OEM and TAOD.
• Worked on cloning of databases using RMAN Utility.
• Key player in taking RMAN backups and in troubleshooting backup issues.
• Used Database Restore Points and Flashback technology onOracle11g, 10g Databases.
• Proactive monitoring of Oracle Databases, close alerts triggers using OEM and Scripts.
• Perform database code deployments, Backup and replication monitoring.
• Involved in query optimization and application tuning.
• Installed oracle client, established client connections and used oracle TOAD.
• Checking the Oracle "trace files" and "alert log files" to investigate error messages.
• Involved in planning and implementation of off-site Disaster-Recovery planning and testing.
• Used conventional export/import utilities for loading data to & from databases.
• Datapump for logical backups, refreshes and migration.
• Raised SRs with Metalink to resolve bottlenecks in the database environments.
• Createdoracledatabases on configured servers manually, DBCA & scripts.
• Configuring Automatic Memory Management using Memory target and memory Max target params.
• Created user accounts, roles, granting required access permissions and privileges to users.
• Reorganized Tables and Rebuild indexes to reduce block fragmentation and to improve access speed to database objects.
• Configure Tnsnames.ora and Listener.ora files
• Carried out performance tuning, including tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Excessively worked on performing database backup and recovery procedures using RMAN.
• Created indexes to allow faster retrieval of records.