Sheldon Williams Email & Phone Number

United States

Greater St. Louis Area

Greater St. Louis Area

St. Louis, Mo.

Promoted several times with exceptional tenure, leading a team of up to 50 database developers and contractors. Manage all source control process and policies for database development, data integration and business intelligence teams, responsible for initial project design reviews, time estimates and resource allocations, as well as training and budgeting for department.■ Designed, implemented and managed development environments created as replicas of production counterparts.■ Installed management systems to provide comprehensive monitoring of system uptime and performance.■ Designed and delivered a cloud based solution for migration from on-premises based development environment.■ Implemented several tools that enabled smoother integration between application and database developers.■ Led team in conversion of source control systems from Visual Source Safe to Team Foundation Services.■ Reduced potential for deployment errors and improved timelines to release changes by converting release management methods from script-only deployments to DACPAC deployments.■ Led a cross-functional team effort to reduce the exposure of client information to non-privileged users through a combination of data masking and data encryption.■ Reduced licensing costs by 50%, converting Development & QA environment systems to Developer Edition versions of SQL Server over the Enterprise and Standard Editions.

St. Louis, Mo.

Led a team of 16 database developers, coordinating a source control conversion project from VSS to TFS. Managed developer time allocation, code change requests and quality control checklists and attended and participated in all design reviews for initial development phase on projects. Delivered weekly development status reports to senior management with recommendations.■ Developed and implemented source control methodology within TFS to manage multiple project teams using the same database solutions for separate projects.■ Led the restructure of the development environment to match production systems in order to reduce deployment errors.■ Played a key role in refinement and documentation of requirements for developer object naming and coding standards.■ Proactively participated in all code reviews as the final level of approval prior to release to production.■ Demonstrated strong skills as a manager, conducting employee interviews, 90-day evaluations, quarterly and annual reviews, as well as career planning and training toward advancement.

St. Louis, Mo.

Led design of SQL Server clustering implementation in new data center, administering over 30 replicated clustered SQL Servers between primary and backup data centers. Monitored over 100 business critical daily jobs to ensure timely completion, communicate issues and mitigate risks. Provided 24/7 on call support for all production SQL Server systems.■ Designed and implemented a highly successful disaster recovery strategy using a database backup and recovery plan involving off-site backup storage and full replication of primary systems to secondary data center.■ Created database maintenance scripts to enable a proactive approach towards potential system issues.■ Performed performance tuning tasks, including index defragmentation, index rebuilds, server side profiler traces.■ Developed documentation for support of the entire SQL Server environment and managed database security using a combination of NT and SQL Server logins.■ Worked collaboratively with clients to define existing system capacity and future planning.

St. Louis, Mo.

Created and maintained database objects within both the development and QA environments, using SQL scripts to create databases, tables, views, stored procedures, and indexes. Responsible for updates to poorly performing stored procedures to increase performance and match current ANSI standards. Provision of sole database support for ten application developers.■ Decreased response time during selects, inserts, updates and deletes through the reengineering of indexes and provided peer review to T-SQL code for adherence to defined code standards and performance requirements.■ Developed ETL processes using SSIS and VB.NET code, converted DTS packages to SSIS and developed asset management database to track entire company IT physical assets.■ Created analysis report recognized as critical to the success of one of the company’s most profitable marketing campaigns.■ Engineered complex report that reduced a compliance officer’s task from a 6 hour process to a 15 minute process.■ Provided scripts to database administration team in order to retrieve large data sets to Federal auditors.■ Created database objects to manage new customer application review process for when online applications required additional compliance review.■ Developed process that enabled migration of customer information from old account to new account in the event of a compromised account.