SUMMARY:

• Certified Database Administrator professional with over 15 years of working experience on databases with strong experience in MS SQL Server administration system building, configuring, performance tuning optimization and troubleshooting
• Over 10 years of experience in MS SQL Server database administration and performance tuning.
• Experienced in migrating the data from SQL Server 2000/2005 to SQL Server 2008 and from
• Strong experience in making the secondary database to restoring state then run backup, copy and restore SQL server agent jobs to resolve data transfer latency in log shipping environment
• Experienced in designing Database Maintenance Plans, Indexes for Optimizing Performance.
• Conducted performance tuning on regular basis to improve performance of slow running queries and stored procedures (utilizing DB profiler and Ignite)
• Experienced in provided 24x7 supports to Production, Preview and Development servers Monitored and Troubleshot jobs in Production, Preview and Development environment
• Experienced in Health Check process for SQL Server databases using Database Maintenance Plans

TECHNICAL SKILLS:

Skills: MS SQL Server Administration Fixed all the alerts related to CMS (maintenance plans, backups, and policies violations) Database Maintenance Plans Installation Reporting Performance Tuning Analysis, design & documentation, and development of relational database system

PROFESSIONAL EXPERIENCE:

Confidential - Chicago, IL

Senior SQL Server DBA

Responsibilities:

• Tuned newly installed Central Management Servers(CMS) for 140 SQL Servers of different versions ( ), for different type of environments: production, staging, and development
• Responded and fixed all the alerts related to CMS (maintenance plans, backups, and policies violations) and built a tool for database refreshes utilizing BI studio for front end SSRS and for backend SSIS

Confidential - Arlington Heights, IL

Database Administrator

Responsibilities:

• Created and managed databases across Development and Production instances using SQL Server Management Studio
• Migrated the data from SQL Server 2000/2005 to SQL Server 2008 and from
• Monitored and Troubleshot jobs in Production, Preview and Development environment
• Provided 24x7 supports to Production, Preview and Development servers
• Involved in Health Check process for SQL Server databases using Database Maintenance Plans
• Coordinated physical changes, current space utilization and performance monitoring of two replicated production servers and two development servers
• Designed Logical and Physical Data Models
• Conducted performance tuning on regular basis to improve performance of slow running queries and stored procedures (utilizing DB profiler and Ignite)

Confidential - Chicago, IL

Database Developer

Responsibilities:

• Worked as a database developer utilizing MS SQL Server 2005
• Installed MS SQL Server 2005. Creating Reports using Reporting Service
• Created stored procedures for data validation and reporting
• Fully designed and developed including all functionality DB system to support address cleaning, validation, and verification system which is used in mailing and e-mailing campaigns

Confidential - New York, NY

Database Developer

Responsibilities:

• Worked as a database developer utilizing MS SQL Server 2000
• Created and documented demoralized logical data model, using Erwin and converting it into physical database objects.
• Created stored procedures for Crystal reports, and to analyze legacy data for forensic purposes.
• Also was responsible for developing DTS packages to transfer processed and unprocessed data between DB’s. Imported data from restored backups.
• Supported backend production database for EnCase tool

Confidential - New York, NY

DBA/Database Developer

Responsibilities:

• Worked as a support DBA/Developer for a trading company
• Utilized MS SQL Server 2000.
• Developed DTS packages to transform, and import data from huge data files

Confidential - New York, NY

DBA/Database Developer

Responsibilities:

• Heavily involved in all database related activities like replication and SQL-DTS, data analysis, database designing & documentation, application development, and server administration.
• Utilized MS SQL - Servers 7.0., 2000. ER/studio 4.03., and ER/Win 3.5.2.
• Responsibilities included: Writing stored procedures to encapsulate the business logic.
• Created primary files and secondary file groups, and assigned database objects to those files.
• Created recovery plans.
• Created & scheduled, monitored and troubleshot jobs.
• Created users and granted them privileges to exec only user's stored process. Monitored log files

Confidential - New York, NY

DBA/Database Developer

Responsibilities:

• Participated in analysis, design & documentation, and development of relational database system for a web-based application utilizing MS SQL - Server 7.0 and ER/WIN 3.5.2.
• Responsibilities included: writing stored procedures to encapsulate the business logic, creating primary files and secondary file - groups, and assigned database objects to those files

Confidential - New York, NY

Database Developer/Junior DBA

Responsibilities:

• Participated in analysis of user requirements, designed and development of relational database utilizing ER/WIN 3.5 and SYBASE 11.5 for a fast growing real estate organization.
• Used ER/WIN tool to define Business entities, attributes, and relationships.
• Walk through all the data models with users to ensure that all the business requirements can be handled.
• Apply the 1st, 2nd, and 3rd normal form against all data models.
• Converted logical database entities and objects to Sybase tables and objects.
• Performed DBA tasks on performance tuning by using indexes.
• Responsibilities included writing triggers and stored procedures to encapsulate the business logic

Confidential - Weehawken, NJ

Programmer/Analyst

Responsibilities:

• Participated in the design, development and maintenance of Client Relational Database System utilizing Visual Basic 5.0 and SQL Server 6.5 for a brokerage and investment research department. The system is used by investment advisor personnel to open different types of accounts, modify and inquire existing accounts, keep track of account activity and provide client information

Confidential

Software Developer

Responsibilities:

• Involved in full life cycle of PubComm Adjusting Billing System for PubComm department of Confidential . Was responsible for design, coding, implementation and testing utilizing MS Visual Basic 4.0/3.0, Sybase 10. The system is designed for categorizing and storing of all transactions, producing statements, statement inquiries and adjustments of all Confidential ’s financial services