We provide IT Staff Augmentation Services!

Sr Sql Dba Lead Resume

Dallas, TexaS

SUMMARY:

Computer professional with over 15 years of experience. Knowledgeable and experienced with SQL Server SQL 2012, 2008R2, 2008,, 2005, 2000 & 7.0, Windows 2012, 2008, 2003 & 2000 Server, VWware, Clustering, ERP Confidential, SharePoint, IIS, Exchange, Confidential Metaframe, Terminal Server, Veeam, Netbackup, Project Management, RFP, Risk Management, PCI and SOCKS.

SKILL:

HARDWARE: Compaq Proliants, Dell 710, Power Edge, IBM RISC 6000, SUN SPARC, HP 3000, HP 9000Net Frame, Cisco Routers, 3COM, Wellfleet, Synoptic, Cubix and Cabletron

OPERATING SYSTEM: SQL 2016, SQL 2014, SQL 2012, 2008 R2, 2008, 2005, 2000 & 7.0, Windows 2016, 2012, 2008 R2, 2008, 2003 & 2000 Server, IIS 8.0, 7.0, Windows 2000 Workstation, Windows 7,98, Windows 95, NT Workstation, Windows XP

SOFTWARE: SQL Sentry, Spotlight & FogLight, IDERA SQL Performance, Service Now, SQL DB Artisan, DB Change Manager, LightSpeed, COMM Vault, IDERA (SQL Safe & Admin Tools), Red Gate SQL Compare, Visual Basic InterDev, Visual SourceSafe, Erwin, Skype For Business, MS SharePoint, Pulse Secure VPN Client, LANDesk, Nagios, MS Office 2010, 2003, 2000 & 97, MS Project Manager, Cisco VPN, FTP, SMS, Truesight, Sitescope, Netscaler, Unicenter, Exchange, Microsoft PSDIAG & Read80Trace, Tidal Job Scheduler, Microsoft Baseline Security Analyzer, Cisco VPN Client, Lotus Notes Mail

PROFESSIONAL EXPERIENCE:

SR SQL DBA Lead

Confidential, Dallas, Texas

Responsibilities:

  • Lead of SQL DBA team meetings internal and with 3 rd party SQL support offshore vendor team
  • Managing/Lead of SQL Server 2017, 2016, 2012, 2008R2 on Windows Server 2012 and 2016 on physical and VMware Servers with SQL HA groups and also SQL Clustering with Active/Passive Nodes and also SQL Multi - Instances
  • Created SQL Server Migration Blue Print from 2008/2012 to SQL Server 2016 to a internal Private Cloud Network (H/W, S/W, Application, Storage, security, HA Groups and Active/Passive Clustering, Maintenance Plans, SQL
  • Managing 1 onsite DBA and 3 Offshore DBA’s and account manager
  • Created, assigned and managed SQL environment SOW projects and Deliverables
  • Managing SQL Server Vendors (Hardware, Software, Tools, Licensing)
  • Data Architecture of SQL Server Operations environment
  • DB design review and provide enhancements of various SQL Server Applications
  • Creating, implementing and support SQL Environment Standard Operating Procedures
  • Approving SQL deployments of SQL Developers/Application teams
  • Installed/Configured and supports SQL Server Database Mirroring
  • Installed/Configured and supports SQL Server Transactional Replication, Snapshot Replication (Publishers, Subscribers and Informatica Power Exchange replication tool), monitor with Replication Monitor, SQL scripts and Replications jobs
  • SQL Server Backups and Restores
  • Creating, maintaining and supporting SQL jobs with Step(s) and E-Mail notification on Job failures to DBA team
  • Capacity Planning, implementation and support (using Veritas, Window Server Manager, SAN, SSD, SQL Sentry One, Foglight and SQL SSMS
  • SQL Security (SQL Logins and Mixed Mode Authentications), Roles, AD groups
  • Creates, implements and supports Blue Print using SQL TDE
  • Data Migration (installed, configured and supporting Microsoft SSMA with Oracle and, MS Access
  • Created, Implemented and supporting SQL Server DB (Single DB Files and Filegroups)
  • Creates, implements and supports SQL Server Maintenance Plans/Jobs (DBCC jobs, Index Tuning and Update Statistics
  • Creates, implements and supports SQL Patch releases/Patches implements and supports Application releases/Patches
  • Code Review and Approval for Prod and Staging environments
  • Enhancing SQL Server Databases Design improvements with Application Development Manager and Lead on DB Architecture
  • Managing Patch Releases (SQL Server and Applications)
  • Managing Vendor Technology Quotes for SQL Servers
  • Created and implement SQL Server DBA Environment Operational and Best Practices Guides working with DBA team
  • Managing SQL Server Environment Project and Deliverables with Project managers, IT, Application management and Power Application Users
  • Accessing SQL technology and SQL Tools moving environment into being majority proactive
  • Working Service Now Application for all SQL Server tickets
  • Creating, implement and support all SQL Server environment
  • Troubleshooting all SQL Server issues with (SQL Sentry One, Foglight, SQL SSMS, SolarWinds SPLUNK, SQL Queries, Stored Procedures, SQL Error and Windows Server logs, Documentation using (Microsoft IT Notebook, MS Word, MS Project, PowerPoint and Excel)

SR. SQL DBA

Confidential, Dallas, Texas

Responsibilities:

  • Install/configuration/maintenance of SQL Servers (Physical, VMware) SQL 2012, SQL 2008 R2, 2008, 2005, 2000
  • SQL Clustering installation, design, implement & Support
  • Data center migration SQL 2012, SQL 2008 R2, 2008, 2005, 2000 physical instances, SQL Clusters & VMware in a Prod, Stage, QA, Dev & test environment
  • SQL Database & Server Migrations
  • SQL backups & restores with NetBackup & Veeam
  • Capacity planning SAN & Local storage recommendations and implementation
  • Database design/de-normalization (Tables/Schema, Views, Stored Procedures, Views)
  • Providing data reports from various required applications
  • Performance tuning/optimization with SCOM, Idera, SQL Profiler traces, Perform monitor, SQL DB Tuning Wizard, Execution Plans, VmWare and Windows server tools.
  • Disaster Recovery
  • Provides R&D for new SQL Technology and tools (SQL 2014, Solarwinds, Veeam Backup, SSIS, SSRS, SAN storage for SQL VmWare & Physical Servers
  • Writing T-SQL queries
  • Recommending SQL Operations and Development best practices implementing both
  • Installing/configuring, implementing and supporting SSIS, SSRS
  • Writing SSIS packages, jobs & supporting them where requested
  • SharePoint DBA support, migration and support for servers (Operations, Design and Performance and generating reports. Recommending best practices and assisting in the implementation.
  • SQL database application support
  • Link Servers for data important/export
  • SQL Documentation (Operational, DBA Guide, Performance SSIS best practices, SharePoint best practices
  • Application support with developers and end users

Confidential, Addison, TX

SQL DBA/ Architect

Responsibilities:

  • Data center migration SQL 2012, SQL 2008 R2, 2008, 2005, 2000 physical instances, SQL Clusters & VmWare in a Prod, Stage, QA, Dev & test environment
  • SQL backups with Idera & Litespeed
  • Capacity planning SAN & Local storage recommendations and implementation
  • SQL Clustering design/implement & Support
  • Performance tuning/optimization with Profiler traces, Perform monitor counters & Execution Plans
  • Disaster Recovery
  • Writing T-SQL queries
  • Creating & supporting SSIS packages
  • SSRS server designs & implementation
  • Documentation
  • SharePoint DBA support and migration
  • SQL database application support
  • Link Servers for data important/export
  • Performance tuning/Optimization (Profiler/Perfmon, NETIQ, Solarwinds, T-SQL)

SQL DBA

Confidential, Branchburg, NJ

Responsibilities:

  • SQL DBA Lead of 100 SQL Servers (Physical Clusters & Single Instances & VMware), (2012, 2008 R2, 2008, 2005, 2000). SQL DBA Lead 1 of Jr. SQL DBA
  • Re-Architecture SQL Server environment
  • Acted as the primary point of contact with customer SQL DB Applications
  • Project management (meeting deliverables, timelines, and defining needed resources and all requirements specifications being defined/implemented
  • Customer support to all related SQL DB/application/content questions
  • Provided monitoring and constant evaluation of projects (status reports, SOW)
  • Responsible for the quality control doing the actual implementation of software/applications with clients onsite.
  • Provided ongoing input to onsite manager regarding all project related processes (Status, milestones, plans, status, deliverables, risk & issues).
  • Participated with on going status/change incident meetings and report on project progress.
  • Supported end users and provided DB/application where required providing great warm hand off of implemented software applications for SQL Databases.
  • Working with Oracle DBA using Confidential to Migrating data to SQL Datawarehouse
  • Working with RFP’s
  • Risk Management
  • Performing Database Architecture Modeling
  • SQL DBA Lead over 80 Web Application servers
  • SQL DBA Lead over 20 Confidential applications on SQL back end
  • SQL Lead working with application developers and support
  • Manager/Support of 6 Active/Passive Clusters
  • Working with EMC SAN team on configurations for SQL Servers
  • Creating solutions that meets both external and internal customer’s data needs regarding marketing and advertising web applications.
  • Mentor junior App Support, DBA and application management
  • Implemented/support enterprise backup solution with Idera SQL Safe & SQL
  • Setup/Configure & support Replication (Transactional & Snapshot)
  • Setup/Configure & support DB Mirroring
  • Create/support SSIS packages & jobs. Import/Export data using Excel, Access & text files into databases
  • Managed databases from 1GB to 2 TB databases
  • Patch management & deployment
  • Working with secure DMZ’S for SQL Servers
  • Performance monitoring, tuning & troubleshooting (Solarwinds, Profiler, Perfmon, SQL Dashboard & DTA)
  • Experience on installing SQL Server and configuring SAN and Cluster server.
  • Work under pressure to meet tight delivery timelines
  • Interacts between application developers, vendors, managers and App support, Intel & VMware
  • Working with Windows 2008 R2, 2008 & 2003 servers
  • Administers, maintains, develops and implements policies and procedures
  • Implements data models & database designs, data access & table maintenance codes; resolves database performance issues, database capacity issues
  • Designed/Implemented DR plan (San Replication between sites)
  • Code/Scripts Review of developers and Vendors
  • Implement/Support SQL Security (Windows & SQL Authentication, roles and AD groups)
  • Assess and develop long-term strategic goals for production databases in conjunction with data owners and managers. Act as a liaison between the developers, application support
  • Design and implement redundant systems, policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
  • Conduct research and make recommendations with servers, applications, database products, services and standards in support of procurement and development efforts; liaise with vendors and service providers for the selection and procurement for new technologies.
  • Troubleshooting though DBA tools (SSMS, Solarwinds, Quest Foglight, Idera, Microsoft Performance Profiler & Monitor)
  • 24x7 on call rotation
  • Manages outsourced support resources to meet operational and delivery objectives
  • Technical presentation to CIO, Director of Technical Services & other Department App Directors
  • Worked with exporting and importing data with SSIS to from Oracle 10g and 11g with SQL Server databases

SQL DBA

Confidential, FT Worth, TX

Responsibilities:

  • Supported end users and provided DB/application where required providing great warm hand off of implemented software applications for SQL Databases.
  • Assisted with pre-sales and marketing of SOW, applications, demos, writing against RFP RFIs & RFPs and responding to business problems customers brought up during meetings.
  • Database administration of SQL 2005 on Windows 2003 and SQL 2008 and SQL 2008 R2 Servers on Windows 2008
  • Standardized and configuration new SQL Servers
  • SQL best practices
  • Implemented & managed all SQL security
  • Release Performance - responsible for monitoring all release testing and gathering performance metrics to determine if adjustments need to be made before production migration. This includes load testing a simulated production load.
  • Production Performance - reviewing production performance metrics to determine how changes are needed to prevent issues. Application\Database tuning
  • Project management (meeting deliverables, timelines and defining needed resources and all requirements specifications being defined/implemented
  • Customer support to all related SQL DB/application/content questions
  • Provided monitoring and constant evaluation of projects (status reports, SOW and provided RFP'S)
  • Responsible for the quality control doing the actual implementation of software/applications with clients onsite.
  • Provided ongoing input to onsite manager regarding all project related processes (Status, milestones, plans, status, deliverables, risk & issues).
  • Participated with on going status/change incident meetings and report on project progress.
  • Liaison, between IT and tech services, communicated with Application support teams, to ensure everyone was aware of release schedules, turns, issues and fixes.
  • Liaison, between IT and Vendor - Communicate any questions or issues that relate to database performance to the vendor. Discuss solutions with tech services Database Administration.
  • Test\QA Application Database support - responsible for coordinating, communicating and executing turns for stored procedures, views, tables, DTS packages, and SSIS Packages within Development\QA.
  • SQL Server Application Job Support - responsible for coordinating the creation and scheduling of application database jobs for all environments with Database Administration. First level of support responsible for: receiving all application job alert notifications, researching application job failures, rerunning application jobs as needed
  • IT Resource - available to IT support team members to recommend ‘best practices’ when developing database processes (e.g. extracts\loads).
  • Database Data Loading - data loading through application code, SSIS packages or imports.
  • Database Data Extracting - data extraction through application codes, SSIS packages or exports.
  • Database archiving\purging - responsible for determining what data should be archived\purged.
  • Table Capacity monitoring - tracking growth of largest tables to determine ways to handle the growth, purges, creation of an archival system
  • Batch Performance monitoring - monitoring the batch processes to ensure optimal performance.
  • Maintenance Jobs - Create SQL jobs (SSIS, security, SQL scripts & database maintenance)
  • Backup\Recovery - create Backup\Recovery jobs (Using Comm vault and SQL)
  • Web Administration - Performed Installation, Configuration and Support of web servers, Web turn deployments, troubleshooting & performance monitoring
  • Performance monitoring of SQL servers, Windows 2003 & 2008 servers & Web servers using SQL Perfmon, profile, SQL scripts, Solar Wind
  • SQL Server Clustering Support Active Passive
  • Created SQL &Web server & Application documentation
  • Implemented Database Mirroring in Development
  • Created SQL Server best practices for Security, Database Administration, Backups & restores, job management, Disaster recovery, patch deployment.
  • Worked with Change control
  • DB2 backup DBA
  • Worked with exporting and importing data with SSIS to from Oracle 9x and 10x with SQL Server databases

SQL DBA

Confidential, Louisville, KY

Responsibilities:

  • Database Design - reviewing\approving database designs before moving to production.
  • Supported end users and provided DB/application where required providing great warm hand off of implemented software applications for SQL Databases.
  • Database Code - reviewing\approving database code before moving to production.
  • Release Performance - responsible for monitoring all release testing and gathering performance metrics to determine if adjustments need to be made before production migration. This includes load testing a simulated production load.
  • Production Performance - reviewing production performance metrics to determine if\how changes are needed to prevent issues. Application\Database tuning - proactively reviewing database specific application code (e.g. stored procedures, packages, etc…) to ensure optimal application and database performance.
  • Liaison, between IT and tech services, communicated with CAE Application support teams, to ensure everyone was aware of release schedules, turns, issues and fixes.
  • Liaison, between IT and Vendor - Communicate any questions or issues that relate to database performance to the vendor. Discuss solutions with tech services Database Administration.
  • Test\QA Application Database support – responsible for coordinating, communicating and executing turns for stored procedures, views, tables, DTS packages, and SSIS Packages within Test\QA.
  • SQL Server Application Job Support – responsible for coordinating the creation and scheduling of application database jobs for all environments with Database Administration. First level of support responsible for: receiving all application job alert notifications, researching application job failures, rerunning application jobs as needed
  • IT Resource – available to IT support team members to recommend ‘best practices’ when developing database processes (e.g. extracts\loads).
  • Database Data Loading - data loading through application code, DTS packages, SSIS packages or imports.
  • Database Data Extracting - data extraction through application code, DTS packages, SSIS packages or exports.
  • Database archiving\purging – responsible for determining what data should be archived\purged.
  • Table Capacity monitoring – tracking growth of largest tables to determine ways to handle the growth, purges, creation of an archival system, etc. This also entails managing the data stored in DataMart databases.
  • Batch Performance monitoring – monitoring the batch processes to ensure optimal performance.
  • Maintenance Jobs – Create SQL jobs (DTS, security, SQL scripts & database maintenance)
  • Backup\Recovery –create Backup\Recovery jobs
  • Managed databases from 50 GB to 2 TB
  • Web Administration – Performed Installation, Configuration and Support of web servers, Web turn deployments, troubleshooting & performance monitoring
  • Performance monitoring of SQL servers, Windows 2003 servers & Web servers using SQL perfmon, profile, SQL scripts, Truesight, HP open View, Sitecope)
  • Windows Server 2003 Administration – Providing support, troubleshooting and configuration for SQL and web environment
  • SQL Server Clustering Support
  • Created SQL &Web server & Application documentation
  • Supported Database Mirroring (Principal, Mirror & Witness)
  • Worked on Sarbanes-Oxley Compliance

SQL DBA

Confidential, Dallas, TX

Responsibilities:

  • Managed SQL 2005 & 2000 servers (Production, Staging, QA, Test and Development)
  • NET Application Support with SQL developers on all SQL databases and supporting databases
  • Created and Managed Tables, Indexes, Performance Tuning and Optimization of Databases, Stored Procedures, Indexes
  • Installed, configure, Support SQL 2000 & 2005 Servers on Windows 2003 Servers
  • Setup and Maintained SQL Server Security for SQL databases. Provided Disaster Recovery Plans.
  • Profiler, Perfmon, Microsoft PSDIAG & Read80Trace for performance optimization
  • Configure and Support SQL Database Backups & Restores
  • Performed Merge replication on SQL Server Databases
  • Implemented & Supported Security of SQL Databases in Production, Staging, QA, Development and Test Environments. SQL script deployment to all SQL Servers through Change Management
  • Disk capacity management
  • Application Support with SQL developers on all SQL databases and supporting databases
  • Installed, Configured, Managed and Support of SQL 2000 & Servers
  • Creating Reports from SQL Databases

Hire Now