Oracle Manager

Prabhu Kumar Tadri

Contact: +1-630-***-****, Email: *******@*****.***

SUMMARY

•Competent, diligent and result oriented Masters in Computer Applications offering 13 years of experience. Currently spearheading functions as a Sr Oracle DBA (Database Administrator) with Exadata.

•Proven expertise in Database Design, Managing Database Servers, Grid Infrastructure environment maintenance on various database versions 12C/11gR2/10gR2 and 13C(OEM).

•Experienced in Oracle installations, refreshes, upgrades, migration, cloning, patching, Data Guard (Physical Standby/ADG) setup, ASM, OEM 13C, Performance Tuning (Instance/Database/SQL queries-DDL/DML), RMAN backup and recovery, partitioning, multi-tenant (CDB, PDB) environment, Golden gate, Exadata, Capacity Planning, TDE, wallet,database access, security, auditing, RAC Real Application Clusters and VLDB (OLTP/OLAP) databases maintenance and regular DBA Application support activities & Project deliverables.

•Experienced in troubleshooting production problems/performance issues faced by project development teams and provided relevant solutions. Expertise in using monitoring tools to provide PT (Performance Tuning) analysis report and recommended SQL query improvements for faster execution.

•Expertise in co-ordination and communication with system administrators, business data analysts, security directors and development & infrastructure teams for different level of project deliverables and deployments.

•Prepared storage capacity, short and long-term database capacity planning in collaboration with cross functional teams (Network/Storage/Linux/Application and Project Management Teams) to provision Linux standalone (or) multi node cluster server resources (CPU/Memory/Huge pages/Swap size), LUNS and ASM Disks based on application requirements.

•Excellent in performing Database migrations across platforms (Linux, Solaris, Windows) and used Golden Gate / DataGuard Standby capabilities to migrate databases 11.2.0.4 from standalone Linux 6.3 to Exadata X7-2 Elastic Rack HC 10TB Linux 7.5 database 11.2.0.4 with minimal downtime or no DB downtime strategies.

•Providing assistance in the planning, development, maintenance, and monitoring of integrated database systems, and ensuring that the conceptual and design phases of new applications are consistent with the structural parameters within the database environment.

•Golden Gate capability to migrate databases 11.2.0.4 from standalone Linux 6.3 to Exadata X7-2

•Ability to handle multiple tasks in high-pressure environments and capable to handle projects simultaneously under tight deadlines and work independently to solve technical production problems.

•Excellent understanding of business strategy and specialized in defining standards for architecture documentation to leverage best business practices and automation process implementation.

•Professional in Oracle Database technologies and knowledge on SQL Server. Quick learning attitude and ability to learn other DB technologies based on project requirement.

•Excellent working experience with different multinational clients such as Apple, Harley-Davidson, McKinsey & Company, Pfizer, CenturyLink, Level (3) Communications, Manhattan, Rackspace, JDA, Ulta Beauty, Conduent etc., contributed to get a successful delivery of multiple projects in my career.

•Adequate working experience with ITIL process oriented projects (i.e. Change, Problem, Incident, etc.) fulfilment of SLA’s (service level agreements). Prepared standard documentation for continuous business, services and process improvement plans for the client and vendor. Excellent communication and written skills.

•Experience in providing DBA on-call rotation & 24/7 service to support Production environment.

TECHNICAL SKILLS

•Operating Systems &Versions: Enterprise Linux RHEL 6.3/7.5, Windows 7/8/10, Solaris 9.0/10.0, HP-UX

•Database versions: Oracle 9i, Oracle 10g/11gr2/12C, Exadata X7-2, SQL Server 2014/2012/2008

•Hardware: Sun SPARC, Intel, EMC2, VMWare

•Case Tools: SQL-Developer, Toad, Xmanager, FileZilla, psftp and Putty, Xming, SPLUNK, idera sql diagnostic manager

•Tools & Utilities: RMAN, EXPDP/IMPDP, EXP/IMP, ASM, Async

•Oracle Monitoring Tools: Oracle Enterprise Manager (OEM 13C), Foglight, AWR, ASH, ADDM

•Ticketing Tools: Cherwell, Lotus Notes 6.5, JIRA, JTrac

EDUCATION/CERTIFICATIONS

•Master of Computer Applications, 2005 - Kakatiya University - Warangal, Telangana, India (Graduated)

•Bachelor of Computer Applications, 2002 - Kakatiya University - Warangal, Telangana, India (Graduated)

•Oracle Certified Professional

•Completed corporate training on Oracle 11gR2 RAC administration

•Received client appreciation certificates and STAR Team Award from TCS company

EXPERIENCE

Conduent Austin, TX April 2018 – Current

Role: Sr DBA – Production Operational Support

Project 1: Electronic Payment Cards Management Systems – CONDUENT is the world's largest provider of

diversified business process services with leading capabilities in digital processing, automation and analytics.

Provides State Government program services such as Electronic Benefits Transfer (EBT), Electronic Payment Cards (EPC), Electronic Child Care (ECC), State Disbursement Unit (SDU) Solutions, Child Support Services (CSS), Payroll Cards runs on EPPIC etc.,

Responsibilities:

•Installation, configuration and administration of Oracle 11gR2 RAC ONE NODE, Oracle 12C FULL RAC on Enterprise Linux (RHEL) 6.1 / 7.5 OS versions.

•Troubleshooting of performance issues and SQL query problems in Oracle database using internal tools like AWR, ASH, ADDM, OEM Grid Control and manual scripts.

•Performing database/schema refreshes using data pump utility (expdp/impdp) in lower environment for test cases to do production deployments.

•Responsible to do SQL query (DDL/DML) tuning and provide solutions to development team and guide the industrial best practices to follow. Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC

•Responsible to prepare and maintain standard documents/templates for all major activities like database software installations, creation, refreshes, cloning, patching, issue resolutions etc., which helps to maintain consistency across all environments (Dev/QA/STRESS/PRODUCTION) during implementation and for the client in the future.

•Automation of RMAN backups, schema refreshes, database refreshes and to monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc., using shell scripting.

•24 X 7 Production database administration, support providing during on-call schedules.

Project 2: DC (Data Center) Migration: Migration of multiple states databases across locations.

Responsibilities:

•Installation, configuration and administration of Oracle 11gR2 4 Node RAC on Enterprise Linux (RHEL) 7.2 OS versions.

•Migration of databases using RMAN utility, Data pump expdp/impdp from Non-ASM to ASM storage systems.

•Setup of DG (Data Guard) Physical standby servers and ensure to get the data sync across the sites (Primary/DR).

•Troubleshoot the issues that occurs during migration process and post migration challenges.

•Prepared DC-Migration execution plan and prepared the procedures to follow for a better delivery of the project.

•Responsible to estimate the timelines, storage requirements, resource planning etc.,

•Golden Gate capability to migrate databases 11.2.0.4 from standalone Linux 6.3 to Exadata X7-2 Elastic Rack HC 10TB Linux 7.5 database 11.2.0.4 with no DB downtime.

CenturyLink Broomfield, CO September 2017 – April 2018

Role: Onsite Lead - DBA Support

•Project Name: CTL Infrastructure Management Systems – CenturyLink, Inc. is an American telecommunications company, headquartered in Monroe, Louisiana, that provides communications and data services to residential, business, governmental, and wholesale customers in 37 states. A member of the S&P 500 index, the company operates as a local exchange carrier and Internet access provider in U.S. markets and is the third-largest telecommunications company in the United States in terms of lines served, behind AT&T and Verizon It also provides long distance service.

Responsibilities:

•Managing a team of 25 offshore members working on different database technologies (Oracle/MS SQL SERVER DBA and SYBASE).

•Database operations and architecture work from all aspects of RDBMS management and lifecycle. DB Design, DB installations.

•Migration of data from Exadata X6-2 Database Machine to RHEL 7.3 X86-64bit machine using RMAN duplicate, Data pump facility.

•Managing oracle databases in a EXADATA environment.

•DB Monitoring, database backup and recovery, Database Security, database consolidations and decommission.

•Performing DB patching, DB code releases, on-call rotations, performance troubleshooting and tuning, and all aspects of Database Management. ASM and Storage management.

•Key contributor to perform Storage based snapshot backup and recovery architecture, and Enterprise implementation of Oracle Enterprise Manager (OEM).

•Backup and Recovery architecture and implementation for backup and recovery solutions utilizing RMAN and NFS, RMAN and NetApp storage snapshots and cloning, 3Par Storage Snapshots and cloning.

•Installation of Oracle 11gR2/12C GI (Grid Infrastructure) software, ASM instance creation, RAC RDBMS software installation and RAC database creation on 4 node clustered environment.

•Responsible for creating databases as per the requirements, maintaining control file, redo log file, data files and creating table spaces and resizing them as per requirement, ASM storage management.

•Performing database refreshes using export and import utilities (exp/imp) at all level. Performed the same using data pump export and Import utilities (expdp/impdp).

•Extensive usage of OEM tool to provide performance test analysis report and for monitoring CPU utilization, data throughput, blocking sessions, ASM disk space usage, tablespaces usage, datafile addition for extra space, configuring alert notifications etc.

•Troubleshooting of performance problems in Oracle database using internal tools like AWR, ASH, ADDM, OEM grid control and manual scripts.

•Deployments and Change request CR implantation in production environment.

•Responsible to work with Oracle Support to resolve issues and open SR using Metalink to resolve the bottlenecks in the database environments.

•Setting up stand-by databases, implemented/ administered data guard for higher availability and disaster recovery. Used the stand-by database for reports generating purpose.

•Environment Used: Oracle 9i/10g/11gR2/12C, OEM 13C, Sun Solaris, Enterprise Linux (RHEL) 6.3 / 7.1 OS versions, VMware, EMC2, l3dbtool, Mputty

Ulta Bolingbrook, IL January 2015 – August 2017

Role: Sr Oracle DBA

•Project Name: Ulta Infrastructure Management Systems – ULTA Beauty is the largest beauty retailer in the United States. The company offers more than 20,000 products from over 500 well-established and emerging beauty brands across all categories and price points, including ULTA Beauty’s own private label. As of today, ULTA Beauty operates 870 retail stores across 48 states and distributes its products through its website, which includes a collection of tips, tutorials and social content. Maintains high-end information technologies to run the business.

Responsibilities:

•Installation, configuration and administration of Oracle 11gR2 RAC ONE NODE, Oracle 12C FULL RAC on Enterprise Linux (RHEL) 6.1 / 7 OS versions.

•Installation of Oracle 11gR2/12C GI (Grid Infrastructure) software, ASM instance creation, RAC RDBMS software installation and RAC database creation on 4-node clustered environment.

•Providing database and system management for multiple Linux and windows servers running Oracle 11g/12C ranging in size from 500Gb to 8Tb+.

•Installed and configured OEM 12C Grid Control, OMS (Oracle Managed Server) and OEM Agent, extensively used OEM tool to provide performance test analysis report and for monitoring CPU utilization, data throughput, blocking sessions, ASM disk space usage, tablespaces usage, datafile addition for extra space, configuring alert notifications etc.

•Troubleshooting of performance and tuning problems in Oracle database using internal tools like AWR, ASH, ADDM, OEM Grid Control and manual scripts.

•Responsible to support L1/L2 activities related to SQL SERVER 2008/2012/2014 databases.

•Monitoring and managing SQL SERVER High Availability services (Clustering, Mirroring, Log shipping, and HA/Always ON.

•Experience in troubleshooting and solving the issues related to HA/Always On in SQL server.

•Reviewed and identified SQL SERVER logs to identify areas for tuning and optimization.

•Providing primary DBA support for e-commerce sites, customer facing OLTP and data warehouse systems of multiple applications related to JDA and Manhattan vendors.

•Helped developers to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

•Responsible to do SQL query tuning and provide best practices to development team in building SQL statements.

•Applying quarterly patches, CPU/PSU and version change patch bundles.

•Responsible to do co-ordination and communication with system administrators, business data analysts, security directors and development teams for different project deliverables.

•Responsible to prepare and maintain standard documents/templates for all major activities like database software installations, creation, refreshes, cloning, patching, issue resolutions etc., which helps to maintain consistency across all environments (Dev/QA/STRESS/PRODUCTION) during implementation and for the client in the future.

•Automation of RMAN backups, schema refreshes, database refreshes and to monitor activates like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding etc., using shell scripting.

•24 X 7 Production database administration, support providing during on-call schedules.

•Environment Used: Oracle 11gR2/12C, OEM 12C, Enterprise Linux (RHEL) 6.3 / 7.1 OS versions, VMware, EMC2, Cherwell Ticketing tool, JIRA, Windows 2007/8, Lync communicator, Tidal, Mputty

Harley Davidson Motor Cycle Hyderabad, India June 2012 – December 2014

Role: Oracle DBA

•Project Name: Harley Davidson Infrastructure Management – Harley-Davidson motor company is one of the leading manufacturers of motorcycles around the world. The GIS-Global Information Systems of Harley-Davidson is maintained primarily with two applications HDMC (Harley-Davidson Motor Company) and HDFS (Harley-Davidson Financial Services), responsible to provide 24/7 production support for entire HDMC application systems.

Responsibilities:

•Performed Oracle database & schema refresh activities.

•Monitored and managed the databases during the generation of large reports.

•Generated and analyzed the AWR, ADDM reports to provide best tuning solutions for performance issues.

•Monitored daily scheduled RMAN backup’s status.

•Performed database backups using data pump, RMAN and logical export/import utility.

•Provided database server maintenance support and outage plans.

•Oracle database upgrades from 9i to 11gr2, 10g to 11gr2.

•Applied CPU/PSU database patches using OPatch utility.

•Migration of databases in cross platform systems. Golden gate usage to migrate data.

•Environment Used: Windows 2007, IBM AIX 5/7.1, Oracle 10gR2, 11gR2, Maximo Tool, Putty, Xmanager

Apple Hyderabad, India May 2011 – April 2012

Role: Oracle Database Administrator

•Project Name: Apple iTunes and iCloud Applications Management Systems – Apple is a leading retail/manufacturing company mainly dealing with many mission-critical applications hosted on various enterprise production databases. Providing support for iTunes, Mobile Me, New Castle and iPhone databases.

Responsibilities:

•24 X 7 Production database administration, support.

•Maintained data guard to ensure high availability, data protection and disaster recovery for enterprise data.

•Extensive experience in data guard configuration, implementing and maintaining stand-by databases.

•Followed the ITIL discipline, proper problem management, inventory management, risk management and risk mitigation plans.

•Installed and configured physical and logical stand-by databases.

•Performance tuning, monitoring session waits and SQL reports.

•Maintained sync between HA and primary by clearing back logs.

•Database cloning over stand-by.

•Re-establishment of log-shipping.

•Monitored the growth of tablespaces by creating and altering required tablespaces, users and roles for the application.

•Environment Used: Apple Mac Laptop, Linux Servers, Oracle 10g, 11gR2, Jabber, Espresso, Houston tool, Mac OS

Boots Hyderabad, India July 2010 – April 2011

Role: Oracle DBA

•Project Name: Data migration for the CRM Ad. Card Futures Program – The Card Futures Program in Boots needed to be migrated into newly created development/QA/Pre-Prod and Production environments. Data was migrated across the environments of Oracle. Needed to coordinate the provisioning and maintenance of various environments in the application development lifecycle.

Responsibilities

•Oracle database server build preparation.

•Installation of Oracle 10g, 11g software in silent mode.

•Created Oracle 10g, 11g databases on different versions of HP-UX servers.

•Manual Creation of Oracle 10g, 11g databases on need basis in HP-UX server.

•Implemented Oracle database 10g/11g migration from windows to HP-UX servers.

•Responsible to do database refreshes, user management, space management.

•

Mckinsey & Co., Mumbai, India May 2007 – June 2010

Role: Database Coordinator & DBA

•Project Name: Environments Management and Applications Development – The Environments Management Team (EMT) is an interface between Application Development and Infrastructure Development teams and coordinates the provisioning and maintenance of various environments in the application development lifecycle (SDLC) Systems.

Oracle DBA Coordinator responsibilities:

•Act as a contact for all development communities in ODC for database issues and coordinates everyday database administration.

•Closely coordinate and work with ID (infrastructure development) and DM (data management) teams on database architecture, upgrade and maintenance related projects.

•Worked on a “Database Decommission Project” to claim space on the servers by removing unused databases.

Oracle Database Administration responsibilities:

•Created Oracle 9i, Oracle 10g Databases on different versions of Linux and AIX servers.

•Dealing with Export / Import, data pump, backup & recovery and various Database issues.

•Implemented backup and recovery procedures (cold/hot backups, RMAN incremental backups & import/export)

•Created database links and materialized views.

•Performed patching on Oracle Database Server 10g and 11g using OPatch utility.

•Troubleshoot and resolve database and/or application problems encountered by end users.

•Environment Used: IBM AIX servers, Linux, Oracle 9i, Oracle 10gR2, Lotus Notes 6.5, Sametime 8.1.0, putty.

Pfizer Mumbai, India December 2006 – May 2007

Role: Jr. Oracle DBA

•Project Name: Pfizer-Infrastructure Migration – Application migration and server consolidation Pfizer Global Pharmaceuticals (PGP) wished to migrate from current Infrastructure to a smart, optimized, next generation infrastructure and consolidate it up to 50%. Responsibilities:

•Created Oracle 9i, Oracle 10g databases on different versions of Linux and Windows servers.

•Create and maintain users, roles and privileges and auditing triggers.

•Monitor tablespace and database growth by verifying shell script generated reports.

•Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, names server, connection manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.

•Prepared standard database creation, schema/database refresh templates for the purposes of the development team.

•Environment Used: Linux, Sun Solaris, Windows, Oracle 9i, Oracle 10G, Lotus Notes 6.5, Putty

Contact this candidate