Oracle Project
Resume:
Sudhakar Govindassamy [pic]
***********@*****.***
[pic]
PROFESSIONAL SUMMARY
Highly accomplished, deeply driven, database engineer with a successful 8+
years track record of success in Oracle database administration which
includes installation, upgradation, patches, replication, performance
optimization, managing and developing backup and recovery plans of oracle
databases. And also responsible for integrity and security of a database.
Worked in various domains of expertise includes peformance benchmarking,
medical technology, telecommunication and logistics. Strong knowledge in
implementation of RAC databases on VMware Workstation and Oracle VM
VirtualBox for development and testing activities of the database.
Good knowledge in installation of Operating Systems which includes Redhat
Linux, Oracle Solaris and Windows. Repeatedly successful in navigating
technical environment, expertise in disaster recovery, performance tuning
and optimization. Exceed ongoing and overlapping deadlined in fast-paced
environments, handle multiple assignments simultaneously and deliverables
with key stakeholders in cross-functional groups.
. Involved in DBA activities for 24/7 Production Support on all
environments and ensure high availability.
. Monitoring day-to-day in-house Oracle databases with regards to
availability, performance and space management
. On-call (24*7) support to troubleshoot problems when necessary on a
rotation basis
. Conduct basic health checks, growth of objects, queues and query
performance and ETL performance.
. Develop standards and guidelines for access to data and implement
security measures to safeguard information in databases against
accidental or unauthorized damage, modification or disclosure.
. Understand the data and non-functional requirements by analyzing
requirement documents, and attending requirement walkthrough sessions.
. Performance tune databases based on performance (load, volume,
contingency) requirements.
. Suggest performance improvements including new indexes and partitions.
. Performance tune SQL queries and help developers rewrite queries in a
more efficient way.
. Performed Migrating Oracle 10g/11g Environments from Windows Server
Enterprise to Red Hat Enterprise Linux 5
. Develop procedure to automate and simplify user database access
. Implement a change control process and ensure its auditable
. Coordinate periodic operational activities to ensure database
compliance
. Verify database backup, restore and data refresh policies adhere to
controls
. Test programs and databases, correct errors and make necessary
modifications
. Approve, schedule, plan, and supervise the installation and testing of
new products and improvements to computer systems, such as the
installation of new databases.
. Communicate with Business to understand requirements and testers to
resolve defects.
. Providing System Testing, UAT and post implementation support for the
solutions.
Technology Snapshot
Extensive use and knowledge of databases including Oracle 9i, 10g, 11g & 12c
running on multiple platforms such as Redhat Linux, UNIX, Oracle Solaris &
Windows Server 2003/2008
Database Utility & : SQL*Plus, Export/Import, Data Pump, RMAN, Oracle 11g Grid
Tools Infrastructure, TOAD, Putty, VNC Server, OEM Grid Control
Middleware Software : Oracle GoldenGate, Weblogic Server
Performance Tools : SQL Tuning, Explain plan, SQL Trace, TK Prof, Statspack,
AWR & ADDM
Real Application Clusters Disaster Recovery ASM
PROFESSIONAL DEGREE
> Bachelor of Technology in Mechanical Engineering
Pondicherry University
PROFESSIONAL CERTIFICATIONS
> Oracle Certified Professional in 10g (OCP)
> Oracle Database SQL Expert Certified (OCE) in SQL
PROJECT DETAILS
Infrastructure & Outsourcing Services
Client : Inspirage, Bellevue, WA
Environment : RHEL Linux & Windows, Oracle 11g, 12c, Dataguard, RAC
Tools : Oracle 10g OEM Grid Control, TOAD, OPatch, Export/Import, Data
Pump, RMAN, Weblogic Server
Role : Senior Database Administrator
Domain : Infrastructure & Outsourcing Services
Duration : November 2013 to April 2014
Project Description
Inspirage is a high expertise global consulting firm that helps clients
realize breakthrough improvements across the value chain in areas from
product ideation through customer delivery.
Responsibilities
. Creating database objects in operational data store and maintaining
them.
. Routine Database Maintenance & consistency checks
. Providing regular DBA support for the database servers.
. Setting up database server based on customer request and providing end-
to-end support on installation and configuration.
. Creating, Configuring and deleting Oracle databases using the DBCA.
. Performing database backups (Logical and Physical) and performing
restoration and recovery when necessary.
. Managing the databases on Automatic Storage Management (ASM).
. Setting up Oracle Data Guard for high availability of Databases by
creating physical standby databases, troubleshooting and managing them
effectively.
. Troubleshooting database related problems and working towards fixing
it
. Automating DBA related activities using Shell script and PL/SQL
script.
. Managing the database's storage structures like control files, redo
log files, archive log files, Rollback segments, tablespaces, and
datafiles.
. Managing users and security by creating roles and profiles.
. Managing schema objects, such as tables, indexes, and views
Oracle GoldenGate Performance Benchmark
Client : Oracle Corporation, San Francisco, California
Environment : RHEL Linux & Windows, Oracle 11g, 12c, Dataguard, RAC
Tools : Oracle 10g OEM Grid Control, TOAD, OPatch, Export/Import, Data
Pump, RMAN, Weblogic Server
Role : Senior Database Administrator
Domain : Performance Benchmark
Duration : April 2011 to September 2013
Project Description
This project involves measuring the throughput of oracle goldengate
performance based on TPC framework by setting up various oracle database
environments including high availability in Linux and windows platforms.
Responsibilities
. Configure and build Golden Gate Extracts/replicate for multiple
databases.
. Configure and build heartbeat monitoring in Golden Gate.
. Configure error handling for restart, logging, production support and
status reporting in GG.
. Identify and produce documentation of best practices.
. Trouble shooting and performance tuning golden gate replications.
. Implementing necessary monitoring scripts for Golden gate in Unix/Perl
scripting
. Operational support experience
. Creating of Physical files
. Documentation of the Implementation
. Creating Users with Quota Management.
. Controlling the users operations by limit the memory spaces and grants
the necessary roles, privileges and profiles to the users.
. Monitoring unwanted sessions and killing them if needed
. Implemented Tablespace Encryption (TDE) in Oracle 11g Database.
. Implemented invalid login attempts auditing.
. Managing tablespace, datafiles and redolog files and its segments
. Monitor physical and logical backup and Recovery Strategies
. Cloning a database according to database implementation
. Monitoring and performing the backups using RMAN
. Monitoring physical and logical backup strategies.
. Monitoring Database growth.
. Managing undo segments redo logs.
. Migrating Oracle 10g Environments from Windows Server Enterprise to
Red Hat Enterprise Linux
. Logical Backup of Databases using Export and Import Utility.
. Recovery of lost objects and data files.
Medtronic
Client : Medtronic, Minneapolis, MN
Environment : Oracle 9i, 10g & 11g, UNIX, SUN Solaris & Windows
Tools : Oracle 10g OEM Grid Control, TOAD, Export/Import, Data
Pump, RMAN
Role : Database Administrator
Domain : Medical Technology
Duration : January 2008 to March 2011
Project Description
Medtronic is a global leader in Medical Technology, in Minneapolis, USA
which serves patients and partner with medical professionals in 120
countries. The Project consists of 1300 and more databases having wide
ranges which are running on multiple servers from 8i to 11g versions. It
has various departments like UNIX, Storage, Data center teams to
accomplish DBA activities and also to fulfill the customer request or
needs at any time. The major databases at Medtronic hold its own
organization business information such as Cardiac Rhythm Disease
Management (CRDM), Spinal and Biologics, CardioVascular, Neuromodulation,
Diabetes, and Surgical Technologies. Medtronic maintain good citizenship
through Medtronic Foundation grants, product donations, employee
volunteerism, and meaningful partnerships with global organizations and
time bound Medical Technology solutions have created a loyal band of
elite clientele that includes several leading companies all around the
world
Responsibilities
. Routine proactive maintenance of Oracle Database using shell scripts
and standard data collection mechanisms
. Working with team on production issues & and escalate the issues to
appropriate team if required.
. Installed, configured and maintained Oracle 10g,9i and 8i Databases on
UNIX Platform
. Reclaiming Physical disk space sizes after purging of unwanted data in
the database thus saving storage space, reducing the backup time and
improving performance of the queries as well
. Taking HOT and COLD backups using RMAN and shell scripts
. Responsible for capacity planning by collecting data regarding DB
growth, application usage
. Proactive monitoring and health checking of all DEV/TESTING/PROD
databases
. Connectivity and locking issues.
. Monitoring Users access, Tablespace usage, CPU usage on server.
. Recover / Restore the database if required.
. Applied database patches using Opatch utility.
. Installed statspack in the database to monitor the database
. Logical Backup of Databases using EXP / IMP Utility.
. Monitoring the Database size and add/resize datafiles when required.
. Granting specific privileges and roles to the users.
. Attending daily, weekly and bi-weekly calls with Customer (IT
divisions) for discussing on-going activities and upcoming projects.
. Clones/Refreshes.
. Trouble shooting Cloning and Patching issues.
. Quarterly password changes as per Client audit.
. Implemented Data Guard setup in production environment
Kalte India Pvt Ltd
Client : Tele Pacific (Prepaid Management Solutions)
Environment : Oracle 9i, Windows
Role : Oracle DBA
Domain : Telecom
Duration : March 2005 to December 2007
Project Description
Tele pacific is one of the leading Broadband and telecom, Calling Cards
solution providers in Australia. The company gives solution for combined
voice and Calling Card, broadband to all types of customers. The Project
consist of online balance management, products information, inquires and
billing solutions. This application allows to multiple users to view all
Billing Related information in different states as well.
Responsibilities
. Creation of tablespaces and datafiles for the project requirement.
. Monitoring alert log file.
. Managing database storage structure.
. Creating Users with Quota Management.
. Creating user Profiles.
. Granting specific privileges and roles to the users.
. Monitoring unwanted sessions and killing them if needed.
. Monitor physical and logical backup and Recovery Strategies.
. Implemented Backup procedures using daily hot backups and weekly cold
backups.
. Checking the consistency of the data files by DB verify utility.
. Logical Backup Using Export & Import utility.
. Monitoring the object growth and space management.
. Identifying Chained Rows and rectify them to increase the Performance
. Analyze and Rebuild Index to rectify segment fragmentation.
. Monitoring the database and gathering database statistics.
. Dropping unused objects (or) user after taking appropriate backup.
Contact this candidate