SIVARAM SANGA

ORACLE DATABASE ADMINSTRATOR

ac46jy@r.postjobfree.com

551-***-****

Over 8 years of experience as oracle database administrator in various roles, my experience has scaled in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication, Database Security, RMAN, User management, ASM, Performance tuning and monitoring the database using OEM Grid Control, and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup recovery, cloning, and space management, shell scripting using ORACLE 12c/11g/10g, performing the role of Oracle Database Administrator according to the set standards and timelines. Performed Data masking and Data redaction and created vault in OEM.

Technical Skills:

Operating Systems

HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005.

RDBMS

Oracle 12c/11g/10g/, Oracle 11g Real Application Cluster (RAC), ASM, MongoDB.

Oracle Tools and Utilities

Data Guard, GoldenGate, Logdump, Defgen, Web logic server, OBIEE, WebSphere, RMAN, OEM, Tuning Advisors, TOAD, SQL*Loader, Export/Import, Data pump, AVAMAR, RMAN, RAC TOOLS ORACHECK, oratop, TFA collector, OSWATCHER.

Languages

C, SQL, PL/SQL, AWK Scripting, Perl.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL Tuning Advisor.

Ticketing Tools

Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console, GIRA.

Experience Synopsis:

Extensive Experience in very large scale database environment and mission critical large OLTP and OLAP systems.

Experience in using oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, upgrading databases and Network Configuration Assistant (NETCA) & NETMGR for creating a Listener, TNS names to establish a Client-Server environment.

Experienced in maintaining databases on large Production, Testing and DEV environments and Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.

Experience with MySQL on both Linux and Windows.

Extensive experience in providing 24x7 on call support for Test, development and production databases using Maximum Availability Architecture using RAC and Dataguard.

Expertise in Implementing Oracle 11gR2 and 12c RAC implementation on ASM.

Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs.

RAC utilities: raccheck, orachk, oratop, TFA Collector, ocrconfig, OSWatcher, Srvctl and Crsctl.

Performed various tasks in RAC Cluster: pinning nodes, used ocrconfig to backup OCR, OLR and voting files, creating services using Srvctl, changing scan port number, Multiplex Voting files, Mirroring OCR on different ASM disk groups, Tuning Node Evictions by setting disk timeout, reboot time, miss count, Creating New VIP to manage high availability, Configuring TAF and used different parameters, Configuring ACFS and configuring for Automatic failover.

Applied Patches in rolling fashion and Upgrading Oracle GRID infrastructure 11g, 12c

Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM.

Good experience in upgrading 10g & 11gR2 database to 12c Pluggable database using Oracle DBUA and/or expdp/impdp method.

Experience in Uni-directional, Bi-directional and Integrated Capture data using golden gate.

Troubleshooting Golden Gate issues such as process abending, and lag on replication environments.

Troubleshooting Golden Gate issues in both development and production environments.

Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using Datapump and Golden Gate replication.

Expertise in Dataguard Configuration, Implementing and Maintaining physical standby databases in 10g/11g/12c on Solaris, AIX, RHEL.

Expertise in configuring Active Dataguard, Snapshot standby and troubleshooting issues and configuring Service Level Agreements for query’s accessing standby databases.

Expertise in analyzing database objects, DB-links, creating indexes, creating materialized views, writing packages, Stored Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle.

Troubleshooting Dataguard using Views, troubleshooting missing archive log scenario, patching Dataguard environment, Applied logs with delay Configured Dataguard Broker and managed standby databases using DG broker.

Experience in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using Golden Gate with Zero downtime.

Used Logdump utility, Defgen utility in GoldenGate environment and Installed Goldengate in dev, test, and prod environment.

Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied Patches to GoldenGate environment 12.1.0.2.

Configured Golden Gate wallet for security purposes.

Expertise in implementing database Backup and Recovery concepts using RMAN utility.

Implemented scheduling full, incremental, cumulative and hot, cold backups writing, editing UNIX Shell Scripts for RMAN.

Performed Various Tasks on RMAN: configuring backup, Block recovery, data file recovery, registering databases in catalog, TBPIR Table space point in time recovery.

Experience in logical backups and Database migration tools with Data Pump, Export/Import and Transportable Table-spaces.

Experience in implementing Flash-Back Technology 10g/11g/12c and used different techniques using Flashback Query, Flashback SCN, creating restore points on database.

Extensively used Flashback for Supporting DML and DDL changes and Handled daily production problems/change requests(DBCRS) with Oracle Patching.

Good experience in Patching PSU and CPU Patches Quarterly and Up gradation of databases from versions from 10g,11g to 12c.

Expertise in Upgrading databases from 10g to 11g and 11g to 12c and applied patches accordingly.

Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like AWR, ASH, SQL-Trace, ADDM, SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage.

Used Data masking to protect private and confidential data by replacing sensitive information with dummy data, knowledge on Physical and Logical structure of database

Worked on Exadata Database Machine X2-2 Half Rack, X3-2.

Implemented new Exadata Machine features like smart scan, Flash Logging, Storage Index, HCC and enabling Smart Scan on Exadata Databases.

Migrated databases into Exadata Machine with minimal downtime using Dataguard.

EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations.

Proficient in EBS Installation, Patching, Cloning, Database Refresh, Upgrade (EBS and Database), Disaster Recovery, High Availability and Backup & Recovery (RMAN).

Developed database monitoring and health check alert scripts for database uptime and downtime status, and sizing issues using grid control (OEM).

Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling jobs using Auto sys, RMAN, SQL tuning advisor to tune sql’s on database.

Use Oracle Meta-Link Support to resolve issues related to database servers, security patches and Proficient in raising SR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments.

Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams.

Have Ability to function independently and plan, evaluate and design solutions to problems as they occur and Ability to work well in a group environment and Good ability to mentor other DBAs in the group.

Work Experience:

Client: Ventiv, Atlanta, Georgia

(Jan 2017-Till date)

Role: Sr. Oracle Data Base Administrator

Responsibilities:

Installed, configured and maintained Oracle 12cR2 Real Application Cluster (RAC) 3 node RAC, Migrating single Instance Databases to 3 Node RAC environments.

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Performed the 12c Upgrade of RAC cluster ware from 11g.

Duplicated issues and tested solutions to make sure problems were resolved properly.

Assisted Development and Business analyst teams by capacity planning and cloning of databases to the test environments so they could develop custom applications and perform a variety of tests for quality assurance and issue resolution.

Installed the 3 node RAC for the 12c database and administered the 12c databases on these RAC server’s.

Managed testing, assisted Developers, and created backups by Exporting and Importing tables when needed.

Established performance tuning best practices used by the DBA and Development teams.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.

Performed the Instance caging for the Exadata databases.

EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations.

Enabled Flashback for database to create restore points and supporting DDL changes.

Applied PSU quarterly on 11g/12c GRID & RDBMS homes using Opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN.

Daily Health Check Up of the Database and SQL Queries and Performed large batch jobs, and tuning of SQL queries and database systems.

Excellent knowledge in using Oracle Golden Gate including maintenance and performance monitoring.

Performance tuning Golden Gate replication and used Log dump and report files for troubleshooting.

Installation and configuration of oracle Golden gate on 12c & 11g.

Configuration and troubleshooting of Golden Gate EXTRACT, Unidirectional and BIDIRECTIONAL REPLICAT issues.

Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM.

Involved in Installation and configuration of MongoDB.

Backup/Restoration of Database through Mongodump/mongorestore utility.

Experience in performing Mongo DBA operational routines.

Worked on Exadata Production databases and providing the Technical support to Application Support team for performance and database related issues.

Up gradation of GRID infrastructure from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2.

Installed 12c pluggable databases on Sandbox.

Have Good overview of pluggable databases.

Plugging from and Unplugging into XML files, creating the Container database and pluggable databases, Upgradation from 11.2.0.3 to 12.1.0.1 and migrating the 11g database to 12c pluggable database.

Performed health checks of RAC Cluster-ware components OCR, voting files and backups using ocrconfig and Troubleshooting Issues using Clusterware logs in 12C.

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.

Oracle Enterprise Manager: Installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 10g/11g/12c and 13c for Configuration of error notifications and adding to the grid control.

Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS_SCHEDULER.

Dataguard: Configured Physical Standby databases using data guard in maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c according to Business.

Configured Active Dataguard 11g Troubleshooting Out of sync issues in Data Guard environment and Configured Dataguard Broker and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing.

Worked on Servicenow Ticketing system to resolve the incidents based on Severity

Used crontab utility for scheduling jobs.

Perform Daily Monitoring of Oracle Instances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.

Also, configured database cloning using RMAN.

Worked with offshore team and coordinating database monitoring, scheduled calls to discuss database issues.

Responsible for database administration and worked in all phases of Software Development Life Cycle (SDLC), and systems analysis procedures.

Extensively used USH, Ticketing Systems BMC Remedy and Service now and 24x7 production Support Database Maintenance and on-call Support.

Environment: Oracle 11g/10g/12c, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL, Database10g/11g/12C, RMAN, DATAPUMP, 10g/11g, Goldengate11g, 12c, orachk Defgen, Logdump, ASH reports, Oracle Patching Opatch, Data Pump, putty,MongoDB.

Client: Carnival Cruise Lines, Miami, Florida

(Mar 2015 to Nov 2016)

Role: Sr. Oracle Database Administrator

Responsibilities:

Upgraded GoldenGate from v10 to v11 while upgrading Oracle databases.

Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate.

Performed Various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicate and replicated tables to different Instances using GoldenGate.

Upgradation of databases from 11.2.0.2 to 11gR2 and Applied patches to databases 10g/11g.

Cloned non-CDB 12c Database to 12c PDB (Pluggable DB).

Configured Disaster recovery databases using Dataguard: configured Active Dataguard, Dataguard Broker and snapshot standby databases, Troubleshooting Issues in Data Guard Environment, missing archive log, performance of Standby databases using stats pack, applied logs with delay, Tuning Media Recovery process, Performed DR testing.

Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database.

Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery.

Planning Recovery Procedures and Performing backups in Both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities.

Configured repository database for setting up OEM 12c, used 10g,11g 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 11g, 12c.

Created User accounts, Roles and granting required access permissions and privileges.

Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes.

Modified and debugged several PL/SQL programs for performance tuning using techniques like EXPLAIN PLAN, TKPROF and DBMS_PROFILER.

Handled PL/SQL compile-time, run-time errors, debugging of Stored Procedures for business logic modification, and responding to system events through triggers.

Performance tuning of databases using AWR, ASH reports, ADDM reports, provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage, Oracle 11g new partition techniques Interval partitioning, system partitioning, Creating Views & Materialized Views, Implementing SQL profiles and Migrating SQL profiles, Creating and rebuilding Index’s, re-organizing tables.

Used 11g new features Invisible Indexes, and turn off indexes temporarily to check how queries perform without Index’s and Worked on Oracle Database Appliance, patching.

creating table partitions and dropping partitions when required, creating index’s and rebuilding indexes for maintenance, creating new DB-links for new environment.

Environment: Oracle 11g/10g, Oracle 12c(Testing), Oracle Goldengate 10.4, Oracle Goldengate 11.2, Oracle Enterprise Manager Grid Control, Oracle Enterprise Manager (OEM), Sun Solaris, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Client: State of Missouri, Kansas City, MO

(July 2013 - Feb 2015)

Role: Sr. Oracle Database Administrator

Responsibilities:

Implemented Oracle Database 11gR2 2,3,4 node RAC Clusters on RHEL Linux Severs.

Performed health checks of OCR, voting-disk, Interconnect and RAC instances and managed resources using Crsctl & Srvctl, creating services using Srvctl, relocating services and patching RAC cluster and troubleshooting 10g, 11gR2 cluster.

Worked on Exadata X2-2 and x3-2 machines and migrated application databases using Expdp, GoldenGate and Dataguard.

Worked on different Features on Exadata x3-2: Hybrid column compression, Smart scan, Flash Logging, DCLI, create and drop Flash disks, Flash Logging, Enabling Flash Cache Compression, Cell monitoring and Alerts, Cell Offload Efficiency, Hybrid columnar compression, controlling database resources using IORM plan.

Performed various tasks on ASM, Installed standalone servers on ASM, used asmcmd to manage disk groups in ASM environment and Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM, tuning ASM parameters for better performance.

Upgraded GoldenGate from v10 to v11 while upgrading Oracle databases.

Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate.

Performed Various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicat and replicated tables to different Instances using GoldenGate.

Upgradation of databases from 10.2.0.4 to 11gR2 and Applied patches to databases 10g/11g.

Worked closely with PL/SQL developers for fine performance tuning.

Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database.

Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery.

Created User accounts, Roles and granting required access permissions and privileges.

Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes.

Environment: RHEL-4.x,5.x, Sun-Solaris 9, OEM 10g-11g, Oracle 10g,11g, RAC 10g,11g, Srvctl, Crsctl, ocrconfig, ASM, ASMCA, Dataguard, Active Dataguard, snapshot standby, GoldenGate v10, v11, Exadata x3-2, x2-8, Migration, TKPROF, AWR, ADDM, ASH, RMAN, Data pump, Opatch, Materialized views, Toad, Putty.

Client: Ernst &Young, Atlanta, Georgia

(Sep 2011 - Jun 2013)

Role: Oracle Database Administrator

Responsibilities:

Grant, control and delete database access based on security requests.

Hands on experience on table promotions.

Monitoring the daily backups.

Monitor database performance through (AWR) Automated Workload Repository and optimize when appropriate.

Monitor system for invalid objects.

Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

Worked in the client location.

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.

Create and manage documentation for databases and processes.

Security provisioning for the users on the daily basis.

Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM.

Performs general database administrative tasks including user account management, access control, database optimization and error resolution.

Perform Daily Monitoring of Oracle Instances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

Created User accounts, Roles and granting required access permissions and privileges.

Excellent knowledge in using Oracle Golden Gate including maintenance and performance monitoring.

Worked on Service Now Ticketing system to resolve the incidents based on Severity

Excellent communication, interpersonal, analytical skills and strong ability to perform as a part of a team.

creating table partitions and dropping partitions when required, creating index’s and rebuilding indexes for maintenance, creating new DB-links for new environment.

Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes.

Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

Created audit vault triggers for the tables.

Involved in migration of databases.

Promoting the tables from UAT to DEV environment.

Experience on changing the database passwords in a monthly rotation manner.

Created standby databases and involved in converting Physical to Snapshot standby and Active Dataguard.

Migration of database from one server to another server.

Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.

Created and configured database manually using Oracle Database Configuration Assistant.

Used to take the backup of databases using RMAN catalog. The restore capability included the restoring via stored RMAN tapes and using the RMAN database and tablespace restore and / or recover capability of RMAN.

Environment: ora10g/11g, service now, toad, sql developer, data guard, data pump, Oracle patching, patch, putty, Red hat Linux, oracle enterprise manager, opatch, OEM 11g, TKPROF, AWR, ADDM, ASH, RMAN, Dataguard including DG Broker setup, Oracle Golden gate 11.2.

Client: HDFC Standard Life Insurance CO LTD

(Aug 2009 - Aug 2011)

Role: ORACLE Data Base Administrator

Responsibilities:

Setup physical standby’s (DATAGUARD) for several Databases running 11g well (Container level and Non-CDB).

Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data.

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI.

Assisted in keeping a daily log of Share point issues and submitting that log each week to IT management.

Converted physical standby to Snapshot standby and back to physical standby.

Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.

Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate.

Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.

Data pump including database links and network links. Upgrade the binaries by applying patchset and interim patches using Opatch and Opatch Auto.

Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.

Configured and implemented Oracle Streams (Advanced Replication) for high availability.

Tested database performance issues (monitoring and tuning) to ensure database optimization.

Involved in gathering requirements from end users.

Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

Replication was configured to run even at the time of failover (Data Guard) of the source database.

Providing technical support to Application Support team for performance and database related issues.

Effective Production Support and off hour support, support handover.

Environment: Oracle 9i/10g, Red Hat Linux 5.8, RAC, Oracle Advanced Security, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, Opatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations

EDUCATION: Bachelor of Technology.

Contact this candidate