We provide IT Staff Augmentation Services!

Sql Server Dba Resume

Muskego, WI

Takeaway: Consolidation of 10+ years of IT Network Engineering, and over 5 years of Microsoft SQL Server Database
Management. Emphasizing relevant technical knowledge and experience, proactive and uncompromising advocate of proper Database
Design &; High-Availability Solutions; Backup &; Disaster Recovery, Addressing bottle-necks at application design, scaling up &; out,
High-Performance Architecture and common-sense Security Management.

  • Identified and resolved SQL Server Database locks and hardware-related issues, using Distributed Management Views &; Functions, Profiler and database engine Tuning Advisor where necessary, to resolve Performance slow-downs due to locking, blocking and other index issues, in an NDS + DDS data flow architecture, etc.
  • Perform SQL Server version upgrades and migrations &; deploy changes to production databases. Create and maintain technical documentation and implement database related policies.
  • MCDBA - Microsoft Certified Database Administrator, SQL Server 2000 DBA, July 2006
  • MCITP - Microsoft Certified IT Professional, SQL Server 2005 DBA, November 2009
  • MCITP - Microsoft Certified IT Professional, SQL Server 2008 DBA, July 2010

MCDBA / MCITP Stored Procedures Scaling-Up / Out Data Security Partitioning
High Availability Database Design T-SQL Server-Side Tracing Replication
Linked Servers Active Directory Disaster Recovery MSDTC / 2PC Storage Solutions
Query Tuning Indexes &; Keys Performance Tuning SQL Lock Mgmt. DMV / DMF
Clustering Mirroring SSAS/SSIS / SSRS2000\\2005\\2008R2 DW Admin

Aug. 2012 Sept. 2012
Confidential, SQL Server DBA

Oakwood, GA

  • Designed and implemented comprehensiveBackup plan and disaster recovery strategies. Automated messaging services onserver failures, for task completion and success. Involved in trouble shooting andfine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using Wait States, Index tuning &; Execution Plan management.
  • Recovering the database from backup in disaster &; maintaining database consistency withDBCC at appropriate intervals
  • Defragging or rebuilding just the indexes, if needed, for better performance &; monitoring SQL server performanceusing Server-Side tracing to find performance issues, etc.

Mar. 2012 - Apr. 2012
Confidential, SQL Server DBA
Charlotte, NC.

  • Determine appropriate risk levels of Vendors, and categorize Line of Business payments based on existing rules. Then write queries to pull global Spend data for analysis, based on manually entered data, categorized by department.

Oct. 2011 - Jan. 2012
Confidential, SQL Server DBA
Charlotte, NC.

  • Designed and implemented a data warehouse for Sales, and used T-SQL scripts &; SSIS for transferring data from EnterpriseOne to create the Data Marts.
  • Performed query tuning to reduce response time by 60% in some cases, using cache plans, execution plans and index tuning.
  • Experience in performance analysis and production support for very large (VLDB) and complex databases, and recovered databases from corruption.

Oct. 2010 - Dec. 2010
Confidential, SQL Server DBA
Charlotte, NC.

  • Participates in the planning, analysis, design &; implementation of databases &; be a primary resource for new application implementation. Provides appropriate consulting, interfacing, and training for users.
  • Establishes and maintains policies, standard operating procedures, and associated documentation for user interaction with the database environment.
  • Consults with vendors and advises management database management issues and participates in various large-scale or highly complex data/database management activities.

Feb 2010 - April 2010
Confidential, SQL Server DBA
Charlotte, NC.

  • Perform day to day Database Maintenance tasks - Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
  • Manage SSIS packages, stored procedures, jobs, and utilize Server Side tracingto identify performance issues with deadlocks &; other locking issues. Proficient with Server-Side System Default &; Blackbox Traces to analyze other issues on the server.
  • SME for Replication issues &; existing publications &; subscriptions to keep data in synch &; solved a 5 year old problem with Snapshot Replication.
  • Setup and configure SQL Server for other business functions. Index &; Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
  • Manage user and data security to allow access to appropriate resources. Proven experience in maintenance of SQL Server in a VLDB environment and resolving database issues with tables in excess of 600,000,000 rows.
  • SME for Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.

July 2008 - Oct. 2009
Confidential, SQL Server DBA
Plantation, FL.

  • Perform day to day Database Maintenance tasks - Clustered &; Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers.
  • Manage hierarchical security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schemas per, Sarbanes-Oxley Act. Ability to prepare for and participate in security audits and database encryption, and disaster recovery measures.
  • Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks &; diagnose issues on the server. Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.
  • Proven experience in maintenance of SQL Server in a VLDB environment &; experience in troubleshooting and resolving database problems.

Feb. 2008 - July 2008
Confidential, SQL Server DBA
West Palm Beach, FL.

  • Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore.
  • Testing of new releases and features for application, O/S and Database upgrade &; Troubleshoot application performance &; Optimize query &; index performance. Installed, configured Microsoft Distributed Transaction Coordinator, both for high availability &; disaster recovery to remote locations.
  • Designed &; Tested a Scale-Out Architecture using Replication, DTC / 2PC, Distributed Database with Data &; Middle Tier, Web &; Client Tier for SQL Server Databases to facilitate a High-Availability environment by creating Read-Only copies for Reporting Services &; Read-Write Hot copies of critical Databases, for Hot Instant Disaster Recovery.

March 2007 - Feb. 2008
Confidential, Crystal Reports Developer
Lake Worth, FL.

  • Designed &; Code Batch Queries, Stored Procedures &; Views to pump data to Crystal Reports, Debugged, Optimized existing views, triggers and stored procedures, Modified System Maintenance, Backup &; Business Continuation procedures.
  • Support multiple SQL Server 2000 / 2005 databases in both clustered and non-clustered environments with replication/DTS, pulling data from UNIX each night. Troubleshoot issues within a clustered server configuration.
  • Performs database tuning and troubleshooting. Install and troubleshoot replication, performs production migrations, backups, and database recovery.

Aug. 2005 - June 2006 Confidential

HelpDesk Technician West Palm Beach, FL.

  • Assisted and trained new Helpdesk co-workers in application usage, proper user setup and Mapping to their correct Data Directories, Network Design and Active Directory Management. Troubleshoot GPS &; other IP &; Wireless applications, in-depth understanding of DNS, Clustering and MS Exchange email server to achieve Corporate goals.
  • Supported various Plant designs nation-wide, with Server and Desktop PC Connectivity issues. Managed Security on Citrix Servers for Remote users to connect and run applications at Corporate Location, to save on additional software Licenses.

Dec. 2002 - Sept. - 15th 2003 Confidential, North Palm Beach, FL.,

Network Engineer / SQL Server DBA

  • Architecture support for fast paced Brokerage House, with point-to-point Single Domain, and Windows 2000 Active Directory connections, Microsoft Exchange Server, Cisco Pix 515 &; 525 Firewall and NAT service management.
  • SQL Server Database Maintenance, design a backup strategy to fit available budget, Cluster State Management and other Disk Integrity and Data preservation methods.
  • SQL Server 2000 Index and Lock management, Primary &; Foreign Key monitoring &; verification, Data Security and patch verification. Evaluate query execution plan, use DBCC OPENTRAN to locate long-running transactions, use SQL Profiler to monitor table and index scans.
  • Design, develop and went live after migrating several MS Access &; SQL Server databases for corporate developers, resolving typical database issues; Setup Replication between sites. Used Query Tuning &; Diagramming to encourage Developers how to design their applications to ensure the Query Optimizer uses the best plan, and improve congruence.

Oct. 28th 2001 - Dec. 12th 2005 (Part-time position)

Confidential, Palm Beach Gardens, FL - Site Technician
  • Network Support for ISDN PPP Compressed Video Equipment Bridge to sites within Nova.
  • Identified Network &; Active Directory Access methods, Messaging server topology &; positioning, in a multi-domain MPLS VPN architecture. Working with the change management process with central &; regional support personnel.

Dec. 22nd 1998 - August 2000

Confidential, Coral Springs, FL. - LAN/WAN Admin &; SQL Server DBA
  • Trouble-shoot Layer-2, VLAN and other Switching issues, Layer-3 Router Functionality &; Architecture, Routing &; Switching Functions. Provide Level-3 support for NOC for PPP Frame Relay Network issues, from congestion control to WAN Switching and optimize remote data exchange.
  • Reconfigure improvements for SQL Server environments, architecture and processes. Experience in performing large scale SQL Server version upgrades. Upgraded 100+ databases across 9 servers.
  • Set up/Install/Configure SQL Server 2000 on standalone as well as clustered environments. Maintain inventory of all servers and database objects.

Hire Now