Maganti Harika

Sr Oracle Database Administrator

Ph: 816-***-****

Email: acw9i7@r.postjobfree.com

Summary

Over 5+ years of experience, including 4+ years as DBA in development and production environments Ensuring Oracle database systems operate efficiently and securely, Skilled in designing and implementing complete life cycle client servers and database applications with various development tools and languages. Managing internal databases, from planning and testing stages through implementation and support and In-depth understanding of security and backup procedures to ensure database integrity, Background in developing backup and disaster recovery plans for nationwide offices and Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.

Experience in Installation, configuration of Oracle RAC 10g, 11g, 12c, developed 2,3,4 node RAC environments for a 1TB+ database

Implemented strategy for partitioning and management of historical data tables in RAC

Experience in Upgrading databases (10g R2 to 11g, 11g R2 to 12cR1)

Excellent experience in OLTP database systems, implementing and managing large Oracle databases (VLDB)

Installed Oracle Clusterware to provide infrastructure for RAC and configured 2,3,4 node Oracle 11g RAC / 12c RAC with EMC.

Experienced in setting up and installation and configuration of release 11g RAC/10g R1 RAC with ASM EMC Storage.

Planned and implemented DR & high availability solutions using OEL 11g Standby Database using Oracle Data Guard, 11g and 12c RAC.

Designed and implemented Oracle Real Application Clusters (RAC) on Solaris for an OLTP application with Transaction Application Failover and high transaction volume.

Proficient in using OEM and RMAN Upgrade and Migration of Databases from Oracle 11g/12c

Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Performance Tuning, capacity planning, script development, and documentation.

Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research.

Expertise in Oracle GoldenGate installation, configuration, and troubleshooting GoldenGate issues.

Experience in using GoldenGate in moving large volumes of transactional data, with minimal impact to online systems.

Hands on experience with Installation, Configuration, Migrations, Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery and Patching, upgrading and administering 40 Terabytes of Oracle Databases on Oracle 12c/11g/10g/9i

Good knowledge on Oracle streams, data guard physical standby databases, working knowledge on BCV’S, SRDF, and managing of partitions and clustering of tables.

Experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using Load testing tools

Configuring DB Links for users located remotely and Expertise in supporting replication with snapshots, Materialized Views and Streams

Installation, configuration, upgrade and performance tuning of Oracle RAC

Experience with OEM, TOAD, Oracle grid-control and Database Tuning, PL/SQL tuning using explain plan and used HINTS extensively to optimize the SQL statements, used cost based approach extensively and also used rule based methods to tune the SQL

Expertise in maintaining Database Security using auditing

Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, Logical and Physical database design.

Experience on Script Programming using Korn shell, bash shell, Perl, Awk and knowledge on archiving tolls like tar, gunzip, backup, auditing both external auditing and internal auditing, experience on various UNIX platform like Redhat, AIX

Management of schemas, objects & partitioning the tables & indexes.

Worked on Advanced Replication including synchronous and asynchronous scenarios

Experience with Oracle 11g and 12c features: Flash-Back Recovery, Datapump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin, In Memory Column Store 12c, Automatic Data Optimization, In Database Archiving, Temp_undo_enabled, Invisible Column, Pluggable databases, Datapatch

Solid experience with Oracle technology architecture, Oracle and Real Application Clusters.

Knowledge of Data transfer between SQL Server and Oracle.

Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Excellent analytical and problem-solving skills and Result oriented, self-motivated, team player, ability to work independently.

Excellent written and verbal communication skills

PROFESSIONAL EXPERIENCE:

Client: TALENT9 INC, Hendon, VA

Date: Dec 2015 - Present

Role: Senior Oracle DBA

Responsibilities:

24x7 Oracle Production Database Administration including Oracle 10g/11g/12c RAC.

Installed, configured and maintained Oracle Databases and Responsible for installing and configuring GoldenGate 12c on Oracle Servers

Install and configure Oracle GoldenGate, Establishing standards, policies, and procedures for GoldenGate replication administration

Configured Integrated extract using downstream capture, used different utilities logdump, defgen to manage golden gate environment

Installed and configured GoldenGate v11 and 12c on AIX 6.1 and RHEL 5.8,6.7 platforms and Configured Integrated Extract and Replicat on Oracle multitenant database 12.1.0.2

Configured Extract and Replicate pumps for golden gate replication 11g/12c and Troubleshooting issues in GOLDENGATE Environment using report files & logdump

Performed Cross platform migration and used Oracle Golden Gate to migrate databases from Aix to Linux as a part of u12 Cloud migration project

Performed Zero-Down Time migration from AIX to RHEL using Expdp and GoldenGate and process improvement for GoldenGate Environment by proactive monitoring using Shell scripts

Installed Oracle GoldenGate Veridata and Agents and created jobs compare data between instances and Used Logdump Utility to Investigate data on the trail and defgen utility to create definition files used for replication

Configured BI-DIRECTIONAL replication and replicated tables between instances and used CDR parameters to resolve conflicts

Managing, troubleshooting, and resolving oracle database, RAC and applications issues.

Involved in Upgrade/Migration of the oracle databases from Oracle 11g to Oracle 12c and Sun Solaris to OEL (Oracle Enterprise Linux)

Designed and implemented Oracle Real Application Clusters (RAC) on Solaris with EMC Storage for an OLTP application with Transaction Application Failover and high transaction volume

Monitored/managed 2,3 node RAC environments, databases using OEM-Grid control, and RMAN database backup and recovery

Managing health check and potential fix using orachk, Crsctl and Srvctl in clusters

Planned and implemented high availability solutions using Oracle 12c RAC, Standby Database using Oracle Data Guard

Implementation of High Availability solutions with Oracle 12cg RAC, Physical and Active Standby Databases (Data Guard)

Configured Service Level Agreement (SLA) for applications accessing standby databases (ACTIVE Data Guard) and applied logs with delay to prevent Block corruption

Developed 2 node RAC environments for a 2+ TB database and Implementing Data guard on this RAC environment with another RAC Standby Database

Installed and configured OEM Grid Control, deployed agents registering and monitoring databases

Enabling and analyzing trace files, optimal Space utilization in table space by avoiding fragmentation and Usage of Partitions to improve the query performance and manageability.

Installation of Oracle RDBMS server software and version upgrades.

Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.)

SQL and PL/SQL Programming and Developed back-end logic for business applications, e.g. views, procedures/functions, triggers.

Developed scripts and reports using SQL, PL/SQL and Perl and Standby Database (Data Guard) setup and configuring DB links

Installation and configuration of Oracle Client software and Tools.

Established best practices and best procedures for database administration. Responsible for Software life-cycle support to include migration of all custom application changes through four different instances to production

Analyzed the user requirements and designed partitioned tables for improving performance of Data marts and Responsible for continuous database monitoring and reorganization for ensuring performance

Worked with developers and Developed Packages and customized functions and Triggers based upon the business logics

Configured multiple weblogic domains including machines, manager servers, node managers and cluster environments

Used WebLogic 12c console to create new Users for managing GoldenGate Veridata, and granting privileges

Creating services using “dbms_service” on pluggable databases in both RAC and NON RAC environments

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 them to the grid control

Managing Oracle Enterprise Manager Grid control 11g/12c for monitoring databases

OEM Grid control 11g and 12c to monitor all databases and performing monitoring and performance tuning and Defining and Setting backup and recovery procedures.

Performed and tuned using AWR, ASH, OEM Grid and Tkprof Oracle Databases.

Tuning the database using statspack on standby database and custom scripts

Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.

Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK

Writing Shell Scripts for managing day-to-day activities and automation of backup

Performed partition maintenance and automated the process of creating new partitions as and when required

Worked with offshore team and coordinating database monitoring, scheduled calls to discuss database issues and Assisting in implementation of change control process in production and

Handled daily production problems/change requests (DBCRS) with Oracle and 24x7 production DBA support, Application and development DBA

Environment: ORACLE, SQL Server, SQL*Plus, OEL 10g/11g/12c, Red Hat Linux 6.x, RAC 11Gr2, 12C, Solaris10, IBM, AIX-6.1, Data Guard 11g, 12c, Golden Gate 11g, 12c, Web Logic 12c, ASM, PL/SQL, RMAN, Toad, OEM GRID, EMC, NetApp, Maria DB, Net Backup

Client: Smart software, Hyderabad, India

Date: Aug 2011 - June 2014

Role: Mid-Level Oracle DBA

Responsibilities:

Implementation of High Availability solutions with Oracle RAC, Physical Standby Databases and 24x7 Oracle Production Database Administration including Oracle 11g RAC Administration and management

Installed and configured OEM Grid Control 12c and mass deployment of agents

Managing, troubleshooting, and resolving oracle database, RAC and applications issues.

Refresh/Cloning of Database and applications for development and testing purpose and Performed Oracle Database upgrades from 10.2.0.4 to 11.2.0.3 in AIX RAC environment.

Implementation and Configuration of 12C OEM & Oracle Management Server for maintenance and monitoring

Involved in Database Administration, Installation, Maintenance and development of Life ray for medi-care and Upgrade/Migrated the production and development of databases to Exadata Machine x2-8 and worked with Oracle platinum support to apply patches on cluster

Used Exadata features smart scan and tested storage Index’s and calculated cell offload efficiency of sql’s deployed

Performing daily Archive log file backup and checking Alert Log files

Monitoring the table space growth and resizing the table space on RAC environment.

Using RMAN & User Managed backup methods for better control.

Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.

Review alert logs and dump files to check for any problems related to the database/user.

Installation and Maintenance of GoldenGate Replication, Veridata

Perform database cloning, Expdp, Impdp to setup identical databases in the production and development environments.

Upgrade and Migrated the production and development databases from 10g to 11g.

Involved in Database sizing, Capacity Planning.

Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine-tuned for better performance

Presenting user-friendly reports, and providing training to end users on reporting functions

Involved in monitoring the lock and block processes, releasing locks in case of resource blockage and gathering statistics.

Experience with Repository Manager to import Metadata for sources and targets and the mapping designer to map source to the target.

Performing Online and Offline database backups on schedule and Scripting (shell) of automated backup for Cold, Hot backups and also defining and Setting backup and recovery procedures

Creating ODBC for users and Application Developers and Co-ordination has been extended to Application developers for coding to improve the performance of the database

Exported data from all Units and Automated the procedures and interface programs using Oracle Advanced Queuing, Oracle Enterprise Manager

Configured and administered WebLogic server with Oracle 10g and 11g databases and Configured WebLogic Node manager for administer the Managed servers

Configured and administered Connection pools, multi connection pools and Data Source for JDBC connections

Troubleshooted emerging application issues from WebLogic configuration side

Applied the patches to the WebLogic servers and Troubleshooting multicast issues using WebLogic Java Utility Multicast Test

Expertise in developing web applications using Java and related technologies and integration issue to figure out the SOA issues from SOA monitor with SOA users and Web Services like SOAP and REST

Developed New Package to call the Fusion Middleware OSB Web Services from the Oracle E-Business Suite database and pass the parameters to them.

Created users and set permissions and Managed database security using groups, roles and handled number of databases in different places

Created database objects and managed the permission access on the objects with necessary security

Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection. Migrated applications to the AWS cloud and Deployed applications on AWS by using Elastic BeanStalk

Troubleshoot the automation of Installing and configuring applications in the test

Supporting different projects in build and Release SCM effort and Deployment of Release to various QA and UAT environments

Environment: ORACLE, AWS Cloud, SQL Server, SQL*Plus, OEL 10g/11g, Red Hat Linux 5.x, IBM, AIX-6.1, Data Guard 10g, 11g, Golden Gate 11g, Exadata, ASM, PL/SQL, RMAN, Toad, WebLogic Server, REST, SOAP, SOA Fusion Middleware, OEM GRID, SQL * Plus, OEM, Erwin Data Modeler

Education:

Bachelor in Science and Technology (ANU, INDIA)

Masters in Industrial Management (PSU, USA)

Contact this candidate