We provide IT Staff Augmentation Services!

Sql Server Dba - Team Lead Resume

4.00/5 (Submit Your Rating)

Jacksonville, FL

SUMMARY:

  • This is a dedicated, team - oriented IT professional with over 15 years of hands-on experience with SQL Server 7.0/2000/2005/2008/2012/2014/2016 , Oracle 11g and Oracle 13g. Seeking a senior- level SQL Server/traveling/remote engineer position.
  • Participated in numerous business critical, enterprise-wide projects as a lead technical resource
  • Environment was SOX and HIPPA sensitive in Medicare Part-D billing and hosted protected health information
  • Extensive experience in performance tuning, and data storage architecture
  • Installed and configured SQL server to use solid state disks along with working very closely with SAN administrators for best disk subsystem designs in a VMWare 5.X environment
  • Activities included WAN performance tuning, all layer 1-3 diagnostics and tuning in rack-mounted HP and Dell blade servers, SSAS, SSRS and SSIS
  • Planned, analyzed, and monitored Enterprise IT
  • Capacity planning, ITIL and HA and DR architecture
  • Tableau and SSRS reporting
  • Data modeling evaluation assistance for developers
  • SQL Server 2012/2014 Always On
  • Oracle 11g
  • Oracle, DB2 to SQL Server conversions

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL Server DBA - Team Lead

Responsibilities:

  • Lead DBA with four reporting.
  • Provided storage architecture guidance.
  • Performance tuning and VM configuration standards.
  • ITIL resource development (resource planning and resource library).
  • Idera performance monitoring, alerting and diagnostics.
  • IT resource planning.
  • Hardware performance and capacity planning.
  • Application enhancement and upgrades on data tier.
  • Always On, mirroring, log shipping and replication management.
  • Diagnostics, troubleshooting on data, mid and presentation tiers.
  • Tableau reporting suite.
  • Weekly DBA team performance reporting.
  • DBA team resource planning, analysis and monitoring.
  • Data security and configuration.
  • Training team members for skills maintenance and development.
  • Process improvement.
  • Problematic database design analysis and assist with efficient data modeling concepts.
  • Diagnostics for SSIS and SSRS performance and diagnostics.
  • Oracle 13G to SQL 2014 connectivity and migrations.
  • DB2 to SQL Server inter connectivity

Confidential, Jacksonville, FL

Project SQL Server DBA

Responsibilities:

  • BMC BDA for audit package push to 503 production servers.
  • Log shipping, mirroring and replication.
  • Performance tuning SQL 2005. 2008, 2012 and 2014 servers.
  • Monitoring and tuning OS and server configurations.
  • Reviewed standard SQL 2008 VM image packages.
  • Used Quest Foglight, DNT, Server Health Check, T-SQL, Extended Events and DMV’s for performance analysis and diagnostics.
  • Completed all required Bank training for security, auditing, financial fraud monitoring, best practices.
  • Over 18 projects completed successfully as DBA resource for all phases of server builds in both clustered and standalone environments, data movement, database configuration and tuning, all audit compliance and Runbook and Enventory documentation.
  • Familiar with extensive list of standard Bank applications, project management methods, and various Bank procedures and corporate culture.
  • DB2 to SQL server conversions.
  • Oracle to SQL server conversions.
  • Configuring linked servers and security.
  • Installed Oracle databases and used SSMA (SQL Server Migration Assistant) for the Oracle to SQL server conversions.
  • Built over 120 SQL servers, SSRS and SSIS machines at the bank in clustered and standalone.
  • OU’s, service and application user accounts and provisioning using the Bank tools.

Confidential, Eaton Rapids, Michigan

Production SQL Server DBA

Responsibilities:

  • Built SQL Server 2008 R2 server.
  • Installed shop management software (Shop Tech, MasterCAM, and SolidWorks).
  • Installed and configured SSRS.
  • Monitored and tuned system performance.
  • Configured all backup and maintenance jobs.
  • Installed LiteSpeed and Quest Spotlight.

Confidential, Boca Raton, Florida

Senior SQL Server DBA

Responsibilities:

  • Managed 28 production SQL Servers in a busy OLTP environment with 129 databases.
  • Provided physical storage architecture guidance on EMC VNX 5700 with VMWare 4.3 and 5.0 using EMC Replication Manager/Recover Point.
  • Dell EqualLogic 6500 iSCSI with auto-tiered solid state FAST layer.
  • Performed a Quest LiteSpeed enterprise backup implementation in addition to EMC Replication Manager/Recover Point solution.
  • Chief resource for disk capacity planning on EMC SAN, performance monitoring, and fragmentation management using Quest Capacity Manager and Spotlight.
  • Rescheduled/balanced production jobs and completely reconfigured SQL Servers for greatly improved memory, processor and IO performance.
  • Installed, configured and made extensive use of Quest Spotlight for enterprise performance monitoring and problem diagnostics.
  • Installed and configured Quest Foglight for enterprise monitoring and alerting.
  • Partitioned large and problematic active tables in OLTP environment, and performed query tuning and stored procedure diagnostics.
  • Built production SQL Servers 2005/2008, including OS installation and configuration.

Confidential, Port Saint Lucie, Florida

Senior SQL Server DBA

Responsibilities:

  • Managed large scale SQL Server OLTP and OLAP environment with over 1750 databases up to 1.6 TB in size.
  • Chief architect for Quest LiteSpeed enterprise backup implementation in 426 server environment (110 LiteSpeed along with Avamar, CommVault and native).
  • Chief resource for disk capacity planning on EMC SAN, performance monitoring, and fragmentation management using Quest Capacity Manager.
  • Successfully used SQL Sentry for data warehouse capacity and performance monitoring, alerting, and job scheduling.
  • Installed, configured and made extensive use of Quest Spotlight for enterprise performance monitoring and problem diagnostics.
  • Installed, configured and made extensive use of Quest Performance Analysis for enterprise performance diagnostics.
  • Used Quest vFoglight for VMWare 4.2 virtual machines on HP blades and EMC storage backends.
  • Designed and engineered disk IO subsystems using IOMETER, Quest Performance Analysis and Spotlight for OLAP and OLTP virtual and physical SQL Servers.
  • Solved business critical performance problems in Windows OS, Teradata, OLTP and OLAP data warehouses, SQL Server and various mid-tier application servers, user applications and IIS and web-related security issues.
  • Specialized in diagnostics and resolution of SAN and disk IO subsystem performance issues with PowerPath and Clariion FAST and SnapView using Brocade switch fabric.
  • Worked extensively in data storage architecture for disk IO subsystem performance and disaster recovery.
  • Diagnosed and resolved performance issues with VMWare 4.2.
  • Performed data migrations and system architecture in the creation of a new QA environment mirroring production.
  • Evaluated job scheduling and performed leveling using Quest and SQL Sentry.
  • Project Manager/Lead Technical on business-critical enterprise upgrade of Windows OS, SQL Server and application server components such as SSIS, SSRS and SSAS.
  • Responsible for installation, configuration, testing, baseline and monitoring of all SQL Servers in production environment from SQL 2000 through SQL 2008 R2.
  • Applied service packs, patches and hot fixes in production and QA environments.
  • Coordinated the successful disk-to-disk-to-tape enterprise backup system using SQL Server native, CommVault, Quest LiteSpeed, and EMC Avamar.
  • Reviewed SQL code from developers in the development, QA and production environments before release to production.
  • Installed, configured for repository and enterprise environment ER/Studio, and Visio.
  • Extensive experience on both performance tuning and development scenarios (index utilization and fragmentation, query design, limiting recompiles in code)
  • Hardware troubleshooting (high disk loading, queues, wait state analysis, resolving memory resource issues, CPU performance issues) in virtual and physical environments.
  • Superior written and verbal communication skills, with solid presentation, analytical, and problem solving skills.
  • Worked well with all levels of business from end users to C-level management.
  • Managed clustered SQL Server 2000 and 2008 R2, and mirrored SQL Server 2008 R2.
  • Installed and configured Sharepoint 2007.

Confidential, Ledyard, Connecticut

Contractor, SQL Server DBA

Responsibilities:

  • Provided SQL DBA support for large financial reporting implementation.
  • Maintained project databases using Quest performance suite.
  • Automated numerous functions and maintenance activities.
  • Performed initial data loads into reporting databases.
  • Created and implemented database design solutions in collaboration with programming team.
  • Optimized MS SQL Server code in production SQL databases.

Confidential, Fort Wayne, Indiana

SQL DBA

Responsibilities:

  • Maintained 58 clustered and standalone SQL 7.0 and 2K servers hosting databases from 4-gigs to over 600 gigs.
  • Created user databases and managed all DB objects.
  • Managed user security.
  • Performance tuned and monitored production databases.
  • Performed backups and database restorations.
  • Assisted closely in design of SQL Server disaster recovery plan.
  • Tested, reviewed and recommend DBA management tools.
  • Used Embarcadero ER Studio, Idera, BMC, and Tivoli products.
  • Installed and configured Windows OS and SQL server on production machines.
  • Performed an MSProject 2003/Sharepoint Services implementation.
  • Acted as consulting resource for six developers and provide third-level support.
  • Tuned and configured client, middle, and database tiers for employee timecard system.
  • Tuned SQL for user databases and assisted developers in indexing and SQL queries on production systems.
  • Monitored maintenance jobs (defrag, reindexing, stats, backup jobs, and archiving.
  • Installed all SQL Server upgrades and service packs.

Confidential, Sault Ste. Marie, Michigan

SQL DBA

Responsibilities:

  • Provided SQL Server consulting services for disaster recovery, backup and restore, and business continuity plan.
  • Performance tuned problematic databases and business critical systems.
  • Resolved performance issues on critical OLTP DBs for Casino Marketplace.
  • Managed backup and recovery activities for fourteen SQL 2K servers on Dell 6400 standalone and clustered machines.
  • Wrote documentation on maintenance procedures, data security and recovery procedures.
  • Reviewed management suites from Quest and Embarcadero and trained users with custom web views.

Confidential, Ann Arbor, Michigan

SQL Server DBA

Responsibilities:

  • Responsible for the successful resolution of complex and time-sensitive customer issues on mission-critical enterprise databases within homogeneous LAN/WAN environments.
  • Provide specialized customer support for the MPC CPM/BI package running on Oracle 8i, 9i and SQL Server 7.0 and SQL Server 2000.
  • Executed tuning and diagnostics on Oracle 8i, 9i and SQL Server 7.0 and 2000 applications using Spotlight on SQL, Spotlight on Oracle, and SQL Profiler and Performance Monitor tools.
  • Provided performance tuning for the application servers and optimization for customer applications.
  • Performed hardware and system engineering services for the consultant and customer base.
  • Supported and monitored customer database architecture, and overall database technical environment for customer financial systems.
  • Responsibilities included providing technical expertise in the operation and administration of DBMS products and environments, and supporting developers in the use and access to DBMS environments.
  • Conducted layer 1-3 network diagnostics, tuning and application response optimization with TCP/IP over LAN/WAN network segments, and satellite links.
  • Routinely provide customer hardware design and analysis, and complete specifications and recommendations for new database servers, application servers, and storage and network subsystems.
  • Installed and configured the Windows 2000 operating system and Oracle and SQL Servers on upgrades and new systems.
  • Improved hardware optimization and configuration onsite, using remote desktop support.
  • Managed backup and restore operations on customer servers and reconfigured custom user security at application, server, and OS levels.
  • Functioned as Sales Engineer and Project Manager for installations and upgrades and interfaced extensively with project managers at client sites.

We'd love your feedback!