PROFESSIONAL SUMMARY

• Over 6 years of Oracle Database Administration experience supporting a variety of critical applications in enterprise and production environment as well as lead teh team as Service Matter Expert.
• Excellent experience on oracle 9i, 10g, 11g, and 12c across multiple platforms like Linux, Unix, AIX, Sun Solaris, HP - Unix, Win2k8 and Windows 2012.
• Organized and prepared System Functional Document (SFD), Technical System Document (TSD) and UIT Document in absence of teh team lead in previous projects.
• Expertise in of various Oracle tools like Enterprise Manager (11g, 12c and 13c grid) with management pack, Oracle Client, OSWatchers, SQL Developer, TOAD, Oracle GoldenGate, RMAN, ASMCMD, LSNRCTL, SQL*Loader, Statspack, SQLT trace to perform day to day job.
• Provisioned and maintained ORACLE 10g/11g/12c RAC multi-node, added nodes to cluster database for high availability. Excellent noledge of Oracle Architecture.
• Involved with installation and maintenance of OEM Database & Grid control for database monitoring, performance and diagnostics.
• Extensive experience in RAC administration and Data Guard Active Recovery, configuration and patching, also in Backup and Recovery.
• Extensive experience in configuring and implementing ASM/ACFS and proficiency in using ASMCMD and ASMLIB, Flashback Technology, Log Miner, ADCRI.
• Extensive experience with logical and physical data modeling and database design using Oracle Designer and Erwin.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases.
• Backup and Recovery strategy development (hot / cold) and implementation with through understanding of Database Recovery Scenarios.
• Proficient in SQL Plus, UNIX and Linux Shell Scripting, TCP/IP, Stored Procedures, Functions, Cursors, Triggers and PL/SQL programming.
• All different levels of installation, upgrade and Patching oracle databases.
• Experienced in a 24*7 platform operation environment and provided technical support to all Application teams as well as lead teh offshore team management.
• Involved in meetings with various App teams, managements and Oracle Platform Operation team as well as generate reports, spreadsheets, documents per requirements.
• Created and maintained design documents, SOPs, technical documents, user guides and training manuals for Offshore and junior resources.
• Excellent written and oral communication, organizational and multi-tasking skills.
• Strong data visualization and reporting abilities.
• Great noledge and observation on a Cloud technology such as Amazon Web Services (AWS), Azure, Kubernetes, Dockers and Containers.
• Hands on experience with MySQL and MongoDB on platform operation environment.

TECHNICAL SKILLS

Operating Systems: Linux, Solaris, AIX, Red HatEnterpriseLinux, HP-UX, Unix, Windows 7, Windows 2012

RDBMS/Databases: Oracle 12c, 11g, 10g, 9i, MySQL 5.6, 5.7, Maria DB, SQL Server, MongoDB, MaxDB

Storage Technologies: Oracle ASM,VeritasNetbackup, ACFS, DDBoost

Virtualization Technologies: VMware, Oracle Virtual Machine, DMZ

DR Technologies: Oracle Data Guard and Goldengate

Backup recovery Tools: RMAN, Flash Recovery, Data Pump

Programming Languages: SQL, PL/SQL, Linux and UnixShell Programming, C++, HTML.

Tools: SQL developer, TOAD, Putty, Oracle Enterprise Manager (OEM) 11g, 12c and 13c grid, Oracle Performance pack, MS Office 2000 and 365, Oracle 9i, 10g, 11g, 12c,, TIVOLI, ERWIN, WINscp, ODAs, MySQL Workbench, DB Manager, AMAZON Web Services (AWS), Service Now, JIRA, Control-M, M360 Monitoring Tool, Compass

Utilities: SQL Loader, Exp/Imp, Data Pump, Expdp/Impdp, LSNRCTL, TKPROF, Statspack, OSWatchers, SQLTXPLAIN, RMAN, ASMCMD, SSH, IBM UDeploy, OAKCLI, AZCLI, AWSCLI

PROFESSIONAL EXPERIENCE

Confidential, Universal City, CA

Oracle Database Admin / SME

Environment: Oracle Database 12c/11g/10g (RAC, Standalone and DR), OEM 13c grid, Oracle GoldenGate 12c/11g, Oracle Database Appliances (ODA), Oracle RAC/non-RAC Provision Scripting, MaxDB 7.5/7.4, MySQL 5.7/5.6, MariaDB 10.1.22, Amazon Web Services (AWS), AWS RDS, SQL Developer, MySQL Workbench, PuttyDB Manager, Service Now, JIRA, Control-M, Data Protection Jobs, WINscp, MobaXterm, Monyog, Compass, M360 Monitoring

Responsibilities:

• Extensively worked in upgrading Oracle Enterprise Manager(OEM) grid to latest version 13c and Oracle Manager Server (OMS) Patching for our OEM 13c bug fix.
• Developed architectural framework, designed, provisioned, maintained, and upgraded Oracle databases.
• Worked with cross-functional teams of application teams, engineers, and production planners to understand business process and develop functional specifications and assist anywhere needed.
• Performed performance management and tuning of Oracle database.
• Space Management for Multi-Terabyte Production Databases using ASM and ASM Cluster File System (ACFS).
• Coordinate with Compute/Server team to request/add/mount LUNs in ASM, ACFS, Filesystem in Linux, Suns Solaris, ODAs and Windows environment.
• Worked with development team to oversee code inspections during a new database provision project.
• Validated RDBMS/ASM version, RPMs on teh server level and installed teh required RPMs.
• Prepared automated job to rebuild indexes for critical Application team such as SAP, Timekeeper, PeopleSoft’s, Rights logic and DreamWorks Animation.
• Experienced in Data Masking for sensitive data from Oracle EM 13c and 12c.
• Created and maintained design documents, SOPs, technical documents, user guides and training manuals for Offshore and/or junior resources.
• Involved in Oracle GoldenGate (OGG) upgrade to 12c, installation, troubleshoot, OGG JAgent upgrade and configured OEM Monitoring.
• Extensive noledge on teh patching workflow as well as applied various ODA, GRiD, DB, DCSS, PSU and SAP Bundle Patching in RAC and non-RAC environment.
• Installed Data Domain (DDBoost) backup tools and configured with RMAN backups.
• Installed Oracle Client 12c/11g in Linux, Solaris, Citrix, Windows 2012 Servers as well as servers behind DMZ/jump box.
• Raised SRs in Oracle Metalink and follow up with Oracle Support and provide required information to resolve any issues or get to RCA and set parameters in teh databases per requirement.
• Installed SQLT to diagnose difficult SQL Queries performance and OSWatchers in ODA environments to generate teh detail oriented trace files.
• Performed active cloning, duplicate database, migration, quarterly refresh, Data Pump (expdp & impdp) of Oracle databases, schemas and its objects.
• Converted and configured teh database with Western European character set (WE8ISO8859P15) during new database provisioning required for PeopleSoft App from DBCA (Database Configuration Assistant) Operations window.
• Increased VARCHAR2 (block storage) from 4K to 32K (max string size = Extended).
• Scheduled control-m jobs such as archive/full backups and purge jobs with Production Automation team.
• Built refresh automation script using Active Cloning Process from teh DR.
• Involved in meetings with various App teams, managements and Oracle Platform Operation team.
• Raised as well as approved Service Now general requests or change requests accordingly to Application or Oracle team's requirement.
• Experienced in a 24*7 productions operation environment and provided technical support to all Application teams as well as lead teh offshore team management.
• Conducted reviews of data models within teh Enterprise Data Warehouse and generated Erwin Data Model frame work.
• Assisted Application team with AWR report analysis and related to RCA.
• Supported open source databases (MySQL and MongoDB) and team’s daily operation activities (create users/DB/objects/docs, backups, refresh, monitor alerts, assist App teams) extensively as L1/L2 resources during business hour.
• Great noledge and experience working with a variety of Cloud technology such as Amazon Web Services (AWS), Azure, Kubernetes, Dockers and Containers.

Confidential, Cary, NC

Oracle DBA

Environment: Oracle 12c/11g/10g, RAC Infrastructure with Data Guard feature, OEM 12c grid, Linux/AIX/Solaris OS, LSNRCTL/TNS, VIP/SCAN, ASM, RMAN, Data Pump/Import/Export, AWR, STASPACK, Unix Scripting, SQL*Plus, PL/SQL, TOAD, Putty, Windows 7, Citrix ANT, Service Now, SharePoint, Oracle Metalink.

Responsibilities:

• Installation, Configuration, Upgrade and Patching of Single and RAC DB’s.
• Oracle DDL, DML operation, Labels deployment and change implementation in daily basis and involved in weekly infrastructure activity.
• Extensively worked in Upgrading databases to new versions and applying database patches in RAC and non-RAC environment.
• Setup, manage, troubleshoot of teh highly critical databases configured with oracle 11gR2 RAC including ticketing system- SRs/Changes/Incidents/Audits.
• Configuring and maintained 10g/11g active Data Guard to ensure high availability, data protection and disaster recovery for enterprise data.
• Extensively worked on teh Grid Control agent setup and configuring required fixes.
• Extensively worked on database refresh/cloning for multiple environments.
• Documentation of all pre-requisites and installation steps involved in above configurations
• Space Management for Multi-Terabyte Production Databases using ASM.
• Designing and implementation of DB backup plans using RMAN backup technology and traditional hot/cold backups.
• Extensively used data moving technologies like exp/imp, Data pump and SQL Loader.
• Monitoring and tuning of databases, includes memory tuning, init.ora parameters tuning, OS kernel parameters tuning and individual SQL statements tuning.
• Supported weekend SAN migration.
• Closely worked in teh matter of capacity planning as per teh requirement.
• Managing Siebel, Dev and production applications.
• Backup and recovery, Patching, Upgrading of DB and Oracle Flashback technology.
• Assisted on Migrating/Cloning UAT and Development databases to RAC environment on Production servers.
• Worked with cross-functional teams of application teams, engineers, and production planners to understand business process and develop functional specifications and assist anywhere needed.
• Written Shell scripts to Monitoring day to day database activities.
• Provided 24*7 productions on call support on regular prod and Siebel environment.
• Occasionally writing (PL/SQL) Procedures, Functions, Triggers and Packages.

Confidential, Sacramento, CA

Oracle Database Admin

Environment: Oracle 10g, Solaris, RMAN, Data Pump, Import/Export, ASM, AWR, STATSPACK, TOAD, Unix Scripting, SQL*Plus, PL/SQL, TOAD, Putty, Windows 7, OLDP, Erwin/Data Models, RAC, Clear Quest, SharePoint, SFD, TSD, UIT, IBM Lotus Notes, Java

Responsibilities:

• Installation and creation of 11g and 10g databases for Development and Testing.
• Working with DEV team to rectify teh sql's for better performance.
• Performing day-to-day database administration tasks like Table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Prepared System Functional Document, Technical System Document and UIT Document in absence of teh team lead.
• Data loading using SQL*Loader, Logical backups using full export and DATAPUMP.
• Excellent noledge of Oracle Architecture, Configuration of TCP/IP protocol, Listeners, TNSnames, SQLNET, V$ and DBA views.
• Provided Oracle database administrative support for Oracle 10g,11g grid control (OGC), Putty, TOAD, SQL*plus, RMAN, Data Pump.
• Planning Backup/Restoration Strategy, Scheduling Backups, Schema backups, taking Logical Backups (with Export/Import Data Pump utilities).
• Export and Import of database objects to copy from one database to another database.
• Creating table spaces, tables, indexes, users, etc.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Addition of users, objects etc as and when required and granting proper privileges for Database access.
• Monitoring and resolving tickets in different environments.
• Experienced with SRVCTL for monitoring and configuring RAC Environment.
• Database Maintenance, Data Mart and Data Modeling using Erwin.
• Assist Programmers and Developers with Oracle problems.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Taking care of database by checking teh size teh database and addition of table spaces, data files.
• Able to work TEMPeffectively with multiple teams at once. Able to thrive in a fast-paced, time compressed and dynamic environment.
• Solid skills and discipline for Change Management practices processes.

Confidential, Charlotte, NC

Oracle DBA

Environment: Oracle 11g (11.2), Red Hat Linux, Oracle Designer, PL/SQL, OEM, Win 2000 Advanced Server, RMAN, RAC, OLTP, ADDM, AWR, TKPROF.

Responsibilities:

• Checked configuration and performance of existing including data file allocation, index, fill factor, fragmentation and impact on system performance.
• Analyzed and tuned teh DB to identify potential database issues such as response delay, locking contention, even server down time by using tools like Stats pack, explain PLAN and TKPROF.
• Monitored and tuned database to optimize teh performance and satisfy teh availability requirements of multiple applications using (STS) SQL Tuning Set and (STA) SQL Tuning Advisor. Analyzes teh data by (ADDM) Automatic Database Diagnostic Monitor in teh (AWR) Automatic Workload Repository.
• Created teh new database objects compiling with (OFA) Optimal Flexible Architecture.
• Modified existing database structures layout such as disk configuration and storage allocation to enhance application performance.
• Worked closely with project managers, programmers and testers to database integrity and security and generated test data and tested new database consistency with existing database to meet teh functionalities requirements.
• Provided suggestions to server administration team regarding disk configuration, RAID according to database sizing and capacity planning. Fully utilize Metalink to maximize Oracle support.
• Maintained day-to-day production support thereafter, check alerts, activity logs, error logs to capture any possible errors to ensure teh databases health.
• Migrated databases of windows server to UNIX servers for new application integration.
• Devised, developed and implemented sophisticating backup recovery strategy using RMAN with VERITAS and designed/implemented disaster recovery test.
• Developed and implemented database maintenance procedures.
• Capacity Planning for both OLTP and Data mart - Allocating system storage and planning future storage requirements for teh existing and new databases.