SUMMARY

• Excellent communication, analytical and problem - solving skills wif proven abilities in establishing,
• Areas of specialization: TEMPeffective task priorities, working independently, and becoming an integral part of a team, Certified DBA, ITIL Certified, SQL Migration, Performance Tuning, T-SQL, Replication, Data Modeling, Data Warehouse, MS SQL Server, DTS, SSIS, SSRS, T-SQL, ASP.NET, Crystal Reports,
• Microsoft Certified Professional- ASP.NET (C#), Microsoft Certified DBA SQL Server 2005 (MCITP), Microsoft Certified Database Developer SQL Server 2005 (MCITP), Microsoft Certified DBA SQL Server 2000 (MCDBA), Microsoft Certified Systems Engineer-Windows,
• ITIL Framework V3 Foundation Certified,
• 14 Years of IT experience including 10 years as SQL Server Production and Developer DBA in SQL Server 6.5, 7.0, 2000,2005 and 2008,
• Mentored Junior DBA’s through classroom training,
• Experienced in gathering requirements, building Use Cases and designing Logical and Physical Database Design,
• Project Lead in developing Logical data model using ERWIN, Visio 2000,
• Designed and implemented SQL Server in a Active-Active Cluster environment,
• Monitored, Optimized and resolved issues related to SQL server Performance,
• Developed Stored Procedures by following SQL best practices,
• Implemented new features of SQL Server 2005 including Service Broker, CLR, CTE and MARS,
• Designed and implemented SQL Server Disaster recovery procedures like Log Shipping and Replication,
• Configured and maintained Replication Servers under SQL Server 7.0, 2000 and 2005,
• Project Lead in Installing, configuring and customizing Microsoft Great Plains ERP,
• Project Lead in migrating SQL Server 7.0 to 2000,2000 to 2005 an 2005 to 2008,

TECHNICAL SKILLS

Platforms: Windows, DOS, UNIX, LinuxRDBMS: SQL Server, MS AccessReporting Services: SSRS, Crystal ReportsETL Tools: SSIS, DTSModeling Tools: Erwin, VisioWeb: IIS, XML, XPATH, XQUERY, ASP.NETDevelopment: C#, JavaScripting: VBScript, Perl, JavaScriptPackages: Microsoft Visual Source Safe, Microsoft Operations Manager, Quest Software SuiteERP: Great Plains ERPMethodologies: Software Development Life Cycle, Microsoft Operations Framework, ITILCompliance: HIPAAPROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Managed a team of 4 Database Administrators
• Enforced Database standards and controls.
• Oversee day to day database issues and ensure they are addressed in a timely manner
• Conduct yearly performance review
• Plan for database expansion by studying plans and requirements and advising senior technical management of teh changes in requirement and prepare yearly budget based on those requirements
• Always informed senior technical management informed by preparing reports on system performance and problems
• Upgraded hardware and software by assessing transaction processing and database production options
• Maintains database performance by troubleshooting problems.
• Accomplished timely upgrades of service packs and improvements by supervising teh DBA tasks
• Secures database by developing policies, procedures, and controls.
• Updating job knowledge by participating in educational opportunities; reading professional publications; participating in professional organizations
• Accomplishes information systems and organization mission by completing related results as needed
• Evaluating and communicating wif vendors regarding new Software purchases
• Lead teh SQL Migration from Migrated SQL Server 2000 to SQL Server 2008 R2
• Designed Service Broker Solution to improve SQL Server Performance
• Designed and Lead teh implementation of Disaster Recovery Solutions for SQL Server
• Designed and Implemented SSIS Solution to Process Daily Data and Archive Old Data
• Developed Customized SSRS reports for SL Server Monitoring
• Designed and Implemented SQL Server Management Data Warehouse
• Maintained Sybase Servers for Assent Systems
• Installed and Configured SQL Server on multi node Cluster wif multiple DTC configurations

Confidential, Miami, FL,

Responsibilities:

• Enforcing Security Controls on teh database by removing Built-in\Admins and reducing teh Sysadmin rights
• Generated Capacity Reports for server utilization
• Identify performance bottlenecks and provide recommendations to teh upper Management.
• Approved and Assigned Work Orders to other team Members
• Helped other team members to resolve issues and help them in becoming independent
• Worked on different SQL platforms SQL 2000, SQL 2005 and SQL 2008
• Mentored 4 Databases Administrators
• Generate reports on database issues and solutions for teh senior technical management
• Interview potential DBA Candidates and provide feedback to Human Resources
• Developed PowerShell scripts to automate SQL Server Administration

Confidential, Charlotte, NC,

Responsibilities:

• Used utilities like PSSDIAG, SQLDIAG, Performance Monitor to analyze performance issues
• Used DBCC commands and utilities like WINDBG to analyze data corruption issues
• Mentored Junior SQL DBA’s on performance and replication through classroom training
• Worked wif teh customer to identify resolve query blocking and deadlocking
• Suggested Customers SQL best practices on installation, configuration and optimization
• Performed SQL Benchmark tests to detect IO issues
• Installed and configured SQL snapshot, transactional merge and peer to peer replication on SQL 2000,2005 and 2008
• Developed Merge replication for CE devices
• Mentored Support Engineers

Confidential., Chicago, IL,

Responsibilities:

• Maintained 1400 SQL Server Databases on 7 SQL Servers
• Project lead in upgrading and customizing of Great Plains ERP
• Developed database design and Stored Procedures for online reports Project working wif teh development team
• Designed and implemented Transaction Replication in SQL Server 7.0 and 2000 and 2005
• Developed customized solutions for Great Plains in Crystal Reports and SSRS.
• Developed applications in Visual Basic, C#, and ASP.NET
• Developed DTS packages to automate daily file transfer
• Installed and maintained SQL Server Transactional Replication for 200 databases

Confidential

Responsibilities:

• Tuning teh SQL Servers and Stored Procedures for Optimum Performance,
• Optimized indexes to give maximum performance,
• Designed and scheduled DTS package to migrate data between SQL Servers and transform data,

Confidential

Responsibilities:

• Installed, maintained, and optimized multiple SQL Servers at client sites,
• Provided performance benchmarks using tools such as SQL Server Profiler and Windows NT Performance Monitor,
• Customized reports using Crystal Report Writer using Version 6.0,
• Configuration of users, groups and implementing trust relationships between Windows NT Domains,

IT Secure,

Responsibilities:

• Installed, configured and optimized Microsoft Products including Windows NT and Windows 95,
• Provided training to users,
• Provided pre-sales and post-sales support,
• Provided data recovery from crashed disks using NDD and other third party software,