Livecareer-Resume

Oracle Database Administrator Resume Example

Love this resume?

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Jessica Claire
  • , , 100 Montgomery St. 10th Floor
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Summary

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs. Proficient in complete, incomplete recovery of the database, Point in Time Recovery (PITR), and Tablespace Point in Time Recovery (TSPITR) using RMAN utility. Extensive knowledge in Database Cloning using RMAN, VERITAS Net Backup, IBM Tivoli Storage Manager (TSM). Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage Implemented Dataguard in the production environment. Excellent experience in various migration techniques like export/import, Data pump, backup restore, cloning, and data guard. Proficient in setting up Standby Database supported by ORACLE DATAGUARD for disaster recovery purpose. Implementing FSFO (Fast start failover) on databases and configuring disaster recovery sites using Dataguard. Also proficient with new 11g features such as Active Dataguard and Snapshot standby database. Experience in PostgreSQL RDBMS with knowledge of installations and Configurations, Backups, Warm/Hot Standby/Streaming Replication/pgHA, bouncer, and ora2pg Configuring PostgreSQL Streaming Replication and PgBadger for load balancing. Expertise in implementing partitioning methodologies Range partitioning, List partitioning, Hash partitioning, Composite partitioning on tables and indexes for high performance. Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control. PostgreSQL Security, roles, group roles, and row-level security and granting privileges. HA solution via Streaming Replication, Setting up logical Replication, configuration of Repmgr, PgBadger, PgBouncer, Pg_Basebackup, PgBackRest, PgAdmin 4, Profile Over 6+ years of in-depth experience as an Oracle and PostgreSQL Database Administrator with experience on 24x7 production and mission critical database support. Hands on experience in configuring, integrating, and maintaining Development, Staging, and production PostgreSQL databases. I possess strong analytical and problem-solving skills, self-motivated, results-driven, team player with excellent verbal and writing communication skills. I have worked on Oracle 11g, 12c and 19c versions as well as PostgreSQL 9.6, 10, 11 and, 12. Other areas of work include performance tuning, backup and recovery, database migration, upgrades, and patches, configuration of Goldengate and Dataguard for Replication, and High Availability, database security and capacity planning. Talented Database Administrator with [Number] years of success using [Type] and [Type] technologies to produce [Result]. Proficient in wide range of development languages, including [Type], [Type] and [Type]. Excellent presentation and communication skills.

Skills
  • Installed and Administered Oracle 10g ASM & 11g, 12c RAC software with ASM & OCFS2 File systems.
  • Strong experience in migrating databases from Non-ASM to ASM and Non-RAC to RAC.
  • Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA).
  • Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
  • Hands on experience on tools and features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
  • Proficient experience as an IT professional along with extensive experience as an Oracle Analyst
  • Proficient in Oracle 12c, 11g R1, 11g R2, 19c
  • Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing.
  • Highly experienced in Oracle 11g, 10gAutomatic Storage Management (ASM) required to fulfill the storage needs.
  • Operating Systems
  • HP-UX, Sun Solaris, AIX, RHEL, Linux Enterprise Server, Windows
  • RDBMS
  • Oracle 11g, 12c, 19c, PostgreSQL 9.x -11.x
  • TOOLS
  • TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, TOAD, PGBADGER, PGBOUNCER, PGADMIN4,
  • DATABASE UTILITIES
  • SQL
  • Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL
  • Loader, RMAN, Datapump, Export, Import.
  • Agile, DML, PL/SQL, Unix
  • AIX, Downstream, Policies, UNIX Shell Scripting
  • Analyst, Features, PostgreSQL, UNIX Scripts
  • ASM, HP-UX, PostgreSQL 9.x, UNIX shell scripts
  • Auditing, Linux, PostgreSQL 8.2, Upgrades
  • Backup, Managing, Quality, Upgrade
  • Balance, Memory, RDBMS, Upgrading
  • C, Access, Red Hat Linux, Utilities
  • Capacity Planning, MOS, Reporting, View
  • Conversion, Windows, Scheduling
  • CPU, Migration, Servers
  • Encryption, MySQL, SHELL SCRIPTS
  • Clients, Enterprise, Scripts
  • Client, Network, Script
  • DATABASE, OCR, SLA
  • Database administration, Operating Systems, Sun Solaris
  • Databases, Optimization, SQL
  • DC, Oracle, Strategy
  • Designing, DB, Tables
  • Disaster recovery planning, Oracle Database, TOAD
  • Disaster recovery, Oracle Enterprise Manager, Troubleshooting
  • Database analysis
  • Agile methodology
  • Data conversion and migration
  • Multitasking
Experience
Oracle Database Administrator, 12/2017 to Current
C2 Essentials, Inc.Chantilly, VA,
Oracle and PostgreSQL Support Database Administrator, 02/2015 to 11/2017
Quintiles TransnationalCity, STATE,
  • Involvement.
  • Used Oracle Enterprise Manager (OEM) 12c R5 cloud Control for monitoring multiple databases and notification of database alerts, and configured EM agents on multiple database servers.
  • Implement policies to maintain databases to make sure that the databases integrity and maximum availability.
  • Performance issue tracking and solution making using Statspack analyze the report and find the root cause of the issue and provide the best solution.
  • Explain plan used to diagnose the long running queries, tuning applied if it required.
  • Virtual database setup to limit the user to access table columns only the admin not the application users.
  • Oracle Advanced Security features like TDE (Transparent Data Encryption), Data Vault and Audit Vault.
  • Successful in installation/maintenance of Physical Standby database using Oracle Dataguard for Oracle 11.2.0.3 and Oracle 10.2.0.5RAC databases.
  • Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
  • Tuned PL/SQL, SQL with Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM).
  • Performed Database health checks and used the notification tool to send the alerts in OEM Grid Control.
  • Supported and managed Oracle Real Application Clusters (RAC) environment on Red Hat Linux.
  • Applied Database software fixes/patches.
  • Built Physical standby databases using Data guard as part of the BCP disaster recovery strategy.
  • Identified database bottlenecks using OEM Grid Control, AWR, ADDM, STATSPACK, UTLBSTAT, UTLESTAT, ESTIMATE, ANALYSE, INDEXES, EXPLAIN PLAN, SQL TRACE and TKPROF.
  • Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.
  • Automated the Data Replication process using Materialized Views for reporting databases.
  • Implemented switchovers on primary and standby databases as a part of planned maintenance activities.
  • Supported and maintained the Production/Development databases on various servers.
  • Extensively worked on setting up auditing in many databases we supported.
  • Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
  • Installed ASM environment and migrated databases from NON-ASM to ASM.
  • Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cGrid Control.
  • Database reorganizations and refresh schema-using Export/Import.
  • Creating the database, table spaces, tables, indexes, setting privileges and user logins.
  • Used hints for SQL tuning and optimization.
  • Performed Explain Plan analysis for Query Optimization and SQL tuning.
Involvement, to
ORACLE / POSTGRESQL DATABASE ADMINISTRATORCity, STATE,
  • Responsible for monitoring environments using monitoring tools like Pg_stats_statement, Nagios and PgBadger for log analysis.
  • Responsible for backup, recovery and upgrading of PostgreSQL database.
  • Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
  • Monitoring databases to optimize database performance and diagnosing any issues.
  • Monitor and manage database indexes for optimal performance.
  • Daily log analysis using PgBadger tool and query tuning Maintaining custom vacuum strategies at table and Database level.
  • Monitoring the bloat report on all the tables and performing maintenance with minimal downtime.
  • Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
  • Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
  • Design and implement disaster recovery for the PostgreSQL Database.
  • Configured third client software PgAdmin 4 to access the database server.
  • Configured the backup jobs on the customer system.
  • Configured PgBouncer for connection pooling and PgBadger for log analysis.
  • Configured and monitored streaming replication between master and slave.
  • Ran maintenance auto vacuum jobs and customized vacuum on certain tables.
  • Implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_basebackup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups.
  • Supported daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on Unix/Linux and AWS Console (Database sizes range 100GB to 25TB).
  • Monitored CPU utilization, memory, Database Connections, and storage space daily using pg_stat_activity, Pg_view, and AWS Cloud Watch alarms.
  • Also, use customs shell scripts deployed on crontab to monitor performance and resources.
  • And Ora2pg.
  • Expertise in Analyzing data Quality checks using shell scripts.
  • Upgrading, installing, and configuring PostgreSQL servers.
  • PostgreSQL Installation, Configuration, Migration, Upgrades and Patches.
  • Server versions ranged from PostgreSQL 8.2 to 9.5.
  • Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
  • Optimize Postgresql.conf for performance improvement.
  • Review all PostgreSQL logs for problems.
  • Partook in database migration from Oracle to PostgreSQL on-premises and AWS, using Migration Tool Kit, Ora2pg, DMS, and SCT.
  • Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and Upgraded from Oracle 11g to 12c.
  • Installing and configuring new servers as per customer's request.
  • Cloning the Development, test and UAT environments with production data as per customer's request.
  • Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
  • 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.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 12c) for migration and logical backups.
  • Applied security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) and OPatch.
  • Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF.
  • Active participant in discussions related to Backup Strategy, DC/DR architecture.
  • Maintained, patched, and upgraded servers as required.
  • Exposure to new 12c Features, Container and Pluggable Database, FAR-SYNC Instance, Cascade Redo Transport Destination, allowed usage of SYNC and NOAFFIRM to extend Data Guard Range, Moving online Data file, etc.
  • Sanitize behavior of SCAN.
  • Perform failover failback testing.
  • Follow up on SRs for different issues (SCAN behavior, Node eviction, Failover etc.).
  • Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers, and UNIX shell scripts.
  • Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
  • Explain PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.
  • Experienced in configuration of ASM for RAC and NON- RAC environments.
  • Configured Repository and clients for GRID Control and implemented DB Control for some databases.
  • Utilized Oracle streams to Capture, Propagate and apply the transfer of data, transactions, and events within managed Databases.
  • Performed patching on Oracle Database Server 10g and 11g using OPatch utility.
  • Implemented Data Guard, Physical Standby database in 11g RAC environment for the Production databases for Active and Passive cluster.
  • Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
  • Used AWR, ADDM and ASH Reports for troubleshooting performance issues and Capacity Planning.
  • Extensively used Explain Plan, TKPROF and SQL Trace.
  • Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification.
  • Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.
  • Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler).
  • Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.
  • Test backups periodically to ensure minimal recoverability time to meet business objectives.
  • Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
  • Data Refresh in Test and Integration Databases using Transportable Tablespaces.
  • Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
  • Root Cause Analysis for database failures, following up with MOS and getting technical solutions for Bugs and applying them.
  • Handle Oracle Internal Errors ORA-600 and ORA-7445.
  • Involved in disaster management and high availability of production environments.
  • Managing password security and user roles.
  • High level evaluation of performance tuning, load balance and TAF failover, RMAN, Dataguard and different database performance tuning with latest Cloud control utility.
  • Integration between Splunk and Oracle RAC databases.
  • Using Oracle Data Pump utility making faster exports/imports on large databases and saving a lot of time.
  • Installed the Oracle software using silent features and created databases.
  • Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.
  • Writing SHELL SCRIPTS for the system and database for effective functionality and report generation.
  • Worked on setting up of Goldengate 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to Downstream systems.
  • Installed Goldengate version 11 and version 12 with latest patches applied on DBFS file system and ACFS filesystem, also working testing new OGG 12.2 new features available.
  • Implemented Goldengate integrated Replicat and coordinated Replicat (available from OGG 12c) to improve the performance of data replication to targets.
  • Supported daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on Unix/Linux and AWS Console (Database sizes range 100GB to 25TB).
  • Monitored CPU utilization, memory, Database Connections, and storage space daily using pg_stat_activity, PEM, Pg_View, and AWS Cloud Watch alarms.
  • Also, use customs shell scripts deployed on crontab to monitor performance and resources.
  • And Ora2pg.
  • Expertise in Analyzing data Quality checks using shell scripts.
  • Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
Education and Training
Bachelor of Science: Business Administration, Expected in 2006
Olabisi Onabanjo University - OGUN,
GPA:
Certifications
ORACLE CERTIFIED ASSOCIATE AWS CERTIFIED SOLUTIONS ARCHITECT ASSOCIATE
Additional Information
  • Regular Proactive Health Checks for all the PostgreSQL and MySQL Databases through my automated shell scripts. Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL and MySQL Databases as requested by the Application Teams based on criticality of the Applications. Monitor Database Performance, CPU Utilization and Memory Resource Utilization Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis Monitoring Space Utilization and Tablespace Usage and Table Fragmentation Extensive knowledge about Migrating data from on-prem to AWS cloud using DMS/SCT Wrote shell scripts and scheduled them in CRON for monitoring and health checks of the database. Managed Backups/Restore of PostgreSQL Databases using pg_dump/pg_restore and pg_basebackup and PgBackrest. Worked with DEVOPS and an agile environment. Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances. Performed backups and crash recoveries using conventional hot/cold backups and RMAN. Managing the monitoring tools for better performance like PEV. Experience in upgrading and migrating various versions of PostgreSQL database on different platforms. Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.
Accomplishments
  • Led team to configure dataguard, earning recognition from upper management and financial reward.

By clicking Build Your Own Now, you agree to our Terms of Use and Privacy Policy

Disclaimer
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:

69Fair

Resume Strength

  • Formatting
  • Measurable Results
  • Personalization
  • Target Job

Resume Overview

School Attended
  • Olabisi Onabanjo University
Job Titles Held:
  • Oracle Database Administrator
  • Oracle and PostgreSQL Support Database Administrator
  • Involvement
Degrees
  • Bachelor of Science