Resume

Sign in

Sr. ORACLE DBA

Location:
Chicago, IL
Posted:
April 11, 2016

Contact this candidate

Resume:

Hemanth Ravipati

Sr. Database Administrator

acubek@r.postjobfree.com +1-630-***-****

SUMMARY:

Seasoned technical team leader/Senior member of the DBA team with over 9+ years of experience of administering, developing, managing development teams, pre-sales, post sales deliveries, providing technical guidance and mentorship, providing professional services, project and product management.

Expertise in Database administration, Data Modeling and Incident Management skills.

Provides guidance and technical leadership for the entire life cycle of the projects in Banking, Telecom and ecommerce domains.

Expertise in establishing solid client relationships in customer based environments.

Experience in working with ISVs, third party vendors, and managing client expectations.

A trusted advisor to external and internal clients, solution architecture, technology roadmaps and choosing right technology and technology partners.

Experience in multiple development methodologies, worked with different teams to setup Agile Development Methodology.

Have good experience in reverse engineering the entire models for identifying the legacy systems.

Database Administration on 24x7 critical and large databases like Oracle 9i, 10g, 11g, 12C and SQL server.

Worked with development teams and data administration staff to enhance Database and application performance.

Experience in writing different backup and recovery scripts, shell scripts, PL/SQL procedures, cron jobs, DBMS_JOBS, Data Pump and Export/Import scripts.

Expertise in node management, cluster management, backup and recovery, replication, cloning, migration, applying patches, export/import, index management etc.

Expert in disaster recovery plan, backup and recovery strategies using RMAN on RAC with ASM and non RAC databases, Flash back.

Hands on experience in Logical and Physical database design.

Good hands on experience on Load test/ Performance tests for supporting the clients in validating the application load.

Led the team in client location (Mexico) for leading the team during the Production deployment and support the DB activities for Telecom Order Management and Billing applications.

Expertise in migration of data from one server to other server.

Experience in Performance Tuning of Database by optimizing SQL, PL/SQL scripts and in tweaking of parameters based on the future growth of loads.

Good hands on experience in Installation and configuration of Oracle on OS environments UNIX/LINUX/AIX and Windows and worked with Windows environment for Oracle9i /10g /11g and 12C.

Experienced in regular Database Administration activities such as Upgrades, Patches, Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.

Good exposure in Effective troubleshooting of database and performance problems.

Result oriented, self-motivated, team leader, ability to work independently and as part of team.

Excellent interpersonal skills and have the ability to resolve the issues by bringing all the respective teams with in the same loop.

Responding quickly to severity/priority issues and pages/bridge calls with Client.

Periodically monitoring Problem management queue and working on problem tickets or sharing across team members and providing timely resolution on bridge calls without impacting SLA of problem ticket.

Updating problem record with proper Root cause analysis (Issue cause, resolution plan and future prevention).

Experience in switching new technologies based on the requirements and prioritizations of the team.

TECHNICAL SKILLS:

Strong expertise and knowledge in data modelling, data warehousing, data analysis, and integration/transformation, and database concepts, different data mining algorithms, and data partitioning techniques, performance tuning techniques, Oracle streams, replication using Materialized Views, golden gate, and Toad Data Point Integration.

Databases – Oracle 12C, Oracle 11gR2, 11gR2 RAC, 10gR2 and Oracle 9i, MySQL, MongoDB, DB2, and SQL Server.

TOAD, Crystal Reports, Spotlight.

JIRA, ARCADE, CONFLUENCE.

Data Modeling Tools: IBM Info sphere Data Architect, DB Visualizer, Workbench, CA-Erwin, TOAD data Modeler, SQL Developer, and Visio.

Languages - SQL, PL/SQL, UNIX Shell Scripts.

OS / RTOS – Linux (Red hat, Centos), IBM-AIX, HP-UX, Solaris and Windows

PROFESSIONAL EXPERIENCE:

Sr. Database Administrator December 2013 – March 2016

AT&T - Hosting Services

ENVIRONMENT: ORACLE 11g, 10g, SQL, PL/SQL, MYSQL, Linux, Oracle DWH

As part of the Professional Services team in AT&T, involved in handing, designing, developing hard core databases for banking, ATG and ecommerce clients.

Taken ownership in performing the tasks individually as well as the team for developing credit card applications for one of the project.

Refreshing of Databases with the requested scenarios within the scope.

Hands on experience in handling multiple projects simultaneously.

Experience in Data Modeling, Database Design and Creation. Data Modeling using ER-Win, TOAD, SQL data modeler tools.

Good hands on experience in automating scripts for Session monitoring and backup activities.

Hands on experience in Logical and Physical data modelling for reverse engineering as well as new projects.

Reverse engineered the complete functionality in order to understand the DataMart life cycle in my current environment.

Experience in performance tuning and monitoring activities using EXPLAIN PLAN, TKPROF, STATSPACK, TOAD, AWR, and ADDM.

Hands on experience in installing of different RDBMS using OEM like 9i, 10g and also upgrading, applying patches, migration experience.

Experience in handling Oracle ASM database on LINUX, SOLARIS, AIX, WINDOWS and platforms on SAN storages.

Experience in writing different backup and recovery scripts, shell scripts, PL/SQL procedures, CRON jobs, DBMS_JOBS, Data Pump and Export/Import scripts.

Having good experience in analyzing the system to overcome the bottlenecks.

Having good experience in Upgrading 10g to 11g R2.

Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.

Managing Database Structure, Storage Allocation, Database Access, Roles and Privileges.

Performed routine health checks on databases, used various advisors (ADDM, MTTR, SQL access, ASH, AWR) for identifying performance bottlenecks, load balancing, and RAC slowdown using STATSPACK and recommend improvements.

Performance monitoring based on client opened problem tickets and needs to provide resolution if we find any performance issue. (Example: Finding root cause: If client is facing performance issues when they are running SQL statements.

Index management, table partitioning, SQL tuning, load balancing, RAC interconnect tuning were some of the activities performed for better performance.

Responsible for validating the various environment scripts.

Educating the development teams in their application programming and usage.

Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.

Re-Organizing oracle database/tablespace/table and rebuilding indexes.

Created the database objects based on the requirements for different environments.

Created Partitions & indexes for better performance.

Setting up and testing the Backup and Recovery strategies.

Extensively used packages like DBMS_JOBS, DBMS_SCHEDULER, cron jobs for scheduling routine tasks.

Periodically monitoring Problem management queue and working on problem tickets or sharing across team members. Providing timely resolution on bridge calls without impacting SLA of problem ticket.

Updating problem record with proper Root cause analysis (Issue cause, resolution plan and future prevention).

Checking failure backups and rerunning them by resolving issue with in non-business hours.

Learning Golden gate in the present environment.

Handful experience in Working with Oracle related errors cases and contacting oracle support in case of internal errors.

Checking database, listener, disk group’s status of ASM instance and database mount point’s status in case of server panic/reboot.

Creating change management records with detailed implementation steps, outage window, fallback plan and approvals.

Implementing only approved change management records with within change window.

Attending change management meeting if we submit any major outage window change record.

Database Administrator June 2011 - Sept 2013

IBM India Pvt Ltd

ENVIRONMENT: ORACLE, DB2, SQL, PL/SQL, AIX, Linux, ITIL

As part of IBM GBS Infrastructure team I use to support clients like IUSACELL, VODAFONE (Italy, Greece and Portugal) in Telecom Industry.

As a DBA, was responsible for handling Development, Test Environments in addition to the Production environments.

Taken ownership in performing the tasks individually as well as the team.

Upgraded data from Oracle 10.2.0.1 to 10.2.0.4, applied patches from Meta-Link.

Responsible for validating and executing in the various environment scripts.

Developed automated refresh of database scripts.

Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.

Developed scripts for SLA management for orders regrouping.

Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.

Created the database objects based on the requirements for several projects.

Created partitions & indexes for better performance.

Participated in Database Security tasks.

Educating the development teams in their application programming and usage.

Backup and Recovery using RMAN.

Performance monitoring based on client opened problem tickets and needs to provide resolution if there are any performance issue. (Example: Finding root cause: If client is facing performance issues when they are running SQL statements).

Helped the teams in tuning the queries.

Responding quickly to severity/priority issues and pages/bridge calls.

Providing timely resolution on bridge calls with Clients as per the SLA of problem ticket.

Updating problem record with proper Root cause analysis (Issue cause, resolution plan and future prevention).

Oracle Database Administrator/Developer August 2009 - June 2011

Neer Interactive Solutions (P) Ltd

ENVIRONMENT: ORACLE 10g, SQL, PL/SQL

Primarily responsible for 24/7 support activities. To keep all databases up and running in the environment.

Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.

Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.

Hands on experience in data modeling and in preparing the scripts.

Created the database objects based on the requirements for project requirement.

Scheduled & automated back-end jobs.

Setting up environments for testing the Backup and Recovery strategies.

Updating problem record with proper Root cause analysis (Issue cause, resolution plan and future prevention).

Generating AWR and ADDM report on specific node based on client request.

Checking database, listener, disk group’s status of ASM instance and database mount point’s status in case of server panic/reboot.

Creating change management records with detailed implementation steps, outage window, fallback plan and approvals.

Automation of scripts based on the current requirements.

Oracle Database Administrator/Developer February 2007 - July 2009

Enervators Global IT Solutions.

ENVIRONMENT: ORACLE 10g, SQL, PL/SQL

Responsible for monitoring and development of daily activities.

Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company’s requirement as necessary, from information given by the application developers.

Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.

Created the database objects based on the requirements for project requirement.

Checking database, listener, disk group’s status and database mount point’s status in case of server panic/reboot.

EDUCATION:

Bachelors of Electronics and Communication Engineering. (2005) from Anna University.



Contact this candidate