Stevan Paylor Email & Phone Number

San Diego, Ca, Us

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)

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

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

Master Of Business Administration (M.B.A.)

Bachelor’S Degree, Computer Science

Associate Of Science - As, Fire Science/Fire-Fighting

Associate Of Science - As, Social Services / Substance Abuse Counselling