SUMMARY:

• Around 7 years of Information Technology experience primarily as Oracle database administrator and SQL Server Database Administrator.
• Extensiveexperience with SQL Server Upgrade/Migration, Business Intelligence/Data warehouse, Business Objects, ETL Tools Experience.
• Supported variety of mission critical production applications in Enterprise and Financial environment.
• Extensive Experience in Oracle Database administration of DATAGUARD 11g.
• Extensive experience with Oracle database administration of Oracle 10g and 11g RAC with multiple nodes covered all aspects of administration like installation, configuration, migration, replication, sizing and space management.
• Over 3 years of experience with MSBI tool set including SSIS, SSAS and SSRS.
• Extensive Experience with basic DBA functions such as Backup and Recovery setup, tuning, installation of tools.
• Understand the challenges of Production Environment, combined with outstanding leadership ability, team player and creative problem solving skills in both strategic and tactical areas.
• Experience setting up Physical Standby & Logical Standby for the databases.
• Extensive Experience in ORACLE FAILSAFE, implementation, configuration & administration.
• Experience in Implementing & Setup of ORACLE GRID CONTROL& OEM. And Also Setup up Backup Jobs for Databases via OEM.
• Have setup backup and recovery with expertise in performance tuning and troubleshooting of database.
• Experience Installing Oracle 11g Enterprise Manager.
• Experienced in the Installation, Configuration of MS SQL Server 2000/2005/2008 and Migration of SQL Server 2005 to SQL Server 2008.
• Experience supporting the development of IT and Database Architecture and Physical Data Models and Creating Data Models with ERWIN and ER/Studio.
• Experience using Data Transformation Services (DTS), Upgrading DTS to SSIS Experienced in and working with Bulk Copy Process (BCP).
• Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export and Capacity Planning.
• Experienced in using Performance Monitor/Profiler to resolve System bottlenecks and Dead Locks/Long-Running Queries.
• Experience working with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and knowledge in Analysis Services (SSAS)/OLAP Cubes.
• Data analysis, Data modeling, Requirements gathering, Project Management, analyzing End User requirements and specifications.
• Knowledge of Unified Modeling Language (UML) , including Use Cases, Sequence, Work Flow Diagrams and Activity diagrams

TECHNICAL SKILLS

• Databases- Oracle 10g/11g, MS SQL Server 2008/2005/2000, MS Access
• SQL Server/Oracle Tools – Enterprise Manager, Query Analyzer, Export & Import, DTS, SQL Server Management Studio, Reporting Services, SQL Server Integration Services, Analysis Services, Oracle Enterprise Manager, Oracle SQL*Plus, iSQL*Plus, SQL Loader, SQL*Plus Worksheet, 10g/11g Data Pump.
• Operating Systems - Windows Server 2003, Windows 2000, Windows XP, Windows 7, MS-DOS, Unix, Linux, Solaris
• Languages–T-SQL, PL/SQL, XML, Shell Scripting, MySQL.
• Networking/Applications-MS Office 2003/2007, SharePoint, ER/Studio 7.5, Erwin, TCP/IP.

CERTIFICATIONS

• MCITP (Microsoft Certified IT Professional) – SQL Server 2008 Database Administrator
• OCP (Oracle Certified Professional) – Oracle Database Administrator 11g, 10g
• OCP (Oracle certified Professional) – Solaris Administrator

Work Experience:

Confidential,Baltimore, MD Jan 2011- Till Date
Role: Database Administrator

• Designed, implemented and administered multiple Oracle databases. Setup and managed replication among several databases. Administered and provided production DBA support to the Oracle databases.
• Performed all the regular DBA tasks including backups, recovery, creating tables and installing patches.
• Have extensive experience with SQL scripting and testing data transfers between systems.
• Successfully performed database creation, and updated scripts for Sign Management and Sign Inventory Management application using Oracle 11g. This project is used to manage road signs, traffic lights and other winter equipment for State Highway Administration.
• Setup and managed replication among various databases. Administered and provided production DBA support to the SHA Oracle databases.
• Wrote stored procedures to import data from previous Sign Management MS Access system to the new Sign Management Oracle database system.
• Tuned the databases resulting in a 10% performance improvement.

Environment:
Oracle 10g, 11g, Solaris 11, Cluster Administrator, SharePoint, DotNet, PowerBuilder, VMware Administration.

Confidential,Rochester, NY Sep 2007 –Dec 2010
Database Administrator

• Served as DBA in the Kodak GORS (Global Operations research group).
• Experience porting data projects from Access 2005 to SQL Server.
• Experience with MySQL 4.1
• Administered multiple SQL server databases from project initiation, database design stage to project closure and archival stage.
• Experience performing database design, developing scripts, database creation, database tuning, SQL statement tuning, backup/recovery, general troubleshooting, fire fighting, script development and documentation.
• Experience with maintaining databases, applying database patches, configuring database security.
• Experience solving problems while working with cross functional teams.
• Experience designing SQL server databases.
• Experience working in RAC\\cluster environment.
• Experience working with Windows 2003, Windows XP and Windows 7 environments.
• Experience with Data Mining and Data warehousing using SSIS, SSAS and SSRS technologies.
• Performed Operating system installations and upgrades on both Windows 2003, Windows XP server environments.
• Experience with database security configuration, database replication.

Environment:
Oracle 11g, 10g, MS SQL 2008/2005/2000, Win Server 2000, 2003, Sun Solaris, Linux, HP-UX, IBM-AIX.

Confidential,India. March 2005 -August2007
Database Administrator

• Successfully designed, implemented and supported the Product warranty Database for Warranty Manager Application at Sree Technologies using SQL server 2000 which is used to manage product warranty for their consumer electronic products.
• Maintained test, training, development and production SQL server 2000 environments.
• Implemented, configured and administered SQL Server 2000.
• Created database backups and restores, installs and upgrades of MS SQL servers.
• Estimated and Monitored Space requirements for databases and transaction log file sizes.
• Worked in a team as the lead DBA for database migration and application upgrades.
• Upgraded SQL Server 6.5, 7.0 to SQL server 2000.
• Hands on support and responsibility of LAN Internet security.
• Provided Technical support for computers and servers.
• Work with developers for analyzing and fine tuning slow running queries and stored procedures.
• Managed Log shipping for warm standby servers and Transactional replication.

Environment:
MS SQL server 2000, Win Server 2000, Oracle10g

Education:
Bachelor’s degree in Engineering