SUMMARY

• 8+ years of experience in IT industry, as Oracle Database Administrator.
• Installation/Configuration and Maintenance of Oracle 12c and 11g Real Application Cluster Database and achieving High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Configured Automatic Storage Management (ASM) to fulfill storage needs and installed Oracle 12c, 11g and 10g RAC software with ASM & OCFS2 File systems respectively.
• Oracle RAC Database Administration including Grid Infrastructure Installation, configuration, SCAN Setup, Backup and Recovery (RMAN) and implemented strategy for partitioning and management of historical data tables in RAC.
• Experience working with Exadata administration. Exadata Half Node configuration utilizing the Smart scan, Flash Cache, Storage Indexes and Exadata Storage server software and features.
• Troubleshooting Exadata smart scan/offloading issues and experience working with Exadata Storage Server software, managing cell disks, grid disks and ASM disks.
• Familiar with cellcli command line interface in Exadata environments.
• Installed, Configured and maintained Oracle Goldengate for unidirectional and bi - directional data replication.
• Troubleshooting and resolving Goldengate extraction, replication and synchronization errors.
• Expertise in gathering of cost-based optimizer (CBO) statistics for tables with Performing Database Tuning - 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 and ADDM.
• Performance Tuning of test and production database, monitoring system. Tuning and diagnosing of database performance by query Optimization and trace facility monitoring users, free spaces, table spaces and indexes.
• Upgrading databases from 10g to 11g and 11g to 12c using DBCA and manual method.
• Applied Security patches and PSU, CPU, SPU on Oracle Databases.
• Migrating Oracle databases across data centers from Solaris/HP-Unix to Linux OS using transportable tablespaces and RMAN convert.
• Configured physical standby databases for Business continuity plan (BCP) and Disaster Recovery Plan (DRP).
• Maintaining Oracle Data Guard & Standby Database and providing critical solutions with Strategic disaster recovery plans with different recovery procedures and methods.
• Experienced in Cloning of databases using RMAN and DBCA to create staging/test databases.
• Experience in installing and configuring Oracle Enterprise Manager (OEM) Grid Control 10g/11g/12c in addition to installing OEM grid agents.
• Excellent knowledge and experience in designing and implementing backup strategies using RMAN and netbackup.
• Complete and Incomplete Recovery of database in case of database crash, disk/media failure, etc.
• Performed complete backups (cold backups), incomplete backups (hot backups) and incremental backups using RMAN.
• Extensively used Data pump, Conventional Export/Import in migration process and to backup databases.
• Experienced in administering oracle 12c/11g/10g OLTP, Data Warehouse databases.
• Transforming logical models to physical models using ER Studio adhering with data governance policy.
• Implemented advanced features of Oracle such as Automatic Segment Advisor, Flashback technology.
• Created B-tree indexes for lots of updates in an OLTP application and Bitmap Indexes for low cardinality column data.
• Typically involved in database Design, Creation and Maintenance.
• Experienced in automation of migrating DB changes to higher environments using Flyway, Jenkins.
• Expertise in PL/SQL, SQL and UNIX Scripting.
• Implemented scripts using bash, K-shell, Perl for monitoring, backup purposes.
• Writing backend procedures, functions, packages and triggers using PL/SQL.
• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments.
• Routine DBA functions like space management, Rollback segments, Undo segments and Invalid objects.
• Planning of logical and physical architecture for a database.
• Creating primary database storage structures (Tablespaces), primary objects (Tables, Views and Indexes).
• Creating Users, Roles and Profiles, Privilege management with role-based security.
• Interacting with data modelers, developers, application owners for gathering the required information and resolving various issues.
• Troubleshoot user related and database related issues using Oracle Support Services.
• Provided developers and end-users with 24-7 database support.

TECHNICAL SKILLS

Databases: Oracle 12c RAC, 11gR2 RAC, 10gR2 RAC, 9i.

Operating System: HP-UX, Sun Solaris, AIX, Red Hat Linux RHEL and Windows.

Tools: /Utilities: RMAN, OEM, Golden Gate, Data Guard, Data pump, Export/Import, ER Studio, Flyway, Jenkins, TortoiseSVN, SQL*Loader, TOAD, DBArtisan, SQL Developer.

Languages: SQL, PL/SQL.

Scripting: Shell scripting.

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. Oracle DBA

Responsibilities:

• Installing and Monitoring Oracle database on 12c and 11gR2 RAC in RHEL using Grid Infrastructure.
• Upgrading databases from 11gR2 to 12c using DBCA and manual method.
• Implemented 12c new features: advanced index compression, RMAN Table Point In Time Recovery, Interval-Reference partitioning, etc.
• Converted single instance databases to 11gR2 RAC on 2node and 3node architectures.
• Installed Oracle Clusterware to provide infrastructure for RAC and configuration, maintenance and tuning of 3 node Oracle 11g RAC with ASM.
• Performed various tasks like administering RAC using SRVCTL, CRSCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
• Worked on Disaster recovery or Business continuity program to step up Exadata servers in remote location using rman techniques.
• Migrated multi-terabyte database(s) to Exadata machine using Datapump utility and also configured dbfs for goldengate trail files.
• Performed database management activities on Exadata X3-2, utilizing features of Exadata like smart scan, flash cache, storage indexes etc.
• Worked on X4-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.
• Performed role switchover in Exadata RAC environment with GoldenGate HA running on the servers.
• Capacity Planning and analysis of load on the current Exadata X4-2 half rack systems.
• Exadata monitoring, Setting up the alerts for database, listener, tablespace monitoring, ZFS backups setup from OEM 12c.
• Setting up goldengate Integrated capture to current classic capture by creating downstream mining database and prepared proper documentation for other dba’s to work on it.
• Upgrading goldengate from 11.2.1.0.23 to 12.1.0.2 and applying required patches using opatch apply.
• Configuring goldengate high availability on 11.2.0.2 RAC databases using control script and on 11.2.0.3 RAC databases using XAG bundle using agctl service prompt.
• Troubleshooting and resolving goldengate errors in a 2 node RAC production environment.
• Prepare Goldengate parameter files for Extraction and Replication.
• Solving production issues when there are any discards and when databases are out of sync, reading trail files using logdump utility.
• Installing ASM environment and migrating databases from NON-ASM to ASM.
• Extensively worked with ASMCMD for managing ASM environment.
• Migrating Oracle databases across data centers from Solaris/HP-Unix to Linux OS using transportable tablespaces.
• Upgrading Databases from 11g to 12c using DBCA and manual method and applying patches using optach utility whenever required.
• Applied one off patches and PSU's to fix software related bugs, security related bugs and patchset upgrades using opatch utility.
• Daily Health Check Up and performance statistics of the Database using Statspack, AWR and ADDM.
• Experience in reorganizing database, indexes and tables thereby tuning the performance of a database.
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database & DataPump.
• Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
• Configured and maintained physical standby using 11gR2 Data Guard and providing critical solution with disaster recovery plan.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability.
• Implemented backup/recovery procedures using RMAN, Data Pump, and performed database recoveries.
• Recovery management and supervision of the technical team to restore the database in-case of system failure.
• Implemented flashback technology for performing point-in-time recovery.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
• Creating physical data models from logical data models using ER Studio adhering with data governance policy.
• Setup of physical naming standards for physical database modeling.
• Extracting DDLs from ER Studio and deploying the scripts in development databases and check-in the changes to SVN.
• Automated migration of DB changes to higher environments using Flyway, Jenkins.
• Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
• Tuning Query performance by creating indexes to perform deep analysis to come up with a better execution plan.
• Used and maintained Bitmap indexes, materialized views.
• Created many common components of UNIX Scripts.
• Troubleshoot user related and database related issues using Oracle Support Services.
• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.
• 24x7 production support

Environment: Oracle 12c/11g, Sun Solaris, Red Hat Linux, OEM GC, ASM, RMAN, STATSPACK, AWR, ADDM, VERITAS Net backup, TOAD, Shell scripting, SQL*Loader, Data guard, Stored Procedures, Data Vault, Grid Control, SFTP, Exadata, GoldenGate.

Confidential, Des Moines, IA

Oracle DBA

Responsibilities:

• Upgrading dev, test, uat and prod databases from 11.2.0.2 to 11.2.0.4 in 3 node and 5 node RAC environments including satndby database.
• Responsible for maintaining of database using SRVCTL, OEM, maintaining Oracle Cluster using CRSCTL.
• Performed Database Migrations from 10g to 11g.
• Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability.
• Implemented switch over methods on primary and standby databases for planned maintenance on primary databases.
• Designed and Configured Oracle 11g Data guard for physical standby database.
• Created Logical Standby, using oracle Data Guard feature for reporting purposes.
• Designed & Implemented backup strategies using Hot, Cold, and Exports based on the business requirements.
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
• Cloned schemas, objects and data on new server from 10g to 11g database using conventional EXP/IMP.
• Performed data migration by using data pump export/ import utilities.
• Extensively used Oracle Enterprise Manager (OEM) for maintaining and monitoring databases.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Performed SQL query optimization by gathering statistics and by using explain plan, STATSPACK, TKPROF.
• Performed Cloning of production database for test databases.
• Worked on recovery methods like Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN.
• Periodically refresh production databases to development & testing databases using RMAN.
• Performing all the Database Administration activity like space management in database, User and Roles administration, Schema management, checking alert log of all the databases using OEM.
• Resolving user connectivity, listener, SCAN issues.
• Created database design according to the requirement of Application Software, Monitored and Configured databases.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Estimate the size of the Database and its Objects.
• Used SQL*Loader for loading legacy systems database data.
• Utilized Oracle Support and Meta Link to troubleshoot the problems and issues.
• Developed UNIX shell scripts.
• Involved in implementing Oracle partition tables.
• Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
• Configured database initialization parameters.
• Tuned optimizer specific parameters, memory areas to optimize SQL operations for best results.
• Prepared documentation for ongoing maintenance and support.
• By using Bash scripting developed scripts for monitoring, backup and recovery.
• 24*7 Production Database Support to ensure availability, efficiency and recoverability.

Environment: Oracle 11g/10g RAC, SQL, MySQL, PL/SQL, RHEL 5.2, HPUX, Windows, OEM, TOAD, Shell scripting, SQL*Loader, Data guard, Stored Procedures, ASM, RMAN, STATSPACK, AWR, ADDM

Confidential, Memphis, TN

Oracle DBA

Responsibilities:

• Installation and creation of Oracle 10g databases on Production and Test Linux servers. Responsible for Upgrade & Migrating databases from 10g to 11g, applying patches.
• Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
• Installed RAC on Oracle 10g and Configured, monitored and troubleshoot of two nodes RAC.
• Successfully implemented backup and recovery strategies and performed full cumulative/differential backups using RMAN.
• Creation and Maintenance of standby database by using oracle high availability method Oracle Data Guard and Implemented physical standby database for production databases for business continuity plan
• For migration/cloning of small sized databases used import/export utilities to move data between environments.
• Performed database migrations.
• For Daily/Weekly performance tuning needs extensively used AWR, ADDM and explain plan.
• Applied latest patch set to fix bugs, to enhance on database security and to increase functionality.
• Troubleshoot databases, provide reports on the database health check, follow up and recommendations.
• Managing database instances for Production and test environments to ensure strong testing environment and smooth transition to production.
• Responsible for Monitoring and Estimating the size of the database & growth, and configuring the database accordingly.
• Responsible configuring listeners for Network Connectivity and Security.
• Diagnose and Resolve Performance, Connectivity, Security and Database corruption issues in a critical production environment.
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.
• Interacted with Data modelers, Developers, Application owners for gathering the required information and resolving various issues.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Tuned SQL statements using EXPLAIN PLAN. Tuned memory (System Global Areas like Shared pool area, Data Buffer Cache, redo buffers), I/O, Contention, modified parameter file and rebuild indexes according to the requirement for performance.
• Used OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning.
• Responsible for setting up Oracle Streams to help in propagating information within and between databases thereby reducing load on the production database.
• Utilized Oracle Support and Meta Link to troubleshoot the problems and issues.
• Transported tablespaces between production and development databases.
• Developed UNIX shell scripts to perform tasks like moving files, to manage alert log, perform backup efficiently and quickly.
• Worked closely between managers and development Team to maximize productive output.
• Checking CRON jobs. Monitoring Application specific background processes
• Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
• Monitoring the database daily activities.
• Frequent Database audits to maintain the security standards.
• Production support and Providing 24/7on-call support

Environment: Oracle 10g/ 11g, OEM, RMAN, DBCA, Data Guard, Putty, XML, FTP, TOAD, UNIX, Solaris, Windows XP

Confidential

Jr. Oracle DBA

Responsibilities:

• Involved in installing Oracle 9i/10g, database creation, and user management.
• Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning, Tuning Contentions).
• Implementing Backup/Recovery Strategies.
• Writing UNIX shell scripts for Backup and Recovery.
• Used to do HOT backup (RMAN) every day and COLD backup during weekends.
• Implement Hot, Cold and Logical backup plans.
• Taking logical backups using export/import at object and schema level.
• Refresh/Cloning of Database and applications for development, testing.
• Monitored the alert logs regularly.
• Write Korn shell scripts to monitor and maintain the Oracle Applications database.
• Write SQL scripts to monitor tablespace and extent growth.
• Managed table spaces and redo logs.
• Creation of schema objects and space management.
• Maintain Oracle schemas and SGA region.
• Create table spaces, tables, and users for custom applications.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers
• Creating databases, objects, roles and privileges.
• Estimating the size of the Database and its Objects.
• Assist Programmers and Developers with Oracle problems.
• Maintaining user security.
• Preparing documentation for ongoing maintenance and support.

Environment: Oracle 10g/9i, SQL, PL/SQL, TOAD, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux.