Prabhu_dba
- 1. S. Prabhu sankprabhu@yahoo.com 98403 27925 Highly accomplished, deeply driven Oracle Database Administrator with an excellent overall 13+ years track record of success in infrastructure project deliveries. Having dealt with global customers of fortune service providers, possess exceptional knowledge in navigating complex technical environments with proven success tracks. During the entire span of my professional career, I have developed core skill sets in the installation, configuration, maintenance & tuning of Oracle database servers 8i, 9i, 10g & 11g on various operating Systems in 24x7 productions environments. Technology snapshot RDBMS : Oracle 8i, 9i, 10g,11g High-end Technologies : Oracle RAC, Data Guard, Golden Gate (9 & 10). Platforms : AIX, Solaris, Linux, HP-UX, Windows Family Oracle Tools : RMAN, TOAD, SQL *Loader,Export/Import & AWR, ADDM, Statspack and Tkprof Summary of Expertise Extensive experience on Oracle database administration. Installation, upgrade and patch activities for Oracle software in various platforms. Database Upgrades from 8i to 10g and 10g to 11g Installing/Upgrading/Managing Oracle RAC Instances including Critical Patch activities. Hands on experience with Automatic storage management(ASM) Defining and implementing backup strategies and handling critical recovery scenarios with RMAN. Extensive experience on Performance tuning and Health checks through collecting the data using explainplan, tkprof,AWR, ASH for database tuning and SQLtuning. Implemented Data Guard and hand on experience on doing the fail-over & switch over. Knowledge on Golden Gate implementation (DB–DB & DB–Flat file).
- 2. Organizational experience Artech Info Systems Pvt Ltd(Recently Joined from Jan 1st 2016) HCL Comnet Pvt Ltd (Feb 2014 – till date) CSC(PayPal) during Aug’07 to till date as Sr.Oracle Database admin Verizon India Pvt Ltd(Jul 2005 – Jul 2007) as Analyst dba Cellarstone India Pvt Ltd(Mar 2005-Jul 2005) as Junior Dba Academic Profile: MCA from Madras University, TN, India. Bachelor of Science in Mathematics from DB Jain College Significant projects Project#1 Name : Database administration Client : HCL Comnet (World Bank) Technology : Oracle 11gR2 (RAC), Sun , Aix Description: Has been involved in various POC’s related to 12c like 12c Inmemory configuration, Multitenant configuration and exploring various features of 12c environment. Roles and Responsibilities: Installation of databases; physical database design & creation. Devising strategy for Backups, recovery & fine-tuning. Creating tablespaces, rollback segments, user maintenance, database security imposition by creation and granting of roles and privileges, performance tuning, backups, tuning of SQL statements and support for various database tool sets and utilities. Manage scripts to monitor and manage multiple databases. Providing technical guidance to application development teams. Evaluating the database features and related products. Interfacing with the IT vendor for technical support. Setting up and maintaining documentation and standards. Devising data modeling strategies and plans. Supporting business information generation and timely reporting of all crucial data. Providing 24x7 supports to critical system. Applying Patchset,PatchesandCritical Patches Updates. Implementing RAC database using in RHEL Worked on POC’s related to 12c features like Multitenant/In Memory/Installation/Upgradation/Patching/Cloning/Refreshes Working on POC’s related to RAC and DATAGUARD
- 3. Project#2 Name : Database administration. Client : CSC(PayPal) Technology : Oracle 9i, 10g, Oracle 11gR2 (RAC), Sun , Aix , GOLDEN GATE Description: PayPal is the safer, easier way to pay and get paid online. I was Supporting OLTP, data-warehousing and reporting systems. Part of DBA team which maintained more than 60 Databases in production, 210 standby database and 2500 databases in pre-production, QA & development Environment. Primary responsibilities included- Creating new databases in the production databases. Started working on Oracle 11gR2 RAC with the ASM. Handling multiple very large databases with the size around 40TB Standby Database Rebuild using RMAN. Refreshing the Database of size 40 TB using RMAN. Close interaction with the business users and IT groups across the region and globally to ensure issues are resolved in a timely manner as per the Database Management standards. Do a Push cycle for a Release. Reviewing the sql queries for pre & post release in production. Worked closely on Golden Gate implementation for replication purpose (DB – DB Replication and DB – Flat file Replication). It includes table level replication and schema level replication. Database upgradation from 9i to 10g and 10g to 11g using normal upgrade and Golden Gate upgrade. Identification and removal of application performance bottlenecks. Automated statistics gathering for the database according to the application. Freezing the object statistics according the application objects. Simulating the DR scenarios, conduct the test and document the entire process steps in accordance to the format provided by the bank Creating and maintain Standard Operation Procedure documents for all major activities Performing Recover scenarios(Database, Tablespace ,Data file incorporating with different test scenarios ) Automated the whole setup of Golden Gate using shell scripts
- 4. Project#3 Name : Database administration. Client : Verizon India Pvt Ltd Technology : Oracle 8i, 9i, 10g, Sun, Aix Description: I was involved in various database and support related activities for development & testing teams. My role involved in installation of Oracle 10g RAC Database & Oracle 10g Application server, Creation and Configuration of databases, Database sizing, Formulating and Implementing backup and recovery strategy, Routine maintenance, Performance monitoring and tuning, security implementation. Roles and Responsibilities: Implementing an effective Backup and Recovery strategy for Production Database(s). Planning for the Database future growth estimating Disk Storage Capacity requirements to identify possible I/O bottleneck. Improve the performance of the database by Optimizing SQL statements, indexing tables. Trouble shooting DB issues to be in-line with SLA. Designing of comprehensive backup policy for all servers to minimize any unscheduled downtime in case of system failures. Performed extensive SQL tuning using TKPROF and optimization on views, queries and indexes.
- 5. Project#4 Name : Database Administration Client : Cellarstone India Pvt Ltd Technology : Oracle 8i, 9i (RAC), 10g (RAC), Sun, Aix Description: As a part of Infrastructure management Group I was involved in various database activities, supporting development activities. Roles and Responsibilities: Upgrading and migrating to higher oracle versions. Performing Recover scenarios (Database, Tablespace, Data file incorporating with different test scenarios). Database refresh by using scripts & RMAN duplicate feature Tracing out the often used tables and pinning them in KEEP Buffer cache. Preparing Oracle Security Document and implementation of the same across all the Oracle Servers in the data center. Interacting with the customer to understand their business requirements and their Technical queries on new project requirements & existing projects. Interacting with the application administrator and giving support to him such as checking the table information’s, index information’s, executing the sql queries, setting some parameters according to their requirements. PERSONAL DOSSIER Date of Birth : 1st July 1979 Email ID : sankprabhu@yahoo.com Languages Known : English, Tamil &Hindi. Marital Status : Married Mobile Number : +91- 9840327925