Information Technology Oracle
Resume:
Ramesh Vidap
***********@*****.***
Profile Summary:
MBA in Systems/IT and Oracle certified professional with over 10 years of work experience in IT.
Experience in Installation of Oracle products (9i,10g,11g) on UNIX (HP-UX, Linux, AIX) and Windows servers.
Experience of maintaining and supporting large Oracle Database in Production Test and Development Environment.
Database and Schema Refreshes using Export and Import, Hot backup and cold backup cloning .
Applying patch sets and routine security patches.
Security administration and user management involving roles, privileges etc
Monitor database utilization and capacity to meet application demands.
Performance tuning using AWR and ADDM, Execution Plan, Hints and Index.
Automation of database daily housekeeping jobs through PL-SQL and UNIX shell scripting
Installation, configuration, and administration of Data guard, Golden Gate and RAC.
Oracle Enterprise Manager 11g & 12c administration.
Sql server db instance backup and restoration, session monitoring.
Identifying and fixing various ORA errors and raising SR to the Oracle support team when required.
Worked in Agile environments with Scrum and Kanban and used Agile testing practices
Worked with Project and Defect management tools such as Rally, JIRA and HP Quality Center
Hands on experience with databases including Oracle SQL, PL/SQL and Sql Server involving stored procedures, triggers, functions, indexes, and packages.
Hands on experience with Putty, WinSCP, VNCviewer, etc.
Programming experience in UNIX Shell Script.
Strong analytical skills with ability to quickly understand client’s business needs.
Involved in meetings to gather information and requirements from the clients.
Research-oriented, motivated, proactive, self-starter with strong technical, analytical and interpersonal skills.
Technical Skill Expertise:
Programming Languages
SQL, PL/SQL, VB, Unix Shell Script, Windows batch script,
Database Utilities
GoldenGate, RAC, Dataguard, OEM, RMAN, Datapump, Streams, Embarcadero, ASM
Tools & Utilities
Putty, WinSCP, VNC viewer, Toad, SQL Developer, PB9, Autosys, HPQC, Jira, Rally
RDBMS
Oracle 9i, 10g, 11g, 12c, SQL Server 2012, MS Access
Operating Systems
Windows 2000/XP, Linux, UNIX
Professional Work Experience:
Travelers, Hunt Valley, MD Aug 2014 – Till Date
Senior Database Administrator
Responsibilities:
Supporting 24x7 for over 200 Oracle databases on various versions and platforms.
Installation of Oracle Database and client software's as per application requirement.
Tune databases, applications, monitor performance of database servers, related processes CPU, memory, storage, and network.
Through knowledge of Oracle tools like OEM, RMAN, SQL Loader, AWR, ASH, ADDM TOAD, SQL trace to perform daily jobs
RMAN Database backups and recovery strategies for the new databases. Configuring automated backups on the databases using shell scripts with Crontab and Autosys.
Physical and logical standby DB creation using Data Guard as per requirement for high availability.
Upgrade 11g databases to 12c. Database refresh activities as per requirements.
Clone databases from PROD to Dev/Test databases, RAC to NONRAC.
Database Performance Tuning SQL Tuning for required applications.
Automating data movement activities with Exp/Imp, Datapump, ETL techniques.
Providing all kinds of DBA support to development teams and production support to the application.
Develop and maintain backup and recovery strategy to provide reliable database as per database downtime and transactions.
Space management and optimization space usage using techniques like compression, Defragmentation.
Develop UNIX shell scripts, Batch scripts, SQLs, PL/SQL procedures, functions, packages and triggers to support and automate repetitive task.
Proficient in using features like Data pump, Flash-Back Recovery, Table space Management, Transportable Table space, Recycle bin
Citigroup, Irving, TX Aug '13 – Aug '14
Senior Oracle DBA
Responsibilities:
Installation and managing of Oracle 11g Databases on Linux and Windows environment.
Planning and implementing the Backup strategy using Logical backups, Cold backups, Hot backups, and RMAN database backup.
Database refresh with Oracle utilities like SQL*Loader, Export/Import, RMAN and DataPump.
Data movement activities across database versions and platforms.
Monitored and diagnose database performance through monitoring of alerts files, trace files and log files.
Incident handling from different databases and Applications.
Monitoring of standby db and Golden Gate for ensuring business continuity & fixing lag issues.
Support for Oracle streams, Golden Gate, Dataguard
Performance tuning with help of ADDM and ADDR reports.
Preparing shell scripts for backups and monitoring databases.
Hungama Digital Media July '11 – July '13
Oracle Database administrator
Responsibilities:
Installation and configuration of Oracle ASM and non-ASM Databases (9i, 10g, 11g) on Linux.
Managing Oracle RDS cloud Instances.
Up gradation of databases applying patches, patch sets
Implementing RMAN backup, Monitoring and Fixing Backup failures.
Apply bug fix patch in production and Non-production databases.
Up-gradation of databases from Oracle 9.2.0.6 later to 11R2 for production and non-production environments.
Identifying Database performance issues and fixing them with help of AWR and ADDM reports.
Ad-hoc Tasks (Collecting job listing / Assist AD team / Adhoc monitoring).
Configuring of Oracle Streams and monitoring replication.
PL-SQL coding and ETL with Oracle utilities like SQL*Loader, External tables.
AO Smith, Irvine CA Apr '11 – July '11
Database Administrator
Responsibilities:
Automating backup jobs using shell scripting
Progress Database Support on MFG/PRO ERP environment
Dump/Load of Production databases
Sun Pharmaceuticals Oct '07 – Apr '11
MIS Officer
Responsibilities
Installation, configuration, administration of Oracle database and client on Windows, UNIX and Linux environment.
Basic database administration like Backup, Tablespaces management, User and Role Management.
ERP Functional support and troubleshooting technical issues related to application and data.
Educational Qualification:
Master of Business Administration (MBA) in Systems/Information Technology and Finance.
Professional Certification/Training:
Oracle OCA 9i certified.
Online Exadata training from Oracle University.
Contact this candidate