VaShaun P.
Senior Advisor, IT Architecture at Virtustream- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Ron M.
Shaun is an expert in large scale MS SQL and MySQL Database environments. He has mastered the understanding of complex, heavy load TSQL transactions. When tuning, database structure, indexes, stored procedure, best practices, up-time, smooth performance are all important, then Shaun is the type of DBA that truly knows how to keep these high standards. If you are growing your feature sets centered around MS SQL or MySQL, then developers will benefit greatly from Shaun’s time to more efficiently write code. If you would like to sleep better at night and know your database will be running well in the morning, then I would recommend finding a DBA with the kind of skill set that Shaun has proven time and time again.
Steven Loper
Over a couple years I had the opportunity to work with Shaun on two Enterprise Level projects and enjoyed is professionalism, work ethic and DBA Technical knowledge. One project in particular was migrating multiple SSIS packages from an older DB schema to a new one for a live production system. Shaun had intimate knowledge of the integration as well as know issues and challenges. Since we were changing a mission critical production system, Shaun implemented appropriate deployment and role back procedures to ensure the system still functioned even if there were issues. The project was under tight deadlines and Shaun’s strong leadership and technical knowledge overcame many obstacles and we successfully deployed the updates without interruption. Shaun as a strong work ethic and works well as part of a team. I look forward to working with Shaun again.
Ron M.
Shaun is an expert in large scale MS SQL and MySQL Database environments. He has mastered the understanding of complex, heavy load TSQL transactions. When tuning, database structure, indexes, stored procedure, best practices, up-time, smooth performance are all important, then Shaun is the type of DBA that truly knows how to keep these high standards. If you are growing your feature sets centered around MS SQL or MySQL, then developers will benefit greatly from Shaun’s time to more efficiently write code. If you would like to sleep better at night and know your database will be running well in the morning, then I would recommend finding a DBA with the kind of skill set that Shaun has proven time and time again.
Steven Loper
Over a couple years I had the opportunity to work with Shaun on two Enterprise Level projects and enjoyed is professionalism, work ethic and DBA Technical knowledge. One project in particular was migrating multiple SSIS packages from an older DB schema to a new one for a live production system. Shaun had intimate knowledge of the integration as well as know issues and challenges. Since we were changing a mission critical production system, Shaun implemented appropriate deployment and role back procedures to ensure the system still functioned even if there were issues. The project was under tight deadlines and Shaun’s strong leadership and technical knowledge overcame many obstacles and we successfully deployed the updates without interruption. Shaun as a strong work ethic and works well as part of a team. I look forward to working with Shaun again.
Ron M.
Shaun is an expert in large scale MS SQL and MySQL Database environments. He has mastered the understanding of complex, heavy load TSQL transactions. When tuning, database structure, indexes, stored procedure, best practices, up-time, smooth performance are all important, then Shaun is the type of DBA that truly knows how to keep these high standards. If you are growing your feature sets centered around MS SQL or MySQL, then developers will benefit greatly from Shaun’s time to more efficiently write code. If you would like to sleep better at night and know your database will be running well in the morning, then I would recommend finding a DBA with the kind of skill set that Shaun has proven time and time again.
Steven Loper
Over a couple years I had the opportunity to work with Shaun on two Enterprise Level projects and enjoyed is professionalism, work ethic and DBA Technical knowledge. One project in particular was migrating multiple SSIS packages from an older DB schema to a new one for a live production system. Shaun had intimate knowledge of the integration as well as know issues and challenges. Since we were changing a mission critical production system, Shaun implemented appropriate deployment and role back procedures to ensure the system still functioned even if there were issues. The project was under tight deadlines and Shaun’s strong leadership and technical knowledge overcame many obstacles and we successfully deployed the updates without interruption. Shaun as a strong work ethic and works well as part of a team. I look forward to working with Shaun again.
Ron M.
Shaun is an expert in large scale MS SQL and MySQL Database environments. He has mastered the understanding of complex, heavy load TSQL transactions. When tuning, database structure, indexes, stored procedure, best practices, up-time, smooth performance are all important, then Shaun is the type of DBA that truly knows how to keep these high standards. If you are growing your feature sets centered around MS SQL or MySQL, then developers will benefit greatly from Shaun’s time to more efficiently write code. If you would like to sleep better at night and know your database will be running well in the morning, then I would recommend finding a DBA with the kind of skill set that Shaun has proven time and time again.
Steven Loper
Over a couple years I had the opportunity to work with Shaun on two Enterprise Level projects and enjoyed is professionalism, work ethic and DBA Technical knowledge. One project in particular was migrating multiple SSIS packages from an older DB schema to a new one for a live production system. Shaun had intimate knowledge of the integration as well as know issues and challenges. Since we were changing a mission critical production system, Shaun implemented appropriate deployment and role back procedures to ensure the system still functioned even if there were issues. The project was under tight deadlines and Shaun’s strong leadership and technical knowledge overcame many obstacles and we successfully deployed the updates without interruption. Shaun as a strong work ethic and works well as part of a team. I look forward to working with Shaun again.
Experience
-
Virtustream
-
United States
-
IT Services and IT Consulting
-
200 - 300 Employee
-
Senior Advisor, IT Architecture
-
Jun 2019 - Sep 2023
-
-
-
-
Data Engineer II
-
May 2017 - Jun 2019
Continuously updating inventory, while concurrently maintaining a 24/7 seamless user experience requires databases to be performing at their peak. -Setup and manage SQL database solutions, for multiple B2B and B2C products, using Microsoft Azure, Amazon RDS, and VMs -Tune code and/or server & database settings to improve data object performance (maxdop, indexes, hints, code modification) -Develop and Implement Disaster Recovery (DR) plans on production servers (High Availability… Show more Continuously updating inventory, while concurrently maintaining a 24/7 seamless user experience requires databases to be performing at their peak. -Setup and manage SQL database solutions, for multiple B2B and B2C products, using Microsoft Azure, Amazon RDS, and VMs -Tune code and/or server & database settings to improve data object performance (maxdop, indexes, hints, code modification) -Develop and Implement Disaster Recovery (DR) plans on production servers (High Availability, Always-On, Clustering, Log Shipping, Replication) -Develop solutions in Powershell (files to/from Amazon S3, files to/from FTP) -Develop data and database maintenance processes (archiving/deletion, dbcc, reorg/rebuild) Show less Continuously updating inventory, while concurrently maintaining a 24/7 seamless user experience requires databases to be performing at their peak. -Setup and manage SQL database solutions, for multiple B2B and B2C products, using Microsoft Azure, Amazon RDS, and VMs -Tune code and/or server & database settings to improve data object performance (maxdop, indexes, hints, code modification) -Develop and Implement Disaster Recovery (DR) plans on production servers (High Availability… Show more Continuously updating inventory, while concurrently maintaining a 24/7 seamless user experience requires databases to be performing at their peak. -Setup and manage SQL database solutions, for multiple B2B and B2C products, using Microsoft Azure, Amazon RDS, and VMs -Tune code and/or server & database settings to improve data object performance (maxdop, indexes, hints, code modification) -Develop and Implement Disaster Recovery (DR) plans on production servers (High Availability, Always-On, Clustering, Log Shipping, Replication) -Develop solutions in Powershell (files to/from Amazon S3, files to/from FTP) -Develop data and database maintenance processes (archiving/deletion, dbcc, reorg/rebuild) Show less
-
-
-
-
Consultant
-
Oct 2017 - Sep 2018
Database Administrator / Database Developer SQL Server, MySQL, MariaDB Upgraded database infrastructure from single node to multi-node High Availability Performance tuned existing database code using code modification, indexes, and server configurations Developed and maintained ETL and Reporting solutions using tools like SSIS & SSRS Designed and implemented new data center relating to database storage, performance, redundancy, and resiliency Reviewed and improved… Show more Database Administrator / Database Developer SQL Server, MySQL, MariaDB Upgraded database infrastructure from single node to multi-node High Availability Performance tuned existing database code using code modification, indexes, and server configurations Developed and maintained ETL and Reporting solutions using tools like SSIS & SSRS Designed and implemented new data center relating to database storage, performance, redundancy, and resiliency Reviewed and improved administration tasks including: maintenance, backup & recovery, auditing Show less Database Administrator / Database Developer SQL Server, MySQL, MariaDB Upgraded database infrastructure from single node to multi-node High Availability Performance tuned existing database code using code modification, indexes, and server configurations Developed and maintained ETL and Reporting solutions using tools like SSIS & SSRS Designed and implemented new data center relating to database storage, performance, redundancy, and resiliency Reviewed and improved… Show more Database Administrator / Database Developer SQL Server, MySQL, MariaDB Upgraded database infrastructure from single node to multi-node High Availability Performance tuned existing database code using code modification, indexes, and server configurations Developed and maintained ETL and Reporting solutions using tools like SSIS & SSRS Designed and implemented new data center relating to database storage, performance, redundancy, and resiliency Reviewed and improved administration tasks including: maintenance, backup & recovery, auditing Show less
-
-
-
AssistRx, Inc
-
United States
-
Sr. Database Administrator
-
Apr 2015 - Apr 2017
Prescription workflow management application that uses various data stores to maintain secure patient information between patients, vendors & healthcare providers. -Performed performance tuning on MySQL databases (server configurations, database settings, code modifications) -Lead a SQL development team that created ETL and reporting solutions with strict deadlines -Ensured that all production processes/jobs are running optimally and resolve if necessary -Created Extract Transform… Show more Prescription workflow management application that uses various data stores to maintain secure patient information between patients, vendors & healthcare providers. -Performed performance tuning on MySQL databases (server configurations, database settings, code modifications) -Lead a SQL development team that created ETL and reporting solutions with strict deadlines -Ensured that all production processes/jobs are running optimally and resolve if necessary -Created Extract Transform Load (ETL) solutions using SSIS & C# (import/export, aggregate, warehouse data) with various connection types (ODBC, OLEDB, MySQL, Files, Salesforce) -Created complex real-time SSRS reports by applying charts, sub reports, and summaries Show less Prescription workflow management application that uses various data stores to maintain secure patient information between patients, vendors & healthcare providers. -Performed performance tuning on MySQL databases (server configurations, database settings, code modifications) -Lead a SQL development team that created ETL and reporting solutions with strict deadlines -Ensured that all production processes/jobs are running optimally and resolve if necessary -Created Extract Transform… Show more Prescription workflow management application that uses various data stores to maintain secure patient information between patients, vendors & healthcare providers. -Performed performance tuning on MySQL databases (server configurations, database settings, code modifications) -Lead a SQL development team that created ETL and reporting solutions with strict deadlines -Ensured that all production processes/jobs are running optimally and resolve if necessary -Created Extract Transform Load (ETL) solutions using SSIS & C# (import/export, aggregate, warehouse data) with various connection types (ODBC, OLEDB, MySQL, Files, Salesforce) -Created complex real-time SSRS reports by applying charts, sub reports, and summaries Show less
-
-
-
PatientMatters
-
United States
-
Hospitals and Health Care
-
1 - 100 Employee
-
Sr. Database Administrator
-
Jul 2014 - Apr 2015
Custom hospital financial processing software. -Monitor daily production processes, perform root cause analysis and resolution on failed processes. -Configure and maintain SQL Server databases in a High Availability configuration. -Implement SQL replication technologies to support database accessibility (SLA) agreements. -Review hardware usage metrics to ensure seamless database growth by reducing emergency maintenance periods. -Created custom dashboard to provide simple… Show more Custom hospital financial processing software. -Monitor daily production processes, perform root cause analysis and resolution on failed processes. -Configure and maintain SQL Server databases in a High Availability configuration. -Implement SQL replication technologies to support database accessibility (SLA) agreements. -Review hardware usage metrics to ensure seamless database growth by reducing emergency maintenance periods. -Created custom dashboard to provide simple, centralized information for departments to see critical information. -Developed solutions using SQL Server Reports (SSRS) and SQL Server Integration Services (SSIS) using T-SQL and C# based on business requirements. -Performed query tuning on poor performing stored procedures or T-SQL statements. Show less Custom hospital financial processing software. -Monitor daily production processes, perform root cause analysis and resolution on failed processes. -Configure and maintain SQL Server databases in a High Availability configuration. -Implement SQL replication technologies to support database accessibility (SLA) agreements. -Review hardware usage metrics to ensure seamless database growth by reducing emergency maintenance periods. -Created custom dashboard to provide simple… Show more Custom hospital financial processing software. -Monitor daily production processes, perform root cause analysis and resolution on failed processes. -Configure and maintain SQL Server databases in a High Availability configuration. -Implement SQL replication technologies to support database accessibility (SLA) agreements. -Review hardware usage metrics to ensure seamless database growth by reducing emergency maintenance periods. -Created custom dashboard to provide simple, centralized information for departments to see critical information. -Developed solutions using SQL Server Reports (SSRS) and SQL Server Integration Services (SSIS) using T-SQL and C# based on business requirements. -Performed query tuning on poor performing stored procedures or T-SQL statements. Show less
-
-
-
Physicians United Plan
-
United States
-
Insurance
-
1 - 100 Employee
-
Sr. Database Administrator
-
May 2012 - Jun 2014
Medicare Advantage Insurance Plan that used multiple software solutions to store and process information related to insurance claims processing (patient, provider, prescriptions, hubs). -Debugged and resolved SQL performance issues between daily front-end processing and reporting/etl processing -Maintained High Availability using Mirroring and Log Shipping -Created T-SQL, SSIS, SSRS solutions to meet the needs of the business Medicare Advantage Insurance Plan that used multiple software solutions to store and process information related to insurance claims processing (patient, provider, prescriptions, hubs). -Debugged and resolved SQL performance issues between daily front-end processing and reporting/etl processing -Maintained High Availability using Mirroring and Log Shipping -Created T-SQL, SSIS, SSRS solutions to meet the needs of the business
-
-
-
Aptitude Solutions
-
Australia
-
Software Development
-
1 - 100 Employee
-
Database Administrator
-
2011 - 2012
Government Industry Government Industry
-
-
-
USIS
-
United States
-
Security and Investigations
-
700 & Above Employee
-
Database Administrator
-
Dec 2009 - Jul 2011
Government Industry Government Industry
-
-
-
United Space Alliance
-
United States
-
Defense and Space Manufacturing
-
700 & Above Employee
-
Database Administrator
-
May 2004 - Oct 2009
Government Industry -Configure, maintain, tune, and backup Oracle 10g Databases -Configure, maintain, tune, and backup SQL Sever databases (MS SQL 2000, 2005) -Configure and monitor replication between SQL servers -Migrate existing databases from MS Access & SQL 2000 to SQL 2005 -Support web-based database-driven applications (SQL Server, Oracle 10g, CF, AS, ASP, JavaScript, VBScript) -Participate in database analysis, design, code, inspection, testing, troubleshooting… Show more Government Industry -Configure, maintain, tune, and backup Oracle 10g Databases -Configure, maintain, tune, and backup SQL Sever databases (MS SQL 2000, 2005) -Configure and monitor replication between SQL servers -Migrate existing databases from MS Access & SQL 2000 to SQL 2005 -Support web-based database-driven applications (SQL Server, Oracle 10g, CF, AS, ASP, JavaScript, VBScript) -Participate in database analysis, design, code, inspection, testing, troubleshooting, documentation and delivery of software products -Maintain IIS Web Server (Windows 2003/2000) and Artemis Server Show less Government Industry -Configure, maintain, tune, and backup Oracle 10g Databases -Configure, maintain, tune, and backup SQL Sever databases (MS SQL 2000, 2005) -Configure and monitor replication between SQL servers -Migrate existing databases from MS Access & SQL 2000 to SQL 2005 -Support web-based database-driven applications (SQL Server, Oracle 10g, CF, AS, ASP, JavaScript, VBScript) -Participate in database analysis, design, code, inspection, testing, troubleshooting… Show more Government Industry -Configure, maintain, tune, and backup Oracle 10g Databases -Configure, maintain, tune, and backup SQL Sever databases (MS SQL 2000, 2005) -Configure and monitor replication between SQL servers -Migrate existing databases from MS Access & SQL 2000 to SQL 2005 -Support web-based database-driven applications (SQL Server, Oracle 10g, CF, AS, ASP, JavaScript, VBScript) -Participate in database analysis, design, code, inspection, testing, troubleshooting, documentation and delivery of software products -Maintain IIS Web Server (Windows 2003/2000) and Artemis Server Show less
-
-
Education
-
2005 - 2008
Florida Institute of Technology
M.S., Compter Information Systems -
1999 - 2004
University of Florida
B.S., Computer Engineering
Community
