SUMMARY

• With over 7 years of IT and related experience coupled with years of extensive knowledge and proficiency in oracle 11g, 12c, 18c and 19c database administration - Worked on very large production databases performing various DBA roles. Experience across a multitude of platforms (LINUX, Solaris, UNIX, AIX and Windows) in production, development and test environments.
• Enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail. Possess excellent leadership ability and creative problem-solving skills in both strategic and tactical areas as well as great communication /documentation skills. Strong aptitude to analyze and resolve problems and possess well-honed ability to adapt and thrive in a dynamic fast paced and challenging work environment.
• Database design and development (SDLC)
• Installation, configuration, and update of Oracle 11g, 12c, 18c and 19c using OUI and DBCA
• Network and Connectivity Startup & Shutdown
• Work with various operating systems like MS Windows Servers (2003, 2008) and Linux (Red Hat)
• Database Security, database migration using Export/Import/Data pump and SQL Loader
• Backup and Recovery using RMAN
• PL/SQL, UNIX Shell Scripting Oracle ASM (clusters) and RAC Configuration and administration
• Monitoring and Performance tuning using Oracle Enterprise Manager (OEM 12c and 13c) Console and SQL Developer
• Monitoring Tablespaces and Transparent Data Encryption (TDE

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis

Oracle Database Administrator

Responsibilities:

• Administered and supported development of Oracle 11g databases by installing, upgrading and configuring the Oracle server, creating databases, objects, database backup and recovery, monitoring and optimizing database performance.
• Installed, configured, patched Oracle database 18c and 19c software. Created databases and migrated data on 18c and 19c.
• Cloned production databases as needed for testing, development using RMAN and Grid Control.
• Installed, configured, and monitored Oracle golden gate in my environment.
• Used statistics generated by AWR, ASH, ADDM reports to monitor and tune the database.
• Implemented backup procedures using RMAN and Data pump utility for Oracle databases and test regularly in conjunction with Operations.
• Maintained 24*7 Availability by implementing standard processes and troubleshooting live issues within defined tight SLA times.
• Assisted in SQL tuning and providing consultation such as creating Materialized views, table partitions, adding indexes, dropping unnecessary indexes, using hints wherever possible, amongst others.
• Utilization of Oracle Exadata Database machine for high performance of Oracle Databases increasing number of databases managed and reducing downtime.
• Managed database security by creating and assigning appropriate roles and privileges to users depending on the user activity, auditing and other security related task including transparent data encryption.
• Troubleshoot Database Performance issues using OEM, AWR, ADDM and ASH.
• Oracle High Availability involving Oracle RAC
• Applied Oracle quarterly patches of the current PSU version to non-RAC and RAC configured databases.
• Performed data and metadata transfer from legacy servers to newly installed servers using Data Pump.
• Implemented Oracle Database advanced security practices such as TDE and Data Masking
• Expert in upgrading databases by applying Patches, Critical Patch Updates (CPU), Patch Set Updates (PSU) and one-off patches.
• Experience in implementing and planning backup and recovery strategies using Recovery Manager (RMAN). Performed block recovery, datafiles and databases using RMAN.
• Proficient in writing UNIX Shell scripts to automate business process and daily backup.
• Data compression, Block level, table level, RMAN level compression.
• Using Data Pump to copy data across different platform.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts
• Utilization of Oracle Exadata Database machine for high performance of Oracle Databases increasing number of databases managed and reducing downtime.
• Monitoring Server Activity, space usage, database health, backup verification, cleaning history and solving problem as needed
• Security Management: SQL Servers and Databases, users, Data Encryption, and data masking
• Managed Database Security, Users and Group Security, TDE (Transparent Data Encryption), Row Level Security, Dynamic Data Encryption.

Confidential, OHIO

Oracle DBA

Responsibilities:

• Identified root cause of Oracle errors and provided solutions to resolve errors. Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Installed and configured the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication
• Monitored bugs from alert log, audit logs and trace files.
• Used DDL statements to CREATE and ALTER within a dynamic SQL script to create schemas, Synonyms and Roles. Extensive use of SELECT statements for reporting.
• Troubleshoot application related problems with developers and system administrators
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes.
• Performed data transfer using Export/Import and Data pump.
• Provided capacity planning, tuning and administration support to application development efforts. Goals achieved ranged from I/O minimization, improved hit ratios, contention reduction, high database availability etc.
• Designed, tested, implemented and documented database migration procedures involving the use of the export/import and migration utilities.
• Used Tablespace Manager, Oracle Expert and STATSPACK to monitor performance bottlenecks, database response time, instance workload and operating system resource usage.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).
• Performing Backup/Recovery of all the Oracle databases using Recovery Manager (RMAN), also setup Recovery Manager Catalog for the same and hot and cold backups.
• Used Oracle Enterprise Manager (OEM12c and 13c) for monitoring and troubleshooting database performance.
• Installed, migrated, and tested Oracle 11gdatabases in various environments.
• Setting up of Oracle and Application user accounts and passwords, monitoring application security.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Setting up Oracle Standby Data Guard.
• Created and configured multiple Oracle databases as required in silent mode using response files and interactive mode using Xming and Cygwin to invoke GUI interfaces.
• Applied Oracle quarterly patches to non-RAC and RAC configured databases.
• Performed data and metadata transfer from legacy servers to newly installed servers using Data Pump.
• 24x7 remote support and on call Database support using RSA-VPN.