Samantha Rae MacAlpine
Nashville
Summary
Database professional with extensive experience in database management and optimization. Proven ability to enhance system performance and ensure data security. Known for strong collaborative skills and adaptability to evolving project needs, leveraging deep knowledge of SQL, database tuning, and data backup processes.
Overview
6
6
years of professional experience
Work History
Database Administrator
The Martha O’Bryan Center
01.2024 - Current
- Developed automation processes utilizing Flows, Workflows, and field-level formulas.
- Developed and maintained hundreds of reports for use by multiple teams, including client facing roles, executive and leadership strategy, and grant reporting and compliance.
- Performed weekly and monthly data migrations from third party databases to ensure a comprehensive and accurate overview of services delivered.
- Collaborated with service teams to streamline processes, improve internal decision making, and simplify end-user experiences.
- Built and developed architecture for new programs from the ground up, encompassing new Objects and Fields, Flows, Reports, Field level automations, Dashboards, and end-user processes.
- Utilized various third party integrations and apps, including Exponent Case Management, Nonprofit Success Package, Zapier, Mogli, and Jetstream.
- Wrote SOQL queries to quickly find specific information for executive leadership, simplify reporting, and ensure data quality.
- Created and edited various Validation Rules to enforce data integrity.
- Prepared for and implemented system updates from Salesforce and third party developers.
- Planned, developed, and implemented comprehensive overhaul of how clients are organized to enable comprehensive tracking of services across entire households.
- Debugged, diagnosed, and fixed various bugs and system issues to maintain and improve functionality.
- Documented development process for new features and programs
- Documented procedures
- Managed creating, maintaining, and retiring user profiles
- Managed user permissions
- Collaborated with third party consultants on projects beyond the scope of my position
- Devised processes for recording and reporting data metrics
- Collaborated with service providers to cater systems to individual needs
- Kept up to date on latest industry developments and best practices.
- Wrote Apex code to program custom functions
- Trained and onboarded new hires on role specific tasks within the database.
Outreach Worker and Housing Navigator
Open Table Nashville
01.2022 - 01.2023
- Maintained databases of clients for internal and external use
- Provided quantitative and qualitative data and consultation to political advocacy and grant seeking teams
- Collaborated with outreach team and other organizations and entities to produce the best outcomes for our mutual clients
- Worked with other members of the outreach team to provide feedback and advisement for future data management needs
- Tracked supply inventories for distribution
- Provided supervision for a bachelor level intern in a year-long placement
Case Manager
Nashville Launch Pad
Nashville, TN
01.2020 - 01.2022
- Built and maintained database for clients and client interactions
- Designed process automations to streamline delivery and recording of services
- Created automated reports for use in grant seeking, compliance, quarterly reviews, and internal decision-making.
- Ensured data quality via regular update and maintenance cycles
- Developed and implemented overhauls of existing programs to meet the evolving needs of clients
Education
Bachelor of Social Work -
University of Southern Indiana School of Social Work
01-2017
Associate of Applied Science in Human Services - undefined
Ivy Tech Community College of Southern Indiana
01-2012
Skills
- Database administration
- Database management
- Data migration
- Flow Design
- Database design
- Report Building
- End-user training
- Backup and recovery
- App Integration
- Debugging and Troubleshooting
Timeline
Database Administrator
The Martha O’Bryan Center
01.2024 - Current
Outreach Worker and Housing Navigator
Open Table Nashville
01.2022 - 01.2023
Case Manager
Nashville Launch Pad
01.2020 - 01.2022
Associate of Applied Science in Human Services - undefined
Ivy Tech Community College of Southern Indiana
Bachelor of Social Work -
University of Southern Indiana School of Social Work