Senior Database Developer candidate in Jacksonville, Florida, United States

Summary

Signature Accomplishments:

Enhanced Application Database Security: You led a transformation from single login with SA/DBO privileges to client-based application logins with minimum access models, improving application database security, data protection, and access control.

Mentored and Trained Developers: You mentored and trained new database and application developers, leading to improved T-SQL, debugging, and general database skills, reducing defects, recode efforts, and making project development more efficient.

Optimized Database Replication Strategy: You reduced development and maintenance costs and server overhead by 90% by implementing streamlined reports ODS for CRM/LOS applications using SSIS, change tracking, and instead-of triggers.

Developed Error Tracking Mechanisms: You developed robust error tracking mechanisms to capture execution status, success, and errors of database objects, improving error handling and reporting.

Maintained Schema Consistency: You ensured 100% schema match across 27 environments by establishing a systematic Data Tier Application (DAC) framework using SSDT, TFS/VS, and DACPAC deployments, maintaining consistency and reducing deployment errors.

Training and Development: You organized effective training and development sessions for QA resources to scrutinize functional specifications and ensure comprehensive evaluation from UI changes to database modifications and coding.

Infrastructure Optimization: You architected cutting-edge database server and storage infrastructure, optimizing server configuration, RAID disk storage setup, and database file-to-disk assignment to accelerate system efficiency and data integrity.

Environment Design and Implementation: You led the design and implementation of three distinct Web and SQL Server environments (Development, Test, and Staging) for two applications, focusing on driving robust testing and deployment ecosystems.

Career Experience:
IT-Database Analyst IV (2020-2023):

Spearheaded a pioneering project to implement PolyBase MS SQL Server to MS SQL Server for 20 client databases, replacing Qlik Attunity.
Received recognition from Microsoft for the best-designed databases in surveys of LendingSpace and PolyBase applications.
Executed over 13,000 lights-out deployments using Microsoft SSDT.
Led seamless partitioning of 110 extra-large loan tables via strategic database projects.
IT-Database Analyst III (2010-2019):

Converted all database projects to SQL 2019 for compatibility with the latest technology.
Implemented a T-SQL process to copy SQL Agent jobs across Availability Group Replica Nodes.
Led PolyBase proof of concept and development initiative.
Restructured SQL Server infrastructure, reducing server count and optimizing resources.
Implemented VS2015 database projects and upgraded encryption for improved data protection.
Implemented a Data Tier Application (DAC) deployment model and integrated multiple application transaction databases into a single database.
Reduced execution times and developed and managed a centralized support database.
Instituted database coding standards and development procedures for adherence to industry best practices.
Your career progression and significant contributions to database management, security, and optimization demonstrate your expertise and leadership in the field of database management. Your ability to adapt to new technologies and implement innovative solutions is clearly evident in your accomplishments.

Expectations

I expect my experience and knowledge to be leveraged for the enhancement and advancement of current database architecture to the next level and beyond. Usage of SSDT and lights out deployments to ensure that valuable developers time is in developing code not managing deployment scripts. Tuning all objects to the to ensure least foot print on server resources