Mark Winchell Email & Phone Number

Colorado Springs, Co, Us

Woodland Park, Colorado, United States

o Responsible for code release management including: merging code in TFVC and GIT, deploying code to all levels of environments, and building the automation for automatic deployments.o Crafted source of truth data tables for CI/CD pipelines in Azure ADO to help improve velocity for automated deployments.o Database consulting planning from ONPRIM platform to cloud platform.o Data mapping for migration from AS400 to cloud platform.o Team lead for the DevOps release team.o Supporting a wide range of developers in setting up, deploying, and troubleshooting various infrastructures.o Assisting corporate level DBAs with troubleshooting and maintaining SQL servers within the SDLC.o Performing DBA duties and performance tuning applications in AWS.o Supporting data migration efforts to and from database platforms.o Reverse engineer software application using MS SQL server to help export data, migrate data, and support production changes requested for.o Created sql scripts to harvest the JSON files embedded in VARCHAR(MAX) column.

o Provide 24 hour production support for BillReview software application serving 50+ clients with the largest client database at 1.2TB in size.o Implement security auditing, controls, and reporting for all levels of SDLC environments for Statement on Standards for Attestation Engagements (SSAE).o Responsible for automating manual SQL scripting processes by leveraging SSIS packages to improve workflow efficiency.o Deploy scheduled and adhoc MS SQL server code to production environments and troubleshoot and performance tune database objects to include: indexes, stored procedures, functions, deadlocks, and table schemas. o Support disaster recovery for main DEV QA and DEV servers. o Rebuild servers and restore databases and environment to normal working status. o Utilize SQL and SSIS packages to load and transform import routines. o Perform data center migrations for all SQL Servers consisting of re-establishing mirroring and log shipping processes.

Tricore Referecustnce Laboratories Albuquerque, NMo Responsibility for database administration availability and performance encompassing: Analysis Services, Reporting Services, SSIS packageso Consult custom strategies for database warehousing and reporting.o Implementation of MSSQL Reporting Services – including writing custom reports, deploying, and troubleshooting.o Provide POC solutions for Electric MPI for data warehousing.o Responsibility for database administration, availability and performanceencompassing: Reporting Services, SSIS packages, and Security forsensitive data. (PHI)o Research and Develop strategies for database warehousing tables with370+ million records for performance and archiving.o Develop and support Project ECHO for UNM patient outreach, datamatching and transfer automation.o Implementation of MSSQL Reporting Services – including writing customreports, deploying, and troubleshooting.o Implementation of security standards for SQL servers and databases in theorganization. Defining security access control processes for data access.o Utilizing SSIS packages for data manipulation and secure transfers to otherhealth organizations. (ETL)o Addressing and correcting data corruption in production systems thatincludes: applying logs, unloading and reloading data, correcting tornpages, and restoring differential backupso Develop strategies for MS SQL server disaster recovery, high availabilityand server consolidation.o Customized SSIS for data mining, storage and reporting on BloodBankIrradiator for CAP and FDA compliance.

o Responsibility for network infrastructure availability and performance.o Provide administration and basic and technical support for users in; Word, ProLaw, Outlook, bank and government web sites, Vodavi phone system, and TalkPath voice mail.o Administration responsibilities for; Exchange 2000, Vodavi phone system, MSSQL server 2000, TalkPath voice mail, ProLaw software, and DLS security softwareo Implemented Wikipedia kBase and VM SQUID Proxy service

o Provide technical support for ProLaw software – including financial management and practice management functionality.o Foster collaborative working relationships with key personnel at small to large law firms and Thomson Elite department teams.o Consult, create, assess, and facilitate technical hardware performance.o Responsibility for reporting and implementing ProLaw software – including MS SQL server distributed environments.o Set up, maintain, and customize SQL databases and triggers in single and multiple replication environments.o Responsibility for quality assurance measures regarding tasks for ProLaw application and supported integrations.o Develop creative solutions for various software integration including GroupWise, Notes, Exchange, Word, Word Perfect, and DMS applications.o Review and update technical documentation (internal and client friendly) for implementation processes, consulting, installation procedures, and standardization.

o Administration responsibilities for; Exchange 2000, Vodavi phone system,MSSQL server 2000, TalkPath voice mail, ProLaw software, and DLSsecurity software.; Provide technical support for ProLaw software – including financialmanagement and practice management functionality.o Specializing in MS SQL server database administration and replicationprojects for ProLaw software clients.o Leveraging custom solutions in SSIS for clients requirements for dataimports, exports and functionality.o Foster collaborative working relationships with key personnel at small tolarge law firms and Thomson Elite department teams.o Responsibility for reporting and implementing ProLaw software –including MS SQL server distributed environments; log shipping andreplicationo Database objects troubleshooting for all sizes of SQL databases,researching slow downs, and identifying code for rebuilding to maximizeperformance.o Set up, maintain, and customize SQL databases and triggers in singleenvironments and replication environments.o Review and update technical documentation (internal and client friendly)for implementation processes, consulting, installation procedures, andstandardization.o Upgrading and maintaining performance for 11 SQL Servers replicationenvironment across the states, and consulting for solutions to improveperformance.o Repairing replication environments preventing zero data loss andrebuilding those environments.

Mcse Windows Server 2000

Education record