Summary

• Oracle Certified DBA with over 10 years of extensive experience in the field of Information Technology Computer Science.
• Working as Oracle Database Administration, Systems Analysis, Project Management, Infrastructure Support, design, implementation, configuration, installation, performance tuning, backup recovery of Oracle V7.3/8i/9i / 10g r2 and 11g.
• Providing support for Oracle databases in LINUX and WINDOWS environments.
• Oracle Database Administration supporting ERP package of L T which is similar to SAP or Oracle e-Business suite.
• Ability to lead, manage, plan projects, problem solving, day-to-day operational activities including break/fix, space management, backup and restore and working efficiently with other team members, developers , project managers and system administrator's.
• Provided Level 1 support and 24X7 on-call production and development support to ensure daily production business requirement are met.
• Hands on working experience in Backup and Recovery procedures Hot Cold Backup and also worked with Recovery Manager RMAN Backup utility of Oracle.
• Willing to work as a key player in challenging and creative environment.
• Knowledge of different stages of Software Development Life Cycle SDLC
• Experience in Performance Tuning using Explain Plan and STATPACK
• Well-versed in Backup and recovery Logical backup and recovery using export/import.
• Having excellent problem solving capabilities and ability to respond positively to varied situations.
• Self having ability to handle multiple tasks and solve complex problems.
• Few of my qualities are excellent leadership skills in leading a team, analytical skills, logical reasoning, interpersonal skills and attitude to lead. Excellent communications skills, fast enthusiastic learner, excellent work ethics and a good team player.

Technical Skills

Professional Experience

Confidential

Role: Oracle DBA Developer

Responsibilities:

• Monitoring alert logs, trace files, disk space, etc periodically through scripts and automating reports through mails
• Provided primary administrative support for Oracle 9i/10g databases in LINUX and WINDOWS environments.
• Consulting with administrative and technical staff to determine information needs, data flows and system definitions.
• Manage table space by resizing or adding data files. Rebuild the indexes when necessary.
• Creation of user, roles and profiles. User Management Security Administration.
• Creation and re-organization of database, table spaces, rollback segments.
• Restoration of cold backup on DR site from production database.
• Recover the logical standby database. Creation of Physical Oracle Data Guard with RMAN
• In house training for RAC implementation.
• Installed Oracle 10g RAC on Linux platform using ASM for a storage manager
• 10g RAC switchover and failover configuration, implementation, and testing.
• Proficient in Installing, Upgrading, Migrating, Configuring Supporting Oracle Databases 9i/10g, on call Support, Performance Tuning Trouble shooting etc.
• Implemented Backup Recovery policies. Took logical physical backups. Daily, Weekly Monthly
• Recovered Oracle databases in scenarios like block corruptions, disk failures, machine movements for different clients at remote locations.
• Report generation as of requirement of clients.
• Responsible for checking Oracle database MAX parameters and planning for recreation of control file whenever required.
• Planning for backup and recovery of database information
• Backup and recovery strategy implemented
• Collect and analyze data to assist end users with troubleshooting
• Prepared documentation requirements in order for users to learn how to manage the phases of the database.

Environment: Oracle 10g, 10g RAC, RedHat Linux 5.0, SQL, PL/SQL

Confidential

Lead Oracle DBA

Responsibilities:

• During this project I have 8 years experience with Oracle implementations on various project sites across different geographical location.
• Worked in a dynamic, multi-tasking environment, which is essential part of my current assignment.
• Total 10 years working experience in a 24x7 HA environment
• I did Monitoring, optimizing and ETL for ERP system which is similar to SAP or Oracle e-Business suite.
• Developed and implemented an enterprise wide Payroll application for monthly payroll system creation for all staff working in the Region. Functionality was derived from PeopleSoft.
• Worked on oracle 7.3, 8i, 9i / 10g 11g, SQL Server Active/Active Cluster.
• I have also done performance tuning for same.
• Experience in installing, upgrading, and managing OEM Grid Control for 10g.
• Good Experience in Performance Tuning Packs, Backup Recovery, Grid Control
• Involved in query tuning and used to do performance tuning as per requirement.
• Involved in planning implementation of backup and recovery of database received from various job sites, which reflect my problem solving skills/ability.
• Attended training for RAC implementation, during this project work.
• Involved in RAC implementation while conversion of system took place.
• Involved in 10g RAC switchover and failover configuration, implementation, and testing.
• Implemented supported system of a major commercial business packaged application solutions for managing Construction projects similar to SAP.
• Experience in Backup and Recovery procedures Hot Backups, Cold backup and Recovery Manager RMAN .
• Used to do identification of performance bottlenecks in the system and used to do performance tuning, if required.
• Have in-depth knowledge of Oracle Applications technology stack, including architecture, installation, as per management norms.
• Used to do configuration, maintenance, cloning and patching procedures as and when required.
• Involved used to Co-ordinate with development team for database design configuration, which includes physical logical Design of Database, creation of Database Links,
• Creation of Database Links as per system guide lines as per management policies.
• Working knowledge of Data warehouse Data Guard Oracle's database replication product.
• Have knowledge of Oracle Streaming, OEM 10G Grid Control.
• Used to co-coordinate I worked with Development team, who used to work in SQL DDL, DML, and PL SQL command/coding, while system modification takes place. Knowledge of Net8 SQL Net.
• Have hands-on experience of, Operational Data Storages, Decision Support Systems, during my project work Database Performance tuning.
• Competent in Unix/Linux shell scripting.
• Implemented data back-up and other system housekeeping procedures.
• Submitted various MIS Reports to my higher management as well as I used to co-ordinate my team.
• Used do preparation of documentation, provide them to team members for the system, while working with team members.
• Knowledge of Windows Server 2003-2008, Blue Coat Proxy Server / HP Blade System C3000 C7000
• Ability to manage multiple tasks simultaneously and complete work within allocated time-frames, as some time I get short notice period to system Up gradation in my region, I used to complete the task in given time limit which you can see in my Achievements .

Environment:

• Platform: OpenVMS Server /Windows 7 / Vista / XP/ SCO UNIX 3.2v4.0 / Linux 5.0
• RDBMS: Oracle 7.3 / 8i /9i /10g r2/ 11g Oracle 10g RAC Environment

Challenges achievements in this project:

• There were around 150 odd project sites under my region located at different geographical locations, total project sites value was 500 M USD.
• I have converted 80 different major important project site's data in span on 3 months, 12 weeks each job has different data size, varying from 1.5 GB to 200 GB
• Total size for the all project site's data I have converted is around 20 TB, which was VLDB.

Confidential

Sr. Oracle DBA

Responsibilities:

• Used to do monitoring and optimising ERP system performance and system tuning for same.
• Used to Co-ordinate system updates and replacement of old versions.
• Worked on system similar to Oracle Financial Services OFS
• Used to Co-ordinate system team for up gradation and replacement of old versions. Oracle 7.3 to 8i 8i to 9i as per manage policies.
• Total data size I was handling was around 100 GB to 250 GB.
• Have done Export / Import of Data / Data Loading / Backup-Recovery/Data Manipulation / Performance tuning of Database as and when required.
• Supported Uses Worked for creation of different financial reports like Ledger / Accounts / Trial Balance / Balance sheet.
• Supported Worked with Payroll team for monthly payroll creation for all staff working in the Region.
• Guided/supported worked with development team any new reports need to be created as per user requirement.
• Ensuring to create healthy I.T team environment in the team.
• Have analytical ability to gather requirements by asking questions by gathering required information.

Environment:

• Platform: Win XP / Windows 2000 / Windows Vista
• Hardware: Desktops Laptops from HP / Compaq / Dell /Acer / Zenith etc.
• RDBMS: Oracle 9i / 10g

Confidential

Sr. Oracle Administrator

Responsibility /Nature of work:

• Worked as Oracle DBA Network / Systems Administrator on this project site.
• Done installation Oracle8i on Servers / Client PCs, Installation D2K on Client PCs, Configuration of Client PC for Connectivity to Server Database.
• Done developmental work using PL/ SQL programming and Developer 2000 using FORMS 4.5, REPORTS 2.5, Oracle Browser Utility, Oracle 8i on Windows NT Platform.
• Involved in IMPORT / EXPORT data DMP file Transfer from Oracle Database Data Manager Utilities , Database Administrator Adding/Removing Users in Domains, Grant / Revoke Privileges for user account according to need in Network Environment.
• My scope was to do the installation of Windows NT on NT servers, Creation of Domains, Installation Oracle8i on Servers / Client PCs, Installation D2K on client PCs
• Involved in configuration of Client PC for Connectivity to Server Database, Developmental work using PL/ SQL programming and Developer 2000, along with FORMS 4.5, REPORTS 2.5, Oracle Browser Utility, Oracle8i on Windows NT Platform.
• Successfully complete networking for Alpha server AS800 along with Windows NT Servers HP NT Server LH3R connected with 50 PCs, HP Brio BA600 / Compaq and all Printers and plotter are successfully connected in LAN / WAN, in an Area of 475 500 Meter., which smoothly work till the completion of project, without any problem.
• Implemented Backup Recovery policies. Took logical physical backups. Daily, Weekly Monthly for the project.
• Implemented system for disaster recovery in case of system crash down.
• Used to do system tinning, performance monitoring for the system.

Some of the achievements made by me during his Posting at Project Seabird:

• Successful Installation of on NT servers, Creation of Domains, Installation Oracle8i on Alpha server AS-800 installation with all required software in-house developed systems for Accounts, Purchase, stores and others departments, on own single handed, without any support, which is still running smoothly.
• Done installation Windows NT Servers HP NT Server LH3R Network along with Alpha server AS-800 connected with 50 PCs, HP Brio BA600 / Compaq All Printers are connected in LAN With in office area / WAN- out of office , in an Area of 475 500 Meter.
• INTRANET-Using VSAT with our Corporate / Regional offices with Voice-Mail Connectivity with Routers and Data Transfer Facility Remote Terminal Access User Login controls.
• Apart from the above, I have a good communication skill and computer skill and
• Involved in different stages of SDLC for the implementation of various systems available for the job sites.
• Handled supported various system for the project ex. Stores systems/ Procurement system / Time Office / Sub contractor billing System / Asset Management System.
• Sound knowledge of L T's ERP package, EIP Enterprise Information Portal which is based on ASP, .NET and SQL server.