SUMMARY

• Excellent communication, analytical and problem - solving skills with proven abilities in establishing
• Confidential Certified Professional- ASP.NET (C#), Confidential Certified DBA SQL Server 2005 (MCITP), Confidential Certified Database Developer SQL Server 2005 (MCITP), Confidential Certified DBA SQL Server 2000 (MCDBA), Confidential Certified Systems Engineer-Windows
• 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 Confidential 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, Linux

RDBMS: SQL Server, MS Access

Reporting Services: SSRS, Crystal Reports

ETL Tools: SSIS, DTS

Modeling Tools: Erwin, Visio

Web: IIS, XML, XPATH, XQUERY, ASP.NET

Development: C#, Java

Scripting: VBScript, Perl, JavaScript

Packages: Confidential Visual Source Safe, Confidential Operations Manager, Quest Software Suite

ERP: Great Plains ERP

Methodologies: Software Development Life Cycle, Confidential Operations Framework, ITIL

Compliance: HIPAA

PROFESSIONAL EXPERIENCE

Confidential

SQL Server Database Director

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 the 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 the 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 with vendors regarding new Software purchases
• Lead the SQL Migration from Migrated SQL Server 2000 to SQL Server 2008 R2
• Designed Service Broker Solution to improve SQL Server Performance
• Designed and Lead the 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 with multiple DTC configurations

Confidential

SQL DBA Manager

Responsibilities:

• Enforcing Security Controls on the database by removing Built-in\Admins and reducing the Sysadmin rights
• Generated Capacity Reports for server utilization
• Identify performance bottlenecks and provide recommendations to the 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 the senior technical management
• Interview potential DBA Candidates and provide feedback to Human Resources
• Developed PowerShell scripts to automate SQL Server Administration

Confidential, Charlotte, NC

Sr. Support Engineer SQL DBA

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 with the 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

Sr. SQL Server DBA

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 with the 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