PROFESSIONAL SUMMARY:

• I am an accomplished and seasoned IT professional with 5+ years of proven experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of applications using Oracle 10g and 11g and 12c.
• I have Proven technical knowledge of rdbms infrastructure combined with outstanding leadership ability and creative problem solving skills.
• I have the abiIity to work in a versatile, dynamic fast paced and challenging enviroments both single or team - based roles with limited direction.
• I have excellent communication /documentation skills and a strong aptitude to analyze and resolve problems.
• Supported as Production and development DBA on OLTP, Data warehouse, OLAP environment. Involved in Change/Release/Patch management and off-shore co-ordination, Product development, data center Migration and administration including design, deploy, tune, trouble-shoot. Efficient to manage 50+DB. VLDB size in 5 TB
• Upgrade databases from 11g to 12c. Apply PSU and bug fix patch. Trouble-shoot upgrade process. Upgrade ASM and RAC. Validate database objects
• Performed Ingress and egress of data to and from AWS while having knowledge of security groups and Network Access Control.
• Migration of databases from Oracle 11g to Amazon RDS
• Maintained RAC configuration including but not limited to VIP management, relocated services, add/delete/modify objects etc.
• Experience in scusing of macros, conflict resolution, filtering and transformationhema management, table space, data file and extent management, as well as user and privilege management.
• Backup of Databases based upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN .Logical backup of schemas using expdp/impdp.
• Recovery of Databases (Media Failure, Block Corruption, drop table etc.)
• Created 12c multitenant container database using DBCA .
• Expert in configuration and Installation of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
• Expertise in maintaining Database Security using security compliance auditing, data masking, data reduction and data encryption using TDE
• Debug PL/SQL objects, function/ stored procedure/ packages Create trigger/ . Manage cursor. Tune and trouble-shooting PL/SQL codes. Handle run-time errors. Create Materialize view.
• Performance, Tuning of databases using ADDM, AWR, explain plan, stats pack, TKPROF and dictionary views. Gather statistics, de-fragmentation of table, re-organize structure. Monitor memory, index, Schedule jobs, Partition pruning for big table. Top sql/session, bottle-neck issues. Tune init parameter. Full table scan and Index usage. Tuned RAC databases, Golden Gate and Dataguard.
• Loading data using Import/export/ sql loader. Purging /cleansing data. Used Data Pump. Estimate timing for imp/exp. Refresh schema.
• Experience with mid-tier architectures , OEM, TOAD, Oracle grid-control .
• Excellent Written and verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS:

Datab Databases: Ora Oracle 12C/11G/10G, Amazon RDS

Opera Operating Systems: HP - Hp-UX 10.x, 11.x. Sun Solaris 8, 9, 10. AIX 5.3, 6.1, RHEL 5.x, Linux Enterprise Server 9, 10. Windows 2012

Tunin Tuning Tools: TKP TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Langu Languages: SQL, SQL, PL/SQL

Utiliti Utilities: RM RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer, Lambda, EC2

WORK EXPERIENCE:

Confidential, Montgomery, AL

Oracle DBA

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c ; AWS RDS

Responsibilities:

• Primary DBA for 100+ databases of Oracle 10g/11gR2 on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
• RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks.
• Debugging PL/SQL scripts using SQL Developer.
• Data guard - configure primary -standby using duplicate from active database command of 11g. Apply SCN-based Incremental backup to sync standby after loss of Archivelogs on primary. Measure data loss based on latency/lag. Cross-platform migration using Data guard.
• Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN. Diagnose and repair block level corruption using RMAN backup/restor
• Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code . Tuning instance by init parameter. Used explain plan and stats pack/TKPROF utility to Improve response time of query. Create/manage local partitioned and bit-map indexes.
• Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.
• Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
• Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.
• Performed Online and Offline backups with RMAN, export/import and expdp/impdp. Performed Point in time recovery using RMAN
• Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results.
• Performed Schema &Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA.
• Supported & maintained the Production/Development databases on various servers
• Extensively worked on setting up auditing in many databases we supported.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.
• Migrated databases from Oracle 11g to AWS RDS, selected appropriate AWS service based on data, compute, or security requirement and appropriate use of AWS Well-Framework.
• Hands on experience using SQL Server Databases.

Confidential. Atlanta, GA

Oracle Database Administrator

Responsibilities:

• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
• Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
• Plan and schedule RMAN backups (hot, cold and incremental backups)
• Setup 12c Oracle Enterprise Manager (OEM), used TOAD for database management.
• Implemented Transparent Data Encryption (TDE) for database security.
• Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control
• Automated the Data Replication process using Materialized Views for reporting databases.
• Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.
• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.
• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
• Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
• Installed ASM environment and migrated databases from NON-ASM to ASM.
• Made optimal use of Oracle Support in resolving the SRs.
• 24 X 7 Production & Development database support and administration.