IBM
Total years of experience :18 years, 10 Months
having worked in memory management, Internal errors, DB Utilities like Export Import, Sql loader, sga and pga leaks, logminer, Streams, Advanced Queuing, Messaging Gateway, Oracle GoldenGate.
•Worked for 5 years in Oracle Corporation handling Oracle Global Customer Support for Memory management, Oracle Internal errors, Datapump, Export Import, DB Utilities, Memory leaks, Performance Tuning, Oracle Streams replication, Advanced Queuing, Messaging gateway, Oracle Golden Gate replication, Queue monitor.
•Well versed in PL/Sql development and Unix Shell scripting.
•Experience on database upgrade from Oracle 10g to Oracle 11i to 12c on production environment.
•Performance Tuning, Capacity Planning, Standby databases, Database cloning, refresh, and Patch management.
•Responsibilities of database tuning, memory tuning, user management & security, performance monitoring, backup & recovery (logical and physical) strategies for archive/non-archive databases, RMAN backup Implementation and validation, Physical Standby database.
•Oracle Database Administration (9i, 10g, 11g, 12c) and production support in 24/7 environment. Worked on database upgrades.
•Exposure to Vmware. Attended training on MongoDB.
•Excellent knowledge of Oracle Architecture, Normalization, Database creation, Space management, partitioning of table, Backup and Recovery, Performance tuning, Query Optimization, User management.
•Having good domain knowledge about Insurance and Payroll
Responsibilities:
•Management of Database implementations.
•Creating and Managing Databases in Dev, UAT and PRODUCTION.
•Interfacing with customers, analyzing their needs and providing recommendations on capacity planning, upgrades, migration of database, application architecture, disaster recovery and performance tuning strategies
•Handling installation, configuration & upgradation of Oracle Database server Software
•Installation, Configuration, Patching and Maintenance of ASM Instances.
•Managing, upgrade and troubleshooting of Goldengate Instances.
•Monitoring Oracle performance and tuning database as per requirement
•Developing shell scripts for managing and monitoring Databases and Database servers
•Working as a part of the team to provide 7X24 support when required
•Assisting the Development Teams with their Database related issues on production
ORACLE CORPORATION. Bangalore
Command line Installations of Oracle clients and servers on windows and Linux platform using config file in silent mode.
•Creation of database in RAC and stand alone using dbca command line, scripts and templates.
•Developed some Unix Shell scripts to automate database operation and database monitoring.
•Implemented database refresh with the hot backup using DUPLICATE or full export.
•Performed database tuning using Explain Plan, hints, Toad and Enterprise Manager.
•Used EXPORT/IMPORT to do table level and full database defragmentation.
•Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space availability, checking for errors in alert logs and trace files, etc
•Handling daily alerts and troubleshooting it with alert log and trace files.
•Performing database point in time (PIT) export or recovery
Clients:- Mfinancial, MetLife, Ameriprise, Guardian, Ez-Data, HSBC, RBC.
Responsibilities:
•Installations of Oracle clients and servers on windows and Linux platform.
•Creation of Development, Test and Production databases with users and roles.
•Scheduling and managing sound backup strategies.
•Implementing RMAN Backup and Restore.
•Capacity management (Includes-Archive, backups, backup copies and Flash recovery Area.)
•Development support for creating Tables, Indexes, Functions, Procedures, Synonyms, Sequences & Database Links.
•Troubleshooting database performance, listeners and networking issues.
•Writing procedures, functions, packages, triggers.
•Perform database tuning and performance monitoring.
•Migration of UDB database to Oracle.
•Developing shell scripts for migration and validation
Summary
•Highly accomplished, deeply driven database administrator with a successful track record of 12 years in Oracle Database Administration
Oracle 11g: Backup and Recovery
Oracle 11g: Performance Tuning
Business language communication
(
from
from