Stevan Paylor

Stevan Paylor Email and Phone Number

Consulting and Contract DBA - Data Engineer @ San Diego, CA, US
San Diego, CA, US
Stevan Paylor's Location
San Diego County, California, United States, United States
Stevan Paylor's Contact Details
About Stevan Paylor

Senior/Staff level DBA and SQL\ETL Developer.Currently Senior DBA at Viejas Casino and Resort. Prior Staff DBA at Qualcomm. Work on very large, complex and diverse database systems. Primary work is with Microsoft SQL Server – all versions – many sizes and configurations – production systems infrastructure as well as development support. Experience with ETL, integration, conversions to/from Excel, Flat files, Oracle, MySQL, DB2, PostgreSQL, and Pervasive PSQL and Business Intelligence. Currently working with Visual Studio, GitLab, On-prem, Azure and AWS for Data Warehouse. Hold MBA and B.S. in Computer Science. USAF Veteran. DOD Secret Clearance (inactive).

Stevan Paylor's Current Company Details
PaylorDataWorks, LLC

Paylordataworks, Llc

Consulting and Contract DBA - Data Engineer
San Diego, CA, US
Stevan Paylor Work Experience Details
  • Paylordataworks, Llc
    Consulting And Contract Dba - Data Engineer
    Paylordataworks, Llc
    San Diego, Ca, Us
  • Viejas Casino And Resort
    Senior Database Administrator
    Viejas Casino And Resort Nov 2015 - Present
    Production and development support DBA at a very dynamic and successful Native American casino and resort • Current main project – Upgrading a complex marketing data warehouse to support analytics and Email campaigns and phone apps – Export to SAS CI360• Currently doing extensive work with SSIS, AWS/RDS, Visual Studio 2019 and 2022 with GitLab• Conducted roll out of SQL Server 2019 and 2022 and migration to Azure and AWS• Sole DBA in medium sized environment with 80+ SQL Server, SSIS and SSRS instances• Numerous, diverse and critical applications requiring very high availability (HA)• Extensive work on design and implementation of policies, procedures and tools to enhance HA • Upgrading critical applications to AlwaysOn Availability Groups (AAG) in SQL Server 2012-2019• Completely revamped entire SQL Server estate with best practices – dramatically eliminated outages• Developed and implemented several SQL scripts and processes to enhance management of databases• Recommended and implemented Idera “SQL Diagnostic Manager” and “SQL Inventory Manager”• Recommended and implemented SolarWinds DPA to replace SQL Diagnostic Manager• Developed scripts and ETL process to replace “SQL Inventory Manager”• In the process of bringing in “SQL Sentry” to enhance SolarWinds DPA functionality• Recommended and implemented Pragmatic Works “Task Factory” add-ons for SSIS• Focus on SQL Server performance tuning using several tools and self-developed utilities• Focus on upgrading, enhancing and stabilizing critical SSIS and SSRS processes• Extensive development and support of ETL processes for Data Warehouse, BI, Analytics tools• 7/24 On-call (Sole DBA on staff)
  • Qualcomm, Inc.
    Staff Database Administrator
    Qualcomm, Inc. Jan 2008 - Nov 2015
    San Diego, Ca, Us
    Production / Infrastructure DBA for very large and diverse global electronics / Telecommunications Company• Staff DBA in large environment of 400+ instances, 5000+ databases and 221+ applications• Architected, installed, configured, and upgraded SQL Servers • Did extensive performance tuning and monitoring• Developed and enforced standards and procedures • Insured high performance, high availability, manageability, reliability and security of databases• Documented and communicated best practices / contributed to team knowledge base• Mentored and lead other DBAs and customers globally• Designed, developed & implemented infrastructure management tools & processes • Did PowerShell and extensive and complex TSQL scripting• Analyzed and enhanced SQL queries, stored procs, etc. for performance, reliability and security• Actively enforced and followed ISRM / MSB Security Standards• Lead troubleshooting & remediation with Microsoft Engineers, MS Support, Windows Admins• Actively worked in a US Government classified environment• Organized, managed and participated in 7/24 On-call rotation for global DBA team• Consistently highly rated in customer service and effective communicationsSpecial Projects• Created a system to automatically create and update Central Management Servers to improve the DBA team’s ability to manage hundreds of SQL Server instances / applications• Developed processes and managed the on-call rotation for a team of a dozen+ DBA spread worldwide• Developed extensive processes that automatically gathered system metadata across the network to feed an in-house developed management application that tracked servers, applications, databases and application/database owners to support on-call• Created a utility that allowed customers to build a self-service VM with SQL Server installed and configured• Conducted deep-dive analysis and evaluation of Amazon Web Servers (AWS) for re-hosting SQL Servers
  • Qualcomm, Inc.
    Database Administrator
    Qualcomm, Inc. Aug 2000 - Oct 2008
    San Diego, Ca, Us
    First SQL Server DBA brought on staff for the Corporate Database Services department (primarily an Oracle shop)• Planned, installed and managed new SQL Server systems• Built out processes and procedures to establish a production environment • Managed very rapid SQL Server growth in the Corporate Database Services department• Acquired databases previously managed in non-IT departments and “productionized” them • Went from less than five SQL Servers to dozens of servers, databases and applications• Aggressively upgraded SQL Server systems to newer versions• Implemented, clustering, log shipping and database mirroring for High Availability (HA) • Migrated data from Lotus Notes and various other non-SQL data sources • Created and implemented ETL / DTS packages to refresh SQL Server databases from Oracle • Created an internal SQL Server User Group to bring together DBAs spread around the enterprise• Provided internal consulting to business and other IT units

Stevan Paylor Skills

Databases Sql Microsoft Sql Server Database Administration Integration Data Warehousing Shell Scripting Software Development Business Intelligence Performance Tuning High Availability Windows Server Troubleshooting Programming Powershell Etl Production Dba Infrastructure Dba Database Architecture Database Mirroring Database Replication Database Log Shipping Pervasive Psql Cobol Sql Server Integration Services System Architecture Ibm Mainframe Datastage Focus 4gl Nomad 4gl Redgate Backup Quest Spotlight Quest Performance Analzyer Database Monitoring Working Remotely Sql Server Alwayson 7/24 On Call Sql Server Reporting Services Microsoft Office Team Leadership Litespeed Backup Database Security Db2 Clustered Systems Trello Idera Sql Diagnostic Manager Idera Sql Inventory Manager Pragmatic Works Task Factory

Stevan Paylor Education Details

  • National University
    National University
    Master Of Business Administration (M.B.A.)
  • Coleman College
    Coleman College
    Computer Science
  • Community College Of The Air Force
    Community College Of The Air Force
    Fire Science/Fire-Fighting
  • Community College Of The Air Force
    Community College Of The Air Force
    Social Services / Substance Abuse Counselling

Frequently Asked Questions about Stevan Paylor

What company does Stevan Paylor work for?

Stevan Paylor works for Paylordataworks, Llc

What is Stevan Paylor's role at the current company?

Stevan Paylor's current role is Consulting and Contract DBA - Data Engineer.

What is Stevan Paylor's email address?

Stevan Paylor's email address is st****@****cox.net

What schools did Stevan Paylor attend?

Stevan Paylor attended National University, Coleman College, Community College Of The Air Force, Community College Of The Air Force.

What are some of Stevan Paylor's interests?

Stevan Paylor has interest in Collecting Antiques, Exercise, Home Improvement, Reading, Shooting, Sports, The Arts, Home Decoration, Children, Cooking.

What skills is Stevan Paylor known for?

Stevan Paylor has skills like Databases, Sql, Microsoft Sql Server, Database Administration, Integration, Data Warehousing, Shell Scripting, Software Development, Business Intelligence, Performance Tuning, High Availability, Windows Server.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.