Sql Server Database Administrator

Satos Mason

484-***-**** *****.*****@*****.*** linkedin.com/in/satos-mason-8623443/

Sr. SQL Server Database Administrator

Accomplished Database Professional with experience developing, designing, administering, and implementing database solutions leveraging enterprise system technologies such as Middleware, Cloud, Virtual Servers, Clustered Instances, and SAN technologies coupled with Microsoft SQL Server.

Qualifications

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008 R2, 2012, 2014, 2016 & 2019 Azure

SQL Server Integration Server SQL Server Report Server SQL Server Agent Database Design Performance Tuning Query Optimization Index Optimization SQL Replication High Availability Security SSIS SSRS TSQL Arcana Tidal Bitbucket Git Service Now Jira Kanban Crystal Reports

Experience

SR. SQL SERVER DATABASE ENGINEER PROGRESSIVE LEASING NOVEMBER 2021- JANUARY 2024

•Collaborated within an agile team comprised of software engineers, quality assurance engineers, and product owners providing technical expertise in the scope of database management systems.

•Developed stored procedures, tables, functions, views, and other database indices to support new functionality and enhancements throughout the entire software development life cycle.

•Developed TSQLt test procedures for regression and functionality testing of new or modified database code changes before implementation.

•Conducted query, stored procedure, and index tuning to prevent or address poorly performing queries and database structures.

•Collaborated with Change Management on releases, deployments, and incident mitigations in the production environment.

•Managed interactions with other critical systems via database-level permissions, windows groups, users, roles schemas, security compliance and other policies.

•Monitor database systems and perform health checks to proactively identify.

SQL DATABASE ADMINISTRATOR ADVISOR ANTHEM INC JULY 2019 – NOVEMBER 2021

•Created, upgraded, and maintained multi-node SQL server clustering to ensure availability.

•Compiled pre and post upgrade analysis reports to plan and validate the upgrade efforts.

•Performed gap analysis and remediation to ensure scalability and performance to streamline operations.

• Analyzed database solutions and designs meticulously aligned with best practices to meet technical and business requirements.

• Performed capacity management and planning to manage storage allocations in the database systems.

•Managed database-level permissions via Windows groups, users, roles schemas, and other policies.

SR. SQL SERVER DATABASE ENGINEER CQUEST AMERICA JANUARY 2013 – FEBRUARY 2019

• Established process standards for migrating Sybase ASA legacy databases to new MS SQL Server platforms.

• Executed Sybase ASA schema conversions, meticulously mapping column definitions to compatible MSSQL 2012 Server data types.

• Collaborated closely with application developers, network engineers, database administrators, and operations management.

•Developed databases and performed maintenance tasks to maintain database health consistency on Windows operating systems.

• Developed SSIS packages for extracting, transforming, and loading of data from legacy Sybase ASA databases, mapping over 529 tables with 5,023 column mappings.

• Developed and implemented an Occasionally Connected Architecture utilizing MS SQL Server Merge Replication to provide functionality to mobile devices on disconnected networks.

• Developed automated environment refreshes for non-production database environments using SSIS.

• Conducted capacity analysis to determine storage requirements, including overhead and growth trends.

• Led all SQL Server database-related projects, creating tools, documentation, and training junior-level database administrators.

SR. SQL DBA\DATABASE ENGINEER BITS @CAPITAL ONE MARCH 2011 – SEPTEMBER 2012

• Utilized host clusters, EMC's SRDF, PowerShell, and SQLCMD to devise a robust process for recovering SQL Managed Services Platform (MSP) instances in disaster scenarios, encompassing conception, design, testing, and implementation to ensure operational readiness.

• Developed comprehensive documentation and conducted training sessions for application and operational DBAs, ensuring thorough understanding and proficiency in the new disaster recovery solution.

• Conducted training and mentorship to junior DBAs, fostering their professional growth and expertise.

• Collaborated with internal application teams and vendors to identify optimal implementation methods, prioritizing efficiency, and minimizing the need for rollbacks.

SQL DBA HUMAN CAPTIAL MANAGEMENT INC DECEMBER 2010 – FEBRUARY 2011

•Monitored all databases and SQL instances utilizing SQL Sentry.

•Provided data modeling and architecture support related to the design, development, and integration of new applications utilizing state-of-the-art database technology.

•Designed and implemented a global disaster recovery model leveraging Commvault technologies to create a comprehensive database backup solution.

Education

LEHIGH VALLEY COLLEGE - CENTER VALLEY, PENNSYLVANIA Business Administration

09/2000 GPA: 3.8

Microsoft Certified Technology Specialist – SQL Server 2005

Contact this candidate