| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidate[pic] Candidate's Name
Mobile No: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEObjective: To obtain a challenging position in a high quality engineeringenvironment Where my resourceful experience and academic skills willadd value to Organizational Operations.Skills: Managing Oracle database on different operating system likeHP UNIX, Linux, Sun Solaris and Windows. Having strong knowledge ininstallation, Configuration, Tuning and Administration of RAC databaseand Enterprise Manager.Experience SummaryHave over 14 years of focused experience in Administration of OracleDatabases, Member of Support team, which provides systems and databaseconsultancy. Have strong exposure in design and optimizing performance ofProduction /Stage and Development databases.Successfully performed the role of database administrator supportingcomplete cycle of multiple project implementations - planning, development,performance tuning, Stand by Database Design, RAC Implementation andapplying patches for bug fixing to Oracle software, Setting operational andbackup/recovery strategies.Defining Upgrade strategy of Oracle database and Oracle Enterprise Managerfrom lower version to higher version (8i to 9i , 9i to 10g and 10g to 11g)and Upgrade of CRS from 10.2.0.2 to 10.2.0.3 and upgrade of grid from11.2.0.3 to 11.2.0.4.EDUCATIONAL QUALIFICATION:|Bachelor of Engineering in Mechanical, B.E [Mech]. From A.I.T ||Chickmagalore, India. |Technical Skills:|OS / Environment |Unix, Linux, HP-UX , Solaris and || |Windows ||RDBMS |Oracle 8/8i/9i/10g/11g and 12c ||Languages |SQL, PL/SQL ||Tools |Toad , Oracle SQL developer ||Replication Utility |Golden Gate, Veridata |1 Certifications > Oracle Certified Professional for 10g (OCP) > Oracle Certified Associate for 9i (OCA) > ITIL Foundation V3Training > Oracle 10g Workshop-I > Oracle 10g RACAchievements Customer Services Pacesetter Award for Q1 FY10 (EM 10g R4 upgrade) inOracle Received Star of the Quarter award for training the new recruiters in TCS Achieved top performance band for the financial year 2014-15 in TCSOracle RAC DBA Experience . Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during installation) . Worked with customer for different RAC related issue [Split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on] . Troubleshoot performance issues for the RAC instances (GC events) . Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) . Resolved/Diagnose Node Eviction . Upgrade of 9i ORACM to 10g and R2 RAC to 11g R2 RAC . Add or Remove Node from RAC. . Upgrade of grid from 11.2.0.3 to 11.2.0.4Oracle DBA Experience . Over 14 years of experience in as an Oracle DBA (11g/10g/9i/8i/8.0.x/ in Production and Development environment. . Worked in 24x7 production environment and provided on-call and day-to- day support. . Strong trouble shooting, problem solving, analytical and design skills. . Expertise in Oracle Enterprise Manager (OEM), TOAD. . Experience in Physical Standby Database Design. . Expertise in handling Very Large Database (VLDB) and OLTP environment. . Experience in Migration of Oracle 7.x to Oracle 8.x to Oracle 8i to Oracle 9i . Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning - Tuning Applications, Tuning Memory, Tuning Disk Usage, Tuning OS . Experience in Oracle 9i/8i/8.x- Installation, Migration and implemented new features. . Experience in capacity planning, space management, database upgrades/migration . Experience in handling clustered databases using VCS technology . Expert in ORACLE Database Administration including planning/implementing backup/recovery strategies using RMAN and without RMAN . Expertise in installation and configuration of Oracle and large databases on Unix Operating System. . Good knowledge of UNIX Administrator for the Linux, Sun Solaris . Creating and maintaining logins, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.PROFESSIONAL EXPERIENCEHewlett Packard Enterprise Feb 2016 to till dateClient:British PetroleumRoles and Responsibilities . As a Sr. Database Administrator, I am Responsible for administration of all Oracle Databases. . Upgraded 10.2.0.4 databases to 11g R2 . Upgrade of grid from 11.2.0.3 to 11.2.0.4 . Involved in environment setup and Installation of Oracle Golden Gate . Implemented Flashback Database on Physical Standby Databases which saved rebuilding of standby databases after application testing. . Advanced Backup and Recovery using Oracle's RMAN utility . Mentor other DBAs. . Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals. . Changes were made dynamically whenever possible to fulfil high- availability requirements. . Enforced need of regular data purging processes from production, design and development, to deployment. . Implemented and maintained Oracle 10g/11g Data Guard/standby databases for fail-over purposes. . Create and maintain materialized views. . Implementing and maintaining database security (create and maintain users, roles and assign privileges) . Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters. . Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed. . Monitored the production Oracle alert logs for database errors. . Monitored system resource availability and responded to system memory and data issues. . Upgraded Standby database from 11.2.0.3 to 11.2.0.4 . Applied Bug Fixing patched on 12c databases. . Expert with OEM Grid Control. . Installed Veridata to ensure consistency of the data. . Setup golden gate replication for BI reporting. . Fixing Golden gate issues. . Golden gate patching for any bug fixes. . DB Switchover involving Golden gate. . DB migration from standalone to RAC along with Golden gate. . Performance tuning of Golden gate replicat processes. . Configured Golden Gate Veridata for validating data sync between source and target db's.Tata Consultancy Services APR 2011 to Jan 2016Client AGCS -Allianz Global Corporate &SpecialtyDuration: Jun 2015 toJan 2016Roles and Responsibilities . As a SME Database Administrator , I am responsible for Administration of over 600 databases . Upgrade of Database from 10g to 11g . Installation of RAC and Managing RAC Environment efficiently . Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements. Monitoring and optimizing the performance of the Database through Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage. . Expertise in OEM . Actively working with other teams for Server Consolidation & Database Consolidation Project 2 APR 2011 to May 2015 Client: PriceWaterHouseCoopers US . As a SME Database Administrator , I am responsible for Administration of over 600 databases . Installing and Configuring Oracle Clusterware & Database Software . Manage RAC environment for Day to Day Administration. . Resolved & Diagnose Node eviction issues. . Experience in handling the clustered databases using Veritas Cluster on Solaris . Planned and Supported Complete life cycle of the projects for database upgrades From 9.2.0.8 to 10.2.0.4 on Solaris and Windows Platforms . Planned and Supported Complete life cycle of the projects for database upgrades from 10.2.0.4 to 11.2.0.3 on Solaris and Windows Platforms . Handled Database Tuning , Application tuning , Maintaining documentation , Capacity Planning database and prepared RCAs . Expertise in Backup and Recovery Using RMAN utility . Planned , documented and Supported Quarterly DR activities . Troubleshooting several production issues and handled generic ORA errors . Planned , documented and implemented database migration . Train the new recruitersMind Tree Limited. Dec 2010 to Apr 2011Client: AIRCELL - ChicagoDatabase: 11g Rel 1 . Managing RAC Databases . Installation and Creation of Database. . Maintaining the ASM Disks. . Managing OEM used for monitoring Production Databases. . Managing Oracle Intelligent Agent. . Support to different activities to adhere timeline for the business . Worked with the Metalink Support to resolve the issue.Oracle India Pvt Ltd Oct 2006 to Dec 2010Database: Oracle 10g RAC, 9i RACRoles & Responsibilities . Managing RAC databases . Installation and configuration of RAC Databases . Applied CRS Bundle Patch and RAC Stabilization fix. . Upgrading of CRS from 10.2.0.2 to 10.2.0.3 . Installation and configuration of Enterprise Manager . Upgrading of database from 9i to 10g . Upgrading of OEM from 10.2.0.2 to 10.2.0.4 . Installation and up gradation of Intelligent Agent . Did Patch Analysis and applied CPU Patches . Responsible for creating back ports for bug fixes . Worked with DEV team to resolve the issue. . Tuned the database to meet optimal performance . Support to different activities to adhere timeline for the businessIBM Global Services India LtdJuly 2005 to Oct 2006Client Capital One -RichmondCapital One is a financial Services industry in U.S. They are into CreditCards, Auto Loans, Savings, Home Loans, and Health Care Finance & InsuranceBusiness.The Job involved Trouble Shooting and Providing Support to the aboveclients.Roles & Responsibilities . Pro-active monitoring of database health . Managing oracle database on Production and dev environment . Monitoring of trace and alert log files . Review and update the Operating system and databases with the latest patches as and when released. . On-call DBA support . Monitoring backup logs and taking corrective action . Used Peregrine & HP Service Desk as problem & change management tools . Responsible for 99.99 % database uptime. . Responsible for successful completion of hot and cold backup jobs. . Support to different activities adhere timeline for the business. . Reconstruction of fragmented table. . Supporting end User and resolving the problem. . Worked as part of a team and provide 24x7 supports.Metro C & C India (P) Ltd Apr 2005 to July 05Client Metro GroupRoles & Responsibilities . Administration of Database, Set Up the environment for development teams, . Pro-active monitoring of database health . 24/7 Database support . Monitor Production and development Database . Pro-active database tuning . Design/review and implementation of backup and recovery policies for existingN-Spire Technologies Inc. BangaloreDuration: Jan 2003 to Mar 2005Responsibilities Oracle Software Installation on Unix/Windows Operating System. Users Maintenance. Tablespace Creation and adding of datafiles as per requirement Monitoring the Health of the databases and alert log monitoring Schema Refresh using exp/imp utilities.12 Contact Details2 Passport Number M96713173 Contact Address #386, 6th B Cross, 4th Main, Health Layout, AnnapoorneshwariNagar, Bangalore - 560091. Karnataka - India [Candidate's Name ] |