Senior Oracle DBA,Oracle database engineer,Oracle infrastructure
Resume:
Rajesh Kolipineni
**********@*****.***
Summary
Have around 10 years of experience as Oracle DBA in the field of IT Industry.
Performed migration from Oracle Database to AWS RDS.
Have good knowledge on Oracle Architecture, PostgreSQL and AWS RDS.
Have knowledge on RAC.
Provided 24x7x365 System DBA on-call support for production databases, catering to applications including mission-critical and priority 1 OLTP/Online systems. Also supported development and test instances.
Maintained SLAs like scheduled adherence and P1 outage resolutions.
Performed database backup configuration and database recovery as needed. Performed monitoring of database backups. Coordinated with Storage Management and System Administration groups for backups and recoveries.
Communicated and worked proactively and re-actively with practically all the groups in the organization,which include, management, development and testing teams, application DBAs, capacity planners, backup planners, storage planners, vendors and their technical support teams, system administrators, security administrators, end users, Netback up and TSM administrators, etc
Performed Oracle client software installation, maintenance, and upgrades when requested by the Application DBA
Monitored Database performance and ensure Oracle init.ora parameters such as SGA, log buffers, and sort area deliver optimum performance to the database.
Created, upgraded, migrated, and managed Oracle DBMS tablespaces.
Maintained database security and system-level audit ability as required by AT&T Operating Practices.
Have experience on applying patching databases regularly to resolve various issues.
creating, managing and monitoring tablespace usage and space related issues.
Experience in working with Global Teams and supporting database across Data centers.
Hands on Upgrading Production Databases using patch set upgrade (PSU).
Experienced in providing 24/7 on-call production support environment.
Willing to acquire new knowledge and training Cross functional teams on Oracle.
Skillsets
Primary Skills : RMAN, RAC,DATA GUARD,AWS RDS
Operating System : Linux, Sun Solaris, RHEL,Windows
Tools : OEM12c,RMAN
Languages : SQL
Database : Oracle 9i,10g, 11g,12c,19c
Utilities : Putty, Toad, VM Ware
Professional Experience:
Project
Client : Pfizer Inc.
Company : Infosys Pvt Ltd
Role : Oracle Database Administrator
Duration : Jan-2019 to Present
Project Summary
Pfizer Inc. is one of the world's largest pharmaceutical companies. The company developed and produces medicines and vaccines for a wide range of medical disciplines, including immunology, oncology, cardiology, endocrinology, and neurology.
Responsibilities
Installation and upgrading of Oracle databases in production and development environments.
Responsible for ensuring the daily backups/ exports of the database, archive logs to disk/tape systems. Set up and maintained backup procedures for database using RMAN.
Applied bug fixes and bundle patches (BP) in standalone and RAC environment (PROD, DEV, TEST) for Oracle RDBMS and Grid Infrastructure (GI) using rolling and non-rolling methods.
Applied PSU patches every quarter recommended by Oracle on Standalone and RAC.
Planned and implemented Physical Standby Databases (Data Guard) for High availability and Disaster Recovery (DR).
Resolving archive log gap between Primary and Standby databases using RMAN incremental backup and Managing Media Recovery process, Network failures and Configuration issues.
Performed in setting up Data Guard Switch-Over scenarios.
Troubleshooting database issues like Table Space Utilization, Temp & Undo Table spaces.
Configuration & Administration of ASM instances and ASM disk groups.
Monitoring the ASM disk groups, add and resize the disk groups, adding disks to the Disk groups.
Cloning/Refreshing the production database to UAT/DEV environment as per the application user requests using RMAN Duplicate command and Data pump.
Performed tasks associated with tuning of sql queries for performance and efficiency enhancements, reviewing the logs, reviewing table space and file system available space, configuring the initialization parameters based on application requirements, optimizing complex SQL queries using the AWR Reports, Explain Plans, Plan Hash Values.
Creation of Database Health Check reports (including database growth, cpu/memory utilization, Top sql etc).
Implemented Golden Gate installation and Configured Uni-directional replication between Oracle and Heterogeneous databases
Provided all kinds of DBA support to development teams as well as production support to various applications.
Monitoring frequently Alert Log file for errors and making necessary actions to rectify them.
Project
Client : Best Seller
Company : KPIT Technologies Ltd
Role : Oracle Database Administrator
Duration : November 2015 – November 2018
Project Summary
The project is a retail management system. This project contains several modules which are divided into small applications. Each application deals with different shopping experience like credit card or Debit card billing system, seasonal offers in Wal-Mart store like any offers, list of goods, financial services, Global Distributed system etc. And also implementing new enhancements to few applications as per the requirements.
Responsibilities
Daily Health checks on all servers and sends the reports to client.
Provided all kinds of DBA support to development teams as well as production support to various applications.
Monitoring frequently Alert Log file for errors and making necessary actions to rectify them.
Cloning/Refreshing the production database to UAT/DEV environment as per the application user requests using RMAN Duplicate command and Data pump.
Experience in Cloning the database for development and testing purposes.
Killed defunct and hung sessions to reduce unnecessary load on the server.
Monitoring the Logs for successful execution of all the specified jobs.
Created and managing Users, Roles and Groups and handling database security policies.
Managing Backups on a daily basis and Recovery as per request.
Checking Alert log, trace files, listener log and other database job logs.
Resolving user’s day-to-day issues.
Installation, Up-gradation, Migration &Maintenance of databases on various OS platforms.
Hands on Upgrading Production Databases using patch set upgrades(PSU).
Project
Client : AT&T
Company : Tech Mahindra
Role : Oracle Database Administrator
Duration : December-2014 to July-2015
Project Summary
The project is based on telecom domain. AT&T Inc. is an American multinational telecommunications corporation, AT&T is the second largest provider of mobile telephone and the largest provider of fixed telephone in the United States, and provides broadband subscription television services.
Responsibilities
Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.
Installation and Upgrading of Oracle Databases on production and development environments.
Raising (SR) to Oracle Support for various Internal ORA errors, bugs and issues by providing log files using TFACTL/ADRCI.
Responsible for ensuring the daily backups/ exports of database, archive logs to disk/tape systems. Set up and maintained backup procedures for database using RMAN.
creating, managing and monitoring Table space usage and deal with space related issues.
Monitoring daily backups and suggest the changes in backup strategy if required.
Have experience in applying database patches and patch set upgrades.
Applied patches to upgrade oracle databases.
Serving user’s requests through emails and ticketing system.
Implementation of backup the databases using RMAN.
Checking Alert log, trace files, listener log and other database job logs.
User creation and providing necessary Roles, Privileges and quota as per the
Requirement.
Resolving user’s day-to-day issues.
Consistently interacted with client and team in resolving the queries.
Checking DB locks, resizing of table spaces, data files, allocating quota for users.
EDUCATIONAL QUALIFICATION:
Master of computer application(MCA) from Osmania University, Hyderabad, Telangana, India.
Contact this candidate