SUMMARY

• Senior Confidential SQL Server Database Administrator - 10+ years of Experience (SQL DBA)
• Well versed wif SQL Server 2008, 2008R2, 2012, 2014,2016, and SQL Azure.
• Recognized as a hands-on, proactive professional who can rapidly identify problems, formulate tactical plans, initiate change and implement effective programs in challenging and diverse environments
• Team builder,capable of implementing best practices and motivating staff to peak performance.
• Solid business leadership skills and abilities which are well suited to a variety of industries
• Strong analytical and problem-solving skills, effective written and verbal communication skills, interpersonal skills, Organizational and Multi-Tasking Skills

TECHNICAL SKILLS

• SQL Server 2005, 2008R2, 2012, 2014, and 2016 (AlwaysOn) (SQL Clustering)
• SQL Server SSIS Deployment/ Confidential SQL Server Reporting Services
• Service Center Operation Management
• Windows Server 2003, 2008 R2, and Window 2012R2 (Windows Failover Clustering) Confidential Visio Professional 2013, Business Intelligence and Analytics
• Visual Studio 2013, Confidential Share Point 2013,
• Idera Diagnostic Manager
• SQL Sentry/SSDT/Apex-SQL, Red-Gate, ServiceNow Platform
• MongoDB Replica Set (Immediate Skillset)

PROFESSIONAL EXPERIENCE

Confidential, Scottsdale, AZ

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2014/2016
• Knowledge of Windows Server 2014/2016
• Configuration and supported of Windows Native Clustering and SQL Clustering and SQL Always ON technology
• Software Support of JIRA and VCloud and VMWare Tracked and resolved all database issues related to Production, QA and Development environments
• Installed and upgraded teh database server(s) and application tools (wif PowerShell Scripting)
• Deliver timely and high quality solutions to customer problems and requests focusing on root cause analysis, prevention.
• Provided Conceptual design ideas for Confidential Security/Autantication wif Development Team, Systems, AD, and Web Teams.
• Assessment of SQL Environment for installation, configuration, storage, CPU, Memory, IO and security
• Assessment of Batch Processes, ETL, SSIS, Database design for Optimization & Performance improvement
• Administration and maintenance of SQL Server Instances into PROD-QA-DEV-DR and MSBI environments
• Setup of Replication, AlwaysOn, Disaster Recovery planning and procedures
• Performance and Tuning of SQL Server using Index tuning, profiler, PerfMon, DTA, DMVs and DMFs
• SQL Server upgrade and migration from version 2014 to SQL Server 2012
• Development of Installer package for Confidential SQL Server Analysis Services and required components
• Maintenance and Administration of Databases and Multidimensional Cubes (Process, Backup, Restore)
• Designing of Security - Active Directory Groups, Roles, Users and Kerberos Autantication
• Setup, administration and maintenance of SQL Server Master Data Services (MDS)
• Assessment, Setup, Monitoring and troubleshooting of routine maintenance jobs and processes
• Documentation, Leading projects, management, Training, Troubleshooting and support
• Tech. Environment: SQL Server2016, SSMS, SSIS, Windows 2016, NET, HyperBac, Red-gate, SAN, NAS, VM

Confidential, Chandler, AZ

Sr. SQL Server DBA

Responsibilities:

• SQL Server 2008, 2008R2, 2012, 2014, 2016, and SQL Azure.
• Configuration and support of Windows Native Clustering and SQL Clustering and SQL Always ON technology
• Implemented and troubleshoot Confidential SQL Server 2012, SQL Server 2014.
• Implemented and troubleshoot MS Azure Database, SQL PDW (Analytic Platform System).
• Created Solutions diagrams for corporate ERP systems wifin (Health, Financial, and Government environments)
• Created/Modified PerfMon counters to track/find issues wifin Windows Server 2012/SQL using teh Server App Tools or Packages Select to process.
• Worked wif application groups and peers to determine implantation details for enhancements, and applications
• Implemented and maintained Database as a Disaster Recovery Solution.
• Worked wifin TSQL, store procedures, packages and functions
• Service Now wif lifecycle runbook documentation.
• Used Data Mart ETL wifin SSIS
• Experienced wif MSF and MOS
• Worked on installing/administering MSSQL 2012 instances

Confidential, Phoenix, AZ

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008/2012
• Knowledge of Windows Server 2008/2012
• Configuration and support of Windows Native Clustering and SQL Clustering and SQL Always ON technology
• Wrote, maintained, and monitored appropriate SQL Jobs and ETLs as needed to transform and load data feeds from and to vendors and clients.
• Implemented and troubleshoot Confidential SQL Server 2012, SQL Server 2014.
• Implemented and troubleshoot MS Azure Database, SQL PDW (Analytic Platform System).
• Created Solutions diagrams for corporate ERP systems wifin (Health, Financial, and Government environments)
• Created/Modified PerfMon counters to track/find issues wifin Windows Server 2012/SQL using teh Server App Tools or Packages Select to process.
• Knowledge of backup technologies (Avamar, SQL Native backups, Idera SQLSafe)
• Worked wif application groups and peers to determine implantation details for enhancements, and applications
• Worked wifin TSQL, store procedures, packages and functions
• Service Now wif lifecycle runbook documentation.
• Used Data Mart ETL wifin SSIS
• Experienced wif MSF and MOS
• Worked on installing/administering MSSQL 2012 instances

Confidential, Plymouth, MN

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008/2012
• Knowledge of Windows Server 2003/2008/2012
• Configuration and support of Windows Native Clustering and SQL Clustering and SQL Always ON technology
• Provided support for DevOps, and Agile Technologies.
• Installed additional SQL server Nodes for Production or maintenance improvements for Department of Defense’s Enclave, and teh Confidential SCOM as a Deployment Tool.
• Built-out reports for teh AML analyst, and data mining, inquiries and reports as well as generating alerts
• Created Solutions diagrams for corporate ERP systems wifin (Health, Financial, and Government environments)
• Created/Modified PerfMon counters to track/find issues wifin Windows Server 2012/SQL using teh Server App Tools or Packages Select to process.
• Worked wifin TSQL, store procedures, packages and functions
• Service Now wif lifecycle runbook documentation.
• Used Data Mart ETL wifin SSIS

Confidential, Fort Lauderdale, FL

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008/2012
• Knowledge of Windows Server 2003/2008/2012
• Configuration and supported of Windows Native Clustering and SQL Clustering and SQL Always ON technology
• Tracked and resolved all database issues related to Production, QA and Development environments
• Installed and upgraded teh database server(s) and application tools (wif PowerShell Scripting)
• Deliver timely and high quality solutions to customer problems and requests focusing on root cause analysis, prevention.
• Provided Conceptual design ideas for Confidential Security/Autantication wif Development team, Systems, AD, and Web Teams.

Confidential, Phoenix, AZ

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008/2012
• Worked on Windows Server 2003/2008/2012
• Configuration and supported of Windows Native Clustering and SQL Clustering
• Prepared, and participated in quarterly DR tests wif our IT and application support teams.
• Implemented and monitored (OS) level security (wif PowerShell Scripting)
• Worked wif vendors and system users to plan and apply operating system patches as required for improved
• Performance, and improve security.

Confidential, Phoenix, AZ

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008/2012
• Knowledge of Windows Server 2003/2008
• Configuration and supported of Windows Native Clustering and SQL Clustering and SQL Always ON technology
• Installed and maintained SQL Server databases, including: ensuring successful backups, resolving system issues, opening cases wif technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updated database by reviewing, planning, testing, installing database security patches and service packs wif PowerShell Scripting.
• Designed, documented, and promoted security "best practices", policies, standards and protocols.
• Worked in Active/Active, Active / Passive Cluster environment as a High availability solution
• Data Warehousing Design and Support
• Created PerfMon counters to find issues wifin Windows Server 2012 Server App Tools or Packages Select to process.
• Service Now wif lifecycle runbook documentation experience.

Confidential, Phoenix, AZ

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008, and 2012
• Knowledge of Windows Server 2003/2008/2012
• Led a team of offshore DBAs in installing and maintaining Boardwalk approved application software and systems that integrated wif Boardwalk's database systems.
• Migrated Databases from SQL Server 2008 to SQL Server 2012 wif PowerShell Scripting
• Data Warehousing Design, and Support Application Developers.
• Developed, implement and maintain change control and testing processes for modification to database structures.
• Worked wif developers, and report writers to identify, and resolve any discrepancies between Cache, Clarity and
• Manage multiple projects and tasks and progress them in parallel Knowledge of backup technologies (Avamar, SQL Native backups, Idera SQLSafe)
• Knowledge of monitoring tools (Idera Diagnostic Manager, Foglight)
• Used TSQL, store procedures, packages and functions and updated notes to Service Now

Confidential, Phoenix, AZ

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008
• Knowledge of Windows Server 2003/2008
• Configuration and support of Windows Native Clustering and SQL Clustering
• Automated teh re-baselining of DBs in teh non-Production environments, wif PowerShell Scripting wif
• PowerShell Scripting
• Tested applications for performance, data integrity and validation issues
• Database Backup Procedures, Restoration Procedures, and Disaster Recovery procedures
• Wif Data Warehousing Design and Support
• Monitored database usage and performance and plan/ implement improvements as needed
• Service Now wif lifecycle documentation.

Confidential, Phoenix, AZ

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008
• Knowledge of Windows Server 2003/2008
• Configuration and support of Windows Native Clustering and SQL Clustering and SQL Always ON technology
• Supported Cluster and Non-Clustered Enterprise Level Databases
• Provided support to teh Security team activities as far as ID creation, deletion, Creating DB links, synonyms, setup of various roles and profiles
• Migrated various objects and function from test to production
• Daily maintenance review, SQL optimization, disaster recovery planning
• Provided work samples for quarterly audits to verify compliance wif security procedures
• Worked as a team member wif other DBAs to ensure 24hour x 7 a week support of all databases

Confidential, Little Rock, AR

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2008
• Knowledge of Windows Server 2003/2008
• Configuration and support of Windows Native Clustering and SQL Clustering
• SQL Server DBA Production Support - E-Commerce Domain
• Designed and Implemented Database Backup Restore Strategy
• Data Warehousing Design and Life Cycle Support
• Refine and automate regular processes, track issues, and document changes
• Developed, implement and maintain change control and testing processes for modification to database structures

Confidential, Redmond, WA

Sr. SQL Server DBA

Responsibilities:

• SQL Server versions 2005/2008
• Knowledge of Windows Server 2003/2008
• Configuration and support of Windows Native Clustering and SQL Clustering
• Designed, documented, and promoted security "best practices", policies, standards and protocols.
• Created processes and procedures for application code and database object migrations to support an efficient and reliable system development Life-Cycle.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in
• Optimized DB interaction wif OS, file system, storage, and network