Role as Oracle DBA

• Regular DBA Operational Duties
• Backups / Recoveries using RMAN and Tivoli.
• Resolving Performance tuning challenges
• Implementation Dataguard setups and managing.
• Quarterly Patch Management
• Applying patches to Oracle DBs on Linux and Oracle DBS on Solaris platform.
• Resolving RAC, Data guard related incidents
• Creating databases, Decommissioning of databases
• Communicating with Vendor and app owners.
• Oracle cloud control
• Right Sizing of the servers
• Change Management
• Cross Platform migrations from Solaris to Linux.
• Goldengate installation configuration & troubleshooting.
• Creating SOPs for the new procedures.
• Install, configure, and maintain (upgrade & patch) database software
• Create, monitor, and optimize database performance utilizing advanced performance tuning skills
• Database management on Exadata machines
• Data guard configurations on Exadata Machines.
• RAC DB creations
• Application Deployments for Instant payment application in Nordea bank

Project 1

Volvo Cars Corporation

Assignment

Oracle Service Manager

Location    

Gothenburg( Sweden)

Duration

03Feb14 to Nov2016

Team Size

20

Role

Service Lead, SME, Architect, Transition lead

Currently Delivering Volvo Cars

 Role as Oracle service Manager

• Incident Management, Change Management, Problem Management.
• Service level agreements, Contractual obligations
• Maintaining Key performance Indicators  for the Database services
• Maintaining service credit points
• Maintaining System appreciation Document, RISK register.
• Ensuring the Proper documentation for standard operating procedures.
• Ensuring the deliverables are mate every month
• Opportunities for new business from customer
• Knowledge transfer for among different site of Volvo cars
• Acquisitions of the new sites from different incumbents.
• Weekly, Monthly meetings with Customer service owner.
• Oracle License Management.
• Oracle Life Cycle Management.
• Managing Oracle Server Delivery
• Acquisition of new sites with appropriate knowledge transfer
• Handling Oracle Projects like transformation, Consolidations, Databases on Microsoft Azure cloud, Oracle VMs.
• Backup & Storage Strategies for the databases
• Capacity Planning for different platforms
• Performance Tuning recommendations
• Team Management: Team physical dispersed at various locations at china,North America,Budapest,India, Sweden

 Day-to-Day Operational responsibilities

 Installations&Designs

·         Installation of various Oracle versions on different Os versions

·         Creating the databases, decommissioning as per the request.

• Implementation of Oracle 11gr2 RAC databases.

·         Installing Oracle 12c databases

·         Installation of Oracle application servers

·         Installation of Oracle WebLogic server.

·         Overall integrations of the database with applications

·         Maintaining Asset  in service now

• Providing operational DBA supports for 800 Oracle databases.

Capacity Planning’s

·         OS level Space capacity reporting

·         DB level Space capacity report

·         Ordering required space and adding them in ASM Disk groups, tablesapces.

·         Space saving by moving the DB objects or shirking them.

Monitoring

• Discovering new tools for database monitoring
• Tivoli monitoring thresholds settings
• Oracle perspective Tivoli Monitoring configurations
• Tools like Solarwinds, Appdynamics, IQsonar
• Ensuring the DBs are backup up properly.
• Ensuring the Dbs are monitored by tools thoroughly.
• Customized reporting tools using Apache tomcat

Backups & Restorations

• Ensuring the backups are safe for all databases
• Tivoli Storage Manager configurations
• Defining the backups strategies
• Responsible for Daily, Weekly Backups.
• Backup retention policies
• RMAN/Datapump/Disk Backups
• Performing the restoration in the P1 situations.
• Moving the of the databases by restoring by RMAN

Upgrtdation& Patching

• Database Life cycle Management (EOSL)
• Applying Security patches
• Upgrading the database to 11gr2
• Database migration from 32-Bit to 64-Bit conversions.
• Database cross platform migrations.

Solutions

·         Suggesting High availability Solutions and implementing it.

• Maintenance of Oracle datagaurd databases
• Implementing the Physical standby databases
• Preparations of Disaster recovery plans.
• Maintenance of Real application clusters.
• Database performance tuning for Oracle 11gr2, Oracle 10gr2 databases.
• Tuning advisory,AWR,ASH.
• Maintain, Performance Monitor.
• Handling all troubleshooting issues effectively
• Oracle 10g application servers support and maintenance
• Oracle Transparent Gateways support and maintain ace
• Responsible for Overall Service availability of oracle databases.

Projectshandled

 Oracle Database Consolidation project

• Proposing the project and its efforts management
• Case studies
• Server / DB Mapping according to the SLA
• Automation of Database movement
• Reducing the license count
• Decommissioning of unwanted DBs
• Schema consolidation / DB consolidation

Volvo Cars Dealers Data Virtualization

• On-premise Database servers moved on Microsoft Azure cloud located in Japan.
• New Server layout, Database design
• Use of Oracle Labeled security for the DB consolidations
• Reduced Oracle License cost.

Performance Tuning Task force for VIDA Profile

• Identifying the performance bottle necks
• Measuring the performances
• Reviewing thresholds, Metrics.
• Reviewing Cache hit ratios, SGAs, RAM server capabilities
• Co relating with it infrastructures & proposing appropriate solutions
• Use of OEM,Tivoli,Appdynamics,Solarwind
• Achieved optimum throughput
• Presenting its actual benefits to business

Platform Transformation

• Implementation of java based Backup reports.
• Automation of Database up gradations using ansible
• TSM Backup server Migrations and performance enhancement
• Service now flow designs for variety of administrative Tasks
• Data guard Database sync report
• Automatized server delivery

Project 2

British Telecom

Assignment

Oracle Service lead

Location

Pune,Ipswitch,MiltonKenes (UK)

Duration

11/08/2010 to 07/02/2014

Team Size

10

Role

Oracle DBA Lead

Delivered at BT

• Proactively give DBA support for more than 255 Oracle databases
• Proactively tune the databases.
• Create and maintain documentation specific to DBA activities of the project
• Schedule and Plan database upgrades
• Maintain, Performance Monitor.
• Setting up the database thresholds & Metrics.
• Monitoring the Databases using DB control & OEM grid control.
• Backup Strategies, policies & solutions.
• Handling all troubleshooting issues promptly.
• Capacity plans for databases.
• Analysis of ADDM and AWR reports for all the application.
• Putting Monitoring in place for all the application.
• Automation of the monitoring done.
• Application database support.
• Backup Strategy document
• Handling all troubleshooting issues promptly
• Use of SQL profiling, Stored procedures, views for query tuning.
• Use of dbms_sqltune package
• Shrinking the objects which are highly fragmented.
• Use of segment space advisories.
• Maintain and updated the documents for DBA related issues
• Analysis of ADDM and AWR reports for all the application.

Project 3

Serco Solutions

Assignment

Oracle DBA lead

Location

Mumbai,Thane

Duration

As employee :   09/2009 – 08/2010 

As contractor : 08/2008 – 08/2009

Team Size

10

Scope

Oracle DBA Lead

·         Administration of 125 + SAP databases servers of Serco group.

·         Maintenance of all DR sites of all production servers.

·         Performance Tuning of all databases.

·         Recovering data from Database block corruption.

·         Database migrations.

·         Appling oracle interim database Patches.

·         Database Auditing.

·         Following SOX compliances.

·         Database Cloning.

·         Redo log resizing.

·         DB level Space management

·         OS level space management

·         Reorganizing the database objects.

·         ASM disk group maintenance.

·         Deciding Backup policies & methodologies.

·         Recovering Database in different scenarios.

·         Tuning rollback segments.

·         Moving databases to AUM.

·         SAP Basis Database Checks.

·         BR tools.

·         Use of RMAN in correlation with BRBACKUPS.

·         Doing Dawn Patrol Activity(Monitoring SAP systems)

·         Performing transports in PRD, QA and PROD system.

·         Tablespace Management through BRtools.

·         Performing Database activities for SAP.

·         Performing weekly DB checks in SAP.

·         Proactive DR Monitoring to avoid High severity calls.

·         Providing solution for EWA Analysis related to database.

·         User creations & assigning responsibilities.

·         File Space management.

·         Analyzing tables, schemas.

·         Hot Backups, offline backups.

·         Database performance tuning.

·         Managing User profiles as per requirement.

·         Restricting user from High CPU usage & from overburdening resource using.

·         Backup Validity & Testing.

·         Co-coordinating with Oracle Support to find the solutions.

·         Maintain the Oracle disaster recovery plans

Project 4

Advance Data Exchange

Assignment

Oracle DBA lead

Location

Pune

Duration

(01/2008) – (07/2008)

Team Size

25

Role

Oracle DBA

Delivered at ADX

·         Administering & managing the Oracle Database with custom scripts & oracle enterprise manager.

·         Responsible for database consistency of Oracle dual node RAC environment.

·         Managing Physical standby database.

·         Managing ASM disk groups, on production & development databases.

·         Manually rebalancing of disk groups.

·         Managing Tablespace, data files, redo logs, tables & other database segments.

·         Managing profiles, resources, password security.

·         Monitoring production database using automatic workload repository.

·         Moving non system & systems data files, reallocating archives.

·          Conducted physical & logical performance analysis of production database with new layout in structures.

·         Rebuilding indexes & analyzing tables.

Project 5

ITC-PSPD DBA support.

Assignment

Oracle DBA lead

Location

Bhadrachalam (AP) India

Duration

(03/2006) – (01/2008)

Team Size

25

Role

Oracle DBA

Delivered at ITC

·         Support production database & replication database in 24*7 operational modes.

·         Maintaining Oracle Parallel servers.

·         Data uploading using SQl Loader.

·         Performing Hot, logical backups of all production databases.

·         Oracle system architecture maintenance for optimum performance.

·         Performing Tablespace, database object reorganization.

·         Rebuilding indexes & analyzing tables.

·         Managing disk space, memory &other resources.

·         Solving Oracle Network related problems.

·         Tuning instance parameter by checking hit ratios, wait events, buffer busy waits using stats pack reports.

·         Maintaining oracle automated jobs.

·         Tracing & analyzing the sessions which are causing performance overhead.

·         Documentation of database processes & procedures.

Achivements

ü  Consistently honored with top rating

ü  Star Award at Techm

Träning/certifikatens/Education

Institution

Qualification

Period

University

Prince 2 Practitioner

Practitioner

Jun2016

Exin

Oracle RAC 2 day training

NA

Nov 2013

Oracle OTN Yathra, Pune

ITIL Foundation

Training

Feb 2008

Tech Mahindra Training center

SQL Star International

OCP

Mar 2004

Oracle Education,Pune

Pune University

MCM

APR2006

Pune University

Shivaji University

B.Sc

Oct 2000

Shivaji University