Michael Grooms
Butler,PA
Summary
Information Technology professional, working primarily with Database Administration and Database Development.
Professional with strong background in managing and optimizing database systems. Proven track record in data security, performance tuning, and disaster recovery. Collaborative team player focused on achieving results and adapting to changing needs. Skilled in SQL, database design, and automation, with reliable and flexible approach to challenges.
Overview
23
23
years of professional experience
Work History
Database Administrator/Developer
ShipMatrix
03.2018 - Current
- SQL 2005/2008/2012/2014/2016/2017 Database Administration, Database Development, Performance Tuning, Query Tuning, Backup and Recovery, Capacity Planning, Creating column store indexes
- Implementing isolation levels to limit locking contention on concurrent transactions
Database/Systems Administrator/Developer
Mitsubishi Electric
07.2020 - 03.2025
- SQL 2012-2022 Database Administration, Database Development, Performance Tuning, Query Tuning, Backup and Recovery, Capacity Monitoring
- Creating column store indexes, supporting Syteline (ERP system)
- Implemented a Data Warehouse
- Utilizing isolation levels to limit locking contention on concurrent transactions
- Manage Security and Permissions, table design and changes, indexes, primary keys, foreign keys
- Creating Stored Procedures
- Index Fragmentation analysis and repair
- Develop job notifications for stored procedures, using database mail to send and receive messages and fix broken/outdated processes as needed
- Perform troubleshooting, manage security access issues, as well as creating ad hoc queries for developers
Database Administrator/Database Developer
Intalere
04.2006 - 10.2018
- SQL 2008/2012/2014 Database Administration, Installation, Performance Tuning, Data Security, Backup and Recovery
- Enhanced Database performance by monitoring SQL Server Profiler, using Query Analyzer to improve Query efficiency
- Ensured technical and functional designs of databases met the business requirements
- Managed Security and Permissions, table design and changes, indexes, primary keys, foreign keys
- Creating Stored Procedures
- Index Fragmentation analysis and repair
- Developed job notifications for SQL Agent jobs, using database mail to send and receive messages
- Created Database Projects, deploy databases using Visual Studio for migrating database changes across Dev/QA/Production environments
- Performed troubleshooting, security access issues and create ad hoc queries to aid developers as needed
- Created Windows groups for SQL users in lieu of Windows domain accounts with SQL Server
- Use SSIS for ETL processing
- Use T-SQL to create Stored Procedures and create scripts for front end developers as well as data flow processing
- Developed a process called Accusave that brought hospital data from upstream systems to insert/update/delete into a normalized environment using SSIS packages and Stored Procedures to run nightly processes via SQL Agent jobs
Data Analyst/Database Administrator
Communifax
11.2001 - 04.2006
- SQL 2000/2005 Database Administration, Installation, Backup/Restore, 24x7 on-call support
- Assess existing SQL databases, identify problems and propose resolutions based on best practices
- Track performance issues related to Indexing, inefficient queries, and SSIS packages
- Prepare and implement solutions
- Reconfigured SQL Backups to improve disk space requirements using Quest LiteSpeed
- Used Primary Keys and Foreign Keys to ensure data integrity across tables with Parent/Child relationships
- Evaluated vendors for purchase of database software and services
- Created scheduled and Ad Hoc reports for data analysis
Education
Bachelor of Science - Management Information Systems
The Pennsylvania State University
Skills
- HP Server Management
- Dell Server Management
- Cisco Router Configuration
- Compaq Server Management
- SQL Database Administration
- Experience with Redgate Tools
- Boomi Platform Experience
- Proficient in SolarWinds DPA
- Exchange
- VMware Administration
- Proficient in Ascential Data Tools
- Experience with Quest Litespeed
- SQL Server Administration
- Bitbucket Version Control Expertise
- Database Management
- PL/SQL Expertise
- T-SQL Query Development
- Data Analysis
- Data Transformation
- SQL Server Integration Services
- IT System Administrator
- Powershell Scripting
- Azure SQL Database Management
Activities And Awards
Dean's List, Spring 1998, Spring 2000, Fall 2000, Spring 2001
Timeline
Database/Systems Administrator/Developer
Mitsubishi Electric
07.2020 - 03.2025
Database Administrator/Developer
ShipMatrix
03.2018 - Current
Database Administrator/Database Developer
Intalere
04.2006 - 10.2018
Data Analyst/Database Administrator
Communifax
11.2001 - 04.2006
Bachelor of Science - Management Information Systems
The Pennsylvania State University
Similar Profiles
Monica AdamsonMonica Adamson
Clinical Assistant/ Surgical Scheduler Coordinator at BHS General SurgeryClinical Assistant/ Surgical Scheduler Coordinator at BHS General Surgery
Amanda McFarlandAmanda McFarland
Corporate Paralegal at Storable, Inc.Corporate Paralegal at Storable, Inc.
Kassidee WaltmanKassidee Waltman
Registered Nurse, Intensive Care Unit at AHN Wexford HospitalRegistered Nurse, Intensive Care Unit at AHN Wexford Hospital
William HarrisonWilliam Harrison
Service Advisor at M&R Power EquipmentService Advisor at M&R Power Equipment
KIBREAB FISEHAKIBREAB FISEHA
Database Administrator/Developer at Federal Aviation Administration (FAA)Database Administrator/Developer at Federal Aviation Administration (FAA)