Senior Consultant- Oracle DBA
TriCore Solutions
مجموع سنوات الخبرة :24 years, 4 أشهر
Organization: TriCore Solutions
Designation: Senior Consultant- Oracle DBA
Duration: Sep 2013 - till date
Role & Responsibilities:
Database Administration Activities:
Managing 4 node RAC setup
Performing production installs and database patching.
Implementation of Oracle OEM agent.
Managing database performance using OEM 10g grid (10.2.0.4)
Handling and monitoring materialized view replication using db-links.
Working on physical standby databases
9i /10g database performance tuning on AIX, SOLARIS AND LINUX boxes
Running RDA and AWR to diagnose database performance issues
Databases upgrades from older versions to newer versions.
Maintaining 100 % SLA towards client's response and actions/resolutions
Backup handling using hot and rman jobs.
Enabling monitoring.
Handling Streams and Propagations.
Database Cloning.
Organization: TriCore Solutions
Designation: Senior Consultant- Oracle DBA
Duration: Sep 2013 - till date
Role & Responsibilities:
Database Administration Activities:
Managing 4 node RAC setup
Performing production installs and database patching.
Implementation of Oracle OEM agent.
Managing database performance using OEM 10g grid (10.2.0.4)
Handling and monitoring materialized view replication using db-links.
Working on physical standby databases
9i /10g database performance tuning on AIX, SOLARIS AND LINUX boxes
Running RDA and AWR to diagnose database performance issues
Databases upgrades from older versions to newer versions.
Maintaining 100 % SLA towards client's response and actions/resolutions
Backup handling using hot and rman jobs.
Enabling monitoring.
Handling Streams and Propagations.
Database Cloning.
4.Specialized software development
5.Corporate training in our area of specialization
The group consists of:-Softenger (India) Pvt. Ltd. which has provided
these services since 1990. Softenger (Singapore) Pvt. Ltd. which has
Integrated Oracle RMAN backup with Netback up
Period Oct 2010 to Sep 2013
Responsibilities:
• 24*7 Production Database Administration Support.
• Installation, configuration and support of Oracle RAC and Standby Databases (Active
DataGuard) for High Availability and Disaster Recovery.
• Cloned/Refreshed Oracle Databases for development and testing.
• Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g, Oracle 7i to 11g.
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN,
TKPROF, AWR, ADDM.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles,
extents, redo logs, archive logs) and assessed database capacity by monitoring online
storage, growth and file system space.
• Backup and recovery. Cold backups, hot backups, Logical backups, RMAN backups
(Full, Incremental Backups, Differential, Cumulative Backups)
• Monitoring Day-Day Backups, Log's.
• Successfully implemented Backup & Recovery solutions using RMAN (Full, Incremental
Backups)
• Responsible for capacity planning, database security, recovery planning and installing
patches
• Shell Scripting.
• 11g Client Installation on windows servers.
2. Employer Genpact .-Hyderabad
Genpact is a global leader in business process and technology
management, offering a broad portfolio of enterprise G&A and
industry-specific services. Putting process in the forefront-coupling
Description deep process knowledge and insights with focused IT capabilities,
targeted analytics and pragmatic reengineering-the Company
delivers a comprehensive client solution. Services are seamlessly
delivered from a global delivery network to meet a client's business
objectives, cultural and language needs, and cost reduction goals.
Role Consutant
Client Name GE
Genpact Pvt Ltd, Hyderabad.
Project=NBCU DBA Support
Oracle 7.3, 8.x, 9.x, 10g Databases
Disaster Recovery site configure using standby database.
Environment Integrated Oracle RMAN backup with Netback up.
Server Locations are new Jersey, LA-west
coast, London, France, Armsterdam, Qwest, DMZ, Orlando, Cincinnati, Alp
haretta, Newyork, where more than 480 databases of version 7.3 to 10g
ranging from 3 GB to 3 TB.
Period Feb 2009 to Oct 2010
Responsibilities:
• Rebuilding Dataguard databases from production database using hot, cold & RMAN
backups.
• Creating of new Oracle Databases as per NBCU standards.
• Handled Migration of critical Production databases.
• Patch Management/Upgrade Management
• Trouble shooting and problem resolution
• Taking care of database related Escalations, Raising Tars for critical errors, bug fixes.
• Coordinated with Oracle World Wide Support (Metalink) by means of Technical
Assistance Request (TAR)
• Uploading output, relevant trace files & Alert log files to Oracle Support for review & analysis
• Scheduling backup for oracle databases in commcell
• Setting up archive backups in cron (ASM)
• Restoring Database using RMAN Script.
• Restoring archive logs using RMAN backup scripts.
• Installation of cluster and RAC on sun, solaris & linux machimes.
• Set up trace and generate trace report for user session.
• Handling OEM alerts
• Creating new users in grid and subscribing email alerts
• Database Performance Tuning.
• Creating users, allocation of tablespace quotas for users in development databases.
• Export and import of big Schemas using data pump.
• Creating duplicate databases using RMAN scripts.
• Killing Specific user sessions on RAC databases.
• Completed Lean project by creating script for automatic Schema refresh using tns entries
• Adding datafiles in RAC/ASM databases on filesytems and raw devices.
• Evaluating oracle 10g new administrator features.
• Planning growth of database objects & extent management.
3. Employer Softenger India Pvt Limited. - Pune
Softenger (India) Pvt Ltd provides services in management of large IT
infrastructure. These services include: 1.System Administration (All flavors of Unix and Windows O/S)
2.Database Administration (Oracle, Sybase and SQL Server)
Description 3.Security evaluation and enhancement
Working at ABN AmRO Bank -Mumbai.
Project=Finacle DBA Support
Environment Oracle 8i, 9i, 10g DatabasesIt had more than 80 databases of version 8i
to 10g ranging from 2 GB to 400 GB.
Period July 2005 To September 2006.
Responsibilities: • Creating tablespaces and adding datafiles to the database as soon as we see any tablespace
alert.
• Creating users and assigning privildges to them as per user requirement.
• Database & software upgradation from 8i-9i-10g
• Monitoring alerts and releasing locks on tables as soon as we find any locks on the database.
• Checking alert logfile for any ORA errors.
• Monitor archive logs and zip, move, purge them periodically.
• Tablespace and table name patterns and rebuild all matching indexes or only those that
were too
too large very fragmented.
1. Employer Mphasis-Pune
MphasiS, a unit of Hewlett-Packard Co., is an information
technology services company based in Bangalore, India. MphasiS
Description is certified with ISO 9001:2008, ISO/IEC 27001:2005 and is assessed at CMMI v 1.2 Level 5..It is the sixth largest IT company in India with more than 38, 000 employees as of 2010. The company has 29
offices in 14 countries with delivery centers in India, Sri Lanka,
China, North America and Europe.
Role Senior Principal Infrastructure engineer
HP, Butterfield, Towers-Perrian, Ownes-
Client Name illions, NASD, Phoenix, Tops, Wester-Union, Affinia, EDS-
Autosys, Eli-lilly, Universal Music Group.
Working at Mphasis Pvt Ltd, Pune.
Project=East HUB Oracle Leveraged
Environment Oracle 7.3, 8.x, 9.x, 10g, 11g Databases
Disaster Recovery site configure using Production copy
1. Employer Mphasis-Pune
MphasiS, a unit of Hewlett-Packard Co., is an information
technology services company based in Bangalore, India. MphasiS
Description is certified with ISO 9001:2008, ISO/IEC 27001:2005 and is assessed at CMMI v 1.2 Level 5..It is the sixth largest IT company in India with more than 38, 000 employees as of 2010. The company has 29
offices in 14 countries with delivery centers in India, Sri Lanka,
China, North America and Europe.
Role Senior Principal Infrastructure engineer
HP, Butterfield, Towers-Perrian, Ownes-
Client Name illions, NASD, Phoenix, Tops, Wester-Union, Affinia, EDS-
Autosys, Eli-lilly, Universal Music Group.
Working at Mphasis Pvt Ltd, Pune.
Project=East HUB Oracle Leveraged
Environment Oracle 7.3, 8.x, 9.x, 10g, 11g Databases
Disaster Recovery site configure using Production copy
Integrated Oracle RMAN backup with Netback up
Period Oct 2010 to Sep 2013
Responsibilities:
• 24*7 Production Database Administration Support.
• Installation, configuration and support of Oracle RAC and Standby Databases (Active
DataGuard) for High Availability and Disaster Recovery.
• Cloned/Refreshed Oracle Databases for development and testing.
• Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g, Oracle 7i to 11g.
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN,
TKPROF, AWR, ADDM.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles,
extents, redo logs, archive logs) and assessed database capacity by monitoring online
storage, growth and file system space.
• Backup and recovery. Cold backups, hot backups, Logical backups, RMAN backups
(Full, Incremental Backups, Differential, Cumulative Backups)
• Monitoring Day-Day Backups, Log's.
• Successfully implemented Backup & Recovery solutions using RMAN (Full, Incremental
Backups)
• Responsible for capacity planning, database security, recovery planning and installing
patches
• Shell Scripting.
• 11g Client Installation on windows servers.
2. Employer Genpact .-Hyderabad
Genpact is a global leader in business process and technology
management, offering a broad portfolio of enterprise G&A and
industry-specific services. Putting process in the forefront-coupling
Description deep process knowledge and insights with focused IT capabilities,
targeted analytics and pragmatic reengineering-the Company
delivers a comprehensive client solution. Services are seamlessly
delivered from a global delivery network to meet a client's business
objectives, cultural and language needs, and cost reduction goals.
Role Consutant
Client Name GE
Genpact Pvt Ltd, Hyderabad.
Project=NBCU DBA Support
Oracle 7.3, 8.x, 9.x, 10g Databases
Disaster Recovery site configure using standby database.
Environment Integrated Oracle RMAN backup with Netback up.
Server Locations are new Jersey, LA-west
coast, London, France, Armsterdam, Qwest, DMZ, Orlando, Cincinnati, Alp
haretta, Newyork, where more than 480 databases of version 7.3 to 10g
ranging from 3 GB to 3 TB.
Period Feb 2009 to Oct 2010
Responsibilities:
• Rebuilding Dataguard databases from production database using hot, cold & RMAN
backups.
• Creating of new Oracle Databases as per NBCU standards.
• Handled Migration of critical Production databases.
• Patch Management/Upgrade Management
• Trouble shooting and problem resolution
• Taking care of database related Escalations, Raising Tars for critical errors, bug fixes.
• Coordinated with Oracle World Wide Support (Metalink) by means of Technical
Assistance Request (TAR)
• Uploading output, relevant trace files & Alert log files to Oracle Support for review & analysis
• Scheduling backup for oracle databases in commcell
• Setting up archive backups in cron (ASM)
• Restoring Database using RMAN Script.
• Restoring archive logs using RMAN backup scripts.
• Installation of cluster and RAC on sun, solaris & linux machimes.
• Set up trace and generate trace report for user session.
• Handling OEM alerts
• Creating new users in grid and subscribing email alerts
• Database Performance Tuning.
• Creating users, allocation of tablespace quotas for users in development databases.
• Export and import of big Schemas using data pump.
• Creating duplicate databases using RMAN scripts.
• Killing Specific user sessions on RAC databases.
• Completed Lean project by creating script for automatic Schema refresh using tns entries
• Adding datafiles in RAC/ASM databases on filesytems and raw devices.
• Evaluating oracle 10g new administrator features.
• Planning growth of database objects & extent management.
3. Employer Softenger India Pvt Limited. - Pune
Softenger (India) Pvt Ltd provides services in management of large IT
infrastructure. These services include: 1.System Administration (All flavors of Unix and Windows O/S)
2.Database Administration (Oracle, Sybase and SQL Server)
Description 3.Security evaluation and enhancement
4.Specialized software development
5.Corporate training in our area of specialization
The group consists of:-Softenger (India) Pvt. Ltd. which has provided
these services since 1990. Softenger (Singapore) Pvt. Ltd. which has
provided them since 2000.Our clients include large telecom and banking sector companies
Working at Citibank -Mumbai.
Project=BRDC DBA Support
Oracle 8i, 9i, 10g Databases
Environment
Citibank Has one of the big set up in India.Where more than 165
databases of version 7i to 10g ranging from 2 GB to 1 TB
Organization: TriCore Solutions
Designation: Senior Consultant- Oracle DBA
Duration: Sep 2013 - till date
Role & Responsibilities:
Database Administration Activities:
Managing 4 node RAC setup
Performing production installs and database patching.
Implementation of Oracle OEM agent.
Managing database performance using OEM 10g grid (10.2.0.4)
Handling and monitoring materialized view replication using db-links.
Working on physical standby databases
9i /10g database performance tuning on AIX, SOLARIS AND LINUX boxes
Running RDA and AWR to diagnose database performance issues
Databases upgrades from older versions to newer versions.
Maintaining 100 % SLA towards client's response and actions/resolutions
Backup handling using hot and rman jobs.
Enabling monitoring.
Handling Streams and Propagations.
Database Cloning.
1. Employer Mphasis-Pune
MphasiS, a unit of Hewlett-Packard Co., is an information
technology services company based in Bangalore, India. MphasiS
Description is certified with ISO 9001:2008, ISO/IEC 27001:2005 and is assessed at CMMI v 1.2 Level 5..It is the sixth largest IT company in India with more than 38, 000 employees as of 2010. The company has 29
offices in 14 countries with delivery centers in India, Sri Lanka,
China, North America and Europe.
Role Senior Principal Infrastructure engineer
HP, Butterfield, Towers-Perrian, Ownes-
Client Name illions, NASD, Phoenix, Tops, Wester-Union, Affinia, EDS-
Autosys, Eli-lilly, Universal Music Group.
Working at Mphasis Pvt Ltd, Pune.
Project=East HUB Oracle Leveraged
Environment Oracle 7.3, 8.x, 9.x, 10g, 11g Databases
Disaster Recovery site configure using Production copy
Integrated Oracle RMAN backup with Netback up
Period Oct 2010 to Sep 2013
Responsibilities:
• 24*7 Production Database Administration Support.
• Installation, configuration and support of Oracle RAC and Standby Databases (Active
DataGuard) for High Availability and Disaster Recovery.
• Cloned/Refreshed Oracle Databases for development and testing.
• Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g, Oracle 7i to 11g.
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN,
TKPROF, AWR, ADDM.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles,
extents, redo logs, archive logs) and assessed database capacity by monitoring online
storage, growth and file system space.
• Backup and recovery. Cold backups, hot backups, Logical backups, RMAN backups
(Full, Incremental Backups, Differential, Cumulative Backups)
• Monitoring Day-Day Backups, Log's.
• Successfully implemented Backup & Recovery solutions using RMAN (Full, Incremental
Backups)
• Responsible for capacity planning, database security, recovery planning and installing
patches
• Shell Scripting.
• 11g Client Installation on windows servers.
2. Employer Genpact .-Hyderabad
Genpact is a global leader in business process and technology
management, offering a broad portfolio of enterprise G&A and
industry-specific services. Putting process in the forefront-coupling
Description deep process knowledge and insights with focused IT capabilities,
targeted analytics and pragmatic reengineering-the Company
delivers a comprehensive client solution. Services are seamlessly
delivered from a global delivery network to meet a client's business
objectives, cultural and language needs, and cost reduction goals.
Role Consutant
Client Name GE
Genpact Pvt Ltd, Hyderabad.
Project=NBCU DBA Support
Oracle 7.3, 8.x, 9.x, 10g Databases
Disaster Recovery site configure using standby database.
Environment Integrated Oracle RMAN backup with Netback up.
Server Locations are new Jersey, LA-west
coast, London, France, Armsterdam, Qwest, DMZ, Orlando, Cincinnati, Alp
haretta, Newyork, where more than 480 databases of version 7.3 to 10g
ranging from 3 GB to 3 TB.
Period Feb 2009 to Oct 2010
Responsibilities:
• Rebuilding Dataguard databases from production database using hot, cold & RMAN
backups.
• Creating of new Oracle Databases as per NBCU standards.
• Handled Migration of critical Production databases.
• Patch Management/Upgrade Management
• Trouble shooting and problem resolution
• Taking care of database related Escalations, Raising Tars for critical errors, bug fixes.
• Coordinated with Oracle World Wide Support (Metalink) by means of Technical
Assistance Request (TAR)
• Uploading output, relevant trace files & Alert log files to Oracle Support for review & analysis
• Scheduling backup for oracle databases in commcell
• Setting up archive backups in cron (ASM)
• Restoring Database using RMAN Script.
• Restoring archive logs using RMAN backup scripts.
• Installation of cluster and RAC on sun, solaris & linux machimes.
• Set up trace and generate trace report for user session.
• Handling OEM alerts
• Creating new users in grid and subscribing email alerts
• Database Performance Tuning.
• Creating users, allocation of tablespace quotas for users in development databases.
• Export and import of big Schemas using data pump.
• Creating duplicate databases using RMAN scripts.
• Killing Specific user sessions on RAC databases.
• Completed Lean project by creating script for automatic Schema refresh using tns entries
• Adding datafiles in RAC/ASM databases on filesytems and raw devices.
• Evaluating oracle 10g new administrator features.
• Planning growth of database objects & extent management.
3. Employer Softenger India Pvt Limited. - Pune
Softenger (India) Pvt Ltd provides services in management of large IT
infrastructure. These services include: 1.System Administration (All flavors of Unix and Windows O/S)
2.Database Administration (Oracle, Sybase and SQL Server)
Description 3.Security evaluation and enhancement
4.Specialized software development
5.Corporate training in our area of specialization
The group consists of:-Softenger (India) Pvt. Ltd. which has provided
these services since 1990. Softenger (Singapore) Pvt. Ltd. which has
provided them since 2000.Our clients include large telecom and banking sector companies
Working at Citibank -Mumbai.
Project=BRDC DBA Support
Oracle 8i, 9i, 10g Databases
Environment
Citibank Has one of the big set up in India.Where more than 165
databases of version 7i to 10g ranging from 2 GB to 1 TB
Role Oracle Database Administrator.
Client Citibank-Mumbai
Period September 2006 to February 2009.
Responsibilities:
• Installation of Oracle 8i, Oracle 9i and oracle 10g on Sun Solaris 2.6, 2.7 HP-UX and IBM-
AIX platforms.
• Creating data guard databases & logical databases.
• Database & software upgradation from 8i-9i-10g
• Planning growth of database objects like tablespaces & extent management.
• Handled Migration of Production database from Oracle 8.1.7 to Oracle 9.2.0.6.
• Part of implementation team for Disaster Recovery Scenario which includes Database,
application and Network Level changes.
• Planning Schedules of Backups (export Dump/Online/Offline)
• Perform database copies (refresh) from one environment to the other and manage all
related tasks
• Work closely with the Application users to schedule the application of patches into the system
• Configure database tuning parameters to ensure efficient operation of the database
• Create, Configure Size and Maintain databases to Support Applications
• Routinely review database logs to review alerts and take corrective actions as deemed
necessary
• Manage and maintain database security and database configuration.
• Databases movement from HP to Hitachi storage which is of 1000 GB.
• Applying VTM patches on quarterly Basis on production, development, staging servers.
4. Employer Cms Computers Ltd. - Mumbai.
CMS Computers Ltd is a leading IT and IT solutions provider in the country with 10000+ professionals worldwide offering wide range of
solutions services across various verticals in strategic IT consulting,
Networking, Training, Outsourcing, Platform delivery, Facility
Description Management, Customizing & Implementing Solutions, on site service
& support, and Applications Management support. We have 4 regional
centers with 40+ branch offices, 3 R&D centers and 3 Software
development centers and support engineers across 160 locations in the country.
Role & Responsibility Junior Database Administrator
Client ABN Amro Bank
• Proactively take care of potential performance issues due to uncommitted hung queries or poor query. Education Details Sr. Board/Univers % acquire / Degree Year of Passing No. ity Grade Oracle9i Certified Professional Oracle July 2005 96% 1 Database Administrator Corporation
University of Nov 2003 55% 2 Bachelor of Engineering Mumbai Professional Qualification: Bachelor of Engineering Oracle Certified Associate (OCA 9i DBA) (scored 100% marks in Fundamentals1) Oracle 10g Certification from Oracle University