Joseph Moss Email and Phone Number

• Database architect assigned to the NEXTGEN project. • Assessed overall database architecture and delivered recommendations and solutions to executive management to achieve their goals of reliability, scalability, performance and overall system stability. This resulted in a much higher scale of user traffic and overall customer satisfaction.• Developed coding standards and performed code reviews of all statis and dynamic SQL code.• Reviewed existing database design and addressed all anomalies identified. This included table design and proper indexing.• Wrote a PYTHON application to compare containerized databases between AZURE environments to ensure consistency between environments. This application also performed other diagnostics as well as needed maintenance.• Created Epics and Stories in Jira as part of the implementation of database findings and recommendations and worked these items until completed and properly deployed.• Provided production support in the form of issue identification, detailed diagnostics and documentation as well as overall trouble shooting. This effort was considered crucial staff augmentation as the customer lost several people after a corporate acquisition. • Performed overall performance analysis and recommendation on application interactions with the database. Made recommendations for application code design changes as well as overall system performance improvements.• Provided database monitoring recommendations and assisted in monitoring rule configuration.• Implemented T-SQL error handling to expose T-SQL errors in Azure AppInsights and provide explicit error information.

Database Engineering; SQL Server Databases; Technical Leadership; Data Governance; and Database Automation.• I play a lead role as Database Engineer overseeing 2600+ SQL Server instances. • I direct the automation, design, architecture, development, administration, optimization, operation and monitoring of all SQL Server based Data Management Systems and applications.• I mentor an expert team of DBAs for implementation and operation of all SQL Server based Data Management systems. • Leads the application development / system teams to ensure projects delivery and challenges are met and resolved. • Designs and develops database automation, including database self-services.• Creates and delivers multiple training sessions on SQL Server database internals.• Successfully mentors, trains and guides an expert team of junior DBA’s.• Establishes, tracks, and enforces Data Governance, database operations and data management policies and procedures.