PROFILE
Organized, detail oriented professionalwith broad information technology support and service skills. Proven ability to effectively manage multiple projects in a fast-paced environment. Self motivated, resourceful, and productive team player with 24x7 on-call availability.

EDUCATION
Bachelors of Science

SUMMARY OF QUALIFICATIONS
7+ Years of database administration experience in MSSQL Server. Comprehensive understanding and hands on experience in SQL Clustering in mission critical environment, Database design, modeling. administration and capacity planning. Expert in developing and implementing DR. Configured, Managed & Tuned OLTP, Hybrid and DSS databases over 500 GB in SQL 2000/2005/2008 Cluster Environment. Organized, detail oriented professionalwith broad information technology support and service skills. Proven ability to effectively manage multiple projects in a fast-paced environment and mentor jr DBA. Self motivated, resourceful, and productive team player with 24x7 on-call availability.

Certifications:

• Microsoft Certified SQL Server 2008, Implementation and Maintenance

Technical Skills:

• Operating Systems: Win 2003, Win 2K Server/Pro, NT4.0, Win9x
• Databases: MS SQL (7.0, 2000 & 2005), MS Access
• Languages: SQL, T-SQL
• Protocols: TCP/IP, UDP/IP, IPX/SPX, NetBEUI, HTTP
• Visual Object Modeling: All Fusion Erwin Data Modeler
• Software/Applications: Visio 2000 Enterprise, Visio 2002 Professional
• Other Tools: SQL Query Analyzer, SQL Management Studio, Integration Server, DBCC Showcontig, DBCC Check Table & other DBCC utilities, Log Shipping, Index Tuning Wizard, SQL Profiler, Crystal Reports, MS-Office 97/2000/2003/2007, Linksys Router Admin, PC Anywhere

EXPERIENCE
Confidential,Chicago, IL Oct 2006-Present
Sr. Database Administrator

• Created, configured and maintained SQL 2005 Clusters and Database Mirroring in mission critical, production

Environment

• Configure cluster on SQL Server 2005 and 2008. Cluster in active -active and active -passive topology
• Planned and managed SAN LUN layout with SAN administrators for optimal disk I\\O in production environment
• Perform backup, Restore, Install Upgrades, Performance Tuning, Database Replication
• Planned and Implemented migration from 2005 to 2008
• Designed, planned and implemented DR strategy using database mirroring and log shipping
• SSRS, Installed, Configure and Deployed on Sql server 2008
• Automate the maintenance of Snapshots on Mirror servers
• Configured managed and maintained QA environments from Production for testing and development purposes
• Managed OLTP as well as Hybrid and DSS databases
• Perform data scrubbing using DML operation to load new data from staging to production tables (T/SQL)
• Review and tune stored procedures, (T-SQL) written by developers
• Plan and Implement Database Maintenance Plan for ensuring database reliability and integrity
• Database capacity planning for optimal performance; Create and manage Indexes and statistics
• Define operators, implement jobs, and configure alerts to automate everyday administrative tasks
• Design the Database Backup and Disaster Recovery strategies via Warm Backups & Hot Backups and also recovery up to Point of Failure in production environment
• Design, Implement and Manage Transactional Replications
• Evaluating and maintaining the Database indexes via DBCC showcontig, DBCC DBReindex for optimal performance
• Monitor database performance at System level, SQL server Level & Database level using Windows Counters, SQL Performance Monitor and SQL Profiler
• Mentor Junior DBA for setting up SQL Clusters

Confidential,Chicago, IL Jan 2002- Oct 2006
Database Administrator

• Upgrade SQL Server 2000 installation to SQL Server 2005
• Plan, Install and configure SQL 2000 & 2005 on Win 2003 Clustered Environment
• Create and configure SQL Virtual server/s on a failover cluster in Active/Passive & Active/Active environments
• Create Database and its objects
• Managed OLTP as well as Hybrid and DSS databases
• Plan and Implement Database Maintenance Plan for ensuring database reliability and integrity
• Database capacity planning for optimal performance
• Managed data integrity via constraints, rules, triggers and stored procedures
• Designed and Implemented Security Policy; Managed security through Application Roles, assigning the appropriate privileges to roles; Created views and stored procedures for additional security
• Create and manage Indexes and statistics
• Define operators, implement jobs, and configure alerts to automate everyday administrative tasks
• Design the Database Backup and Disaster Recovery strategies via Warm Backups & Hot Backups and also recovery up to Point of Failure
• Build DTS packages for data extraction, transformation & load
• Automate the maintenance of standby servers by using log shipping
• Design, Implement and Manage Transactional Replications
• Manage the Push Snapshot Replication; setting up the Publisher, Subscriber & Distributor & automate the Replication
• Develop Data Design models using All Fusion Erwin Data Modeler
• Evaluating and maintaining the Database indexes via DBCC showcontig, DBCC DBReindex for optimal performance
• SQL Server monitoring using NetIQ
• Developed technical documentation for SQL server administration