SUMMARY:

• with over 6 years + of experience in IT infrastructure and ERP implementations with strong technology leadership experience to technical engagements, along with a broad functional expertise. Ability to provide expert - level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup and recovery. Self-motivated, able to forge and sustain positive business relationships using interpersonal acumen to garner customer satisfaction and achieve cooperate goals.
• Full responsibility and expertise in database administration (DBA), performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instance
• Proficient in database administration, production supporperformance tuning, capacity planning, space
• Proficient in Oracle 12C (Container and Pluggable database) Implementation
• In-depth knowledge of TDE (Transparent data encryption (at rest) with network encryption in inflight
• Performed FLASHBACK features to handle efficient database recovery
• In-depth knowledge and understanding of Oracle Database features such as RMAN for backup and recovery, Materialized Views, Export/Import, Data Pump and Data Guard
• Bulk loads and data migrations (using SQL*Loader, data pump import/export, FTP, ETL)
• Expert in RMAN backups including full, incremental and cumulative
• Experienced in Installation of high availability RAC environment and upgraded standalone databases to RAC environment
• Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability
• Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN
• Experience in applying patches (CPU)/ patch sets (PSU) to multiple different databases
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod

PROFESSIONAL EXPERIENCE:

Confidential, DULUTH, GA

ORACLE DATABASE ADMINISTRATOR

• Experience in applying CPU/PSU patches to various versions of databases with minimum downtime.
• Proactive monitoring, identifying areas that need to be improved in the application and database using ASH Analysis, EXPLAIN PLAN, SQL TRACE, ORADEBUG, AWR, ADDM, and 10g OEM Grid Monitoring.
• Good experience in Oracle Clustering services (CRS), and High Availability features. Extensive Knowledge of 10g and 11g ASM.
• Good Experience in Database Backups and Recovery Strategies Using RMAN and Expert experience in Hot and Cold Backup of databases.
• Good knowledge in creating RMAN Duplicate Databases and FLASHBACK recovery features.
• Design, document, implement, and maintain all backup, recovery including disaster recovery.
• Worked with EXP/IMP, EXPDP/IMPDP data pump to refresh the schemas and tables
• Strong Exposure on High Availability Concepts (GoldenGate, RAC, Standby) Database Cloning, and Oracle Streams.
• Oracle GoldenGate experience with Installation, configuration and troubleshooting of Oracle GoldenGate 11g/12c replication setup across heterogeneous database servers and ensure data synchronization.
• Proficient in Oracle Database Administration activities such as Upgrades, Patches, my oracle support

Confidential - IOWA CITY, IA

ORACLE DATABASE ADMINISTRATOR

• Responsible for Oracle 11g and 12c logical and physical database design, implementation, and maintenance on Windows and Linux environments
• Created new databases and users: set up backups, export, and other monitoring scripts
• Deploying codes from one database to another and worked on resolving various performance issues
• Implemented database refresh using expdp, provided improved database performance resolution and effective space management
• Migration from one platform to another using transportable table space and import and export utilities
• Managing database security automated data backup and restoration methodologies.
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU)
• Applied Patch Set Updates (PSU) for RAC and Stand - Alone instances as releases were made available by Oracle
• Applied Oracle Patches to environments where problem tracking with Oracle Support suggested on RAC & Single Instance environments
• Provided 24x7 Remote / on-call production supports
• Provide technical support for database maintenance and disaster recovery
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager)
• Index creation and management for optimization of DB Processes
• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification
• Extensive experience implementing backup and recovery strategy for disaster recovery using Hot/Cold Backups and using the Oracle backup utility such as RMAN.
• Analyzed Statspack/AWR Reports to identify on-going/proactive issues and worked with application teams to resolve
• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History (ASH).
• Supported and maintained Development, Test and Production databases on various servers
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints. Used hints for SQL tuning and optimization
• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Experience with database replication and scaling issues
• Setup dataguard broker successfully; Configured Oracle Data Guard (standby database, both logical and physical)
• Implemented and configured goldengate on a 2-node RAC cluster

Confidential - Ann Arbor, MI

Oracle Database Administrator Oracle DBA

• Installation, configuration and administration of oracle databases. Experience in DB upgrades, patch application, db migration, performance tuning and all general database support
• Ensure that daily and hourly database backups completed successfully and perform period database restore testing to ensure the database can be restored in the case of a disaster
• Good knowledge on the Creation of table spaces, data files, roles, redo logs, rollback segments, and index rebuild. Performance and space management of the database
• Extensive experience in Performance Tuning of database, instances, SGA, I/O, and Rollback segment using different methods and detecting locks
• Experience in Implementing FLASHBACK technology and its various features in Oracle 10g/11g and 12c
• Experience in applying several patches such as CPU/PSU patches, One - Off Patches, Interim patches, DST, Patch sets as per the oracle recommendations
• Participated in planning and implementation of off-site Disaster-Recovery planning and testing
• Duties included database creation, backup/recovery using RMAN, tuning/reorganization, user and security management, auditing, cloning, general troubleshooting
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring database
• Expertise in database refresh, schema changes, backup and restore testing, database troubleshooting and db performance tuning
• Worked closely with Developers, Application analysts, Database programmers and web developers.
• .involved in converting a single instance database to oracle 12c, 11g, 10g RAC databases

Confidential - Colorado Springs, CO

Oracle Database Administrator

• Supported Oracle on Linux Red Hat, HPUX, & AIX environment
• Cloned Oracle environments using Recovery Manager(RMAN) for user acceptance testing of new releases
• Applied Oracle Patches to environments where problem tracking with Oracle Support suggested on RAC & Single Instance environments
• Capacity analysis of Oracle Databases and the Data warehouse
• Review and Troubleshoot issues within the Oracle environment as issues presented
• Work with application support to troubleshoot any performance issues within the environment
• Analyze any issues and provide root cause analysis to the RCA Board
• Managed Oracle 10g, 11g, and 12c databases
• Create documentation for all issues and new implementations maintain, and fix shell scripts used to monitor the database
• Monitor the database via OEM 12c and resolve any issues that presented
• Database restoration and backup with RMAN a
• Attend weekly change board meetings and ensure all changes to the database have proper visibility
• Review, monitor, and resolve all tickets within the database ticket queue

TECHNICAL SKILLS:

Databases: Oracle 10g, 11g, 12c, Exadata

Database Tools: Oracle (Oracle Enterprise Manager, DB Configuration Assistant) Toad, OEM Grid, RMAN, Exp/Imp/Data Pump, AWR, DBCA, DBUA, ADDM, TKPROF, Toad, Putty, WinSCP, SQL Developer,, SQL*Plus, SQL LOADER, EXADATA OEM 12c. Oracle RDBMS 10g, 11g and 12C (Container and Pluggable databases)

Operating Systems: RedHat LINUX 5,6,7, UNIX, Solaris, WINDOWS, ), IBM AIX:

Other Skills: Oracle, DATA GUARD, GOLDEN GATE, RAC, SQL SERVER and Exadata