Dave Wallace Email & Phone Number

Dave Wallace is a Senior Database Administrator at VinSolutions. He possess expertise in microsoft sql server, sql, databases, database administration, ssrs and 14 more skills.

Listed skills include Microsoft Sql Server, Sql, Databases, Database Administration, and 15 others.

• 

  Senior Database Administrator

  Vinsolutions

  Jul 2014 - Present

  Database Development Tasks:* Collaborate, Design and implement comprehensive order entry data architectures.* Conceptualize, Design and implement an automated sales personnel commission payment issuance system.* Collaborate, Design and implement a commission payment structure according to performance trends.* Conceptualize, design, and implement a promotional points system for sales personnel incentive programs.* Conceptualize, and design a reporting structure to allow 30,000 reps across the United States and Canada tovisualize and analyze organizational performance.* Collaborate, design, and implement an online order entry system.* Conceptualize, design, and implement an online lead assignment system to connect reps and blind leads forsales and recruiting opportunities.Database Administration Tasks:* Conduct SQL Server version upgrades across multiple clustered and non-clustered server environments.* Data migration processes from FoxPro to SQL Server database management systems.* Implement and maintain transactional database replication.* Implement and maintain log shipping processes.* Monitor Database performance, health, and security.* Implement and Administer SQL Server Reporting Services.* Implement Disaster Recovery Policies.* Monitor and maintain multiple development environments.* Troubleshoot and optimize performance for various SQL elements, including application-generatedhibernate queries.* Maintain database security using active directory services, as well as ad-hoc rights as required.Database Team Leadership Tasks:* Lead, mentor, and conduct yearly performance reviews for a four man database team that includes SQL,C#,SSIS, SSAS, and SSRS developers.* Delegate development projects among personnel to promote knowledge sharing, learning, and teamwork.* Provide SQL tutelage for management and business intelligence personnel.