Scott Kelley

Phoenix, Az *****

adhjuq@r.postjobfree.com

480-***-****

Summary

Experienced Database Administrator, Data Warehouse Architect, and Solutions Integrator

Excellent written and verbal communications skills

Relevant Skills

Ms Sql 2000 - 2019 database administration specializing in security and preventative maintenance solutions.

Ms Sql 2000 – 2019 database design, query tuning, and performance analysis.

Highly Available On-premises and Hybrid Geo-diverse clusters design and implementation solutions.

Distributed Availability Group implementation solutions specialist integrating key data matrix reporting.

Monitoring ETLs for data warehouses and data marts used for cloud based reporting.

Experienced with Azure (IaaS, SaaS, PaaS, Express Route, and PowerBI Premium)

Experienced with AWS (Data Lakes, Athena, Glue, Kinesis, Red Shift, and RDS)

Experienced MS-SQL, MySQL, Oracle, PostgreSQL with tools:Solar winds DPA, Red Gate, VS, and various scripts

Automated Extract, Transfer, and Loads (ETLs) using integration services for on-premises and cloud applications.

Developed automated secure scripts to install SQL engine, deploy schema, and sync data in cloud or on-premises.

Developed power shell scripts for SQL server shutdown and restart of standalone instances used by other teams

Developed power shell scripts for cluster failovers and maintenance used by DevOps and other teams.

Remote deployment MS SQL & Oracle systems for public and secure networks -DOD NIPR, SIPR, & others.

Deployment and Maintenance of multiple node SQL clusters supporting multiple tiers of collected data.

Warehouse design, data modeling, schema design for 150tb reporting warehouse.

Develop ETL applications for weekly data transfers between HP Oracle Data Cube. (AIR, supply chain, others)

Experienced with Management Studio- SSMS, Reporting- SSRS, Integration- SSIS, and Analysis- SSAS Services Experience with creating and running tSql queries, stored procedures, and user functions in various script formats.

Configuring storage schema with clustered and non-clustered index optimization, and filtered indexes.

Configuring dual encrypted Service Broker connections with private keys for replication and data migration.

Develop SSIS packages using stored procedures and jobs to update 25tb database weekly.

Develop web based GIS data mining agricultural applications using .Net tied to SQL backend.

Develop web based data collection, data processing, and report generation applications.

Develop a rich client inventory control application for HP R&D lab stock using .Net & MS-SQL.

Database Systems: MS SQL 4.2-2019, Oracle 7 -12., MySQL, PostgreSQL, Casandra, and DB2.

Languages: Microsoft .net, Visual Basic, Perl, Korn, Java, ASP, PHP, XML, HTML, DHTML, Pascal, Visual Foxpro, Fortran, Cobol, Scripts- bash, VB, VBA, SQL, Java, batch, and cgi.

Certifications

Member of PASS volunteer

Microsoft Certified Systems Engineer

Microsoft Certified Professional

Certified Linux Professional

Data Center Advanced Technical Specialist

HP Master Accredited Systems Engineer

HP Accredited Integration Specialist

ITIL v3 Foundations

Security+ comptia

Employment History

Senior Database Administrator/Developer Equiant Financial Services 2020-2020

Senior Database Administrator 3RP Inc. 2019-2020

Senior Database Administrator Cyracom, Inc 2013-2019

Database Administrator/Developer TekSystems, Inc 2012-2013

Functional Area Expert/Senior Database Engineer NetCentrics Inc 2010-2012

Education

Electrical Engineering, Computer Science, Fire Fighter III-1992, Montana State University

Contact this candidate