Oracle Database Administrator (Oracle Support)
Resume:
PATIENCE WANKA
ORACLE DBA
*************@*****.***
CORE COMPETENCIES
Provided day to day Database operations support
Provided support on-call rotation.
Managed 10g, 11g, 12c, 19c, 21c and 26ai Databases
Build ASM disk groups and managed ASM databases.
Build 11g Data Guard for Disaster Recovery site.
Upgraded databases from 10G to 12c.
Migrated from non-ASM to ASM databases.
Proficient with Oracle Performance Tuning using ASH, AWR, ADDM, TKprof, Explain plan and dynamic views
Setup monitoring of databases from OEM.
Worked on various exports and imports from exp/imp and Datapump.
Proficient in writing shell scripts to automate jobs
Performed Security administration tasks, set up user accounts, passwords, roles, profiles and quotas
Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Planned and Performed Daily, Weekly and Monthly Backups. Tested and implemented restore procedures for complete and incomplete recovery using RMAN.
Perform capacity planning required to create and maintain database environments
Clone Database using RMAN duplicate / Export Import / Data Pump
Create thorough documentation of installation procedures and administrative tasks in the clustered environment.
Some working knowledge in Exadata
Good working knowledge in Oracle GoldenGate Replication.
PROFESSIONAL EXPERIENCE
Oracle Corporation APRIL 2019-PRESENT
Designated Support Engineer, Lehi, UT
Responsibilities:
Advise the customer about new software upgrades if necessary
Assist in remote software upgrades and maintenance events when required.
Advise and help implement best practices with respect to configuration and operation.
Review the performance and suggest fine-tuning where/when appropriate.
Troubleshoot any problems
Keep Account page updated with account specific expectations, special handling instructions
Responsibilities:
Oracle Database Foundation:
Acting as the first layer for Oracle Database issues which is part of Oracle Global Support
Assisting customers for Oracle Database issues in Database Administration within SLA time frame
Problem analysis, data collection, investigation and providing action plans toward the resolutions with outstanding services.
Proactive support to help the customer resolve the reported issue.
Provide training and knowledge transfer for new products and new enhancements
Participating in internal projects for Global delivery
Handling the customer for any high escalation issues
Helping peers with any complex issues
Initiative, proactive and fast learner
ADVANTASURE
Oracle Database Admin, FEB 2017 – MARCH 2019
Displayed a high level of expertise while handling the various scenarios of database Backup & recovery and cloning using the RMAN tool in RAC and Data Guard environments of large to very large databases also set up RMAN catalog for the same.
Hands on experience in installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
Tuning of Oracle Databases for performance improvement using AWR, ADDM, ASH, Trace Analyzer, SQLTXPLAIN, OSWatcher and other OS related utilities like pstack, pmap, top, vmstat, iostat, prstat, strace, and Oracle Enterprise Manager (OEM) 11g to monitor databases.
Converting Standby database to Snapshot standby database for pre-go live activities
Performed Oracle Software Installations, Creation of new standalone and clustered databases.
Led a team of 5 DBA’s during the configuration of a Data Guard
Administering and setting up 11G RAC and 10G RAC clusterware and instances.
Resolved RAC issues, OCR related issues, rebooting faulty nodes, relocating the switched over services.
Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
Worked on Network data encryption to improve security and implemented SSL wallet to secure the connections.
Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
Implemented 11g Interval Partitioning for monthly partitioning of large tables.
Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.
Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.
Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.
Designed and implemented different backup strategies like Cold, Hot, RMAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
Handled Chained Rows and Row migration and solved the database performance issues.
Experienced with ASM, adding, deleting disks to the disk group.
Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations for Application jobs, time/CPU consuming queries
Information Technology- Data transmission, data retrieval, data manipulation, data processing and data storage
Implemented real time replication on a pilot project in Golden Gate
I have done unidirectional and bidirectional replication in Golden Gate
Implemented DML and DDL replication in Golden Gate
Done schema, table, column and whole database replication in Golden Gate
Displayed a high level of expertise while handling the various scenarios of database Backup & recovery and cloning using the RMAN tool in RAC and Data Guard environments of large to very large databases also set up RMAN catalog for the same
Converting Standby database to Snapshot standby database for pre-go live activities
I have and still take responsibilities of Analyzing and troubleshooting databases to enhance its performance. In doing this I have used tools like ASH, AWR, ADDM, TKProf, OEM, Toad and Scripts
INFOSYS LTD
JUNE 2012 – JAN 2017
Oracle Database Administrator
Displayed a high level of expertise while handling the various scenarios of database Backup & recovery and cloning using the RMAN tool in RAC and Data Guard environments of large to very large databases also set up RMAN catalog for the same
Hands on experience in installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
Converting Standby database to Snapshot standby database for pre-go live activities
I have and still take responsibility of Analyzing and troubleshooting databases to enhance its performance, by doing this I have used tools like ASH, AWR, ADDM, TKProf, OEM, Toad and Scripts
Daily I overlook the entire performance of the production services by monitoring and administering the Production system
TECHNICAL SKILLS
Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5 and up. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000
RDBMS: Oracle 10g, 11g, 12C, 19c, 21c, 26ai
Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL
Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM, Toad
Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import
Ticketing: Service now, Remedy
YEARS OF EXPERIENCE
ORACLE DBA – 10+ YEARS
SQL SERVER – 4 YEARS
PERFORMANCE TUNING – 10 YEARS
RMAN – 8 YEARS
RAC – 8 YEARS
GOLDENGATE – 8 YEARS
Contact this candidate