We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Atlanta, GA

SUMMARY

  • Over 6 years of extensive experience as an Oracle/PostgreSQL database administrator, I have supported complete life cycle from development, test, QAT, and production. I have worked on oracle 18c, 12c, 11g and 10g versions and PostgreSQL 9.x - 11.x running on AIX, Solaris, LINUX, and Windows. some daily duties involve configuration and monitoring of dataguard, Goldengate, RAC, upgrades, patches, migration, backup and recovery, performance tuning, security, and refreshes. I am a good team player, good communicator, and a fast learner. I am a multitasker and I can work well in a fast environment.
  • Full responsibility and expertise in database administration, with duties including performance tuning, database backup, database recovery, database security, database optimization, data migration of Oracle instances and SQL-server databases.
  • Good communication and cooperation skills with an aptitude to learn quickly, take responsibility, work under pressure.
  • Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Streams.
  • Configured Oracle Data guard for Oracle Disaster Recovery and Performed switchover from primary database to standby database for testing purpose for the application teams when required.
  • Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for issues and validating disk space.
  • Using list partitions for large tables and bitmap indexes for the OLAP databases.
  • Managing the servers, Web Servers, Load Balancing, and Keepalived, distcache, Apache Configurations, PHP configurations and deployment of accounts.
  • With RMAN Utility I Scheduled Cumulative Incremental backups using RMAN and Cloned databases
  • Installation and configuration of GoldenGate for Replication of important tables.
  • Resolved/Diagnose Node Eviction issues.
  • Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 8 TB.
  • Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
  • Experience in Identifying performance bottlenecks on high volume transaction systems. Analyze SQL statements and design indexes to improve response of queries.
  • Automated monitoring of Golden Gate process and heart beat monitoring.
  • Experience in Installation of Oracle Databases 10g, 11g, 12c and 18c.
  • Experience in the Upgrade of Oracle Databases in patch set Level and in version Level from 10g to 11g, 11g to 12c and 12c to 18c
  • Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
  • Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN(full and incremental)
  • Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, datapump export/import.
  • Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.
  • Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB
  • Worked actively in configuring and maintaining Oracle Physical Standby/Active Data Guard Database oracle 11g/12c/18c on linux, AIX and Window servers.
  • Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM 12c/13c)
  • Performing Fault Injection Test Cases for verifying the High Availability at each layer of RAC stack like port failover, instance failover, ASM failover and Node failover.
  • Installation and Configuration of Oracle 12c Multitenant container and pluggable databases with Flex Cluster and Flex ASM.
  • Configuring Postgresql Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
  • Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
  • Responsible for backup, recovery, and upgrading of PostgreSQL databases.
  • Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
  • Extensive experience with Cloning and Refreshing pre-prod/dev databases with prod databases.
  • Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Cloud Control.
  • Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
  • Implementation of Flashback Technology
  • Proactively monitoring the database's health and taking preventive or corrective actions
  • Proficient in Database Design (Physical and Logical Database Design) and Normalization.
  • Proficient in using various database Utilities like EXPORT/IMPORT and DataPump.
  • Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.
  • Automated many common tasks using crontab including Backups, exports and imports.

TECHNICAL SKILLS

Operating Systems: HP-UX, Sun Solaris OS (5.1, 5.2, 5.3, 5.9, 5,10, 6.1), Red hat Enterprise Linux, Oracle Enterprise Linux, and Windows 2008 and 2012 R2, Exadata X5-8

RDBMS: Oracle 10G (10.2.0.5), Oracle 11G (11.2.0.2, 11.2.0.3, and 11.2.0.4), Oracle 12C (12.1.0.2 and 12.2.0.1), and Oracle 18c, PostgreSQL 9.x - 11.x

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, WinSCP, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities/ Tools: OEM 12c & OEM 13c Cloud Control, Toad, Putty, SQL developer, Exp/Imp, Data Pump, DBCA. DBUA, OUI, RMAN, Goldengate Monitor, DGMGRL, GGSCI

PROFESSIONAL EXPERIENCE

Confidential - Atlanta, GA

Oracle Database Administrator

Responsibilities:

  • Supporting multiple databases for production, development, test and staging purposes on Sun Solaris, AIX, Linux and Windows environments.
  • Created and monitored Physical standby databases on maximum protection and performance mode using Data guard for Disaster Recovery and High Availability.
  • Upgrading Grid Infrastructure and databases from 11.2.0.3 to 11.2.0.4 and from 11.2.0.4 to 12c.
  • Configured and implemented Oracle 11g ACTIVE DATAGAURD for Database Disaster Recovery by using DATA GAURD broker (DGMDRL)
  • Installed and configured 3 node server side load balancing Oracle RAC 11g, 12c databases on Linux with ASM and Data Guard.
  • Configuring Postgresql Streaming Replication and Pgpool for load balancing. Managing the monitoring tools for better performance like PgBadger, Kibana, Graphana, and Nagios.
  • Experience in upgrading and migrating various versions of PostgreSQL database on different platforms.
  • Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
  • Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
  • Production support database on 10g, 11g,12c, and 18c oracle DB with standalone and RAC environment.
  • Set up user profiles and roles as per the access level of user for the data and application security.
  • Re-wrote the shell scripts to monitor Golden Gate processes various states (like STOPPED/ABENDED/LAG/HUNG) to reduce number of alerts by grouping them together by environment
  • Installation and configuration of Oracle Golden gate.
  • Responsible for implementation and administration of disaster recovery strategies for 24/7 operations and deployment of high availability systems on Oracle 11g, 12c using Oracle RAC, Data-Guard, Streams, ASM, RMAN.
  • Cross-datacenter disaster recovery and backup architecture. Performing schema management, database sizing, maintaining privileges. Data migration while upgrading database versions.
  • Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
  • Performance monitoring and optimization. Installing and configuring Object level replication like Slony etc.
  • Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.
  • Tables created with Daily Range partition, indexes and script automated which add/remove partition as per client requirement.
  • Monitoring and optimizing the performance of the database/application using OEM 12c/13c along with scheduled scripts.
  • Capacity planning: Allocate system storage and plan future storage requirements.
  • Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
  • Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
  • Upgrade DBs from 11.2.0.4 to 12.1. Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.
  • 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 datacenters.
  • RMAN point in time recovery and Instance recovery done on 11g.
  • Developed compliance reports and performed auditing at higher levels.
  • Provided valuable inputs for various performance tuning issues.
  • 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, SQL*Trace, AWR, ADDM, ASH, SQL tuning advisor etc. Done resetting of storage parameters by series of exports and imports of tables, used conventional as well as direct path loads to upload the data into the server using SQL loader.
  • Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
  • Upgrade and Migration of Database from 11.2.0.2 to 12.2.0.2 and applying patches whenever required.
  • Efficiently performed installation, setup and creation of 3 node node cluster RAC with Oracle11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
  • Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
  • Successful in installation/maintenance of Physical Standby database using OracleData Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases
  • Performing monthly and annual performance reports for trend analysis and capacity planning.
  • Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
  • Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
  • Knowledge in Oracle Data warehouse DBA skills relating to administration and management of OLAP environments.
  • Experience in writing UNIX/SHELL scripts for providing the reports.
  • Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Confidential - San Antonio, TX

Oracle Database Administrator

Responsibilities:

  • Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2.
  • Worked on disaster recovery of exadata dataguard physical standby Failover/switchover/loss of service /rebuild/corruption/loss of datafile testing.
  • Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and resync RMAN catalog.
  • Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
  • Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
  • Performed troubleshooting of database using AWR and ADDM reports.
  • Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import) EXPDP and OS methods.
  • Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
  • Responsible for network configuration and involved in a Client-Server environment using TNSnames, LISTENER, Net Configuration Assistant and other configuration files.
  • Creating and restoring databases using Oracle Flashback Technology with Guaranteed restore point.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using opatch.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility, Datapump, and conventional Export/Import of Oracle 18c, 12c,11g, and 10g.
  • Installed Oracle and grid software on standalone servers on ASM and file system.
  • Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
  • Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
  • Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
  • Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
  • Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.
  • Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

Hire Now