Oracle Database Administrator resume example with 8+ years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105609 Johnson Ave., 49204, Tulsa, OK
Home: (555) 432-1000
Cell:
resumesample@example.com
Professional Summary
7+ years of experience in the field of oracle Database administrator with experience in designing, developing, and managing and Successful Database Administrator with years of experience in database development and production environments. Areas of expertise include maintenance and security. Proactive in establishing backup and recovery processes and protocols to protect and retain valuable company data.
Skills
ADR, RDBMS
IBM AIX, Scheduling
AIX, Sun Solaris
ASM, SQL
ASM fi, SSL
Auditing, Statistics
Backup, Tables
C, TOAD
Conversion, Trouble shooting
CPU, Troubleshooting
Encryption, Type
Database, UNIX
Management, Shell scripts
DBMS, Upgrading
Designing, Utilities
Disaster recovery
DML
Fast
Features
Flash
Linux
Managing
Memory
Windows
Migration
Network
OCR
Optimization
Oracle database
Enterprise Manager
Oracle PL/SQL
PL/SQL
Processes
RAC
Oracle Golden gate
Work History
ORACLE DATABASE ADMINISTRATOR, 09/2018 to Current Cognizant Technology Solutions – Chadds Ford, PA,
RMAN, Had fixed several performance tuning issues which relates to RAC & DataPump, Export, standalone databases by recommending better solutions that could Import save cost, virtualization, and resources.
Implemented fast start failover on databases and configuring disaster recovery site using dataguard.
Also proficient with new11g features such as Active Dataguard and Snapshot standby database.
Implemented & Managed Physical Standby and even Configured Automatic Storage Management (ASM).
Applying Patch set, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and run Installer under UNIX and Windows.
Performance Tuning of Oracle database using OEM , SQL analyzer , Stats pack, AWR, ADDM, ASH, RDA, Explain plan, SQL TRACE and Ordebug.
Data transferring using Export/Import utilities and SQL.
Loader.
Expertise in creating and maintaining databases to Oracle Optimal Flexible Architecture (OFA) standards in very large scale database environment (VLDB) and mission critical OLTP and DSS systems.
Performed database tuning by using various tools such as ADDM (Automatic Database Diagnostic Monitor) from AWR(Automatic Workload Repository), OEM (Oracle Enterprise Manager) and STATSPACK.
Performed SQL Tuning using Explain Plan, TKPROF with SQLtrace and STA(SQL Tuning Advisor).Coordinated with System administrators, application developers and other DBAs.
Performance Tuning i.e.
Tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redomechanisms Installed Oracle 10g,11g RAC software with ASM & ACFS File systems Resolved database network problems using Oracle Net configuration Assistant, Oracle Net Manager, Net stat and ping utility.
Involved in writing stored Procedures, Functions and Triggers in PL/SQL to interface application with database system.
Tested programs and databases to identify issues and make necessary modifications.
Created and implemented database designs and data models.
Oracle Database Administrator, 02/2015 to 09/2018 Cognizant Technology Solutions – Chapel Hill, NC,
Performance tuning, Schema creation, maintenance, and trouble shooting.
Migrated Oracle 11gR2 RAC databases and non-RAC databases to in-house Data center.
Maintain Oracle 11gR2 RAC (ASM Real.
Application Cluster), Non-RAC (ASM) and File System based databases of varying sizes.
Upgrade databases from 11g to 12c.
Developed Oracle PL/SQL Packages to Scrub Data to refreshes internal lower environment databases.
Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.
Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc Able to resolve performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.
Hand on experience in cloning non-multitenant container database to pluggable database in 12c using PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC.
Install and configure Golden Gate, trouble shoot Golden Gate and monitor replicate lag and check point.
Designing & implementing Oracle Golden Gate 11g/12c replication to remote sites (active/passive and active/active) for disaster recovery.
Installed Golden Gate using Zero Time Migration, Integrated and Classic Capture/Extract.
Configured Golden Gate 12c against RAC and non RAC databases using Cluster Ware Database file system.
Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g,11gRAC & 12C environment for Production databases.
Configured and managed Data Guard extensively for Production.
Databases of sizes ranging from 50GB to 5TB.
Experiencing in Installing OEM 12c Cloud Control and upgrading 11g management agents to 12c agents.
Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.
Migration of databases to 12C from Oracle 10g&11g.
Implemented and maintained Oracle 11g Data Guard/standby databases for fail-over purposes.
Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
Also worked on Network data encryption to improve security and also implemented SSL wallet to secure connections.
Database Services creation for distributing applications across multiple nodes, Extensively used all command line.
Utilities SRVCTL, CRSCTL, ADR, ASMCMD, Redefined of tables using DBMS_REDEFINITION, partitioning tables in production, re-defining columns data types, and moving LOBS to different table space Partitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of exchanged partitions, dropping or truncating of old portions.
Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC) Provided valuable inputs for various performance tuning issues.
Proficient in performance tuning using Explain Plan,.
STATSPACK, TKPROF, AWR, ADDM.
Performance Tuning of database (Memory Tuning, I/ O Tuning) Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL.
Trace, TKPROF.
Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory Implemented 11g Interval Partitioning for monthly partitioning of large tables.
Developed RMAN Backup strategies for cloning test databases with production environment and worked on RMAN active-active duplication.
Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.
Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.
Handled Chained Rows and Row migration, and solved database performance issues.
Experienced with ASM, adding, deleting disks to disk group.
Supported development teams for all database related issues and handled critical issues like network failures and ASM DISK group errors and node failures in RAC cluster.
Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analysed reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.
Used Explain Plan, Oracle hints and creation of new indexes to improve performance of SQL statements.
Production Support Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
Supporting multiple databases for production, development, test and staging purposes on Sun Solaris and Windows environments.
Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
Refreshing Dev and Test instances with data from Production on a regular basis.
Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
Thorough knowledge in setting up infrastructure for databases in huge data centers.
Installed Oracle 11g on Linux platform using ASM.
RMAN point in time recovery and Instance recovery done on 11g.
Developed compliance reports and performed auditing at higher levels.
Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
Performed Data refresh activities using the export data pump utility.
Installation of 2 node and 3 node RAC, Migrating of database to RAC database.
Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
Excessively worked on performing database backup and recovery using RMAN.
Key player in troubleshooting backup issues.
Taking the RMAN incremental and cumulative backups.
Good hands on performance tuning related issues with Experience in query analyzing and Performance Tuning for the SQL queries, which are running slow, consuming high resources.
Worked on converting big file to small file table space conversion for very large data (included 2T of data).
Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
Refreshed/cloned databases using RMAN utility.
Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
Installed ASM environment and migrated databases from NON-ASM to ASM.Used TOAD for database management.
Made optimal use of Oracle Support in resolving the SRs.
24 X 7 Production & Development database support and administration.
High School Diploma: , Expected in 12/2008 Russell High School - Peter Kerchhoff St, Pietermaritzburg, 3201, South , GPA:
Associate of Science: COMPUTER SCIENCE, Expected in Durban University of Technology - 41/43 M L Sultan Rd, Greyville, Durban, 4001, Sout, GPA:
Accomplishments
Oracle Databases.
EDUCATIONSKILLS SUMMARY.
PIETERMARITZBURG, KwaZulu-Natal, South Africa.
Administer over 600 databases across Development, QA, UAT and PROD environments via use of
command line and Oracle tools-Oracle Enterprise Manager Cloud 12c.
Installing Oracle Golden gate on RHEL
and setup table level replication as well as DDL replication too.
TECHNICAL PROFICIENCIES:.
Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in
Oracle Streams.
Operating Systems:Manage large complex Oracle RAC clusters with 50+ applications.
HP-UX, Sun Solaris,
Installed Oracle 11g RAC and Upgrading Oracle 10g RAC AIX, Linux Enterprise databases.
Server, Windows 2010Upgraded databases from 11g to 12c.
RDBMS:Set up Active Dataguard Configurations for oracle database
Oracle 10g, 11g, 12c11.2.0.3 for thirty databases whose size varies from 10TB to 30TB on a 6 node
RAC.
Languages:Designed GoldenGate configuration for databases & implemented SQL, PL/SQL,filters with
rules to meet the business usage which will reduce load on the production databases for better performance
with replication Tools:on multiple sites.
TKPROF, EXPLAIN PLAN, STATSPACK, Migrated and upgraded
Oracle 11gR2 Databases from Sun AWR, and ADDM.Toad,Solaris 10 to Red hat Linux 5 using
Goldengate.
Winscp, Remote Worked on SQL Tuning and how to use the available tools outside of Desktop, VNC, and
Oracle Enterprise Manager.
Cisco VPN ClientWorked on Performance Tuning, identifying large objects, analyze those objects and
recommend changes to improve performance.
Database Utilities:Updated MVIEWS and test code to improve performance.
SQL.
Plus, Oracle Enterprise
Manager, Identifying objects no longer accessed and remove those Real Application objects which
results in saving space in the databases.
Cluster, ASM, Worked on moving data from one storage area to another.
Transportable Installed and Administered Oracle 11g & 10g RAC software with Tablespaces, ASM.
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.