Senior Oracle DBA
TriCore Solutions Pvt Ltd
Total des années d'expérience :22 years, 0 Mois
• Presently working as Senior Consultant with TriCore Solutions India Pvt Ltd, Hyderabad from Nov 2013 till date.
• Worked as Principal Consultant with IT Convergence Professional Services Pvt Ltd, Hyderabad from March 2013 till October 2013.
• Worked as Senior Oracle DBA with IBM India Pvt Ltd from January, 2011-February 2013)
IBM India Pvt Ltd
Role: Senior Oracle DBA
Customer: Loblaw Companies Limited, Canada (January, 2011- February 2013)
Supporting Oracle 10gR2 & 11gR2 with RAC, ASM, Dataguard and Golden Gate.
Responsibilities as Senior DBA:
• 24X5 support for the 11gR2/10gR2 Oracle RAC & Standalone databases.
• Installations / upgrades of 11GR2 Grid Infrastructure and RDBMS for Prod and Non Prod envs.
• Successfully implemented Data replication using Oracle Golden Gate in Non- Prod and Prod Envs.
• Identify and Resolve Golden Gate replication issues.
• Oracle Data guard setup and maintenance including active standby
• DB cloning using RMAN from RAC to Standalone database.
• Developing shell scripts for RAC & Standalone databases.
• Managing ASM disk groups & tablespaces.
• Change / SR Management using BMC Remedy.
• Alert monitoring using Autosys and BMC Remedy.
• Working on SQL & Database performance issues.
• Working with Oracle Support for resolving various Database issues.
• Working with Storage / Server backup team for resolving backup issues.
• Database migration using Transportable Tablespaces.
Genpact India Software, Hyderabad
Role: Oracle DBA Consultant
Customer: COX Communications, USA (April, 2010- January, 2011)
Supporting Production Oracle 10gR2, 11gR2 DBs with RAC & ASM and Oracle Streams on RHEL 4.5
Responsibilities as Oracle DBA:
• 27X7 support for the / Non-Production 11gR2/10gR2 databases.
• Database Performance & Backup Monitoring.
• Prod / Non- Prod DB creation using dbca in RAC env.
• Developing shell scripts for RAC & Non- RAC databases.
• Managing ASM disk groups & tablespaces.
• Oracle Streams Setup / Monitor and resolving issues on Streams.
• Alert Monitoring and Resolution using HP Sitescope.
• Change / SR Management using BMC Remedy.
• SQL Query / Database performance tuning.
• Code Migrations using Standard processes.
• Preparing SOP Documents.
• Worked with Oracle Support for resolving various Database issues.
• Worked as Oracle DBA Consultant with Genpact India Software, Hyderabad formerly known as GE Capital International Services (from April, 2006-January, 2011)
• Worked as Senior Software Engineer with HP Global Soft Ltd, Bangalore (from June '2005-March '2006)
Genpact India Software, Hyderabad
Role: Oracle Core and Applications DBA Consultant
Customer: Equifax, USA (June, 2007- March, 2010)
Supporting Production Oracle 9iR2 DBs with Oracle Apps 11.5.10.2, Discoverer 11.1.2.3 on AIX 5.3 Servers
Responsibilities as Oracle DBA:
• 27X7 support for the Oracle ERP & Non-ERP environments.
• Oracle Applications & DB Cloning from Production to Non-Production envs.
• SYSADMIN Activities like Responsibility setup / migration
• DB upgrades from 9i to 10g Rel. 2 and Applications Upgrade to latest module version.
• Analyzing and Applying Patches to Applications / DB as required and recommended by Oracle.
• Capacity Planning.
• SQL Query / Database / Applications performance tuning.
• Analyzing and implementing the Disaster Recovery Trials.
• Developing Alerts / Automation scripts for Windows / AIX databases.
• Worked with Oracle Support in resolving various Database / Application issues.
• Develop, document and maintain procedures for upgrades, patching, data backups, restores, performance tuning, configurations and automations.
Genpact India Software, Hyderabad
Role: Oracle DBA Consultant
Customer: GE Energy and GE Transportation, USA (April, 2006- May, 2007)
Supporting Production / Non-Production Oracle 9iR2 DBs with RHEL.
Responsibilities as Oracle DBA:
• Execute support tickets (Support Central & HP Open View service desk 4.5 Tools)
• Was in 24 X 7 On Call DBA and the escalation point of contact for any database related critical issues.
• Primary responsible for the support of Oracle databases. This Includes installation, updates/patches, upgrades, tuning, optimization, backups and resource management
• Develop, document and maintain procedures for patching, data backups, restores, performance tuning and configurations
• Administer, maintain, develop, document and implement policies and procedures to ensure the security and integrity of all Oracle and some SQL Server databases.
• Worked with the QC /Operations / Application Teams in standardizing the application management / production deployments.
• Responsible of deploying the application into respective severs (categorized as per business P&L)
• Responsible of migrating databases from one data center to another data center depending upon the business requirement.
• Coordinate Knowledge transition sessions for new Hires.
• SPOC for preparing various kinds of reports in Operations perspective.
HP Global Soft Ltd, Bangalore
Role: Senior Software Engineer
Customer: Hewlett Packard, France (June, 2005- March, 2006)
Supporting Production / Non-Production Oracle 9iR2 DBs.
Responsibilities as Oracle DBA:
• Database Administrator & Developer for the project of HP, France
• Involved in UNIX Scripting, Designing Database for PLASMA, Developing SQL & PL / SQL Scripts.
• Discussing Design and Report requirements with the Clients and implementing the same in PLASMA ANALYTIC Application.
• Prepared the SLA & SOW for the project.
• Preparing the Monthly Quality related documents on the Project Status.
Thomson Business Information India Pvt Ltd (Currently Thomson Reuters), Bangalore
Role: Software Engineer
Customer: Merrill Lynch, US (July, 2004- May, 2005)
Supporting Production / Non-Production Oracle 9iR2 DBs with RHEL.
Responsibilities as Senior Software Engineer:
• Database Administrator/Designer for the project of Merrill Lynch, a financial management and advisory company.
• Involved in Logical and Physical Data Model development which supports project needs.
• Designing the internal schema of a databases, depicting the data tables, the data columns of those tables, and the relationships between the tables
• Defined Weekly Database Build Plan in terms of DB export, creating new schemas, uploading latest packages and procedures, Creation of synonyms, Executing Objects, Data Export and New Data Loads.
• Database administration during development.
• Defining and implementing Backup Strategy as required.
• Worked as Software Engineer / Database Engineer with Thomson Business Information India Pvt Ltd, Bangalore. (from July '2004-May '2005)
• Worked as Associate Consultant with SQL STAR INTERNATIONAL, Hyderabad. (from June '2003 to June '2004)
SQL Star International, Hyderabad
Role: Associate Consultant (June, 2003 - June, 2004)
Customer: T. Rowe Price, USA
Supporting Production / Non-Production Oracle 9i R1 & R2 DBs.
Responsibilities as Associate Consultant:
• Database Consultant for the project of T. Rowe Price, Global Investment Management Company.
• Installation of Oracle 9.2 for Testing and Development environments.
• Creating Databases, setup monitoring scripts, Space Management and Backup & Recovery using RMAN.
• Worked as Java Programmer with Data Metrecs Ltd, Hyderabad (from April' 2002 to May' 2003)
Project Summary:
TriCore Solutions India Pvt Ltd.
Role: Senior DBA
Supporting Oracle 11gR2, 10gR2 with RAC, ASM & Dataguard
Responsibilities as Senior DBA:
• Support 24x7 operations for Production/Dev/UAT databases in Onsite/Offshore working model and ensure 100% uptime of IT Infrastructure for Clients.
• Installation of 11.2.0.4 Grid Infrastructure and RDBMS in multi-nodes for Prod and Non Prod environments.
• Production Support for 11Gg/10g GI, RAC & Standalone databases.
• Migration of databases from Non-ASM to ASM Storage including conversion from Standalone to Cluster envs.
• Oracle Data guard build, resolve various gap issues and maintenance activities.
• Working with Oracle Support for resolving various Database high priority issues.
• Perform disaster recovery trails using data guard flashback and switchover.
• Setup RMAN backup / recovery strategies for Prod / Non-Prod databases.
• Working on SQL & Database performance issues.
• Working with Network / Storage teams for Server / Database maintenance activities.
IT Convergence Professional Services Pvt Ltd
Role: Primary DBA
Supporting Oracle 10gR2, 11gR2 with RAC, ASM & Dataguard
Responsibilities as Primary DBA:
• Primary DBA contact from offshore for assigned customers.
• Mentor / Help team members for resolving various db related issues.
• Support 24x7 operations for Production/Dev/UAT databases in Onsite/Offshore working model and ensure 100% uptime of IT Infrastructure for Clients.
• Installation of 11.2.0.3 Grid Infrastructure and RDBMS in multi-nodes for Prod and Non Prod environments.
• Upgrade of Grid Infrastructure and RDBMS from 10.2.0.4 to 11.2.0.3 version.
• Upgraded DB from 10.2.0.4 to 11.2.0.3 including platform migration from Sun Os 5.10 to RHEL 5.9 and RAC conversion.
• Production Support for 11Gg/10g GI, RAC & Standalone databases.
• Migration of databases from Non-ASM to ASM Storage including conversion from Standalone to Cluster envs.
• Oracle Data guard build, resolve various gap issues and maintenance activities.
• Alert monitoring using Nimbus Soft.
• Working with Oracle Support for resolving various Database high priority issues.
• Perform disaster recovery trails using data guard flashback and switchover.
• Setup RMAN backup / recovery strategies for Prod / Non-Prod databases.
• Working on SQL & Database performance issues.
• Working with Network / Storage teams for Server / Database maintenance activities.
Data Metrecs Ltd, Hyderabad
Role: Associate Programmer (April, 2002 - May, 2003)
Customer: National Library of Singapore, Singapore
Responsibilities as Associate Programmer:
National Library provides latest business information to the persons who are in quest of business information. The public needs to register with BusinessOne Virtual Community in order to access the information. Application enables the user to register as a member of BusinessOne Virtual Community. And can access other sites without registering with those sites. Application caters Services like providing solution (given by experts) to the queries and provides information on business book availability at various library centers.
Presently pursuing MBA in Operations Management from SYMBIOSIS, Pune. Bachelor of Commerce from Osmania University with 70% (1993-96)