Sql Server Data Analyst

Jeanette Reed

SQL Database Analyst / SQL Server Database Administrator / SQL Database Developer

832-***-**** ************@*****.*** 46 Glade Bank Place The Woodlands, Texas 77382

SUMMARY:

An accomplished Senior SQL Server DBA / SQL Database Developer Analyst with fifteen years of enterprise experience in large-scale SQL Server virtualized environments including three years focused on Azure Virtual Machines, Azure SQL Managed Instances, and Azure SQL Databases. DBA experience includes database design, installation, configuration, maintenance, monitoring, migrations, replication, clustering, performance tuning, troubleshooting, backup / recovery, security management, disaster recovery, resolving technical problems, scalability, upgrades, and Microsoft licensing true-up processing with Agile and Waterfall project environment experience. Data Analyst experience includes conducting data mining, data modeling, performing statistical analysis, business intelligence gathering, building data visualizations, and reporting. Adept and passionate at understanding day-to-day issues that could benefit by data analytics automation and designing and creating data-driven tools and reporting as a means of improving productivity across the enterprise.

EDUCATION & CERTIFICATIONS:

BACHELOR OF SCIENCE DEGREE in COMPUTER SCIENCE

Minor in Mathematics

Stephen F. Austin State University

Nacogdoches, Texas

CERTIFICATIONS:

AZ-900 Microsoft Certification: Azure Fundamentals Credential ID 989741152 Issued: April 5, 2021

SKILLS:

• Microsoft Azure SQL Solutions

• SQL Server Architecture & Administration

• SQL Server Installation & Configuration

• Relational DBMS & Data Modeling Methodologies

• Data Mining & Cleaning

• Database Security & Encryption

• Backup / Recovery / HADR / Disaster Recovery

• ETL Pipeline & Data Integration Technology (SSIS)

• Performance Tuning & Optimization

• SQL Programming, PowerShell Scripting & SQL Reporting (SSMS, SSRS)

• SQL Upgrades, Migrations, & Patching

• Source / Version Control Tools (GitHub)

• Dashboard Visualization Tools (Power BI, Tableau)

• MySQL, NOSQL (MongoDB)

PROFESSIONAL EXPERIENCE

Computer Biz Spectrum, The Woodlands, Texas

Sept 2023-Present

A computer services company providing software support and training to clients in various business sectors.

SQL Server DBA / Data Analyst

Attended Mastering the DP-300 Exam with 6 Comprehensive Practice Tests course by Udemy and completed practice tests.

Attended DP-300 Prep: Microsoft Certified Azure Database Administrator Associate (DBA) course by Udemy and completed labs in Azure.

Lab experience with Intelligent Insights, SQL Insights, Log Analytics workspaces, Microsoft Sentinel, Azure Monitor, Data Masking, Transparent Data Encryption.

Knowledge of Virtual Networks, Private Endpoints, Azure Firewalls.

Installed Power BI and attended Data Analysis SQL Tableau, Power BI & Excel course by Udemy.

Installed Azure Data Factory and attended Introduction to Azure Data Factory course by Udemy.

Installed newer release of MySQL and updated skills by completing The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert by Udemy.

TechStyleOS, El Segundo, CA

May 2023-Sept 2023

TechStyleOS is the globally integrated Operations and Services provider behind the fastest growing online fashion brands in history, including Fabletics, Savage X Fenty, JustFab, ShoeDazzle, and FabKids.

Senior Database Administrator

Supported high performance architecture with AlwaysOn Availability and transactional replication for four hundred databases across twenty SQL Servers on multi-terabyte databases.

Troubleshot, performed root cause analysis, and resolved incident tickets and change tickets.

Monitored overall performance of Database Operations service delivery making suggestions and implementing procedures that continue to meet or exceed Service Level Agreements.

Performed database restores and backups as requested and monitored the health of backup operations.

Provided performance monitoring using Perfmon, Extended Events, and SolarWinds SQL Sentry to evaluate database and server health.

Performed data quality assessment and code reviews for refresh jobs that execute in dev and QA environments.

Performed scheduled transfers of data between servers to refresh data in databases.

Participated in monthly unit load testing with various brands on multiple SQL servers to assess impact of software changes to overall performance to ensure customer success.

Designed, developed, and optimized stored procedures, views, triggers, User Defined Functions, constraints, indexes.

Limited access privileges and implemented Transparent Data Encryption on sensitive data to align ISO standards with GDPR compliance in dev, QA, and prod environments.

Assisted in data mapping and conversion efforts in decoupling data from multiple brands within one database into separate databases for future divestitures.

Designed, built, and maintained high-quality dashboards, reports, and visualization tools to produce daily baseline, wait, and growth statistics which were coded using SQL scripts and Power BI.

Troubleshot SSIS job failures and resolved errors.

Provided on call support to operations teams on production issues, deployments, server maintenance, backups, restores.

SQL Database Developer Analyst

Performed data analysis and requirements gathering using SQL queries to interpret complex datasets and to uncover trends, patterns, and insights to influence strategic decisions.

Investigated data discrepancies and wrote SQL code to resolve them.

Applied data modeling methodologies to help structure new data collection functionality.

Implemented new database design by converting conceptual / logical data models to physical data models for new business processes.

Developed and maintained dashboards, reports, and visualizations using Tableau.

Reviewed existing T-SQL stored procedures and functions to tune indexes and restructure SQL code for query optimization and improved efficiency.

Troubleshot SSIS job failures and resolved errors.

Worked with data from various sources (text files, Excel spreadsheets, XML, JSON).

Spotlight Inc. (contracted @ Alterra Mountain Company), Denver, CO

Jun 2022-March 2023

Alterra Mountain Company is an American Hospitality Company that is a conglomerate of fifteen ski resorts worldwide.

Senior SQL Database Administrator

Supported approximately one hundred eighty on-prem SQL databases and Azure cloud-based databases that provided high availability across fifty SQL Servers.

Developed, executed, and maintained automation scripts (PowerShell, T-SQL) as needed for new and existing SQL Server environments.

Developed and implemented data pipelines in Azure Data Factory and SSIS packages in SSIS before deploying them to production.

Managed and maintained database schemas by using version control with TortoiseGit and GitHub to maintain all Database Operation team development scripts, ETL packages, SSRS reports, and database schemas.

Monitored overall performance of Database Operations service delivery making suggestions and implementing procedures that continue to meet or exceed Service Level Agreements.

Triaged and resolved incident and change tickets.

Authored RFCs (Request-For-Change) with detailed steps, including roll back, and communication plans.

Populated Security Groups with user accounts in Active Directory.

Consulted with network team, server staff, business analysts, application support, and software developers to understand / troubleshoot database systems leveraged in their environments and deployed solutions to monitor performance, automated processes, performed tuning recommendations, and ad-hoc queries as needed.

Evaluated, tested, implemented data encryption software in dev, test, and production environments and met with vendors for software evaluations.

Negotiated with users and application owners to define least privileged access levels.

Created and monitored backups on a daily / weekly schedule using Rubrik backup software.

Collaborated with Database vendors to troubleshoot and resolve database-related escalated issues with Rubrik software.

Collaborated with Enterprise and local resort teams, including Systems Support, Security, Engineering, and Network to help business leaders create and manage reports and dashboards and to add users to proper security groups based on org chart.

Utilized PerfMon, SolarWinds DPA, and Extended Events to evaluate database and server health.

Utilized Azure Monitor for monitoring both on-prem and cloud environments.

Applied experience with SQL Server internals, indexing strategies, statistics, execution plans for performance tuning.

Troubleshot issues with AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups.

Programmed SQL scripts for capacity planning, database space, and computer resources.

Researched various hardware and software products; recommended the best solution and implemented approved products.

Performed data quality assessment and code logic evaluation for various lines-of-business and database systems, including Siriusware, RTPOne, and Spring Miller SMS.

Performed RTPOne 2022 database software updates and performed root cause analysis on missing reports in RTPOne as a part of post upgrade support.

Interviewed job applicants for Jr. SQL DBA role.

Attended weekly Change Advisory Board meetings.

VPN-ed in as a Remote employee which encrypted the internet connections protecting sensitive company information from cyberattacks.

Provided on call support to operations teams on production issues, deployments, server maintenance, backups, restores.

SQL Database Developer Analyst

Performed data analysis and requirements gathering; programmed complex ad hoc requests and updated data directly within the platform's SQL Server databases.

Implemented new data structures to efficiently model new database business processes.

As the Snowflake support DBA, tuned Snowflake SQL code allowing for faster data access and improved reporting.

Reviewed existing T-SQL stored procedures and functions to tune indexes and restructure SQL code for query optimization and improved efficiency.

Troubleshot SSIS job failures and resolved errors.

Worked with data from various sources (text files, Excel spreadsheets, XML).

Matrix Resources (contracted @ XTO Energy/ExxonMobil), Spring, Texas

Oct 2018-Oct 2021

XTO Energy is an ExxonMobil Company that specializes in the drilling and production of unconventional oil and natural gas assets through hydraulic fracturing.

Sr. SQL Server DBA

A team of three performed readiness assessments and data migrations on over three thousand SQL Server databases to Azure (one thousand databases) or to ExxonMobil on-prem SQL databases (two thousand databases) in a nine-month period using Agile / Waterfall methodologies and Data Migration Assistant.

Installed, upgraded, patched by installing routine SQL Server service packs and rebooting services, monitored SQL Server (2008, 2008R2, 2012, 2014, 2016, 2017, 2019) for development, test, and production environments as on-call production support.

Provided support for Business Objects, Carte, GIS, Greenhouse Gas (GHG), ProCount, SharePoint, SiteView, Spotfire, SCADA, Wellview, and Data Warehouse application databases.

Created and monitored backups on a daily / weekly schedule using Idera SQL Safe.

Simplified complex SQL queries using CTEs for easier readability and faster executions.

Assisted in data mapping and conversion efforts in merging data from subsidiary into corporate data structures for common applications.

Tuned Data Warehouse high-volume ten terabyte databases using SQL Profiler, Dynamic Management Views, Extended Events, SQL Tuning Advisor, Index Tuning Wizard, Query Store, rebuilding indexes, and execution plans.

Developed and updated stored procedures, views, triggers, User Defined Functions, constraints.

Utilized Bulk Copy Utility to transfer data between SQL Server and data files.

Interfaced with security for setup and resolution of network security problems in Kerberos.

Developed, tested, and performed all disaster recovery testing for SQL databases by installing SQL Server, restoring databases, creating logins, and troubleshooting application issues.

Performed nine-month cross-functional database project upgrading SQL Server from 2008R2 to 2016 for twenty-six Windows Servers.

Designed, built, and maintained dashboards, reports, and visualization tools by creating daily baseline, wait, and growth statistics (key performance metrics) which were derived using Windows PowerShell Scripts, SQL Agent Jobs, SSIS, SSRS, and SQL databases.

Identified and troubleshot database-related CPU, memory, blocking / deadlocking issues (with concurrency reviews for reoccurring issues), connectivity, job failures, I/O, disk space, and other resource contention issues.

Managed specific projects as well as heavy involvement in project implementation.

Supported SOX application databases providing reports for compliance and performed annual IT audits to ensure compliance of IT General Controls.

Attended weekly Change Advisory Board meetings.

Provided on call support to operations teams on production issues, deployments, server maintenance, backups, restores.

McDermott International/CB&I, The Woodlands, Texas

Jun 2014-Oct 2018

McDermott International/CB&I is a full spectrum energy solutions company that designs, engineers, and constructs energy infrastructure projects.

Enterprise SQL DBA

Installed and patched SQL Server (2008, 2008R2, 2012, 2014, 2016) on Windows platforms for dev, test, and production environments.

Supported twenty-four hundred enterprise level databases across more than one hundred fifty SQL Servers in dev, test, and production environments.

Provided technical customer support and comprehensive documentation of database structures for ChangeAuditor, Cintellate, Citrix, Cognos, Docusphere, eCar, eStats, Equential, HSE, McAfee, Peoplesoft, Primavera, QIMS, SharePoint, Project Server, ShawCableManager, SitePro, SourceForge S3D, The Welding Institute, ToolHound application databases.

Troubleshot unexpected issues across application, database, network, storage, server tiers during on-call production support for SQL Server and MySQL databases.

Created and monitored backups on a daily / weekly schedule using Tivoli Storage Manager.

Optimized performance of critical production applications via IDERA SQL Diagnostic Manager, SQL Activity Monitor, and SQL DMVs.

Supported high availability of Always-On Failover Clustering with active Tool Hound clusters in a production environment.

Designed and maintained transactional replication for time entry system offloading reporting to a subscriber SQL Server.

Utilized Windows, SQL Server, and Mixed Mode Authentication Mode with SSMS.

Implemented CDC, Change Data Capture, to track / capture falsified changes to hourly data for production auditing purposes to Equential, an hourly time management system.

Performed cross-functional teams project by upgrading two hundred fifty-eight databases from SQL Server 2005 to SQL Server 2008R2 on time and within budget.

Downloaded data, via SSIS packages, from JD Edwards Enterprise One and Peoplesoft into various SQL Server web-based applications.

Designed, built, and maintained data-driven and reporting tools; collected, cleaned, analyzed server, database, SQL edition, and SQL Server version data to build inventory system which was built using SQL Agent Jobs, SSIS, SSRS, and SQL scripts.

Performed data mining; identified irregular patterns in data sets; cleansed / scrubbed data for accuracy and integrity issues; and rectified data integrity issues including duplicates, missing values, and consistency issues on Cintellate Safety application.

Improved performance by utilizing Brent Ozar’s reorg / rebuild index recommendations.

Utilized SSIS to develop automated tools for server and database tracking.

Supported SOX application databases providing reports for compliance and supported auditors on annual IT audits to ensure compliance of IT General Controls.

Contributed to the development and training of new DBAs.

Provided on call support to operations teams on production issues, deployments, server maintenance, backups, restores.

Professional Directional Enterprises Inc., Conroe, Texas

Jun 2013-Mar 2014

An independent provider of directional and horizontal drilling services to E&P companies for US onshore development.

SQL Database Administrator

Provided technical support to business units for all production financial, operational, and BI applications and databases.

Interacted with stakeholders to understand data modeling needs and implemented effective solutions.

Designed and implemented new database / data solutions using Microsoft SQL Server (tables, views, indexes), Excel (pivot tables), and Microsoft Access.

Mentored the accounting team in the utilization of Microsoft Dynamics GP ERP and third-party products (Encore, eOne SmartConnect, eRequester, Mekorma MICR, Zevez) in the production environment.

Performed year-end closing activities using Microsoft Dynamics GP ERP.

Provided technical support for troubleshooting, defect resolution, software installations, and software updates.

Mentored end users in identification of data sources and SQL Server ODBC connectivity solutions.

Created / maintained Microsoft Dynamics GP ERP conceptual and physical data models as a part of the enterprise solution design.

Improved performance by using maintenance plans to monitor index fragmentation, rebuild indexes, update statistics; and by modifying SQL code.

Provided on call support to operations teams on production issues, deployments, server maintenance, backups, restores.

SQL BI Developer

Migrated data across environments and performed ETL data integrations of disparate systems.

Programmed complex SQL reports using Common Table Expressions and outer joins.

Created customized reports by accessing data in Excel, Access, and SQL Server using Crystal Reports.

Created Excel spreadsheets using Dynamics GP data stored in Microsoft SQL Server using Jet software and ODBC.

Developed and maintained dashboards, reports, and visualizations using Tableau.

Computer Biz Spectrum, The Woodlands, Texas

Jun 2010-Jun 2013

A computer services company providing software support and training to clients in various business sectors.

Database Technical Consultant

Installed new releases of Microsoft SQL Server 2008 for clients including SSRS, SSIS, and SSAS.

Converted Oracle SQL reports to SQL Server SSRS reports.

Trained new clients in coding complex SQL queries and using Report Builder.

Implemented ETL data integrations to support conversion of accounting data to other applications.

Implemented Business Intelligence solutions for accessibility of Microsoft SQL data across disparate platforms including Microsoft Access and Excel.

Conducted relational data modeling sessions, using Erwin, and performed third normal form analysis in the construction of the enterprise data model for the enterprise data warehouse.

Contact this candidate