Summary:

Having 7 years of experience primarily as an oracle database administrator on UNIX/NT/Client Server environment, production support, installation, configuration, upgrades, patches, backup and recovery, performance tuning, cloning, database security, space management.

• Installation, configuration and administrating Oracle GoldenGate replication.
• Installation, configuration and administrating Oracle RAC databases.
• Converting single instance into multiple instances (RAC).
• Worked as a team member to provide 24x7 on-call production database support.
• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments.
• Excellent experience in installation and configuration of Oracle 8i, 9i, 10g and 11g in UNIX/LINUX and Windows environment.
• Have great Knowledge of Oraclearchitecture.
• Good experience in SQL, PL/SQL, Shell Scripting, Parallelism, Partitioning, Data modeling, OLAP, Logical and Physical data model using ERWIN, Backup and Recovery procedures.
• Involved in meetings with data modelers, developers, and dba's.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data using external tables and SQL*LOADER.
• Management of schemas, objects & Partitioning of tables & indexes.
• SQL*Loader, Export, Import, datapump, PL/SQL, SQL*Plus, SQL*Net, BMC-SQL, Server Manager.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Streams.
• Installation, Configuration of Oracle Data Guard for Physical and Logical mode.
• Migrating and upgrading the databases to higher versions.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup , IBM TSM & LEGATO Storage Manager
• Excellent experience in Database cloning (single instance) , RAC database to non-RAC database cloning and RAC-RAC database cloning
• Extensively used Database Administrative tools like Oracle Enterprise manager (OEM) Grid control, DBA Studio, SQL*PLUS, TOAD, DBArtisan.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning, Database/Instance Tuning.
• Tuning the application, memory, and disk using Oracle and third party utilities and initialization parameters including explain plans, tkprof and Statspack.
• Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
• Good knowledge of SQ SERVER.
• Good knowledge of ODBC drivers and interfaces with front end technologies like .NET/java applications and good experience in Oracle Application Server.
• Enterprise Oracle Database Professional.
• Object Oriented Design and Programming, proficient in many programming languages as C,C++, VB.NET and C# ; multi-platform development, Web development and database design. Provided value added services to the company through thoughtful experience, testing habits, excellent written and verbal communication skills.

Technical Skills:
Operating System: UNIX, Linux and Windows
Language: SQL, PL/SQL and Shell scripting
Hardware: TCP/IP hardware, Cisco routers and switches, modem and SAN.
Database: Oracle 11g/10g/9i, Ms-Access and Ms-Excel.

OEM (Oracle Enterprise Manager), ADRCI, STATSPAK/AWR, SQL*PLUS, PL/SQL, SQL*Loader, Export/Import (Data Pump), RMAN (Recovery Manager), VM Ware, TOAD and cSupport ticketing system.

PROFESSIONAL EXPERIENCE:

Role: Oracle Database Administrator/ Goldengate Administrator
Project Scope: Walgreen Co is the leading Pharmacy Retail Client in United States. It has about 6000 stores and about 70.000 different product lines; the project involves maintenance and configuration of database for various transactional, OLAP and reporting databases with huge data volumes and to provide the applications support to the development teams and also the user community.
Responsibilities:

• Installation, configuration and administrating Oracle GoldenGate replication between oracle databases.
• Installation, configuration and maintenance of Oracle 10g/11g databases.
• Part of the team for databaseupgrade from 10.2.0.2 to 10.2.0.4with logical and physical standby in place.
• Set up, configured and maintained oracle data guard/Veritas Cluster (primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Excellent experience in Opatch and Oracle upgrades.
• Support & Maintenance of Production, Development and Test Databases on various servers Solaris and HP.
• Creating and managing users with appropriate tablespaces and Indexes, public and private database links.
• Rebuilding Indexes and gather statistics on tables on different databases on a regular basis to gain database performance.
• Manage users, privileges, profiles, schemas using Oracle Grid Manager,Oracle Enterprise Manager (OEM) and SQL.
• Worked on import/export and datapump export/import
• Tuning the Databases for optimization using AWR, ASH, ADDM,STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Used Quest live re-org and IONS for database tuning.
• Configured shell scripts for job/process automation.
• On call DBA and provides 24X7 supports for production problems.
• Excellent experience in moving databases to different servers and schemas to different databases.
• Excellent experience in managing space for tablespaces with physical and logical standby databases in place.

Environment:

Oracle 11g/10g/9i/, data guard with physical and logical standby databases, Sun Solaris 10 on M5000/M3000, HP servers, Oracle Enterprise Manager, SQL, TOAD, AWR, ASH, ADDM, TPROF, Explain plan, STATSPACK, and Oracle GoldenGate replication from oracle to oracle databases.

Role: Oracle Database Administrator (RAC)

Responsibilities:

• Installation, configuration and maintenance of Oracle10gRAC database.
• Converted single instance into multiple instances (RAC).
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems
• Supported 17 production/development databases.
• Migrating and upgrading the databases to higher versions.
• Part of the migrating team responsible for up gradation from Oracle 9i to Oracle 10g.
• Worked on Opatch and Oracle upgrades.
• Responsible for installing, upgrading and configuring the Oracle server.
• Worked in release management involving database components.
• Support & Maintenance of Production, Development and Test Databases on various servers.
• Oracle security and familiar with database vault.
• Installation of ASM into various storage parameters like SAN and NAS.
• Implemented Logical, Physical and Conceptual Data Modeling using ERWIN Data Modeler to visualize data structure to effectively organize, manage and moderate data complexities.
• Creating, monitoring and maintenance of oracle database replication and integration by materialized views and streams.
• Creating users, tables with appropriate table space and Indexing, database links.
• Manage users, privileges, profiles, schemas using Oracle Enterprise Manager (OEM).
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Set up Grid Control to monitor databases.
• Worked on import/export, export datapump/import datapump and SQL- loader.
• Excellent experience in RAC to non-RAC database and RAC-RAC database cloning.
• Backup/Restoration, scheduling Backups, taking Logical Backups
• Setup backup, recovery and testing backups and procedures using RMAN.
• Automation of job scheduling by crontab.
• Tuning the Databases for optimization using STATSPACK, Explain Plans and TKPROF, Estimating Table & Index Size.
• Database Tuning - Tuning Applications, Memory Tuning and Tuning Disk Usage.
• Partitioned large tables to increase the performance.
• Supported FAMS (Fraud Analysis Management System), an IBM tool. It is a combination of software and services designed to help investigators and auditors identify and analyze suspect providers and claims.

Environment:

Oracle 10g/9i , HP-UX, Windows NT/2000, Sun Solaris 10, Oracle Enterprise Manager, SQL, TOAD, Erwin Data Modelar, RMAN, TPROF, Explain plan, STATSPACK, I3agent, SQL* Loader

Role: Oracle DBA.
Client: Confidential, Charlotte December' 08 - November' 09

Project Scope: Time Warner Cable Inc. is all about connecting people and businesses with information, entertainment and each other. They bring you the latest innovations for your home - from high-definition television to Enhanced TV features to high-speed data and Digital Phone services.
Responsibilities:

• Installed 9i, applied patches in various environments and upgraded databases from 9i to 10g.
• Set up, configured and maintained oracle data guard(primary and standby databases) to ensure disaster recovery, high availability and data protection.
• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems.
• Management of table spaces for different users by granting quota on Default & Temporary tables paces.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects UNIX Shell and Perl scripting. Implemented for capacity planning.
• Created UNIX shell and Perl scripts to automate batch jobs through Crontab.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views and streams.
• Utilized SQL*loader and data pump import to load data into tables.
• Utilized Oracle Enterprise Manager (OEM) to manage users, privileges, profiles, schemas.
• DatabaseAdministration and Planning including logical design, physical design, backup & recovery.
• Took a logical backup of the entire database using import/export utility.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAINPLAN, optimizer hints and SQL tuning advisor.
• Tuning test and production database by altering the parameters.
• Implemented Transparent Gateway tointegrate data stores from non-oracle system like DB2, SQL SERVER.
• Implemented JDBC (Java Database Connectivity).
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.

Environment:
Oracle 10g/9i , HP-UX, AIX, Sun Solaris, Red Hat Linux, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, Erwin Data Modelar, RMAN, TPROF, Explain plan, STATSPACK, SQL* Loader, Windows NT/2000

Client: Confidential, Armonk, NY January' 07 to October' 08

Project Scope: MBIAis a premier financial guarantee company; there were many development projects which were going on, as a result of ever growing demand of new databases in the organization, the development projects were more client based, which included all the client related information as well as investment data, other tasks also included supporting production databases.

Responsibilities:

• Attend meetings with data modelers, developers and other DBA's in the organization
• Backup/Restoration, scheduling Backups, taking Logical Backups
• Capacity Planning, Storage Allocation and Space Monitoring & Management.
• Data Refreshin Test and Integration Databases using Transportable Table spaces.
• Support & Maintenance of Production/Development Databases on various servers.
• Taking care of test databases.
• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Scripts to Copy Database to flat files for loading into SQL Server and other environments.
• Creating users, tables with appropriate table space and Indexing, database links.
• Logical, Physical and Conceptual Data Modeling using Data Modeler (ERWIN).
• Performing Partial, Complete and Metadata Exports & Imports.
• Database monitoring for deadlocked process and maintaining logs/Backups using Imp/Exp Utilities.
• Tuning the Databases for optimization using STATSPACK and Explain Plans, Estimating Table & Index Size.
• Creating Users, Roles, Schemas with suitable Permissions, Synonyms, Contexts for Stored procedures, packages & triggers to support the Front end Applications.
• Supported test and development environments to ensure smooth transition of applications into production.
• Supported the development team as well as production Environment.

Environment:
Windows NT, SUN SOLARIS 7, Oracle 8.1.7, PL/SQL, Oracle Enterprise Manager, SQL*Loader, Shell scripts.

Role: Oracle Database Administrator/ Oracle Developer

Client: Confidential, India January' 04 - March ' 05

Responsibilities:

• Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.
• Responsible for installing, upgrading and configuring the Oracle server.
• Created database objects such as tables, views, synonyms, indexes, sequences and database links
• Partitioned large tables to increase the performance.
• Responsible for optimizing the queries and application tuning.
• Database Links for data porting, and business logic changes/database merging.
• Implement Hot, Cold and Logical backup plans.
• Created scripts for speedy troubleshooting of database problems
• Use TOAD tool to access the database
• Developed validation procedures and error reporting on the data in the intermediate tables
• Worked on handling exceptions
• Written SQL Loader Scripts for data extraction and transformation
• Created Stored Procedures and functions to be used as a part of development work
• Used ASP and Developer 2000 for designing the client server applications.

Environment:
Windows 98/NT/2000, HP-UX, Oracle 8i, Oracle Enterprise Manager, Toad and SQL*Loader.

EDUCATIONAL QUALIFICATIONS:

• Bachelor of Technology in Computer Science & Information Technology
• Oracle Certified Professional (Oracle 10g administration).

References: Provided upon request