Resume

Sign in

Data Oracle

Location:
Norcross, Georgia, United States
Posted:
October 05, 2016

Contact this candidate

SIVACHARAN PAPINENI

Sr. Oracle Database Administrator (248) ******* acwxdo@r.postjobfree.com

GOLDENGATE - RAC - EXADATA - 12C - DATAGUARD

PROFESSIONAL SUMMARY:

Over 9+ years of experience in as an Oracle Server Database Administration (12c/11g/10g/9i) in

Production and Development environment.

5+ years financial services experience

Involved in creation, installation, maintenance and administration of Databases in UNIX, LINUX,

AIX, Sun Solaris and WINDOWS Platforms.

Over 5+ years of experience in RAC (Real Application Cluster) implementation, monitoring and

administration.

Hands on experience on Advanced security option, Database Vault, Security Vault

Over 6+ years of experience in configuring and maintaining disaster recovery databases using

Dataguard, Expertise in implementing Active-Data Guard and monitoring

Over 6 years of experience using RMAN.

Over 5+ years of experience in configuring and monitoring databases through OEM10G/11G/12C

Over 5+ years of experience GoldenGate, migrated databases using GOLDENGATE v11, 12c,

Performed Datacenter Migration for all oracle databases using GoldenGate

Over 5+ years of experience, installing standalone servers on ASM 11g, maintain ASM in RAC and

Non-RAC Instances

Expertise in Oracle Enterprise Manager (OEM), TOAD, Erwin- Experience in Logical and

Physical Design of Databases for OLTP and Data Warehouse.

Over 1+ year experience in migrating databases to EXADATA x3-4 machine.

Manage RAC environment for Day to Day Database administrator, Performance Tuning.

Migrate over 3 TB data from Across the Platform (From AIX to LINUX )Strong trouble shooting,

problem solving, analytical and design skills.

Worked in 24x7 production environment and provided on-call and day-to-day support Creating,

Updating, Altering Table-spaces, Indexes, Tables, Views, Synonyms, Profile, Role, Privileges

Managing the production database for Oracle and resizing the space of database, datafiles,

tablespaces and archive logs

Creating/Managing users profiles and analyzing their privileges and table-space quotas

Strong experience in administration and database monitoring, Experience in Oracle Security

management.

Excellent experience in Oracle Migration from 10g to 11g Databases.

Used BCV split/Data Guard technology to migrate over 13 TB Database .

Supporting Data Warehouse Database i.e. over 30 TB in size.

Expertise in Oracle database replication, Expertise in Oracle 11g/10g Data Guard and standby

databases, Snapshot maintenance and creation.

Expertise in handling Very Large Database (VLDB) and OLTP environment.

Expert in ORACLE Database Administration including planning/implementing backup/recovery

strategies using RMAN and without RMAN.

Expertise in installation and configuration of Oracle and large databases on Unix Operating System.

Production maintenance and supporting (7x24).

Extensive experience implementing Disaster Recovery Plans.

Excellent knowledge in Different types of partitioning.

Involved in coordination of distributed teams to increase productivity and reduce turnaround times.

Seeking a position where my experience and capabilities can be used to contribute to a company's

objectives.

TECHNICAL SKILLS:

Operating Red Hat Linux RHEL 3.x, 4.x, 5.x, 6.x, HP-UX 10.x, 11.x,

Systems Sun Solaris 9.0/10.0, AIX 5.1, 5.2

Data Bases Oracle 12c/11g/10g/9i, Oracle 12c, 11g/10g Real Application Cluster (RAC),

ASM, MySQL, SQL SERVER 2008/2012, Mongo DB

Languages SQL, PL/SQL, UNIX Shell Scripting

Tools/ RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import,

Utilities RMAN, NETCA, DBCA, TOAD, Exadata, Patch Management, SQLNET,

OEMCTL, Dbverify, ODBC, Export/Import, Data pump, Data-Guard, Erwin,

OEL, Log-miner, MS Visio, VERITAS Net Backup, BMC remedy,

Pac 2000, VMware, Crontab, oradebug

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR

Terminal Putty, Telnet, FTP, TOAD

Emulation

PROFESSIONAL EXPERIENCE:

VISTEX Chicago, IL

Sr. Oracle DBA Sep 2014 -Till Date.

The software and services provided by Vistex are optimized by industry to deliver an end-to-end solution for

the design, management and administration of the entire spectrum of Go-to-Market programs. Vistex

provides solutions that equip you to efficiently manage dealer incentives, purchase rebates, promotions and

claims, special pricing, co-op and MDF and channel inventory tracking, creating a comprehensive solution

that offers end-to-end visibility into revenue and gross-to-net profit.

Responsibilities:

Worked as Operational Database Admin in 24x7 production environment and provided on-call and

day-to-day support.

Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment. -

Used ocrconfig, srvctl and crsctl utilities in RAC / cluster environment.

Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle cluster-ware) & also

issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net

configuration files.

Used ASMCA to create disk groups in RAC environment.

Configured dataguard for Two Node RAC.

Migrated ASM Database to 11g R2 Two Node RAC ASM.

Installed 12C RAC CLUSTER and created 12.1.0.2 in memory databases on TEST and DEV

servers.

Installed Data Guard and standby databases. Snapshot maintenance and creation.

Mentor other DBAs in effective use of RMAN software and my scripts.

Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle

internals.

Advanced Backup and Recovery using Oracles RMAN software; used offline/online. or recovery in

a production environment via Korn shell scripting.

Credential Store is implemented in Oracle GOLDENGATE as an autologin wallet within the Oracle

Credential Store Framework (CSF).

Installed and configured Oracle GOLDENGATE on AIX 6.1 and RHEL 6.3.

Enabled ENABLE_GOLDENGATE_REPLICATION, STREAMS_POOL_SIZE parameters for

11.2.0.4+ databases to support integrated capture in goldengate environment.

Performed migration using GoldenGate from sunsolaris9 to O.E.Linux 6.1 platforms

Used report files, trail files, ggserror log to troubleshoot oracle goldengate issues in environment.

Used different tools in Goldengate environment like defgen, logdump and convchk to manage

Oracle Goldengate environment.

Tested Oracle Goldengate REPLICAT apply run rate with different parameters for large volume

tables.

Used VERIDATA to compare data between instances replicated by goldengate.

Upgraded databases in RAC and NON-RAC databases.

Migrated databases to EXADATA x3-4 machine, worked with oracle in configuring environment.

Upgraded OPATCH UTILITY version to 11.2.0.6 and applied patches to Oracle homes- Refreshing

databases using RMAN and Data-pump. Used 11g new feature recovery advisor in RMAN.

Migrated databases from 11.2.0.4 to 12c.

Hands on experience with OEM 12c, installing agent, creating templates, daily health check-up of

the database using OEM

Worked on Issues with block change tracking in RMAN& also flash recovery area.

Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization

parameters, I/O, Memory and Operating System kernel parameters.

Replicated to a disaster recovery site for increased server manageability and availability.

Implemented Active-dataguard with real-time apply and monitored.

Implementing and maintaining database security (create and maintain users, roles and assign

privileges).

Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization

parameters, I/O, Memory and Operating System kernel parameters.

Managed appropriate use of free-space within table-spaces, reclaimed space whenever possible.

Reorganized tables and indexes within databases when needed.

Used DBMS_SCHEDULER for scheduling jobs on databases.

Verify all scheduled jobs, RMAN jobs have run successfully without any issues.

Generated AWR, ASH, ADDM reports using OEM 11G/12C and manually to analyze the database

performance.

Worked on Refreshing materialized views, creating views, triggers and new tables according to

requirement.

Created SQL profiles to improve performance of SQLs in environment, Used SQL TUNING

ADVISOR from OEM, EXPLAIN PLAN to tune long running queries on database.

Worked on rebuilding indexes and partitioning tables, Used ADRCI to check health and errors on

databases.

Clear documentation was prepared on all the tasks performed.

Environment: Oracle 11g/12c, RAC, ASM and Dataguard . Oracle Goldengate, RMAN, Performance

Tuning, TOAD 11.x, OEM 11g/12c, Solaris/Linux, EXADATA SQL, PUTTY, EXPLAIN PLAN, AWR,

ADDM, ASH, TTS FLASHBACK, DATAPUMPS.

Grange Insurance Detroit, MI

Sr. Oracle DBA Oct 2012 - Aug 2014.

Grange Mutual Casualty Company, commonly known as Grange Insurance, is an American

insurance company. Grange markets its products exclusively through a network of about 3,600 independent

agents to offer home, auto, life, and business insurance protection to policyholders.

Responsibilities:

Checking Databases Backup and Restore validity periodically, and Data refreshes from Production to

Non-Production environment, Creation Duplicate Databases using RMAN Backups.

Involved in Design and implementation of oracle 11g Data Guard both physical/logical

Standby databases for high availability and disaster recovery.

Implementation of High Availability solutions with Oracle 12c,11g RAC,10g RAC,

Standby Database (Active Data Guard), Replication.

Responsible for Installation of RAC and Managing RAC Environment efficiently

Installation and configuration of Oracle Enterprise Manager Cloud Control 12c

WebLogic performance tuning and upgrade to 12c and 11g

Implemented Monitoring Templates and Incident Rule notifications using OEM 12C

for database alerting.

Worked extensively on 12C OEM and configured DB alerts for DBA

Effectively made use of Indexes, Table Partitioning, Collections, Analytical functions, Materialized

Views & Query Re-Write.

Supported functional data warehouse projects.

Worked with database export & import scripts to backup database structures and automation

procedures

Installation, Configuration, Upgrade, patching of Oracle RDBMS and applications Work on different

versions of Databases with OEM Grid control to maintain the database effectively.

Configured different levels of replication such as DDL replication, DML replication for table level,

schema level, database level using Golden Gate.

Implemented classic Golden gate replication as well as integrated replication. Implementing and

maintaining database security (create and maintain users, roles and assign privileges)

Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques,

Explain Plan, Trace, Hints and Tkprof. SQL, PL/SQL and UNIX shell scripting.

Monitored the Applications and database using OEM and OAM.

Document and communicate changes to the OLTP, OLAP systems and data warehouse teams,

including Data Modeling, ETL and Database teams.

Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM)

in RAC for Performance Tuning.

Built 4 node RAC 10gr2 Standby database and set up DG Broker

Setup of High Availability of the database using RAC, Standby, Data guard.

DBA activities such as configuring Grid events, Regular Backup's, Replication, Tuning, and

troubleshooting performance issues.

Maintain, upgrade, troubleshoot all enterprise oracle and SQL server databases

Install and Configure OracleFusion Applications 11.1.5 on Exalogic/Exadata -- setup and Maintain

system and configurations.

Advanced Backup and Recovery using Oracle RMAN software; used offline/online for recovery in

a production environment via Kornshell scripting.

Provide development and production support related to database

Perform other regular DBA activities including space management and performance monitoring.

Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.

Design, development, testing, performance tuning, deployment, and support in Data warehouse

system

Performance Tuning of Databases, Oracle instances, and Applications. Finding Performance

Bottlenecks using STATSPACK, EXPLAINPLAN, SQLTRACE, TKPROF, AWR, and ADDM

Upgrade and Migration of Databases from 10.2.0.5 to 11.2.0.2 and applying patches whenever

required.

Environment: ORACLE, SQL*Plus,OEM/12c,Exadata V1/V2/X2-2/X2-8, PL/SQL, Oracle

11g/10g,RAC, Microsoft SQL Server 2005 & 2008,DB2, Golden gate, Shell scripting, Red Hat Linux

5,Solaris 10,Unix, VCS, Oracle Enterprise Manager, Data guard, ASM, PL/SQL, RMAN, Toad.

First National Bank (Financial Services) Kansas City, MO

Sr. Oracle DBA Oct 2011- Sep 2012 .

Responsibilities:

Worked in data center migration project and Worked in 24x7 production environment and provided

on-call and day-to-day support.

Installing & configuring Oracle cluster-ware & Database Software (Troubleshooting using cluvfy

& handling common issues that arise during integration of the whole bugs, network issues,

configuration files issues, OCR issue, deinstallation & cleanup of cluster-ware)

Performed various activities in Real Application Cluster, created databases using DBCA, used

SRVCTL and CRSCTL to manage services and resources on cluster.

Used cluster-ware logs to troubleshoot Real Application Cluster environment.

Worked on ASM in cluster environment, Used SYSASM to create disk groups with different

redundancy levels.

Worked on creating ASM dynamic volume.

Changes were made dynamically whenever possible to fulfil high-availability requirements.

Maintained standby databases, in both local and remote locations, for fail-over purposes.

Strategic involvement with client for Server virtualization and manageability of infrastructure.

Involved in implementing Solaris Containers to achieve Server Virtualization.

Data center Migration using Data Guard.

Used Dataguard broker to perform operations in dataguard environment.

Monitored system resource availability and responded to system memory and data issues.

Installed and configured Oracle GOLDENGATE on light-ray application and replicated base tables

to reporting instance.

Configured uni-directional replication using goldengate replicated data across instances for load

balancing.

Implemented Goldengate lag monitoring scripts, discard reports and process monitoring scripts in

Goldengate environment.

Cloning databases using RMAN in test & dev environment.

Refreshing and migrating data across prod, Test & dev environments using DATAPUMP

Implementing and maintaining database security (create and maintain users, roles and assign

privileges)

Engaged in monitoring free-space within table-spaces and reclaimed space whenever needed.

Monitored the production Oracle database alert logs for database errors.

Worked in build stage and performed various operations creating databases, updating, altering

tablespaces, indexes, tables, views, synonyms, profile, role and privileges, testing databases

parameters in test, dev and production environment

Upgraded databases from 10g to 11g, upgraded patches using opatch utility.

Applied patches to database home to 11.2.0.1 and 11.2.0.2 and upgraded databases.

Estimated growth of database size by detail analysis of the company's future policies and generating

reports for the management to act in advance.

Clear documentation was prepared on all the tasks performed.

Environment: Oracle RAC, ASM, Data guard and GOLDENGATE. SHAREPLEX, Oracle 10g/11g,

SQL server, OEM, GRID control 10g/11g, AWR, EXPLAIN PLAN, TOAD, RMAN, RHEL 5.x, AIX

5.x, HP UNIX.

ICICI BANK (Financial Services) Noida, India

ORACLE DBA April 2008- Sep 2011

Responsibilities:

Provided DBA Services to improve their performance of databases i.e. supported company that works

with Oracle on a highly OLTP and DW environment.

Setup Disaster Recovery solutions (Dataguard), Tuning Code, Resolved bottleneck problems.

Applied Patches, Backup and recovery (with RMAN and Shell Scripts) over high volume Terabyte

Databases.

Installed and configured Oracle RAC.

Helped other team to migrate from Oracle 10g to Oracle 11gr2

Installed standalone servers on ASM 11g, worked on creating disk groups, partitioning raw-devices .

Used ASMCA extensively to create disk groups in ASM environment

Installed and configured Oracle databases on severs RHEL.5.5 and RHEL 5.8

Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.

Installed & managed 10g OEM grid monitoring solution and deployed agents.

Performed Logical backup using and full/partial export/import and Data Pump.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and

Logical backups.

Created bit-map Indexes for data warehouse databases.

Worked with ETL team for understating mappings for dimensions and facts.

Configured Physical and Logical Standby database for reporting environment.

Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do

table level and full database defragmentation.

Clear documentation was prepared on all the processes like program specification, bugs fixing log &

change requests for future reference.

Proactively managed the databases; set up notifications, alarms using shell scripts for managing any

exceptions in day to day management of the database

Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER,

STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.

Managing table spaces, user profiles, indexes, storage parameters -- Develop table structures,

PL*SQL stored procedures and database triggers to implement.

Responsible to provide 24x7 database administrative activities over different database servers

Environment: Oracle RAC 10g/11g, RMAN, OEM and ASM. RHEL 4.x,5.5,RHEL 5.8, Sun Solaris,

TOAD, IMPORT/EXPORT, Windows NT/2000, ETL.

Charm Info systems Pvt.ltd Bangalore, India.

ORACLE DBA June 2006

April2008

Responsibilities:

Monitored performance of database using AWR report, ASH.

Participated in group meetings and shared my ideas on different issues.

Created and Monitored table-space sizes. Worked on undo table-space size and changed undo

retention time as per the requirements.

Created Indexes on tables and performed rebuilding of Indexes.

Used Explain plan, SQL trace and TKPROF to analyze the database and different SQL queries.

Had good experience in working with TOAD.

Worked with other team to convert data dictionary tablespaces to locally managed tablespaces

Performed cold and hot backups.

Took the privilege to install database using DBCA and manually.

Added new datafiles to the existing tablespaces.

Multiplexed controlfiles and altered different parameters depending on the requirement.

Created listeners and tnsnames to the new databases using NETCA and manually.

Good experience on creating views and materialized views on the tables.

Gathered statistics using packages at different levels (statistics on table, schema) etc.

Created snap shots manually to compare and take the AWR report.

Placed small tables in the memory to decrease the response time and made the tables default after the

requirement.

Worked on the Change Requests taking minimum downtime.

Performed exports and imports and refreshed data across instances.

Developed, executed and managed Oracle PL/SQL such as procedures, functions, packages and

database triggers

Used RMAN to take backups

Environment: Oracle 9i/10g, RHEL 4.x, 5.x, TOAD, Oracle Windows, OEM 9.2.0/10g, RMAN,

Performance Tuning.

EDUCATION:

Bachelors degree in Mechanical engineering

MIC College Of Technology, VIJAYAWADA, INDIA.



Contact this candidate