Roger Hill Email & Phone Number

Alpharetta, Georgia, Us

• Six years experience working with large pharmaceutical companies on system integration projects involving AWS services, Posit, SAS Studio, Redshift and Postgres in GxP compliant environments. • Design, deployment, and validation of cloud-based, GxP-compliant Clinical Data Repository (CDR) incorporating data ingestion, cataloging, quality checks, and curation of study-based clinical trial data using AWS-based services and tools.• Design and development lead for SAS Studio management, EKS-based application for starting, viewing, and terminating pod-based sessions, centralizing and simplifying enterprise administration of large SAS installations.• Design, deployment and management of large claims-based data mart with billions of rows frequently being processed using Talend-based orchestration and Redshift/Azure database storage• Database administration and optimization of AWS Redshift/RDS instances and clusters, report and script development, training, and creating technical documentation as required.• Creation and presentation of engineering diagrams and slides for project progression and training• Creation of Statement of Work (SOW) and sales proposal documentation• Day-to-day management, time management, and career planning for a team of 5 consisting of Cloud Developers, Data Engineers, and Technical Writers

Atlanta, Georgia, Us

• Database administration on SQL Server 2005, 2008, 2012, 2014 and 2016, including Installation/Set up, SSIS, SSRS, Service Broker, customer maintenance queries using T-SQL and PowerShell scripting, AD and SQL Server-level security, backup/recovery, Service Broker queue maintenance/setup.• Query optimization and troubleshooting blocking, deadlocks, failed tasks, and ETL deficiencies utilizing Extended Events, SQL Profiler, and third-party vendor tools.• Tested and configured AlwaysOn AG for high-availability and disaster recovery.• Quarterly database/server performance evaluations with supporting reports.• Project Management: SOX Compliance, DML-level database auditing, Microsoft SQL Server Licensing Audit and CyberArk enterprise-wide security audit initiatives.• Followed and enforced strict ITIL change control guidelines for all database environments.

Irving, Texas, Us

Manager – Service Delivery/Hosting Support (2013 – 2016)• Managed Tier 2/Tier 3 Support personnel and vendor relationship utilizing Virtualized/Follow the Sun Service Desk model, supporting over 300 on-premise and 30 Hosted customers. • Routinely led and attended escalation calls related to support issues and conducted Post-Incident Reviews for system and service outages for 24x7/365 environments.• Trained Help Desk and existing staff to handle Tier 1-type issues and reinvigorate stagnating operations, resulting in 73% of all support tickets (SAP CRM) being triaged and resolved by Tier 1 and Support Desk personnel.• Spearheaded Six Sigma projects, including automation for Post-Incident Review and Situational Dashboard initiatives.• Achieved marked savings by shifting repetitive and common issues to Tier 1 and Help Desk personnel, reducing monthly support ticket costs by $20k/month.• Coordinated support operations for hosted applications in datacenter in Drohan, CA with outsourced near-shore and off-shore resources, • Managed team of 12 Citrix Support Engineers and SQL/Oracle Database Administrators for Hosting Operations Support. Duties included bi-annual performance reviews, escalations, scheduling, one-on-on-mentoring and weekly team meetings. Team tasked with Application/Database administration for customers on Citrix/VMWare virtual platforms. McKesson One Content, Patient Folder, Paragon, and Horizon software applications all supported in high-availability/24x7 environments. • Designed and deployed ExtraHop reporting for Citrix license compliance, eliminating approximately $50k in external consulting fees.• Orchestrated distribution of metrics and status reporting, ensuring quality of support using ITIL-based incident and problem management; innovated new ways to present data and redesigned and rewrote analytics package.

Irving, Texas, Us

Manager – Tools and Automation (2008 – 2013)• Managed team of 8 highly-skilled and tenured engineers/developers dedicated to the maintenance and deployment of remote monitoring and reporting toolsets.• Instituted training for 70+ support personnel/engineers to oversee operations and development for BMC-based monitoring infrastructure of over 5,600 mission-critical healthcare application and database servers across North America.• Directed team Service Desk operations for 25 outsourced customers with 8,000 + end-users, generating 400+K support tickets annually and implementing new reporting infrastructure for outsourced customer. • Designed a remote monitoring solution for McKesson Paragon, which accommodated true end-to-end, 24x7 monitoring of all application-related components.• Managed team on maintaining CA Service Desk internal ticketing application—primary system for 20 McKesson Outsourced sites and 3,000 users—consistently meeting goals at 99.9 or 100%. • Utilized data analysis and internal tools, reduced number of tickets created from monitoring alerts by 15-20% over 3-month period, eliminating $135K in support-related costs.• Project Manager/Coordinator for successful Service Capability and Performance Support Center Certification, which the organization failed two previous years.

Irving, Texas, Us

• Promoted based on performance and supported best practices for $28M managed services organization. • Designed SQL Server internal data warehouse for 2 support ticketing systems, monitoring archive, call statistics, surveys, and server inventory for reporting, eliminating need for applications costing $100K. • Executed internal solution for monthly call performance, ticket response and survey responses/scores for 20 McKesson Outsources sites, eliminating part-time contractor and saving $9,600 annually.

Irving, Texas, Us

• Trained and mentored junior/senior team members on SQL Server and McKesson applications and established monitoring policies and guidelines for SystemCare remote monitoring, increasing efficiency.

Irving, Texas, Us

• Developed remote application monitoring, database and system support for Horizon Patient Folder; formulated and implemented database maintenance policies, expanding to $8M service offering.

Irving, Texas, Us

Administered remote systems and database support for 250 Windows 2000 servers in clustered/single server configurations, developing and deploying custom database/application monitoring scripts.

Irving, Texas, Us

• Performed as customer advocate and supported 5 customers who had over $300K yearly maintenance with McKesson, ensuring projects and support were delivered in timely and efficient manner. • Led team to build cornerstone of $8M annual maintenance stream adopted in 2003 and still in operation.

Irving, Texas, Us

Recruited to McKesson for daily management of 6 database administrators, resolving escalated issues.

Us

Actively worked with an experienced development team in a Support role. Performed daily/weekly/monthly/quarterly database administration tasks including performance tuning, monitoring, backups and recovery, security, availability assurance, and capacity planning.

Remote Database Administrator for healthcare customers running applications on the SQL Server RDBMS.

Microsoft Engineering Consultant for outsourced large-scale installations and Help Desk operations.

On-site and remote support deployment consultant for healthcare software. Responsibilities included on-site installation, set-up. Also performed formal Microsoft SQL Server training.

Fayetteville, Nc, Us

Development and support for bar-code related systems and software. Provided internal support for sales representatives and executives.

Worked on high-end microwave communications components. Government projects required a Top Secret security clearance, which was obtained in 1993.

Sales for high-end servers, printers, and remote terminals.

Boulder, Co, Us

Maintained and operated a Decompression Chamber and Ejection Seat Simulator, both used for annual training of Naval and Marine Corp Aviators.

Randolph Afb, Tx, Us

On-aircraft maintenance and support of communication and navigation equipment on F-4E Phantom fighter and KC-135R tanker aircraft.

Operated and maintained communications equipment used to support missile and space operations associated with the Eastern Space and Missile Range operated out of Cape Canaveral, Florida.

Bachelor Of Science (B.S.), Industrial Engineering Technology

Associate Of Arts (A.A.)