SUMMARY

• Over EIGHT years of experience as an Oracle Database Administrator in providing 24X7 production and development support for 11g/10g/9i databases on different platforms like SUN SOLARIS, Red Hat Linux and Windows and over TWO years of experience as an SQLSERVER DBA.
• Proficient in database administration, installation, configuration, upgrades, patches performance tuning, backup and recovery, cloning, space management, troubleshooting, physical and logical database design.
• Experience in implementation of High Availability solutions with Oracle 11gR2 Real Application Clusters (RAC) with ASM, Physical Standby Databases (Data Guard).
• Experience in Migration of Database from 9i to 10g, 10g to 11g.
• Experience in performing backups and recoveries using conventional hot & cold backups and RMAN.
• Knowledge and experience of managing Oracle 11gr2RAC environments.
• Good knowledge in logical backups, Hot/Cold Backup and Recovery and Cloning of databases using RMAN, IBM Tivoli Storage Manager (TSM).
• Experience Troubleshooting skills in OS level and Database level.
• Experience in cloning oracle databases for development and testing.
• Experience in using OEM, Data Migrations using export/import using Load testing tools.
• Experience in Implementing Data Pump, Export and Import utilities.
• Experienced in using 10g features Data pump, Flash - Back Recovery, AWR, ADDM, Grid Monitoring.
• Good experience in resolving the issues related to installation, upgrades and patches.
• Experience using Oracle 10g Flashback on Database, Drop & Table features.
• Good Knowledge with databases running on UNIX /Linux using ASM.
• Working experience in both OLTP and Data warehousing environments.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Good knowledge in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Expertise in creating and scheduling jobs through OEM.
• Proficient with 11g new features: Active Datagaurd, configuring Snapshot standby database.
• Experience working with the client side, doing requirements gathering, providing innovative solutions, client interfacing and support for application and queries.
• Expertise in cross platform data migrations using Transportable Table spaces.
• A Self-starter with a positive attitude, willingness to learn new concepts and acceptance of challenges.
• Excellent interpersonal skills and analytical skills.
• Experienced in Oracle Support (raising SR) processes for technical requests via Metalink.
• Have good knowledge and understanding on oracle security and auditing.
• Have analytical, problem solving, communications and interpersonal skills with ability to
• Interact with individuals at all levels
• Monthly reviewing of audit related log files to check violations as per the PAD-ITPM policy.
• Managing Users, Roles, Privileges, Backup databases and refresh activities in SQL server.
• Configuring maintenance plan in SQL server.
• Configuring databases mirroring, role changing of mirroring databases in SQL Server.
• Installating MS-SQL Server with service pack for SQL server.
• Worked on backup failures in SQL server. Monitoring the database via SQL server profiler.
• Has good experience in SQL Server MSSQL Server 2000/2005 Log Shipping, Database Mirroring.
• Oracle 11gr2 OCP certification completed
• ITIL certification completed

TECHNICAL SKILLS

Operating Systems: WINDOWS NT/2000/2003 Server, Red HAT Linux 9/8/7.2/7.1/6.2, RHEL 2.1/3.x/4.x, Sun Solaris 8/9/10

RDBMS: Oracle Server 9i/10g/11gR2, SQL Server 2005 & 2008

DB Management: OEM 9.2/10g (10.1/10.2), Grid control (RAC)

Tuning/Monitoring: RAC 11gR2, Data-Guard 9i/10g/11g, DB Cloning, Standby databases, RMAN 9i/10g/11g/, TKPROF, EXPLAIN PLAN, STATSPACK

PROFESSIONAL EXPERIENCE

Confidential, NYC

Oracle DBA

Responsibilities:

• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution for multi-terabyte database issues during Pre & Post GO-LIVE period. Daily Health Check Up of the Database.
• Installation, Configuration and Administration of Oracle 11gr2 RAC.
• Upgrading production and development databases to Oracle 11g.
• Installation and creation of 10g and 11g databases in Dev/Test environment.
• Participate in disaster recovery exercises using Oracle Dataguard technologies including Fail-over and Switch-over operations.
• Delivering SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Stats pack) reports, ADDM, SQL Tuning Advisor, Oracle Enterprise Manager (OEM), Grid control.
• Experience in Implementing Data Pump, Export and Import utilities.
• Conducting sizing and capacity planning for Oracle databases.
• Upgraded development and test databases to Oracle 11g.
• Applied patches to Oracle Databases and Oracle Applications.
• Cloned/ Refreshed Oracle Databases and Oracle Applications for development and testing.
• Oracle RMAN configuration for backups to disk and tape. Implemented Backup & Recovery strategies and performed Disaster & Recovery drills
• Backup & Recovery (Hot, Cold, Logical and RMAN Incremental Backups)
• User roles and profile management for enforcing password complexity and securing databases
• Database security and auditing
• Optimizing the SQL’s for maximum performance EXPLAIN PLAN
• Creating SR (Oracle Support request), follow up with Oracle support, running diagnostic scripts and upload output files to oracle support
• Maintained all documents of Oracle database operations. Prepared documentation of database backup and recovery standards.
• Monitored the various database activities such as BACKUP, ERROR LOGS, Space, Objects, Performance, User and Session monitoring to ensure proper capacity and availability.

Environment: Oracle 11g RAC Sun Solaris, Red Hat Linux, Windows, OEM, RMAN, ASM, Oracle Dataguard

Confidential

Database Administrator

Responsibilities:

• Managing 1500+ databases under the Europe, Asia Pacific and North America regions.
• Monitoring alert logs, trace files, disk space, etc periodically through scripts and automating reports through mails
• Managing space by resizing or adding data files.
• Knowledge in Installation, Configuration of Oracle on Sun Solaris, Linux, NT.
• Monitored the backup and check its consistency in TSM,RMAN,EXPORT
• User management and security such as creating users, assigning profiles, roles & privileges.
• Managing, monitoring and synchronise the physical standby databases.
• Database support using ITSM, Request Centre, Remedy ticket system, DBCR, GICC and eTracker system.
• Refreshing the test database with the production database.
• Monthly reviewing of audit related log files to check violations as per the PAD-ITPM policy.
• Implemented the Database Access Management - Vulnerability (DAM-VA) process.
• Implemented the Password Auto Repository tool.
• Preparation of daily operation report.
• Interacting with Oracle Corporation for technical support.
• Applying oracle security patches.
• Taking manual backups as and when required.
• Migration/up gradation to new releases.

Environment: Oracle 11g RAC Sun Solaris, Red Hat Linux, Windows, OEM, RMAN, ASM, TSM, Oracle Dataguard

Confidential 

Database Administrator

Responsibilities:

• Oracle Installation/Migration of various versions from 9i and 10g.
• Oracle Data Guard for maintained oracle disaster recovery and OEM for database monitoring, performance and diagnostics are been configured.
• Monitored and Tuned database to optimize the performance and satisfy the availability.
• Installing new software releases, upgrades, evaluates and installs patches and resolves software related problems.
• Performance Tuning by using Oracle utilities like Stats Pack, Tkprof for addressing performance bottlenecks are performed.
• Taken Backup & Recovery by using RMAN.
• Analyzed and monitored that data got by ADDM performed logical database using Export utility
• Export and import of different databases using Oracle DATA PUMP Export / Import utilities.
• Table fragmentation tuning, partitioning the large table by date.
• Provided all kinds of DBA support to development teams as well as production support to various tasks.
• Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
• Supported development effort by providing SQL statement tuning and query performance bottlenecks by using tools Explain Plan, SQL Trace, Tkprof and Oracle Enterprise Manager
• Trouble shooting and resolving any database and/or application issues or errors that occurred
• Performed database tuning by using various tools, like Oracle Enterprise Manager and STATSPACK
• Opatch is used for Patched Oracle Database Server 9i and 10g.
• Established database backup/recovery strategy for different databases
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Performed daily alert log files, trace files check, and general data consistency & data integrity check.
• Developed scripts to monitor the storage usage, object status for daily job.
• Oracle support and Metal ink are utilized to troubleshoot the problems and issues.
• On-call supports regarding production-related database problems are performed.
• Installed SQL SERVER 2005 and SQL SERVER 2008.
• Managed logins, users, permissions, linked server.
• Perform refresh activity for SQL database from higher environment to lower environment using Tivoli tool.
• Managing Users, Roles and Privileges. Troubleshooting user connectivity issues.
• Backing up of system and user databases. Using maintenance plan
• Configuring databases mirroring, role changing of mirroring databases
• Installation of service pack in SQL server. SQL server profiler
• Backup failure of SQL databases. Suspect mode of databases.
• Connectivity issues

Environment: Oracle 10g, 9i, RAC, Red Hat Enterprise Linux, OEM, Explain Plan, SQL Trace, Tkprof, STATSPACK, Metalink, Opatch, Data Pump.