Siva Kumar

Professional Summary:

Over * Years of experience in Oracle Database Administration (Oracle databases 8i/9i/10g/11g, 12c running on HP-UX, SUN SOLARIS, AIX, Red Hat Linux and Windows.

Expert in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, auditing, troubleshooting, database design, TAR support, Unix shell scripting and documentation.

Proven Experience with 11g Release 2, 10g Release2, 9.2.0.2 - 9.2.07, 8.1.7.4

Performed several cross-platform upgrades and migrations and single node to RAC conversions.

Involved in policy formulation and Physical and Logical design of Database.

Experienced in Backup and Recovery, Disaster Recovery policy formulation and implementations.

Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

Experienced in Data Migrations using oracle export/import, data pump.

Good experience with replication tools installations and configurations.

Supported Golden Gate and Shareplex replications both unidirectional.

Configuration of Oracle Goldengate from Oracle to Oracle database.

Replication using Initial Data Load and Online Change Synchronization.

Responsible for the configuring Oracle Goldengate EXTRACT, REPLICAT, PUMP and their parameters.

Experience in Configuring DML and DDL Synchronization.

Experience with Oracle 12c/11g/10g features: Flash-Back Recovery, Data pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.

Proficient with Database Cloning, Migration, Standby Database, Data Guard and Patching of Oracle Databases and Oracle Applications.

Implemented Data guard for Disaster Recovery Setup using 11g Active Data guard.

Experience in Configuring Oracle DATA GUARD with Physical and Logical Standby, also familiar with 11g ACTIVE DATA GUARD.

Experience with case management of DB2 technical support.

Expertise with usage of tools including Oracle Enterprise Manager (OEM), TOAD, Sql Developer.

Experience in Unix Shell Scripting for automating the DBA tasks and schedule Jobs in UNIX environment.

Good experience in Migrating 11g to 12c Database, Upgrade 11.2 RAC to 12c RAC.

Extensively used utility SQL LOADER, External Tables to load data from flat file to database.

Configured and implemented Golden Gate and Streams for Data Replication materialized views and advanced replication methods.

Strong work experience with tools like Toad, PL/SQL Developer, Oracle SQL Developer, OEM Grid Control.

Wrote Server-side Stored Procedures and Triggers, formulated RMAN Backup/Recovery strategies, Optimizing Query Plan, Performance Tuning, Explain Plan, TKPROF, and Stats Pack.

Managed ASM configuration and migration of database from clustered file system to ASM.

UNIX Systems Administration - Database and application integration efforts; CVS system installation experience; Heavy UNIX shell scripting, CRON jobs.

Actively involved in resolving pre or post-implementation problems and work around.

Experienced in technical documentation.

Involved in upgrading and migrating the databases from 11.2.0.1 to 11.2.0.4.(PSU and CSU)

Sound analytical, troubleshooting, problem-solving skills, and equipped with excellent communication and interpersonal abilities, and an acceptable teammate.

On call 24X7 Production Support. Willingness to work beyond regular hours.

Technical Skills:

OPERATING SYSTEMS:

HP-UX 10.x/11.x, Sun Solaris 8/9/10, AIX 5.2/5.3/6.1, Red Hat Linux RHEL 7.3/8/9, SUSE 10.0 and Windows NT/2000/2003.

LANGUAGES:

SQL, MYSQL,PL/SQL, C, C++, XML, Unix Shell Scripting, VMware, Perl, HTML, PHP

Database :

OEM, DATA GUARD, Recovery Manager (RMAN), Data-pump, STATSPACK, ASH, AWR, TKPROF, ADDM,, ETL, Clusters, EMC Storage, DTS, Developer 2000, SQL Loader, TOAD,SQL*LOADER, putty, WinSCP3, SQL*PLUS, Net Backup, EXPLAIN PLAIN, SecureCRT

PROTOCOLS:

FTP, SFTP, Ssh, Telnet, TCP/IP

Replication

Golden Gate, Oracle Multi-master Replication, Data Guard, Shareplex.

Front End Tools

Power Builder 8, Visual Basic 6, Business Objects, Developer 2000, Oracle Discoverer, Oracle Reports 6i

Utilities

SQL*Plus, SQL * Loader, SQL * Net, Toad, ER-Win, Visual Safe Source, Subversion, PL/SQL Developer

Backup Utilities

RMAN, HP Omni Data Protector, SQL Backtrack,), VERITAS Net backup, Export/Import

Oracle Monitoring Systems

OEM 9i/10g, Oracle 12c Cloud Control, Oracle EBS, Oracle Golden Gate Director

Professional Experience:

Wells Fargo, Des Moines, IA Dec'2015 - Till date

Database Administrator

Responsibilities:

Configuration, Administration and Maintenance of Oracle 11gR2 Real Application Cluster Databases on UNIX platforms and achieving High Availability.

Performing various tasks like administering RAC using SRVCTL, CRSCTL, administering storage components, parameter management, and configuring high availability features for RAC.

Configuring and Maintaining Oracle Data Guard for disaster recovery Business Continuity Plan.

Tuning and diagnosing of database performance by query Optimization.

Ensuring quality, integrity and availability of the data.

Assisting development in design of database systems and staged implementation of changes.

Data Refresh from Production to Test and Development environments using RMAN and Data Pump.

Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of database environments.

Daily Health Check Up and performance statistics of the Database using OEM, AWR and ADDM.

Providing developers and end-users with 24-7 database support whenever required.

Maintaining tablespace resize the datafile’s, adding a datafile to a tablespace.

Analyzed tables and re-builded indexes regularly and Reports, Statspack, AWR, Explain Plans, ADDM and monitor the database performance on daily basis.

Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.

Utilized SQL*loader and data pump import to load data into tables and Oracle Flashback Data Archives.

Implemented Data Guard and created Physical Stand by database for high availability and Maintained Database.

Work with VMware Infrastructure Client in supporting our Windows 2003 & 2008, Linux Enterprise 5 Server environment.

PSU,CSU patches has been applied for various oracle versions in various operation systems

Creating ORACLE SR and following up timley to get the solution.

Responsible for the configuring and designing Oracle Goldengate EXTRACT, REPLICAT, PUMPS and their parameters.

Created, monitored and maintained definitions and rules based upon requirements from Service Level Agreements (SLAs)

Jointly co-developed SLAs and KPIs with vendors to monitor and support of DB & ERP information infrastructure

Oracle Goldengate Process is configured in such way that it will not create any load on production and read data from Archive logs of the production.

Experience in Using Goldengate to maintain Live Standby Database

Experience in Configuring DML and DDL Synchronization.

Experience in Configuring Oracle Goldengate in Heterogeneous environment (operating systems and databases)

Experience of Using Logdump Utility to check Trail files and troubleshoot.

Data migration from one technology to another without downtime using goldengate.

Successful replication of Oracle Database 11g using Initial Load, Online Synchronization and Datapump process of Golden Gate.

Configuration of Oracle Goldengate from Oracle to Oracle database.

Replication using Initial Data Load and Online Change Synchronization.

Experience in relocating the ggvip of Goldengate manager from one node to another using crsctl in RAC environment.

Involved in establishing baseline SLA for systems administration and databases services

Troubleshooting Goldengate issues by checking report files, trail files and ggs error log files.

Environment: Red Hat Linux, Sybase, Oracle 11g, 12c RAC, VMware, SQL*Plus, OEM, TOAD, RMAN, TKPROF, SQL Trace, STATSPACK, ADR, AWR, ASM, ADDM, Data Guard, Shareplex, Exadata, DB Connection Pooling, Virtual Columns.

USPS, Raleigh, NC Jan'2015 - Nov'2015

Oracle DBA

Responsibilities:

24X7 Production database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database and applications issues.

Created/managed Oracle Databases in 11g and 12c RAC in both windows and Linux.

Upgraded many postal databases from 11g to 12c RAC.

Migrated windows 10.1.2.0.2 database to 12c RAC on Linux

Applying approved patches and modifications, in accordance with policies and procedures established by the Postal Service.

Experienced in Data Migrations using oracle export/import, data pump.

Implementing appropriate database security administration and ensuring that logon IDs are unique. Managing sessions and authentication and implementing account time-outs.

Testing database software to ensure that security mechanisms are functioning properly. Tracking database software vulnerabilities, and deploying database security patches.

Ensuring database logs are turned on, logging appropriate information, protected from unauthorized disclosure or modification, and retained for the time period specified.

Reviewing database audit logs and maintaining records of log reviews. Assisting with periodic reviews, audits, troubleshooting, and investigations, as requested.

Ensuring the availability of databases by implementing database backup and recovery procedures.

Setting up and managing accounts for systems under their control in accordance with policies and procedures established by the Postal Service.

Implemented strong user authentication using the wallet for external password store

Cloning database from Prod to CAT(Using RMAN catalog)

Configured Disaster Recover and Logical standby for Production database in 10G.

Tune databases performance, Schedule backup, jobs using OEM Grid Control.

Involved optimizing database schemas, SQL queries, database procedures, and installation.

Cloned/Refreshed Oracle Databases using RMAN for development and testing.

Installation and configuration of Golden gate for replication and resolve issues to sync Databases

Migrated VMs across hosts within a HA cluster to perform maintenance tasks on ESXi hosts.

Used VMware vMotion to eliminate application downtime from planned server maintenance by migrating running virtual machines between hosts.

Installed upgraded and patched DB2 software and associated applications.

Installed, and configured RAC9i,10g,11g databases using ASM

Tuned SQL statements using explain plan and Tkprof. Monitoring and Performance tuning.

Written shell scripts for digitization the process and for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.

Designed and implemented a multi-segment Veritas backup infrastructure for internal and customer backups with policies, procedures, and SLA definition responsibilities.

Installed and configured Oracle SOA suite.

Supported upgrades from oracle 9i to 10g, 9i/10g.

Performed migration from 9i to 10g from AIX to Linux.

Tuning SQL queries using AWR, ADDM, TKPROF, EXPLAIN PLAN, and SQL TRACE.

Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.

Performing Backup/Recovery of all the Oracle databases using RMAN and also setup RMAN catalog for the same.

Involved in patching 10g ASM instances and CPU patching for RAC instances and single instances.

Experience in SQL*Loader, loading data from text files.

Performed scheduling of Change Control-activities and scheduling jobs.

Environment: Oracle 12c/11g RAC/10g RAC, 9i, ASM, Data Guard, VMware, Data pump, DB2, UNIX Shell Scripting, SUN SOLARIS 10, ETL, OEM, MySQL, SAP, Perl, PL/SQL, Red Hat Enterprise Linux 4.x, Explain Plan, Tkprof, Oracle EBS, SQL*LOADER, SOA suite, Cloud Control, UNIX/Linux, RMAN, AIX 6.1, 5.1 and RHEL 5, 4.

ClearXchange, San Francisco, CA Aug ’2013 – Dec'2014

Sr. Oracle DBA

Responsibilities:

Installed, configured and monitored multi node Oracle 12c/11g/10g RAC.

Converted a single instance database to Oracle RAC.

Installed and configured Data Guard using physical and logical standby for high availability and reporting purpose.

Data pump Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN.

Configured ASM in Oracle 11g Release2 databases

Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.

Work within the production support team and maintain operational consistency and efficiency.

Performance Monitoring and tuning using STATSPACK, TKPROF, EXPLAIN PLAN, AWR, and ADDM.

Up gradation of Database from 9i to 10g, 9i to 11g, 10g to 11g and applying patches whenever required.

Implemented transportable tablespace to migrate database from 11g to 12c.

Performed migration from 9i to 10g from AIX to Linux.

Supported upgrades from oracle 11g to 12c, 9i/10g/11g/12c.

Performed DB2 installation and configuration.

Install and configure SOA Suite 11.1.1.3.

Oracle EBS upgrade from 11.5.10.2 to 12.1.3.

Tune databases performance, Schedule backup, jobs using OEM Grid Control.

Involved in creating Tables, Indexes, Triggers, Sequences, Procedures and Packages.

Cloned Oracle Databases and Oracle applications for development and testing.

Applied upgrade patches to RAC databases 9i,10g.11g, ASM, Clusterware

Involved in Data modeling, Logical database design, physical database design, normalization and renormalization.

Maintained Shareplex unidirectional replication for the billing server ARBOR.

Management of security, granting and revoking permissions to users/roles as and when required.

Writing UNIX shell scripts for backup and recovery, Import and export procedure.

Writing PL/SQL functions, procedures, packages and triggers.

Installed upgraded and patched DB2 software and associated applications.

Planning and Execution of RMAN backup and recovery based on SLAs.

Create and maintain Fusion, Oracle EBS Suite environments, DB templates, RAC environments, Zip DB for entire Oracle product development division.

Experience in Identifying performance bottlenecks on high volume transaction systems.

Database administration tasks involving installation, performance tuning, space management, user management, backup & recovery strategy planning.

Experience on Data Modeling tools such as Erwin Data Model and ER Studio.

Provide development and production support related to database.

Install Oracle RAC 10g on Oracle Enterprise Linux Using VMware Server.

Working with QA and Development teams for the regular database support.

Daily Health Check Up of the Databases and applications

Environment: Oracle 12c/11g RAC/10g RAC, 9i, ASM, Data Guard, VMware, Shareplex, Oracle EBS, Data pump, DB2, UNIX Shell Scripting, SUN SOLARIS 10, ETL, OEM, MySQL, SAP, Perl, PL/SQL, SOA suite, Cloud Control, Linux, RMAN, AIX 6.1, 5.1 and RHEL 5, 4.

Belk, Charlotte, NC Mar’ 2012 – Jul ’2013

Oracle DBA

Responsibilities:

Installed, configured and administered 3 node 11gR2 RAC with ASM on Redhat Linux.

Configured the Public Network/Private Interconnect for RAC.

24X7 on Call Production Support for 3 Node/4.5TB RAC Cluster

Database Installation, Configuration, physical and logical design.

Supported Billing software including ARBOR and RIBS

As a part of maintenance activity excluded some tables from replication without shutting down the whole replication in Shareplex and later included in the configuration file.

Installed and configured Oracle SOA suite.

Configured and maintaining Data Guard (Physical Standby database) for the production database and tested for switchover, failover, activating the standby to primary and zero data loss.

Maintenance and monitoring of oracle 11gR2/10g database instances hosted on Linux (RHEL5) and Sun platform.

Performed DB2 installation and configuration on OS Mainframe platform.

Migrate 11g to 12c Database, Upgrade 11.2 RAC to 12c RAC -- Configure Containers, Implement Audit Vault and new database security features.

Upgraded Oracle EBS Database to 11g (11.2.0.3) RAC in both TEST and PRODUCTION environment.

Upgraded databases from Oracle 9ito Oracle 10g &Oracle10g to Oracle 11g and migration of the databases using transport tablespaces export/import, data pump utilities.

Written PL/SQL Stored Procedures, Packages, Functions and Triggers.

Worked on transportation of Tablespaces, Data Archival, and Database Defragmentation.

Used Opatch utility for applying CPU and One-off patches & RDBMS patch set Upgrade (PSU).

Creation of database server from scratch and implementing ASM file systems

DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.

Clone copy of production databases into test databases for application upgrade testing.

Installed, configured, and maintained Oracle Fusion Middleware with SOA Suite.

Assisted developers in tuning SQL statements in the applications for Performance tuning and Query Optimization

Utilized SQL*loader and data pump import to load data into tables.

Assisted developers and also involved in creating stored Procedures, Triggers, Functions, Cursors and Packages.

Developed SQL, PL/SQL Programs such as procedures, functions, packages and triggers

Provided 24 * 7 on-call Production support for Oracle 10g and 11g

Responsible for memory and Application tuning of the databases using Oracle utilities like OEM, SQL Trace, TK Prof and Explain Plan.

Partitioning of large tables for fine tuning performance.

Designed and implemented crash recovery strategies using RMAN, Hot, Cold and Logical backup plans.

Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.

Recovered Data block corruption using RMAN.

Installed upgraded and patched DB2 software and associated applications.

Taking periodic Backup of the Database and the software using Recovery Manager and VERITAS.

Generated regular Stats-Pack/AWR/ADDM reports for the performance tuning of the databases.

Experience with DBUA/Export and Import to migrate the database.

Performed Replication of the Production database for setting up instances for the QA and Testing teams.

Unix Shell Scripting and Scheduling jobs using CRON, DBMS_JOB& DBMS_SCHEDULER.

Generated Automatic Workload Repository (AWR) report to collect processes and maintained performance statistics for problem detection &self tuning purposes.

Generated Automatic Database Diagnostic Monitor (ADDM) in order to analyze data in the Automatic Workload Repository (AWR) in order to identify potential performance bottlenecks.

Installed and configured 11g Grid Control and deployed the agents to several target production/test/dev database environments.

Extensively used 11g Grid Control for monitoring databases proactively.

Environment: Oracle 11g/10g, RAC, Red Hat Linux, Cloud Control, Solaris 10, Oracle Enterprise Manager, Data Guard, ASM, OEM, PL/SQL, Data pump, ETL, SAP, Unix shell scripting, Oracle EBS, Perl, DB2, SOA suite, MySQL, Shareplex, AIX 5.1, UNIX, RMAN, Toad.

Apollo Hospitals, Hyderabad, INDIA May’ 2011– Dec’2012

Oracle DBA

Responsibilities:

Installed Oracle 9i and created databases to evaluate new features like Persistent INIT.ORA parameters (SPFILE), Oracle Flashback, Oracle Managed files Management, Automatic Undo space management, online operations like Table redefinition, online index rebuild

Installed Oracle 10g on Development and Test environments and upgraded the environments from Oracle 9i to 10g.

Responsible for User Management and Role Management using SQL authentication.

Experience configuring RMAN with Data Protector for Backup, Data Recovery & Data Protection

Applied patches of Oracle 9i, 8i (8.1.5/8.1.7) Enterprise Edition on Sun Solaris UNIX server and windows NT/2000 server.

Tested and Implemented procedures to detect the poor database performance, collecting required information, root cause analysis

Tuned and improved the performance of the Oracle databases.

Configured the Public Network/Private Interconnect for RAC.

Experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning.

Installed Golden Gate for replication in Test Environment.

Implemented Table Partitioning for large tables.

Involved in load testing and capacity planning of Production/Development databases.

Configured and implemented RMAN utility (8i/ 9i) for backups and recovery.

Developed shell scripts, PL/SQL procedures to monitor the databases and scheduled UNIX cron jobs and Oracle DBMS_JOBS.

Environment: Oracle 8i/9i/10g, SUN SOLARIS 5.9, RAC, ASM, HP-UX 11.0, Import/Export, OEM, SQL* LOADER, FTP, RMAN, STATSPACK, EXPLAIN PLAN, Perl, TKPROF, JDBC, MySQL, Data Guard, SQL, UNIX/Linux, PL/SQL, and Windows NT/2000.

Andhra Bank, Hyderabad, INDIA Nov’ 2009 – Apr’2011

Oracle Developer

Responsibilities:

Installing, configuring and administering ORACLE 9i/8i on LINUX and Solaris.

Worked in Development Support for Oracle based systems and Unix based Server environments

Perform capacity planning required to create and maintain database environments.

Partitioning strategies for very large tables. Partitioned large objects to improve the query performance and manageability.

Planning Backup and Recovery Strategies for various database environments.

Developed Recovery procedures that are applied for complete and incomplete recoveries depending on the type of failure.

Created PL/SQL and shell scripts to automate batch jobs through crontab.

Participated in Disaster Recovery Drills, documented database and application validation steps.

Writing scripts for the system and database for the effective functionality and report generation.

Applied High priority, security patches downloaded from Meta link.

Developing Hot, cold and logical backup scripts to automate the backup procedures.

Upgraded databases from Oracle 8i to Oracle 9i.

Monitoring Database for fragmentation and correcting them.

Experienced with Space Management and Security.

Management of table space growth, monitoring data files additions, extent growth

Performed Database, OS and application tuning.

Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.

Monitoring Scheduled jobs of the daily activities for the performance of all the databases.

Prepare the documents of the process and knowledge transferring about the project to the new team members.

Used Database export/import using exp& imp utilities to take logical backups.

Performed Data loads using SQL loader utilities.

Contact to the development team to solve the issues with the new enhancement releases.

Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases.

Environment: Oracle8i/9i, Linux, Solaris, PL/SQL, UNIX/Linux, Windows NT/2000, Toad.

Contact this candidate