Chris Smith
Columbus
Overview
11
11
years of professional experience
Work History
SQL Server Database Administrator
Ohio Department of Public Safety
Columbus
10.2014 - Current
- Monitored database performance using tools such as SQL Server Profiler and Performance Monitor, identifying and resolving bottlenecks
- Implemented backup and recovery strategies to minimize data loss and protect business continuity
- Managed and maintained multiple SQL databases, working towards optimal performance, security, and availability
- Performed regular database maintenance tasks including index rebuilding, statistics updating, and database integrity checks
- Collaborated with development teams to design efficient database schemas that met application requirements
- Implemented security measures such as user access controls, encryption of sensitive data, and auditing mechanisms to protect against unauthorized access or data breaches
- Upgraded SQL server software versions while minimizing downtime through careful planning and testing procedures
- Developed scripts for automating routine tasks such as backups, restores, monitoring alerts, or generating reports
- Documented standard operating procedures (SOPs) for common administrative tasks to ensure consistency across the team's practices
- Designed disaster recovery plan including regular backups with point-in-time restore capability ensuring RTOs met.
- Migrated legacy databases from older versions of SQL Server to newer versions minimizing security risks while meeting business needs
- Developed disaster recovery plan including regular backups with point-in-time restore capability reducing potential data loss below department accepted losses.
- Worked on multiple data migration projects reducing costs for county and state resources as part of the Innovate Ohio platform.
- Collaborate with City, State, County and Federal Agencies to ensure accurate and timely data exports and imports meeting legislative requirements.
- CJIS security training yearly in addition to regular background checks for managing PII as well as law enforcement data.
- Ensured database compliance with legal and regulatory requirements.
- Provided technical support and training to end-users and junior DBAs.
Education
Master of Science - Master's Degree in Information Systems
Keller Graduate School of Management
Illinois06-2019
Bachelor of Science - Computer Information Systems
DeVry University
Columbus, Ohio06-2015
Skills
- Database performance monitoring
- Backup and recovery
- Database maintenance
- Security management
- Disaster recovery planning
- Data migration
- Writing and verbal communication skills working with business analysts, project managers and division administrators to achieve data related requirements
- Experience with Azure Managed Instances as well as Infrastructure as a Service
- Experience with AWS RDS and Cloudwatch
Affiliations
- Enjoy painting models and miniatures
- Enjoy 3D printing
- Enjoy working on mechanical projects, currently it's a 79 Ford Pickup
- Enjoy being a dad to my 4 year old son
Timeline
SQL Server Database Administrator
Ohio Department of Public Safety
10.2014 - Current
Master of Science - Master's Degree in Information Systems
Keller Graduate School of Management
Bachelor of Science - Computer Information Systems
DeVry University
Quote
Keep Smiling
Scott Smith
References
References available upon request.
Similar Profiles
Taylor RoutteTaylor Routte
BMV Investigations College Intern at Ohio Department Of Public SafetyBMV Investigations College Intern at Ohio Department Of Public Safety
Todd HawkTodd Hawk
Diver Exam Area Supervisor at Ohio Department Of Public SafetyDiver Exam Area Supervisor at Ohio Department Of Public Safety
Phyllis OberPhyllis Ober
Human Capital Management Senior Analyst at State of Ohio, Department of Public SafetyHuman Capital Management Senior Analyst at State of Ohio, Department of Public Safety
Christian WesleyChristian Wesley
Administrative Specialist at US Marines CorpsAdministrative Specialist at US Marines Corps
Kelsey BurklundKelsey Burklund
Bartender at Beer Barrel Pizza and GrillBartender at Beer Barrel Pizza and Grill