SUMMARY

• 20 years of IT experience as Oracle DBA of progressively responsible positions in diversified and very large production and development environments with database and Application implementations in various platforms of Unix flavors and Windows with a proven track record as a Senior Oracle DBA.
• Interested for DBA position in Part - Time or Flexible-time fashion
• Extensive experience in production DBA activities including installations, patching, cloning, High Availability (SuperCluster (Exadata), RAC, Dataguard, RMAN, OEM Cloud Control & Grid Control).
• Expertise in Oracle RAC, ASM, Data Guard, installation, migration, patching, designing, scripting, performance tuning, database security and auditing, Oracle Internals, Oracle databases(8.x, 8i.x, 9i.x, 10g.x, 11g.x and 12c.x), Oracle Cloud Control(12c) & Oracle Grid Control 10g.x & 11g.x).
• Oracle Certified Professional (9i DBA). Microsoft Certified Professional (NT Server).
• Helped company gain 3000 Oracle licenses before Unlimited License Agreement(ULA) expired.
• Engineered solutions and implemented Oracle’s Transparent Data Encryption, Pluggable Container Resource Management, Partitioning, Container creation, GoldenGate for databases using Data Guard and RAC. Used Agile methodology.
• Installation of Oracle 18c (with multitenant architecture i.e. CDB and PDB) database on Oracle Linux.
• Extensively upgraded 11gR2 to 18c, 10gR2 to 11gR2 & 9iR2 to 10gR2.
• Broad knowledge and success in planning / implementing database projects.
• Actively working for three(3) years on Exadata in OCI.
• Recommended hardware and OS platform for database systems. Conform to industry standard practices for implementing tools and components.
• Extensive experience in managing, leading and mentoring junior DBAs.
• Solid experience in system analysis and design, development, documentation, code review, code analysis, process improvement and participating in customer presentations.
• Write Jira Epics and Stories and present in Sprint Reviews.
• Cross-Platform Migration of "Oracle Database" from Windows to SUSE Linux Platform and upgrade of it from 9i and 10R2 to 11g R2.
• CPU /PSU patch analysis and application.
• Foolproof Database Upgrade from 11gR2 to 12cR1 using Real Application Testing (RAT).
• Strategize and implement Oracle database RMAN backups and logical backups using export/import utility.
• Configured RMAN Backups using TDPO & TSM.
• Experienced in administration and design of OLAP and OLTP databases.
• Analyzing AWR, ADDM and ASH reports to tune Oracle Databases.
• Oracle RDBMS design and developing stored procedures, packages, triggers, cursors & functions using SQL and PL/SQL.
• Expertise in tuning procedures, packages and SQL statements.
• Proficient in error handling and debugging coding issues and troubleshoot production problems.
• Possess excellent problem solving skills, very strong written and verbal communication skills.
• Able to direct multiple tasks efficiently and master innovative software and tools.
• Illustrated performance in identifying problems in initial stages, executing quick resolutions, and communicating technical issues to non-technical personnel.

TECHNICAL SKILLS

Relational Databases: Oracle (19c, 18c, 12c, 11g, 10g, 9i, 8i, 8, 7).

ERP Applications: Oracle ERP Apps (10.7, 11.0, 11i).

Oracle Tools/Utilities: RAC, RMAN, ASM, OEM Grid/Cloud Control 11g/12c/13c, Active Dataguard, Golden Gate, Snapshot Standby Database, SQL Developer, SQLPlus, TOAD, SQLLoader, TKPROF, IMP-EXP, Expdp-Impdp, SQLT, STATSPACK, AWR, ADDM, ASH, ORAChk, OSWatcher. DBV, Shell Scripting, Top, SAR, VMSTAT & IOSTAT.

Operating Systems: UNIX (SUSE Linux,OEL, HP UX, Sun OS, IBM AIX), Windows (2012, 2008).

Programming: UNIX shell, SQL, PL/SQL, Awk, MQL and ThinkScript.

Internet: HTML, CGI and Perl.

Other: SuperCluster, Oracle Enterprise Manager (OEM 13c & 12c), Oracle Data Guard, MS Access, MS-Office, Putty, Winscp, VNC Viewer.

PROFESSIONAL EXPERIENCE

Confidential, Livonia, MI

Senior Database Administrator

Responsibilities:

• DBA Lead for dynamic and complex environment running on Oracle and SQL Server.
• Successfully lead and completed the project to extend the usage of Oracle’s Unlimited License Agreement. Company gained around 3000 Oracle licenses after ULA’s expiry because of the project.
• Engineered solutions and implemented Oracle’s Transparent Data Encryption, Pluggable Container Resource Management, Partitioning, Container creation and GoldenGate for databases using Data Guard and RAC. Used Agile methodology.
• Wrote scripts in SHELL and PL/SQL to use and to implement solutions I developed for TDE, PDB creation, DBRM, Partitioning, etc.
• Incorporated Agile methods to all projects and customer requests and issues.
• Deployed Oracle 18c features like Multitenant, Partitioning, Resource Management, Data Encryption for 18c DataGuard databases.
• Documented each 19c feature implemented at Workforce and performed knowledge share with DBAs.
• Architect and Implement Oracle RAC 19c in Oracle Cloud Infrastructure (OCI).
• Developing Wiki page for DBAs to support RAC 19c in OCI and future OCI rollouts.
• Upgrade/Migration of Databases from different Oracle versions.
• Migrate customers from Azure to OCI. OCI is running RAC in Oracle 19c.
• Successfully moved customers from MS SQLServer to Oracle using GoldenGate.
• Configured GoldenGate’s extract and replicat and Migrated 11g and 12c Oracle database to 19c.
• Performed Initial load and Change Data Capture for Golden Gate.
• Document and perform knowledge share to DBAs on continuous basis.
• Identify gaps in 18c implementations and fix the gaps and document the fix.
• Improved RMAN backups by running them on Standby.
• Identify and proactively perform capacity management for client’s databases.
• Identify clients experiencing performance bottlenecks using resource contention methods and migrate to Oracle 18c and to SQL Server 2017.
• Develop, create, and apply monitoring templates for 18c Data Guard health using Oracle Cloud Control 13c.
• Streamline and strategize to fix targets in Oracle Cloud Control 13c. Wrote shell script to fix target names to database unique name and handle Data Guard dependencies.
• Perform tuning and optimization of Client’s databases.
• Took ownership and lead a team of DBAs to complete patching using automation of all Oracle rows to fix Resource Manager bug.
• Attend standups on a daily basis to share and report progress on customer and project issues. Handled customer requests using Salesforce and Atlassian Jira.
• Brainstorm with team on Jira Epics and write Stories for projects I am working on.
• Groom Jira Epics and Stories on a continuous basis.
• Present progress of the projects in Sprint reviews to all Cloud Services teams during bi-weekly reviews.
• Collaborated with developers to migrate stored procedures and help various software development .
• Demonstrated great analytic skill and showed ability to independently troubleshoot application issues with vendors’ technical support.
• Self-motivated and learned additional skillsets outside of DBA duties, supporting various applications as a team player.
• Work independently and on a team in an agile environment.
• Provide DBA on-call support on a continuous basis.
• Working to get Oracle Cloud Infrastructure Cloud Operations Associate certified.

Confidential, Livonia, MI

Oracle DBA

Responsibilities:

• Provide hands-on database administration in support of production and lower environments.
• Lead and primary DBA for Cerner PathNet. Helped in technology planning, database project implementation and db environment design.
• Performed database refreshes using manual and RMAN duplicate process.
• Performed upgrade of 11g GI to 12c.
• Support the maintenance for RAC-one and RAC nodes during SP5 upgrades.
• Designed backup strategy for daily and weekly backups using RMAN from Standby rather than Primary.
• Upgraded 11.2.0.4 databases to 12.1 CDB.
• Used SQL Baselines and SQL Profiles to optimize query performance and monitoring sql plan changes as proactive approach.
• Lead a project to identify required stats on mission critical applications where the DATA volatility is more than 10% and scheduled an automatic stats gathering job in non-peak hours as proactive measurement to avoid issues pertaining to table statistics.
• Participate in on-call duties on a rotational basis.
• Took action to support LUN failure. Performed switchover. Recovered the original RAC database.
• Fixed excessive incarnations in RMAN catalog.
• Configured Snapshot standby for 724 Downtime Viewer database.
• Eliminated space errors by implementing proactive space monitoring and effective space allocation.

Environment: Oracle 12c, 11g, AIX,Red Hat Linux, ASM, CRS, RAC, RAC one, ACFS.

Confidential, Dearborn, MI

Senior Oracle DBA

Responsibilities:

• Administer and support the continuous operations of Oracle enterprise server databases running on UNIX and Windows environments(size from 300Gto 10T).
• Part of the core group to document and implement DBA standards (installation, database naming/creation, Backups, Disaster Recovery, Oracle ERP environments, automatic startup/shutdown scripts, on-call support), Standard Operating Procedures (SOP’s).
• Installing Oracle RDBMS and GRID Binaries 11.2.0.4 & 12.1.0.2 in Silent and GUI Mode for Oracle Restart and RAC environments.
• Performed RMAN and TDPO backup tuning. Successfully fixed RMAN backup issues. Developed solutions to fix various issues with scripts for RMAN.
• Patching Oracle and GRID Binaries using Opatch Utilities.
• Planned the setup and provide continuous support to the clients and ASM on SuperCluster. Adding and dropping disk from ASM.
• Upgraded Oracle databases from 11.2.0.4 to 12.1.0.2.
• Administration of Oracle 11gR2 RAC (2 Nodes) databases.
• Converting Single instance to RAC database and RAC database to Single instance.
• Administration of Oracle Active Data Guard Standby and Snapshot databases.
• Cloning of Oracle 11gR2 Database using RMAN Duplicate.
• Successfully implemented RMAN backups using Multisection for big file tablespaces.
• Developed scripts to generate reports on security issues on database servers and in databases.
• Developed and implemented script to cleanup files under adrci in 11g database servers. Deployed the solution globally in Confidential .
• Wrote documents and did presentations to Global DBA team. Wrote document on handling TDPO RMAN tickets, to perform DB migration from Windows to Linux and Linux to Linux.
• Lead project to reduce incidents. Developed strategies to reduce incidents.
• Provided KT to DBAs globally on various DBA activities.
• Piloted 12c OEM agent installations and migrations for multiple hosts in one go.
• Participate in evaluating databases for security problems prior to internal and external audits.
• Facilitate and Lead meetings.
• Developing and testing database upgrade to 12c.
• Lead Problem Management team for all Oracle Databases groups.
• Took up the expert role to perform 11.2.0.4 database upgrades for number of sites and applications.
• Worked with Confidential and internal managers to brainstorm on 12c courses. Successfully arranged for Oracle to host training at Confidential for 55 Oracle DBAs.
• Brainstormed with DBAs and Engineers to developed solution for GDIA's Attunity requirement.
• Providesupportto more than3000 production databases. Render on-call support for 24 / 7 operations on a rotation basis to ensure functionality and efficiency.
• Implement policies and procedures for ensuring the security and integrity of the Oracle databases.

Environment: Oracle 12c, 11g, 10g,Suse Linux,Windows 2003,Sun OS (2.8), HP-UX 11.0, 11i, IBM AIX 4.3, Oracle9i.

Confidential, Schaumburg, IL

Oracle Database Administrator

Responsibilities:

• Administer and support the continuous operations of Oracle enterprise server databases running on UNIX and Windows environments.
• Support Oracle ERP 10.7, 11.0.3, and 11i databases.
• Utilize RMAN and Veritas Netbackup to design / implement back up methods and disaster recovery strategies.
• Implement DR solutions using Data Guard.
• Use export / import, RMAN, Veritas Netbackup3.4, and EMC BCV copy process to refresh non-production databases.
• Support in excess of 1000 production databases. Render on-call support for 24 / 7 operations on a rotation basis to ensure functionality and efficiency.
• Implement policies and procedures for ensuring the security and integrity of the Oracle databases.
• Created 9i Data Guard environments for two production datawarehouses.
• Worked on Oracle migration projects. Performed Database migrations from 8.1.7/8.0.4 to 9.2.0.5 Version with oracle 9i new features.
• Played an instrumental role in the upgrade of 11.5.5 Oracle ERP application to 11.5.8 on HP-UX. Precloning and postcloning. Implemented Autoconfig feature. Upgrade to 9iAS 1.0.2.2.2. Applied patches using adpatch and admrgpch. Used AD tools like adconfig, admrgpch, adclone, adchkcfg, adpatch, adadmin, and adctrl.
• Installed Oracle 9i. Performed database creation and setup on Sun OS. Implemented 9i features like automatic undo management, LMT’s, spfile, dynamic SGA and default temporary tablespace.
• Developed a Capacity Planning solution for analyzing database growth.
• Carried out performance tuning of Informatica Datawarehouse database using Statspack.
• Refreshing the Production over the Dev, Staging, and UAT and keeping the Test Instances in sync with other instances.
• Spearheaded migration of Oracle on HP-UNIX.

Environment: Sun OS (2.8), HP-UX 11.0, 11i, IBM AIX 4.3, Oracle 8i, Oracle9i and Oracle 7.3.4, Oracle ERP 11i, 11.0.3, 10.7.

Confidential, Chicago, IL

Database Analyst

Responsibilities:

• Worked in conjunction with Database Administrator in the design, documentation, maintenance, and administration of the internal databases on SQL Server.
• Provided short- and long-term database strategic planning and implementation for Information Services Department.
• Utilized MS Access and SQL Server on a Windows platform to develop applications.

Environment: Microsoft NT Server, SQL Server 7.0, MS Access