Oracle Manager
Resume:
Adrian Chita
Oracle Database Administrator
******.*******@*****.***
Professional Skills
I have over 6 years of experience as an Oracle Database Administrator. Have extensively worked on Installing, configuring Oracle 12c, 11gR2 and 10g. Performed Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security. Managed databases running on AIX, Linux, UNIX and Windows environments. Experienced in configuring and managing Oracle Real Application Cluster (RAC), Data Guard and Golden Gate for Oracle High Availability.
Work Experience
Sonexus Health - Lewisville, TX
January 2015 – Present
Oracle Database Administrator
●Supporting multiple databases for production, development, test and staging purposes on linux and Windows environments.
●Very comfortable with Rman for online and offline backups, datapump for moving data across the full SDLC.
●Using GoldenGate to migrate and upgrade Oracle 11gR2 database from Sun Solaris 10 to Red hat Linux 5.
●Capacity planning: Allocate system storage and plan future storage requirements.
●Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production .
●Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
●Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
● Managed resources like data files with ASM (Automatic Storage Management) (Troubleshooting, Add, Remove Files etc.), online redo log files, control files. Allocating logical storage structures like tablespace, Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases
●Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
●Refreshing Dev and Test instances with data from Production on a regular basis.
●Creating and assigning appropriate roles and privileges to users depending on the user activity.
●Responsible for support of Oracle Databases of sizes ranging from 100 GB to 40 TB.
●Responsible for configuring and taking level 0 and level 1 incremental RMAN backups and resolving issues arising out of those. Performed daily health check of the databases by implementing above backup and recovery procedures.
●Highly Experienced in Hot/Cold Backup and Recovery strategies and Cloning of databases using RMAN
●Knowledge of Database Recovery Techniques and implementation of those recovery techniques like point in time recovery (PIT) to ensure business continuity.
●Part of DB support team, providing 24/7 support for Production databases.
●Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, using Oracle RAC, Data-Guard, Streams, ASM, RMAN.
●Configured deployed and administered 2 node RAC clusters on Solaris 10 and Redhat Enterprise Linux 5.9.
● worked with very large 24x7 Oracle RAC 11g databases on ASM of nearly 700GB to 30TB.
●Extensively involved in performance tuning of applications, SQL queries and databases using Explain Plan, ADDM, AWR reports and TKprof.
●Monitor Oracle 10g/11g/12c databases using OEM and Grid Control.
●Participated in migrating Oracle database server from 10g x-86 RHEL Environment to 10g in Solaris10 Environment and Participated in upgrading Oracle database server from 10g to 11g and to 12c.
●Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
●Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM
●Monitored and troubleshoot database issues with OEM grid control.
●Built physical standby using RMAN Active duplication method as well for Disaster recovery site
●Performed database recovery using GRP (Guarantee Restore Point)
●Setup the unidirectional replication on oracle 11g databases using Goldengate in heterogeneous data environments.
●Successfully upgraded the databases from 11g to non CDB 12c.
●Created Oracle Wallets and implemented Tablespace level TDE security.
●Configuration of Listener and Tnsnames.
●Responsible for Maintenance and Support of multi-terabyte databases in production, testing and development environments. (Sun Solaris, Linux Redhat)
●Successfully installed Oracle Real Application Cluster (RAC) including; Grid infrastructure (Clusterware and ASM) and Oracle rdbms software on a 3 nodes RAC architecture in development and UAT running oracle.
●Experience in designing and configuring high-availability systems using DataGuard with physical standby effectively configured and used DataGuard Broker utility.
●Configured 12c Oracle grid infrastructures & Oracle database software to meet the current needs and upgraded as required to meet the expansion needs of the company.
●Performed logical backups using Export/Import and Data Pump
●Efficient in SQL query optimization and instance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR and ADDM reports, gathering statistics, pinning the objects, Running scripts.
●Doing the regular activities like monitoring the alert logs, redo log status, listener. Log and checking the space for normal segments, rollback segments and tablespaces.
Dynamics Resource - Chicago, IL
Mar 2012 – December 2014
Oracle Production Support Database Administrator
●Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
●Proficient with new 11g features such as Active Dataguard and Snapshot standby database.
●Applied Patches including; Patch Set Update (PSU)/Critical Patch Update (CPU) and One-off Patches using OPatch and run Installer under UNIX.
● Restoring SQL Server Databases from FULL and DIFFERENTIAL backups.
●Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
●Loading data from flat files to database using SQL*Loader, External Tables.
●Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
●Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
●Installed ASM environment and migrated databases from NON-ASM to ASM.
●Used TOAD for database management.
●Performed SQL and PL/SQL tuning to, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
●Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and on the tables.
●Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
●Experienced in cloning the databases using HOT and COLD backups.
●Made optimal use of Oracle Support in resolving the SRs.
●24 X 7 Production & Development database support and administration.
●Extensively used AWR, ADDM and explain plan for periodic performance tuning.
●Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
●Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
●Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and SQL Trace & TKPROF, EXPLAIN PLAN.
●Database monitoring/maintenance, and performance tuning using OEM (Oracle Enterprise Manager).
●Applying upgrade patch, maintenance and interim (opatch) patches on all databases.
●Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.
●Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
●Refreshed/cloned databases using RMAN utility.
●Performed Database upgrade from Oracle 10g (10.2.0.5) to Oracle 11g (11.2.0.4) RAC database.
●Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Education
●SQL certified associate
●bachelor's degree in information technology and Information Systems
TECHNICAL SKILLS
Operating Systems
HP-UX, Sun Solaris, AIX, RHEL, Linux Enterprise Server, Windows 2012
RDBMS
Oracle 10g, 11g,11gr2, 12c
Tools
TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Toad, Putty, NX client, WinSCP, VNC, Cisco VPN Client, SRVCTL and CRVCTL
Database Utilities
SQL*Plus, Oracle Enterprise Manager(OEM), OEM cloud control 13c, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
Contact this candidate