Database Administrator Sql Server
Resume:
BENJAMIN SHELTON
SENIOR DATABASE ADMINISTRATOR AND DATABASE ANALYST
CONTACT INFORMATION
Email: ***********@*****.***
Cell: 678-***-****
SUMMARY
20+ years of SQL Server DBA experience within healthcare, retail, and aerospace/defense areas. Extensive knowledge in optimizing existing systems, implementing new infrastructure/capacity planning, and database access and security assessments.
SQL Server DBA and ETL Administrator with 6 years of Epic experience in Cogito
As Technical Manager of Data Services at Northeast Georgia Health System
(NGHS), I managed teams of Operational Database Administrators, SQL Server Database Administrators, SharePoint Administrators, and Financial BI Analysts supporting IT and the organization as a whole in the design, development, delivery, and management of data services technical solutions
As Senior Database Administrator at Northeast Georgia Health System, involved in two EHR implementations; most recently, supported the infrastructure, architecture, and design of newly acquired Epic EHR servers and database environments and provided senior-level database administration for multiple NGHS critical and non-critical applications; built and modified Clarity data ETLs and worked alongside business intelligence developers to accommodate requests for new database objects, confirm validations, and troubleshoot performance issues; also performed database monitoring, performance tuning, including index creation, database maintenance tasks, and other objects within the databases, and utilized multiple tools for predictive analysis of capacity planning and requirements in collaboration with systems architecture team
Certified in Clarity Administration (ETL), with additional experience in System Pulse Monitoring and Caboodle (Healthcare EMR) Data Warehouse EXPERIENCE
UNIVERSITY OF KENTUCKY HEALTHCARE, LEXINGTON, KY
Principal Database Administrator (10/2020 – Current)
Provide senior level ETL and database administration for multiple UKHS critical and non-critical applications on a 24/7 basis, including on-call rotation with other members of ETL/DBA team.
Lead team of Data Architects on data extractions and loads (ETLs) from the Healthcare system’s EHR into the Enterprise Data Warehouse (EDW).
Work alongside Data Architects and Infrastructure teams for capacity assessments to accommodate requests for new ETL objects as new requirements for data arise.
Perform general database monitoring, performance tuning including index creation, database maintenance tasks, and other objects within the databases. INDUSTRY EXPERIENCE
20+ years of Server
Architecture and Best Practices
20+ years of Database
Administration
15 years of Infrastructure
Capacity Assessment Planning
and roadmap projections
SSIS/SSRS
SQL Server (Versions 6.5-2022)
SQL Server AlwaysOn High
Availability solutions
SQL Security best practices
SQL Server Optimization and
performance tuning
7 years of Epic experience
5 years of personnel
management experience
10 years - healthcare industry
Windows 2K-2019 Server OS
AWS (EC2, S3, Secrets Manager)
Azure (Synapse and
fundamentals)
DD Boost (~7years)
PowerShell (~1 year)
DPA Server monitoring
Agile Methodologies/JIRA
Service Now
Confluence
EPIC CERTIFICATIONS
Clarity Administration (ETL)
EPIC EXPERIENCE
System Pulse Monitoring
Caboodle Data Warehouse
Caboodle Development
Cogito/Clarity Administration
BENJAMIN SHELTON
SENIOR DATABASE ADMINISTRATOR AND DATABASE ANALYST 2 of 3
ADVANTAGECARE PHYSICIANS, NEW YORK, NY
Senior Consultant – Caboodle (SSIS) Development (7/2020 – 10/2020)
Performed Caboodle development for ingestion of payer data using SSIS and other software into the EDW.
Collaborated with other team members using JIRA software and adhering to Agile methodologies NORTHEAST GEORGIA HEALTH SYSTEM, GAINESVILLE, GA
Technical Manager of Data Services (10/2015 to 6/2020)
Managed multiple teams, consisting of operational database administrators, SQL server database administrators, and SharePoint administrators, to support IT and organization
Managed design, development, delivery, and management of data services infrastructure and technical solutions, as well as the allocation of technical personnel and resources
Worked closely with operational customers, other technical and non-technical managers, and those in senior leadership to determine task and resource priorities based on workload, business case, and resource requirements
Attended and facilitated meetings surrounding area readiness, project assessments, change controls, and infrastructure and technology assessments to facilitate the direction of organizational vision and direction
Oversaw training, coaching, and mentoring of all team members in personal growth and development; facilitated annual performance reviews and assessment evaluations
Assessed and approved leave requests along with maintenance of each teams’ on-call rotation Senior Database Analyst / Clarity Administration (10/2013 to 10/2015)
Built and modified Clarity data extractions and loads (ETLs), utilizing Clarity Console to manage ETL processes
Worked alongside business intelligence developers to accommodate requests for new database objects, confirm validations, and troubleshoot performance issues
Installed, migrated, maintained, and supported a variety of database server instances for both production and development infrastructure environments that ranged in size from 50 MB to over 3+TB
Provided senior level database administration for multiple NGHS critical and non-critical applications on a 24/7 basis, including on-call rotation with other members of DBA team
Performed database monitoring, performance tuning including index creation, database maintenance tasks, and other objects within the databases
Assisted in leading the team of ODBA and SQL DBAs to act as an intermediary between DBA team members and other groups as well as upper-level management
Collaborated with other team members and groups in discussions on strategy and creating solutions for infrastructure and capacity planning
Supported architecture, infrastructure, and design of newly acquired Epic EHR servers and database environments to ensure a safe and secure back bone
Utilized multiple tools for predictive analysis of capacity planning and requirements in collaboration with systems architecture team
Provided guidance to other team members concerning strategies and solutions for various database management systems in order to maintain optimal functionality of all production environments BENJAMIN SHELTON
SENIOR DATABASE ADMINISTRATOR AND DATABASE ANALYST 3 of 3
MACY’S SYSTEMS & TECHNOLOGY, JOHNS CREEK, GA
Senior SQL Server Database Analyst (2010 to 2013)
Maintained and supported a variety of database server instances for both production and development databases that ranged in size from 50 MB to over 1TB in size
Managed SQL Servers in both stand-alone and clustered environments for performance tuning and resource utilization in current versions of SQL Server (2005, 2008 R2, and 2012)
Worked with a variety of IFS, divisional, and vendor resources to plan and execute systems infrastructure implementation projects and ensure optimum functionality
Provided technical guidance and played lead role in implementation of stable and high performing databases
Trained other team members on recent technologies to enhance overall skill set and effectiveness of team
Maintained SQL server logins and user accounts, roles, and privileges
Ensured backups were verified through restore processes, as well as developed high availability and disaster recovery plans
Upgraded and installed all SQL patches, service packs, and new releases
Made day-to-day operational and effective strategic decisions to support business and customers
Provided 24/7 coverage via an on-call rotation
OLDCASTLE APG, ATLANTA, GA
Senior SQL Server Database Administrator (2005 to 2010)
Maintained and supported multiple SQL Server instances in a clustered environment for both production and development databases that ranged in size from 25 MB to over 500 GB
Managed benchmarking and scalability statistics for all SQL Servers
Designed, supported, and administered large, high-volume databases to ensure high availability
Managed performance tuning and monitoring to ensure optimum reliability of ERP application
Designed, implemented, and monitored SQL Server replicated environment
Maintained server logins and user accounts, roles, and privileges
Constructed and maintained backup/restore and disaster recovery plans
Upgraded and installed all SQL patches, service packs, and new releases
Provided 24/7 coverage
NORTHROP GRUMMAN - MISSION SYSTEMS, ATLANTA, GA
SQL Server Database Administrator III (2000 to 2005) CREDENTIALS
UNIVERSITY OF WEST GEORGIA, CARROLLTON, GA
BBA in Information Systems – 6/2000 (3.2)
BRENAU UNIVERSITY, GAINESVILLE, GA
MBA in Business Administration – 4/2021 (4.0)
Member of Phi Kappa Phi – Honors Society
Contact this candidate