SUMMARY:

• Microsoft Certified Professional (MCP) with 9 years of technical experience in Production Support and implementation and system administration using Microsoft SQL Server 7.0, 2000, 2005 and 2008.
• Experience in creating and maintaining MS SQL Server installation, performance tuning, backup, restore, security and disaster recovery.
• Excellent Experience in SQL Server clustering, replication and log shipping for high availability solutions.
• Exposure to Web Services architecture.
• Excellent verbal, written and presentation skills.
• Overall 8 years of technical experience in IT industry.

TECHNICAL SKILLS:

DBMS: MS SQL Server 2008, 2005, 2000, 7.0 and MS Access.

Hardware: IBM Compatible computers and Apple Mac

Operating Systems: Windows 2008, 2003,2000, NT, XP, MS - DOS, UNIX, and Sun Microsystems

Application: MS Office, MS Project, Visual SourceSafe, Lotus and Visio.

Tools: NT Performance monitor/System monitor, SQL Profiler, SQL Query Analyzer, ISQL, OSQL, NetIQ, Erwin, Cluster Administrator, Lotus, Quest, Lite Speed, Foglight, HP openview and Remedy.

CLEARANCE: OPM Background Check 6C

PROFESSIONAL EXPERIENCE:

Confidential, VA

Responsibilities:

• Critical production support for 60 production servers excluding 70 DRF, TEST and DEV servers.
• Maintained SQL Servers with maximum a vailability.
• Installed and configured SQL Server 2000, 2005, 2008 service packs and hot fixes.
• Involved in improving database server performance using performance monitor to find bottleneck of CPU, disk and memory devices.
• Responsible for database server trouble shooting and maintain maximum available time.
• Experienced with SQL Sever Performance Monitoring, Server and Database optimization and Query tuning.
• Document server and database policies and procedures.
• Worked on database schema for table creation, index creation.
• Investigated and resolved any database corruption, performance related issues with minimal and maximum reliability.

Confidential, NY

Responsibilities:

• 24* 7 critical production supports for 90 production servers out of 150 total servers.
• Installed and configured SQL Server 2000, service packs and hot fixes.
• Installed and configured SQL Server 2005, service packs and hot fixes.
• Installed SQL Clustering for 3 production environments.
• Involved in c apacity planning, sizing and database growth projections.
• Involved in improving database server performance using performance monitor to find bottleneck of CPU, disk and memory devices.
• Installed and configured transactional and snapshot replication.
• Created the backup and restore strategy to production, development and test environments.
• Installed and configured log shipping for Clustered production servers to DR servers.
• Participating in DR test to connect the application from Production to DR server.
• Created databases, tables, stored procedures, triggers and rules.
• Upgraded the SQL Server 7.0 server to SQL Server 2000.
• Upgraded the SQL Server 2000 server to SQL Server 2005.
• Involved in day-to-day database administration activities and troubleshooting database problems.
• Created the database maintenance plans for database optimization, integrity checks and database backups.
• Worked with developers to tune the SQL queries and stored procedures.
• Created Data Transformation Services (DTS) for transferring data from SQL to SQL Server.
• Maintained SQL Servers with maximum a vailability.
• Worked on database schema for table creation, index creation.
• Investigated and resolved any database corruption, performance related issues with minimal and maximum reliability.
• Involved in change management procedures using remedy software.

Confidential, TX

Responsibilities:

• 24*7 critical production support, total of 80 Production Servers in which 10 are mission critical clustered production servers.
• Installed SQL Clustering for 2 production environments.
• Implement routine database and log backups, restores as needed.
• Upgraded SQL 7.0 to SQL 2000.
• PMI to check the backups and daily, weekly and monthly maintenance of all production servers.
• Troubleshooting DTS package jobs and nightly batch process jobs 24*7
• Create role and permission to access production database servers for the users according to the ticket assigned.
• Closing 2-15 tickets per day for permission and job failure issues.
• Attending weekly CAB meeting to anticipate any change control that affect the production databases and SQL Server boxes.
• Involved in Disaster Recovery activities to rebuild SQL Server in DR test
• Involved in Capacity planning for large databases.
• Responsible for database server trouble shooting and maintain maximum available time.
• Experienced with SQL Sever Performance Monitoring, Server and Database optimization and Query tuning.
• Document server and database policies and procedures.
• Involved in Disaster Recovery processes and created the documentations.
• Monitoring the growth of the database objects for capacity planning.

Confidential, MD

Responsibilities:

• 24* 7 critical production support for 65 production servers out of 95 total servers.
• Responsible for production support, installation and migration.
• Involved in database optimization, performance tuning, and monitoring and capacity planning.
• Upgraded SQL 7.0 to SQL 2000.
• Created stored procedures and triggers to help SQL development team.
• Performed backup, restore and disaster recovery.
• Worked with different replication methods like snapshot replication, transactional replication and merge replication.
• Configured database control parameters for database performance tuning.
• Worked with SQL Profiler for auditing and index tuning and analyzed the execution plans for database optimization.
• Created logical and physical data modeling for development database projects using Erwin tool.
• Involved in query tuning processes for SQL developers.
• Created DTS Package designs for Import/Export from Access to SQL 2000