We provide IT Staff Augmentation Services!

Sql Server Database Director Resume

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

Hire Now