Jeff Wright Email & Phone Number

Montgomery, Alabama Area

Experienced Database Administrator specializing in managing and optimizing CAP SQL Server databases within Azure VM Windows environments. Proven expertise in performance tuning, security implementation, and enterprise application support. Adept at driving operational efficiency and aligning database operations with organizational goals.Key Achievements:** Optimized Database Integrity: Led a team to resolve over 600 missing primary keys in multiple databases, improving system reliability and data quality. Directed team hiring and project planning for long-term success.** Accelerated Job Execution: Enhanced server settings to reduce SSIS package runtime for month-end jobs from three days to just 30 minutes.** Redesigned Queries: Improved database performance by converting inefficient table variables and CTEs into temp tables or optimized joins.** Enabled CI/CD Integration: Eliminated 30,000+ errors during database imports, ensuring seamless integration in DevOps pipelines.** Resolved System Issues: Identified and fixed recurring performance degradation caused by Windows OS updates, restoring stability.** Managed Replication: Established and monitored replication across servers, ensuring data integrity and load balancing for over 66,000 users.** Implemented Security: Designed Row-Level Security policies to enforce data access controls based on organizational membership.Collaborative leader skilled in mentoring teams, setting priorities, and conducting performance evaluations. Proficient in creating technical and budgeting documentation, training staff, and facilitating cross-functional communication to meet operational needs. Passionate about delivering innovative solutions that enhance performance and security.

Montgomery, Al

Provide technical expertise and team leadership in establishing and maintaining SQL Server environment for this hospice-centric pharmacy solutions provider working with doctors, pharmacists and patients on a global scale. Interface across all departments to identify/resolve/automate DBA and reporting processes. Monitor all database functions, including creating SSIS packages, importing and exporting data from diverse sources. Oversee development and execution of multiple concurrently running projects, including Data Warehouse for medical claims processing and customer billing/CMS reporting. Train peers to troubleshoot SQL Server SSIS package issues and resolve file formatting and data input mistakes quickly and effectively. Key Achievements:** Successfully automated transfer/parsing large amounts of data supporting Drug Database, Duplicate Therapy, Allergies, ICD10, Interactions data, and Medi-Span suite of drug data. ** Dramatically improving system performance by analyzing server execution plans, fine tuning indexes, and upgrading servers to SQL Server 2014, utilizing improved cardinality estimator to streamline operations.** Drive process to transition multiple projects from outsourced contractors to an in-house development team to support data warehousing process for medical claims processing and customer billing/CMS reporting.

Recruited by this high-profile Mortgage Banking firm to oversee the development and maintenance of mission critical database infrastructure, including creating the GUI web interface and all data export / import / parsing processes. Worked closely with end-users to define and gather user requirements, establish project specifications, and document database designs. Supervised training of 50+ staff members on proper use of new website interface and database tools to upload, modify and export data for 3rd party / government use. Reported project status and achieved benchmarks to senior leadership team. Key Achievements:** Realized $480K in cost savings through development of SSIS 2008 packages that allowed for data transfer from legacy database to SQL server for upload to Fannie Mae / Ginnie Mae.** Reverse engineered a 1997 MS access database application used for multi-family housing funding into a modern streamlined SQL Server 2008 database and VB.NET web interface.** Credited for authoring all stored procedures, table valued and scalar valued functions, index creation and monitoring, maintenance planning, SQL Server planning and installation.** Drove process to purchase and implement Spotlight for SQL Server and Idera SQL Secure to streamline operations and ensure security of database and integrity of all stored data.