Resume

Sign in

Data Manager

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

Contact this candidate

Resume:

MAHESH BAVINENI

Oracle Database Administrator

Mobile – +1-678-***-****

acwxyw@r.postjobfree.com

PROFESSIONAL SUMMARY

9+years of experience in IT industry, worked as Oracle Database Administrator in Retail, Ecommerce, Financing and Banking segments,encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Monitoring and tuning RAC, Data Guard, Grid Control,Worked on Sybase,OVD.Extensive Worked on databases in mission critical large OLTP systems in a variety of environments like Linux, HP-UX, IBM-AIX, Sun Solaris, RHEL and Windows.

Expert with planning, creation, administration and troubleshooting of Oracle 12c/11g/10g/9i, OLTP (multiple instances)/OLAP databases in production, Good experience in Oracle APEX.

Managed users, privileges, profiles, schemas using Grid Control of Oracle Enterprise Manager and Involved in registering a database in grid control.

Hands on experience in implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM on 10g/11g/12c )

Expertise in trouble cluster ware startup issues

worked on Exadata X3-2, migrated databases on X3-2 machine

Experience on Data Replication using Snapshot, Materialized views, import/export and Oracle Golden Gate & Data guard.

Implemented disaster recovery databases using data guard & configured physical standby on 10g/11g/12c.

Oracle Golden gate installation, configuration, troubleshooting Golden Gate Extract and Replicat files.

Solid experience in Database backup concepts and options such as user-managed backup, RMAN-managed backup, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies. Implemented database security using Transparent Data Encryption.

Created and monitored database objects like Tables, Indexes, Views, Users and DB links.

Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL*Loader and External tables.

Proficient in setting up the network connections (i.e. setting up Listener and TCP/IP Connections).

Performance tuning of the database SQL Tuning, Used Tuning utilities like STATSPACK, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Expertise in Using Explain Plan for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.

Writing scripts in the UNIX based environments for Managing the user's roles and privileges, scheduled backups (using data-pump / cold backups), manage statistics, Disk space management.

Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various Unix Shell Scripting

Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.

Worked along with System and Network Administrators for minimal downtime of the Databases

Involved in doing extensive administrative tasks on UNIX & Red Hat Linux server Databases

Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment

Supported machine critical application databases by giving 24x7 supports.

TECHNICAL SKILLS

Database

Oracle 12c, 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i

Oracle Products

Real Application Cluster, Golden Gate, Data guard, Import and Export, Data pumps, Oracle Wallet Management, Automatic Storage Management,RecoveryManager,Oracle10g/11g/12c(GridControl),OracleRealApplication Cluster,RMAN, Transparent Data Encryption, OID, OUD, OVD.

Operating System

Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL), Sun Solaris, Windows XP/2003/2008, AIX 6.1

Languages

SQL, PL/SQL, Unix shell scripting

Tools& Utilities

SQL Trace and SQL tuning Advisory, SQL* plus, ADDM,DBCA, Log Miner, BMC Remedy, TKPROF, AWR, ASH, Toad, Putty, ERWIN, ETL tool

EDUCATIONAL QUALIFICATIONS

Bachelor of Technology in Computer Science from Jawaharlal Nehru Technological University (JNTU)

PROFESSIONAL EXPERIENCE

Wells Fargo, St Louis, MO March’ 15 – TILLDATE

Role: Oracle DBA

Responsibilities:

Administering and supporting Oracle database environment over 120 databases, up to 15TB, utilizing advanced concepts such as Data Guard and Oracle RAC combined on all the production, development and testing environments.

Installed, configured and maintained Oracle 2/3 Node 12c RAC

Performed various operations relinking protocol library, implemented 12c Transaction Guard while configuring services, deployed instance caging

created container and pluggable databases in 12c RAC and created services configured with PDB

Registered databases in Oracle Virtual Directory.

Configured database servers to use Kerberos authentication.

Involved in end user security mapping, created global roles and users in database and requested EUSM mapping to active directory security groups.

Involved in creating and deploying ldap.ora on client and server side to make use of Oracle Internet Directory.

Wrote ldap queries to find the status of db registration in OUD and OVD.

Used ldap queries to find the causes for authentication issues with keytabs.

Involved in troubleshooting the issues with End User Security mapping and also Kerberos authentication issues

Performed root cause analysis and documented resolution for EUSM and Kerberos Issues

Worked on ASMCA and used SYSASM for created disks, drop and add disks to disk groups and tuning ASM parameters according to requirement

Configured disaster recovery databases using data guard and performed DRTesting Performedswitchover and monitor using DGMGRL

Worked on Active data guard and performed Troubleshooting data guard environment

Involved in Oracle Golden gate installation, configuration, troubleshooting Golden Gate Extract and Replicat files.

used Defgen utility to create definition files in Goldengate

Migrated databases using Goldengate with minimal downtime

Involved in up-gradation of databases from 10g to 11g and applied patch set and interim patches whenever required

Upgradeddevelopment and production databases from 10g to11g on Linux

Involved in Installation and Configuration of Management agents in 12C(CloudControl)

Used 12C/11G grid controlMaintenance, tuning and monitoring databases

Providing Application Support for performance and database related issues

worked with teamsand Involved in building Databases for BI (Business Intelligence) Applications.

Worked on storage Indexes and tested their behavior with different query predicate conditions

Performed cross platform migration of databases on Solaris 10g to Linux 11g using GoldenGate

Documented and logged errors in GOLDENGATE environment and worked on OLTP Compression

Extensively used Log dump utility and define utility for resolving issues in GoldenGate

Extensively used data pump for migrating data between platforms

Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.

Implementation of Flashback Technology and cloned databases for development and test environments using Recovery Manager

Involved in scheduling incremental, cumulative and full backups and configured retention policy Using RMAN

Worked in Data Warehouse environment, involved in activities like partitioning tables, Creating materialized views and reorganizing index’s

Database Sizing, Table space Management and Rollback Table space Management, Transaction Management and Security Administration.

Used 10046 Trace for tracing client connections, sql statements and bind variables

Implemented database security using Transparent Data Encryption

Configured Oracle Wallet for Transparent Data Encryption (TDE).

Strong understanding of business processes with good experience in development.

Strong knowledge in SDLC and all phases of Application development.

Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process.

Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.

A logical, analytical thinker with exceptional databse skills having rich experience as a Oracle PL/SQL developer.

Encrypted sensitive information like Tables, table spaces, Encrypted columns within the database and implemented Encryption keys on relational database management systems by using TDE.

Performed Explain Plan analysis for Query Optimization and SQL tuning

Performed Database and SQL tuning by using various Tools like AWR, ADDR, ASH, TKPROF, Explain Plan, SQL Advisor and optimizer hints.

Involved in managing end-end lifecycle of user identities across the enterprise resources using Oracle IDM (Identity Management).

Effective Production Support and off hour support, support handover, off-shore co-ordination.

Environment:Oracle 11gR2/12C, OVD, Solaris/Linux, SQL, OEM, RAC, ASM, Data guard 10g/11g, GoldenGate, putty, RMAN, Explain Plan, AWR, ADDM, ASH, TTS, Flashback, Data pumps, OID, OUD, OVD, LDAP.

Adecco North America, Jacksonville, FL Jan’ 12 – Dec’ 14

Role: Sr.Oracle DBA

Responsibilities:

Worked as Operation DBA and having good experience working in build-stage Planned and Implemented High Availability using RAC and Data guard

Worked in build stage, Installed and configured oracle software, databases from scratch

Installed and configured RAC (2node) & created Databases using dbca

Created custom services for RAC database for distribution of load across the nodes.

Performed various operations on X3-2 machine, bringing down oracle cluster-ware resources, created ASM disk groups and managed grid infrastructure network resources

Involved in configuring thresholds for cell metrics using CELLCLI

worked with Application team, for indentify cell offload execution plans, enabling and disabling smart scan on asm disk group in x3-2 environment

Migrated databases into EXADATA RAC- databases, x3-2 successfully using data pump

Installed standalone servers on ASM, created disk groups on ASM

Worked on ASM and Performed SAN migration

Performed Migration of databases from Hp UNIX to Oracle 11.2.0.x on RHEL.

Implemented load balancing using 11.2.1.0.6 Oracle Golden gate,

Installed and configured, troubleshooting Golden Gate Extract, pump and Replicat processes on AIX 5.x servers

Configured disaster recovery databases using DATAGUARD & worked on 11g new feature active data guard.

Converted physical standby databases to snapshot standby, performed manual switch over to DR servers

Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers.

Applied patches on standalone servers using OPatch utility and upgraded OPatch utility from lower version to Higher version.

Involved in migration of databases from standalone (ASM) to cluster Environment.

Maintained catalog server and registered databases in catalog server.

Using SQL Tuning Advisor and SQL Access Advisor to fix bad SQL.

Having Good experience in monitoring databases through grid control.

Installed and configured Oracle Enterprise Manager 11 g Grid Control.

Worked on Performance Tuning (11g &10g) on Solaris 10, AIX 5.2.

Implemented data transfer using Data Pumps and Export/Import utilities.

Involved in scheduling incremental, cumulative and full backups and configured retention policy.

Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.

Implemented advanced features AWR, ADDM reports for monitoring database performance, Modified and updated the Performance tuning scripts.

Involved in gathering requirements from end users.

Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

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

Mentoring Level-II DBA’s and involved in 24x7 Production-on calls supports for all the production databases with Oracle.

Environment: Oracle 11g/10g, Red Hat Linux 4.x, 5,x, Hp-Unix 7.1, RMAN, SQL server, RAC 10g/11g,EXADATA X3-2, CELLCLI, IORM, Data Guard, OEM, Grid Control 10g/11g, STATSPACK, AWR, Explain Plan.

Bank of New York, Brooklyn, NY June’ 10 – December’11

Role: Oracle DBA

Responsibilities:

Worked on Oracle Database 10g 2 node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.

Configured Oracle Data guard for Oracle Disaster recovery.

Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Implemented Oracle database backup &recovery solutions using RMAN.

Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.

Performed large batch jobs, and tuning of SQL queries and database systems.

Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.

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

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Worked with Data pump to take the logical backups of databases.

Experienced in performing Point in time recovery using RMAN.

Involved in designing logical and physical data models using Erwin.

Created indexes to facilitate easy user interface implementation and tuning.

Worked on Databases through Business Intelligence tool.

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

Environment:Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle RAC, Data-Guard,TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Commerce Bank, Bloomington IL Feb’ 08 – June’ 2010

Role: Oracle DBA

Responsibilities:

Provide backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade support for approximately 40 Oracle databases.

Administration and support of Oracle Application Server 9i and 10g.

Installation and maintenance of Oracle 10g Data Guard.

Involved in backup and recovery using Recovery Manager

Standby database setup via Data guard for Database Disaster Recovery.

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

Database Restore using RMAN, Cold Backup and Export/Import.

Responsible for planning, testing and implementing different backup and recovery strategies.

Created database objects such as tables, indexes and views.

Table Partitioning, creating Index Organized tables, Creating Locally managed Table spaces and Responsible in configuring and backing up database using hot backups, Cold backups and Logical backups.

UNIX shell scripting as and when required based on the requirement.

Migration and Up-gradations of Databases and Patched Oracle Database Server 10g using Opatch.

Performance tuning on production databases supporting the application using stats pack/AWR.

Develop, document, and implement security configuration for Oracle software and database instances to comply with existing standards.

Refresh development/test databases from copies of production..

24x7 Production-on calls supports for all the production databases with Oracle 10g/9i.

Environment:Oracle 9i/10g, SQL, PL/SQL, SQL plus, TOAD, Import/Export Oracle Enterprise Manager, Windows NT/2000, Sun Solaris 2.5/2.6, Red Hat Linux.

Apps Associates, Hyderabad, India August’ 07-February’ 08

Role: Oracle DBA

Responsibilities:

Installation, Maintenance and administration of Oracle 10g on Red hat Linux.

Implemented Data guard and administered the production database.

Responsible to schedule backups through RMAN.

Extensive application tuning through STATSPACK, explain plan, SQL*Trace.

Implemented scripts to capture high resource utilization query's, Implemented scripts for daily monitoring like db status, free space etc.

Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.

Extensively used SQL Queries (Sub queries, correlated sub queries and Join conditions) to handle data mapping.

Tuned the SGA, Monitored the shared Pool, Database buffer cache and Redo log buffers. Monitored Table spaces and Segment fragmentation. Performed trouble-shooting activities, created new users and assigned privileges and roles to users.

Environment:Oracle Windows, IBM-AIX,RHEL,Oracle 10g PL/SQL, SQL*PLUS, Oracle Enterprise Manager 9.2.0/10g, RMAN



Contact this candidate