SUMMARY

• Over 6 years of experience as an IT professional along with extensive experience as an Oracle DBA in Production, Development and Test environments. I have lead various projects in 11g/10g/9i using RMAN for Backup and recovery, Data guard for Disaster recovery, Installation, Configuration, Migration, upgrade, Capacity planning, cloning, patching, Performance Tuning.
• Excellent experience in Installation and configuration of Oracle 11g, 10g, 9i, on Operating Systems UNIX, Linux and Windows platforms.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g / 11g.
• Expertise in administration, production support, configuration, upgrades, patches, space management, database security, performance tuning, troubleshooting database design, UNIX shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g and 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Experienced in using 10g and 11g features Data pump, Flash - Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup, & IBM TSM Storage Manager.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Expert in SQL* Loader, export/import and data pump to load data in to tables.
• Oracle Database capacity planning, space management, storage allocation and different type of storage structure (SAN/NAS).
• Proficient knowledge in RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery.
• Excellent knowledge in SQL, PL/SQL, Partitioning, Data modeling with utilities like ER/Studio, OLAP, Logical and Physical Database Design, Procedures, Functions, Packages, Database Triggers.
• Implemented development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise
• Expert in implementing development, testing, staging, production and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Implementing standby database and database replication to provide high availability of database.
• Expert in implementing oracle streams, and two types of standby databases supported by dataguard, logical standby and physical standby databases.
• Expert in Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, ADDM to collect and maintain performance statistics and improve the database performance.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener, TNS Names, SQL Net, V$ views, DBA views and Data modeling, Logical and Physical databases design using tools like Erwin and Visio.
• Experience in working with ETL tools like ODI (ORACLE DATA INTEGRATOR) and other data ware housings transactions.
• Worked with the application design team in developing a custom ETL application using built-in Oracle technology (Oracle Replication, Materialized Views, Snapshot's, and PL/SQL) as well as designing the Star Schema used to support the company's Enterprise Business Intelligence system.
• Experience as On-Call 24x7 production DBA and application/development DBA and Oracle Support processes for technical requests through Meta link and other Support Procedures.
• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.
• Excellent interpersonal and strong analytical, problem-solving skills with customer service oriented attitude.
• A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2Red Hat Linux RHEL 2.1, 3.x, 4.x,5.x and NT/2005/

RDBMS: Oracle /11g/10g/10gRAC/9i

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting.

DB Management: TOAD 9.5, Enterprise Manager grid, OEM, Grid control (RAC)

Tools: /Utilities: RMAN, OEM, Sql Navigator, Oracle Management Service(OMS), SQL*Loader, ASM, Export/Import, TOAD, Patch Management, ODBC, Data pump, Data guard, VERITAS Net Backup, MS Access.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.

Database Modeling: Erwin 4.1.2, Visio.

Hardware Platforms: Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 0, HP XP256 / XP512, IBM C server p5 model 590, and various PC desktop and servers.

PROFESSIONAL EXPERIENCE

Confidential, Newyork, NY

Sr. Oracle Database Administrator

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle 9i, 10g 11g databases.
• Performed upgrade/migrations of databases 9i to 10g and 10g to 11g.
• Worked on import/export, export data pump/import data pump and SQL- loader.
• Installed and Implemented Backup & Recovery procedures, Implemented Hot, Cold, Logical backup plans.
• Installing and configuring RMAN and Flash Recovery. Cloning databases using RMAN as well as scripts.
• Devised and implemented backup strategies for hot, cold, export and RMAN using shell scripting.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAW Devices.UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g.
• Daily Health Check Up of the Database using STATSPACK, AWR, ADDM, TKPROF, explain plan.
• Used SQL server for ecommerce apps.
• Configured Streams to capture propagate, apply changes in multiple databases.
• Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.
• Configured, administered, and monitored a Streams environment using various tools like OEM console.
• Installation, maintenance and tuning of Oracle 10g RAC databases including ASM and CRS.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Data Migration as part of enterprise data warehouse project.
• Used shell scripting for automation of job Scripts, for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Data Modeling, Database Design and Creation using ER-Win, Visio.
• Monitoring and Troubleshooting of Database Replication issues using Shareplex and golden gate, dealt with conflict resolution and performance issues.
• Load balancing, Databases/Schema/Table Re-Organization for faster performance using export/import & Move procedures. Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Installed Oracle 10g Enterprise Manager (OEM) (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on databases.
• Designing the security and database access strategies using tools like ESM.

Environment: Oracle 10g, Red hat Linux 5.X, Solaris 10, Oracle 10gRAC/9i, Toad, SQL-navigator, PL/SQL, SQL*Loader, ODBC, ASM, OLTP, Telnet, Flashback, OEM, Erwin 4.1.2, MS Access, Oracle database platform includes installation, configuration, maintenance, and performance tuning of Oracle instances on Oracle 10g, Oracle RAC, Grid Control, Streams, and Data guard.

Confidential, Alabama

Sr. Oracle Database Administrator

Responsibilities:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 9i on, Sun Solaris and Windows 2003, Redhat4.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, Creation of Materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security
• Have created database on SQLsqrver2005, backup and recovery.
• Database Restore using RMAN, Cold Backup and Export.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Worked on Advanced Replication including synchronous and asynchronous scenarios.
• Problem analysis involving interactions/dependencies between UNIX and Oracle.
• Performed Data Migration as a part of enterprise data warehouse project.
• Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Extensive Performance Tuning, Memory (SGA) Tuning, RAC tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Performed and maintained replication.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.
• Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Developed tools to migrate the data from legacy systems to oracle database.

Environment: Oracle 10g/9i, Java, SQL, PL/SQL, Toad, Pl/SQL Developer, Erwin, O/S: RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, ASM Packages.

Confidential, IIIlinois

Oracle Database Administrator

Responsibilities:

• Installation of Oracle 10.1.0.2 on Sun Solaris as well as Windows Servers.
• Install, Upgrade and configure Oracle database for various 32-bit and 64- bit platforms like HP-UX, Solaris - SUN SPARC & Intel, MS Windows 2000.
• Involved in Design and implementation of oracle 10g Dataguard both physical/logical standby databases in high availability mode.
• Use of Data Guard Manager, 9i and 10g Data Encryption.
• Carry general administration tasks using tools like OEM and Toad.
• Implemented and maintained streams for synchronization of data at various sites.
• Used RMAN for backup and recovery jobs.
• Create & Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges. Created multiple Raid levels using volume manager.
• Applying Patches 9.2.0.6 on Oracle database.
• Used shell scripting to automate all RMAN jobs.
• Ran the Oracle STATSPACK on the Oracle Instances to find out the System Performance Statistics during the peak load times.
• Enabling the Trace files for the sessions which experience a very bad performance and generate the Trace output using TKPROF utility for further analysis.
• Trace the SQL that have poor performance and identify the ways of improving the performance by adding necessary indexes or removing the unwanted indexes.
• Trace the frequently called procedures/packages and pinning them to improve the performance.
• Responsible for Load and Performance testing of the database servers and application servers, analysis and documentation of results.

Environment: Sun Solaris, SUN SPARC, HP-UX, Windows 98/NT/2000, IBM X Series Server, Oracle 9i, Oracle Enterprise Manager, STATSPACK, TKPROF, EXPLAIN PLAN

Confidential

Database administrator

Responsibilities:

• Provided technical support for Oracle Server to customers for Production Database.
• Supported customers including international customer to install the developed application on different operating system e.g. windows, UNIX of all flavors on Oracle Database (8i, 9i, 10gR1).
• Also provided support to customers to manage their operational data ranging from GB to TB in Oracle database, solving of space problem, data loading problem Experience with building, installation, upgrade, and patching of Oracle.
• Worked on in house installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database, prepared Oracle database environment for the application analyst.
• Analyzed SQL queries causing performance problems.
• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities.
• Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance.
• Refreshed schema using Export/Import. Created the database, tablespace, tables, indexes, set privileges and user logins.
• Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration.
• Provided OS (RAM, I/O, CPU) tuning for Oracle Database.
• Worked on Unix Shell scripting in csh, ksh for automating startup/shutdown of databases, getting system alerts etc.
• Applied patches both Server side and Client side.
• Supported the Upgradation from Oracle Server 8i and then to 9i/10g.
• Implemented OLAP on Oracle platform using Oracle Express (OLAP server), Relational Access Administrator (RAM), Oracle Sales Analyzer (OLAP front-end) in Oracle 8i / 9i environment, Data Migration as part of enterprise data warehouse project. Logical and physical data modeling using Erwin, Dimensional / OLAP Data Modeling, Relational / OLTP modeling.
• Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• Used Oracle Advanced replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.

Environment: Solaris 8.0/9.0/10.0 , HP-UX, AIX, Linux Red Hat, Windows 2000/2003 Oracle 8i (8.1.6/8.1.7 ), Oracle 9i/10gR1, Oracle Enterprise Manager, Oracle Partitioning, Oracle Replication, SQL*Plus, PL/SQL, SQL*Loader, SQL Server 2000, Toad 8, ERWIN 3.6.

Confidential 

Database administrator

Responsibilities:

• Responsible for managing production, development & test databases and applications.
• Designing and creating schema objects like Database tables, indexes, views, synonyms, and all schema objects in Oracle.
• Responsible for writing database programming to Store/Retrieve the information from the database using SQL.
• Wrote Stored Procedures according to specs and control files for input to SQL*Loader utilities for loading data from external files into the Oracle database.
• Creating databases, objects, roles and privileges.
• Partitioned large tables to increase the performance.
• Configured scripts to monitor activity with database. .
• Implement Hot, Cold and Logical backup plans.
• Used Oracle UTL file features to create flat files and Procedures for Data Extraction.
• Oracle Configuration. Oracle Tuning. Oracle Patch Administration.
• Creation of Table space, Data files, Indexes, Rollback Segment and monitoring them.
• Creation of Users and Granting them privileges and roles.
• Performed Database Tuning. Performed Database Security and Integrity. .
• Wrote extensive Sub Queries, PL/SQL procedures, functions, database triggers and packages.
• Writing Pl/SQL procedures and functions. Writing shell scripts to automate the data loading.
• Monitoring the data loading jobs and tuning the Sql queries.

Environment: Oracle 8i, SQL Server 2000, UNIX (Sun Solaris), Windows (NT/2000/Advanced Server), TOAD, OEM, SQL*PLUS, Explain Plan, UNIX Shell Scripting, Quest software tools, PL/SQL navigator.