Jonathan W. Email & Phone Number

Timnath, Co, Us

Reston, Va, Us

• Assess company’s technological ecosystem to align with its operational requirements.• Design structures and plans that meet current and long-term data requirements.• Designed internal process improvements to automate repetitive tasks, shortening data delivery times.• Create and maintain Data Governance to ensure best practices and regulations are being followed.• Developed database architectural strategies at modeling, design, and implementation stages to address business or industry requirements.• Create migration program for database technologies for on premises to cloud offerings such as AWS(EC2, Redshift, Aurora) or Google Cloud(AlloyDB, CloudSQL). • Perform database engineering tasks using SQL Server, PostgreSQL, and Oracle.• Conduct interviews and hire recommendations of potential candidates.• Supervised and mentored team of database engineers to develop, test, modify and deploy solutions to technical problems.• Work in SAFe Agile team to groom database development user stories using Jira.

Reston, Va, Us

• Create new Data Governance program for each team to follow which increased efficiency 30-40%.• Use entity relationship diagram tools such as PowerDesigner to maintain ERDs.• Enhanced data dictionaries and standards for databases, creating easy to read catalog.• Implemented new database lifecycle, improving speed and accuracy of database deployments by 80-90%.• Utilize Visual Studio TFS and Azure DevOps for code management.• Work in SAFe Agile team using Jira.• Ensure database code performs at highest level of efficiency using unit tests in Redgate.• Designed internal process improvements to automate repetitive tasks, shortening data delivery times.• Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls.

Gilbert, Az, Us

Monitor all SQL servers using SentryOne, Solarwinds, and email alerts. Perform on call duties following the scheduleDatabase Lifecycle Management leadSupervise the DLM team to ensure the database code is release properly Set a schedule for production code release primary and secondary Set standards for the DLM code release processUtilize Availability Groups as well as Windows ClustersPerform index tuningExplore improvements to the database systems Create system design for installing SQL Server Optimize database permissionsAssist with database backup and restore using CommvaultAssist the database developers with code optimizationWrite stored procedures, views, functions, queries for data pulls, and assist with other database development tasks

Gilbert, Az, Us

Design, develop and maintain the architectural design and development of transactional databases for critical systems based around SQL technologies.Work closely with .NET Developers, Scrum Masters, and Project Owners to determine proper system and database designs.Actively participate and contribute to the continual improvement of best practices by developing and implementing system recovery and database management.Write T-SQL against complex and critical databases to optimize performance.Database tune, troubleshoot issues, analyze query plans, run traces, and interpret logs to address root causes of failures, bottlenecks and potential improvements.Produce ERD modeling, database design, and documentation for data models.Provide accurate data and reports to end users.Stay current on all new features made available of SQL Server.Document requirements and processes, as needed.

Scottsdale, Az, Us

Worked on a SCRUM team to enhance our latest version of the probation management application. This application tracks various pieces of information for each person that is on probation for numerous counties throughout certain states in the United States Utilized technologies in C#, ASP.NET, LINQ, MVC 4, JavaScript, and Microsoft SQL Server 2008, 2012, or 2014Performed database conversion for new customers as we as existing customers who are upgrading to a new version of the application. Created or updated stored procedures, functions, views, and triggers in Microsoft SQL server 2008, 2012, and 2014Performed large data changes due to bad data that was reported by the customersDeveloped or updated reports utilizing Microsoft SQL Server Reporting ServicesCompleted project work orders from customers for new application development or enhancementsUsed Team Foundation Server TFS for version control and task assignmentsPerformed database backup and restore upon customer request Set user permission for access to the database and SSRS reports

Chandler, Az, Us

Utilized extensive knowledge in various languages to fulfill the department programming language requirement Convert older applications and databases to a newer language. Which may include Java, JavaScript, Perl, Oracle, and MS SQL Server Assist with data accuracy checks for the probe testing environments System administrator for the probe departmentSetup and maintained Windows Server 2003 and 2008, backup server, web server, and all machines connected in active directory Maintained working condition of all machines that are in production

Assisted the database administrator with creating new databases, queries, database maintenance, and stored procedures using Microsoft SQL Server 2005 and 2008. Assisted the senior system engineer with set up and maintain the thirteen onsite/offsite servers. Platforms used are Windows server 2000 and 2003, running Windows XP, Vista, and Windows 7 clientsTroubleshoot various hardware issues, and resolve customer’s software/hardware difficulties utilizing the ticket or phone method

San Antonio, Texas, Us

Trainer for all required skills for new employeesReceived, evaluated, screened and analyzed telephone calls for proper disposition across all USAA lines of businessUtilized knowledge of technology/enterprise systems/Internet, defined procedures, and current corporate services to successfully provide members and employees with services or appropriate call routing Provided direct support to members for registration to the USAA corporate website (USAA.COM), resolved website access problems, and offered technical support regarding browser and website navigational issues

Arlington, Virginia, Us

Supervised operations and assisted the team members in installation, repair, operation and maintenance checks of multi-channel transmission equipment Installed and operated multi-channel transmission equipment which included line of site antennas, radios, and satellite connectionsOperated diagnostic equipment specific to network switchesRequested logistical support for operations