Sr. Oracle Database Administrator Resume
Atlanta, GA
SUMMARY
- Oracle database administrator with 8+ years of experience in maintaining Oracle databases and Experience in the design, maintenance, and administration of high volume databases with sizes varying from 100GB to 200+ TBs of data on multiple versions of ORACLE 19c/18c/12c/11g/10g/9i.
- Good Experience on installation, configuration, performance tuning, production support, space management, backup and recovery, cloning, Migration, implementing TDE, writing stored procedures, space management, database security.
- Proactively patched and upgraded databases to latest release . I have an experience in deploying database systems, assessing client needs, and coordinating development teams, and performing troubleshooting, worked as a Member of DBA 24x7 support team , monitored alerts and supported RAC, Standalone Data guard, Goldengate databases on Exadata machines, RHEL, OEL, SOLARIS and AIX, Windows environments.
- Performed database change requests, worked closely with Oracle support to debug issues and resolved the issues .
- Extensive knowledge on database administration for Oracle 19c/18C/12c/11g/10g/9i with experience on very large - scale database environment and mission critical OLTP and OLAP systems
- Having good experience in 11g, 12c and 18c,19c database administration in Real Application Cluster on ASM and configuring high availability systems like Real Application Cluster 10g/11g/12c/18c/19c on RHEL, OEL, AIX.
- Mitigate planned and unplanned downtime using oracle GDS Global data services.
- Extensive experience with Oracle database administration of Oracle 10g, 11g & 12c,18c &19c RAC with multiple nodes covered all aspects of administration like installations, configurations, migration, Patches, Critical Patch Updates (CPU), Upgrades, replication, sizing and space management.
- Experience in Installation, Configuration and Monitoring of Oracle ASM on UNIX, Linux, AIX and Windows Environments.
- Experience in applying Oracle rolling patches, rolling upgrade on RAC 11g/12c/18c/19c environments using response file, Applied PSU quarterly on 11g/12c GRID & RDBMS homes using opatchauto and Up-gradation of 11g/12c/18c databases and Implementing catalog backup from RMAN.
- Identified and fixed the logical block corruption using RMAN& PERFORMED logical backup using DatapumpExpdp and Impdp Utility.
- Administrated database of various sizes up to 200+TB, supported enterprise databases using Oracle Grid Control 10g, 11g, 12c,18c.
- Mass deployment of agents from OEM 12c and13c, patching OEM, performing administrative tasks using OEM, generating reports, scheduling RMAN jobs, SQL tuning advisor Developed database monitoring and health check alert scripts for database uptime and downtime status, and sizing issues using grid control (OEM)
- Good experience in Installing, Configuring and replicating databases using Oracle Goldengate, configured transactional level DDL, DML, BI-DIRECTIONAL replication using Goldengate v10, v11 and 12 on RAC ACFS
- Good experience in upgrading Goldengate from v11g to 12c to 18c and applying patches to v11 and 12 &18 Used different utilities in Goldengate Log dump utility, Defgen utility
- Installed, configured and maintained databases on Exadata X5-2 /X5-8, X6-2/X6-8,X7-2/X7-8.
- Configured Database File System (DBFS) on Exadata X5-2 /X5-8, X6-2/X6-8,X7-2/X7-8 and Setup physical standby’s (Dataguard) for several Databases
- Migration of databases to EXADATA's (cross platform), Patching, RE-IP & EXADATA maintenance activities
- Worked on EXADATAX7-2/X7-8, X6-2/X6-8, Quarter RACK Half RACK. X7-2 half RACK & X7-8 Full RACK
- Implemented OLTP Compression, Partitioning, Hybrid Columnar Compression for databases on Exadata, and the basic, low, high compression methodologies
- Good experience in Planning and Implementing Disaster Recovery databases using Dataguard and configuring, managing, troubleshooting and monitoring Physical standby using Dataguard 10g/11g/12c/18c/19C.
- Installed patches using OPatch utility and upgraded databases on 9i/10g/11gR2 and expertise in applying Oracle PSU and CPU patches
- Good experience in Performing Migration between different datacenters and Converting Single Instance databases to RAC databases.
- Represent DBA and support DB changes in CAB (Change Authorization Board).
- Good experience with Flashback technology and used data pump for moving data between different environments including prod, dev and test
- Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies
- Storage Migrations: Solely responsible for migrating the Prod/Test/Dev Databases from NetApp to HNAS and to block level storage. (Migrating the databases from Non-ASM to ASM)
- Expertise in Querying RDBMS such as Oracle and MYSQL by using SQL for Dataintegrity and used my cluster manager for administrating MYSQLNDB cluster.
- Good Experience in writing SQL Queries, PLSQL Procedures, functions, packages and used SQL hints to improve the SQL performance and implemented SQL profiles and SQL baselines
- Optimization and tuning SQL queries using Trace File, Tkprof, Explain Plan
- Proficient in RAC Performance tuning &Experience in UNIX Bash Shell Scripting.
- Training the new team members on Security Baselines and Installation Qualifications
- Monitor and educate team with new processes and standards
- Expertise in Oracle Transparent Data Encryption (TDE) such as Defining Keystore, Creating Wallet, Generating Master Key, Enabling Autologin, Rotating Master Key Encryptions
- Expertise in installation, configuration of Oracle in Aws Ec2-Console. Migrated development and production databases from data center to AWS RDS on oracle platforms. Troubleshooting performance related issues in AWS Oracle data warehouse environment.
- Good experience with AWS DMS, database tuning, caching application architecture of cloud computing & administration of EC2, auto scaling, Oracle 12c Cloud Control, BMC Tools
- Experienced in functional and technical aspects of Oracle E-Business Suite/ Applications 10g and 11i deployment Requirements, Coding and Development. Also, supported EBS Financial, WebLogic Middleware Stack and Oracle Fusion Middleware.
- Writing script for creation of database objects stored procedures, user defined functions, indexes, Triggers, views, sub queries, stored procedures in TSQL,PL/SQL/DB2/
- Involved in migration process of SQL server databases to oracle databases
- Extensive experience in providing 24x7 on call support for Test, development and production databases and used oracle metalink Support to resolve bottleneck on databases and downloading patches
TECHNICAL SKILLS
Operating Systems: HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5,6,7 Red Hat Linux 4.x,5.x,6.x,7.x and windows 2003/2005/2008/2012/2014.
RDBMS: Oracle 19c/18c/12c/11g/10g/, Oracle 18c/12c/11g Real Application Cluster (RAC), ASM.
Tools: and Utilities: RMAN, OEM 13c/12c/11g TOAD, SQL*Loader, Export/Import, Data pump, Web logic Server, Log dump, Defgen, srvctl, crsctl, Ocrconfig, impdp, expdp, Netca, dbca,dbua,Query builder, ggsci, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Dataguard, Cloning, Migrations.
Languages: C, SQL, PL/SQL, Shell Scripting, Perl
Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.
Ticketing Tools: Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console,service now
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
SR. Oracle Database Administrator
Responsibilities:
- Upgraded databases from 12c to 18c and 19c.
- Installed, configured, and supported Oracle 11g, 12c,18c &19c databases.
- Worked on workload Balancing and Global service failover using GDS .
- Installed and configured Oracle 19c/18c/12c/11g databases on Exadata X7-2/X7-8 machines and Migrated databases using expdp/impdp,dataguard & golden gate with minimal downtime and Supported Applications.
- Supported Exadata lifecycle management tasks like patching the storage cells,IB switches,database servers,Grid Infrastructure.
- Performed health checks of RAC cluster ware components ocr, voting files and backups using OCR config and Troubleshooting Issues using Cluster ware logs in 18c, 12C and 11g RAC.
- Upgraded OEM from 13.1 to 13.2 .
- Used RAC Tool orachk to scan different stack of layers and finding potential risk and reconfiguring RAC cluster and Creating and managing services using RAC Tools Srvctl and cluster ware resources using crsctl.
- Adding a New Node to 4th Node RAC cluster and Installed Oracle RDBMS software on new node of cluster and Created ASM Volume using ASMCA and Created ACFS for Goldengate 12,18.
- Converted single Instance Databases to RAC databases manually and expertise in troubleshooting RAC issues, very strong in using ocr config to backup OCR and voting files.
- Upgraded databases from 11.2.0.4 to 12.1.0.2 and 12.2.0.1.
- Upgraded multiple databases from 11.2.0.4 to 12.1.0.2 and migrated Non-CDB to PDB databases.
- Migrated Standalone databases to RAC 12c clusters and Supported Applications.
- Upgraded RAC Cluster from 11.2.0.3 to 11.2.0.4 and Applied Patches.
- Installed STANDALONE servers on ASM, Red hat LINUX, Installation, and maintenance of Oracle 11g, 12c Dataguard.
- Installation, configuration and maintenance of Oracle 11g/12C/18c/19c databases on Exadata machines.
- Configured Physical Standby for Production databases and converted Physical standby to snapshot Standby and ACTIVE data-guard.
- Configured Active Dataguard 11g & 12c and worked on snapshot standby databases.
- Implemented Dataguard Broker and performed various operations like Switchover, Stop and Start MRP.
- Conducted analysis and feasibility studies for development of Oracle Exadata solutions
- Migrated databases to Exadata x7-2 by configuring physical standby and switchover
- Worked on EXADATA X7-2 and x7-8 machines and migrated application databases using Expdp, Goldengate and Dataguard.
- Experience in Migrating Database to Exadata using Transportable Table space.
- Experience in Tuning database/Application for Exadata features.
- Installation, Up gradation, Configuration and Troubleshooting Goldengate version 11,12,18 software
- Installed Goldengate for replication of database on 12c/18c RAC environment and Configured parameters for the Bi-directional replication
- As part of the GDBA Support team, we provided L2/L3 level support to the application teams during high-risk issues (escalations) and within normal activities like code migration, Database recovery via RMAN, troubleshoot performance issues, export and import of tables/schemas among environments
- Designed, implemented and tuned interfaces and batch jobs using PL/SQL
- Provided L2 and L3 production support depending upon the ticket assigned to meet the corresponding SLA's
- Configured Extract and Replicate pumps for goldengate replication for 11g/12c/18c databases and Troubleshooting issues in Goldengate Environment using report files & log dump
- Performed Zero-Down Time migration from AIX to RHEL using Expdp and Goldengate and process improvement for Goldengate by proactive monitoring using Shell scripts.
- Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic
- Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
- Replication of tables across cross platform using Goldengate and Creating Materialized Views
- Applying PSU Patches and interim patches whenever required to make the database software up to date.
- Perform Daily Monitoring of Oracle Instances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
- Database backup configurations, 10g,11g and 12c and 18c (CDB and PDB) DBA support
- Data masking sensitive data in production databases using OEM 12c/13c and Scheduled Oracle Jobs using DBMS SCHEDULER
- Migtarted the ETL data from Oracle to Postgresql Databases.
- Scheduled backups and performed refreshes of Postgresql Databases using pg dump & Pg basebackup.
- Configured repository database for setting up OEM , used OEM 12C/13C for monitoring databases, created administration group, template design, Black out, Database Administration, AWR, ASH, ADDM, SQL Tuning Advisor, monitoring performance of databases etc. using OEM 12c/13c.
- Extensively used Flashback for Supporting DML, DDL changes, and handled daily production problems/change requests (DBCRS) with Oracle Patching.
- Implemented 11g, 12c,18c Oracle Advanced Security using TDE (Transparent Data Encryption) and Enabling Auto Login for the Key store for cdb$root and Pluggable databases.
- Extensively used USH, Ticketing Systems and Service now and 24x7 production Support Database Maintenance and on-call Support.
Environment: Oracle 19c/18C/12c/11g/10g, Oracle EXADATA X7-2/X7-8 HALF RACK, Oracle 11GR2/12C/18c RAC, Goldengate, Linux, AIX, Red Hat Linux, RMAN, SQL server, Dataguard, OEM, Grid Control, STATSPACK, AWR,AWS.
Confidential, Duluth Atlanta, GA
SR. Oracle Database Administrator
Responsibilities:
- Worked on maintenance of Oracle 10g/11g/12c/18c RAC databases on Linux and Configured 2,3,4,5 NODE RAC on Grid Infrastructure
- Administered and monitored over 15 0 databases both on 10g/11g/12C /18C/19C on prod/test/dev environments.
- Administering Oracle Databases 10g/11g/12c/18C of sizes ranging from 100GB to 5TB
- Experience in Creating Physical and logical database design Data Models using Erwin Tool
- Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c/13C for monitoring databases.
- Programming in shell to create shell scripts that automate the database backups and maintenance
- Applied patches and CPU regularly to keep the databases in current version
- Work with oracle support to report and resolve issues in production databases.
- Capacity planning and creating databases for development, staging and production
- Database and Data Migration using Export/Import, Migration Utility
- Performed full and incremental Backup Using RMAN Utility for Production databases
- Database refresh and schema refresh using Datapump activities on Application user’s request.
- Worked with application teams and implemented conflict handlers in Oracle Goldengate
- Implemented High availability using Goldengate replication, Implemented bi-directional replication using Goldengate.
- Created password Wallet for confidentiality and security purpose so as to avoid the password in the Golden Gate parameter file of the process
- Installed and configured GoldenGatev11 and 12 & 18 on AIX6.1 and RHEL 5.8,6.7 platform and Performed Cross platform migration and used Oracle Goldengate to migrate databases from AIX to Linux as a part of u12Cloudmigration project.
- Migrated SQL servers from 2008R2 and 2012 to 2014 on standalone and cluster environment
- Performance tuning of oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor
- Expertise in Querying RDBMS such as Oracle and MYSQL by using SQL for Data integrity and used my cluster manager for administrating MYSQLNDB cluster.
- Supported EBS R12 platform migration from AIX to Oracle Linux
- Technically skilled in areas of Oracle Database and Applications Upgrade and maintenance, Upgrade Assessment, Technical Architecture solutions for ERP, DR, HA and Oracle Applications System
- Installed Goldengate using Zero Time Migration, Integrated and Classic Capture/Extract
- Migrated SYBASEASE15 to oracle 10g using goldengate
- Configured Goldengate v 12 against RAC and non-RAC databases using Cluster ware Database file system
- Regular database management on 10g and 11g OEM
- Performed Mass deployment of OEM agents on different hosts and registered the databases on those hosts to the OEM for monitoring.
- Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
- Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance
- Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
- Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c
- Taking the RMAN incremental and cumulative and scheduling the databases backup using Crontab.
- Implemented Dataguard with maximum availability and performance configurations for production databases
- Worked on Active dataguard, Fail over and Switch over cases
- Managing disk groups in ASM, partitioning Luns using fdisk as required, created disk groups with different redundancy levels and Installed databases on it
- Migration of databases from 10g to 11g and 11g to 12c & 18c using export/import and data pump export/import utilities
- Performed rolling patch upgrades on RAC environment for bug fixing.
- Weekly Data Refresh from Production to Development and Test environments using data pump export/import
- Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
- Table space monitoring, Performance monitoring and tuning for performance improvement
- Creating batch files and automating the tasks.
- Granting roles and privileges to end users
- Daily health checkup of the database using TKPROF, AWR, ADDM.
- Coordinated with Oracle support for SR/Tar to resolve Oracle bugs and ORA-600 errors.
- Ability to work effectively and can liaise as a part of team monitoring proactively.
- Involved in 24x7-production database maintenance and on-call support.
- Have a good experience in administering Oracle Aws RDS components. Installed Oracle 12C on Linux platform in a data warehouse in AWS environment
- Configured AWS EC2 redshift Instances using AMIs and launched instances. Created highly available and scalable infrastructure in AWS cloud by using various AWS services like EC2, VPC, and RDS.
Environment: Oracle 10g, 11g,12c,18c,EBS RHEL 5/6, SOLARIS, OEM, RMAN, Grid, RAC, ASM, Dataguard, Goldengate, TOAD, TDE, SQL*LOADER, Performance Tuning, AWR, ADDM, ASH, Data pumps.
Confidential, Atlanta, GA
SR. Oracle Database Administrator
Responsibilities:
- Migration of databases from 10g to 11g using export/import and data pump export/import utilities
- Installed and Configured 2node RAC on Linux.
- Oracle Grid Control 12c Installation and Configuration, Configuration of Physical Standby database for maximum performance mode - Oracle Dataguard
- Installation, Configuration and Maintenance of Oracle RDBMS and Client software in various environments
- Worked with new interfaces and procedures for transmission of critical expense, payroll data and banking activities from client to payroll vendors, banks and other outside entities
- Using list partitions for large tables and bitmap indexes for the OLAP databases
- Performed rolling patch upgrades on RAC environment for bug fixing
- Setup of Jobs using the Oracle Enterprise Manager (OEM) database control
- Weekly Data Refresh from Production to Development and Test environments using data pump export/import and Refreshing the Database from one version to another version
- Daily incremental backup and weekly full backup of databases using RMAN
- Involved in migration of applications of the clients
- Installation and configuration of Goldengate and Replication of data using Oracle Goldengate, performed with cross platform upgrade using bi-directional (active-active) data replication using Goldengate.
- Worked on some stages in Exadata performing Smart scan, Storage Index, DBFS mount points and Flash cache
- Focusing on Exadata administration, worked with platinum support, and worked on different features such as Hybrid column compression, smart scan and storage index
- Loading data into database tables using SQL *Loader
- Implemented Materialized views, database links
- Regular database management on 10g and 11g OEM
- Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
- Table space monitoring, Performance monitoring and tuning for performance improvement
- Creating batch files and automating the tasks
- Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures and Triggers
- Involved in writing complex SQL statements
- Developed backup and recovery strategies, batch processing, performance monitoring, log maintenance and automating functions wherever possible
- Maintained database security by managing user’s roles, privileges. Implemented new security rules via roles as per the company policies.
- Tuned the performance of the SQL’s using Tkprof and Stats pack reports
- Monitoring alert log/system log and managing Database Locks and blocking sessions
- Defragmentation of tables and indexes for improved performance and efficiency.
Environment: Oracle 10g, 11g,12c, SQL, PL/SQL, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux
Confidential, Jefferson City, MO
Oracle Database Administrator
Responsibilities:
- Provided 24x7 support and On-Call rotation when needed for very large databases
- Performed migration of database from 10g to 11g in development, testing, and in production environment
- Configured two node RAC in System Test and Production.
- Created ASM, Done migration from non ASM to ASM environment
- Managed daily online backups (Level-0 and Level-1) and Archive Backups using RMAN
- Involved in migration of databases from 10g to 11g using export/import and data pump export/import utilities
- Performed database refresh activities for business requirement and tuning purposes.
- Had a good experience in migrating data using Exp, Imp, Expdp, and Impdp
- Implemented Dataguard physical standby database in 11g for disaster recovery
- Suggested storage requirements for all the environments, Performed RMAN Incremental and Cumulative backups and developed backup strategies
- Performed logical backups using both classic and Data Pump methods
- Had a very good experience with the Spatial Data like building spatial indexes, creating metadata and Performed Patching on Oracle databases using Opatch utility
- Pitched in help in other areas of the EBS such as fixing issues with the customer extensions in Oracle Project
- Worked on creation of users, granting privileges to users and table space management
- Performed daily monitoring of Oracle databases from Oracle Enterprise Manager and alert log files
- Involved in fine tuning stored procedures by making use of PL/SQL Collections and its BULK FETCH and BULK INSERT features
- Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF
- Involved in optimizing SQL statements using Indexes and Hints
- Made use of the REF CURSORS in stored procedures for report generation
- Performed security management and accessibility control by managing OS and Password file authentication, creating profiles, privileges and roles
- Installed Oracle Client in order to access to the oracle databases
- Performed performance tuning of database by using AWR, SQLT, and EXPLAINPLAN
- Maintained database security using security compliance auditing and profile management, password complexity in order to control access to database
Environment: Oracle 10g, 11g, RAC, Goldengate, Dataguard, TOAD, EBS,ASM, Resource Manager, Oracle Cloud Control
Confidential
Oracle Database Administrator
Responsibilities:
- Performed daily maintenance tasks like space management, rectified locking problems, managed quotas
- Installation, configuration and maintenance of Oracle 10g/11g databases
- Installed Goldengate for replication between cross platforms
- Configured parameter files for extracting and replicating in Goldengate .
- Applied patches on standalone servers using OPatch utility.
- Performed Migration of databases from 10g UNIX to 11g on Linux.
- Implemented data transfer using Data Pump Export/Import utilities.
- Registered databases in catalog server and Performed Cloning of databases using RMAN from production to test and dev environment
- Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN
- Configured listener for external procedure calls, Worked closely with ETL applications team .
- Estimated growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
- Performed daily maintenance tasks like space management, rectified locking problems, managed quotas.
- Configured network components like TNSNAMES, Connection Manager, for easy and effective management of Oracle networking
- Extensively used AWR, ADDM and EXPLAIN PLAN for generating reports
- Involved in administration of all databases in the areas of maintenance, tuning, performance, and troubleshooting and debugging SQL/PLSQL involved in Application development
- Efficient in using the Oracle Tools like, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN
- Involved in writing shell scripts for monitoring health checks and for taking RMAN backups and Developed Scripts for transferring data from production server to testing/development servers
Environment: Oracle 10g, 11g, AIX 6.1, HP-Unix 7i, DBUA, RMAN, People-soft, Goldengate, Grid, RAC, ASM, Dataguard, SQL*LOADER, AWR, ADDM, ASH, TTS, TDE, Data pump