1st Franklin Financial is seeking a highly skilled Database Administrator to join our team. The ideal candidate will bring a strong expertise in Azure SQL and Snowflake, with hands-on experience in ADF Pipelines, monitoring tools and advanced database performance tuning. This role will be critical in ensuring the reliability, performance, and cost effectiveness of our database and date integration environments.
This position is hybrid and requires four (4) days per week in person in Toccoa, GA or Greenville, SC.
The Mid-Sr. Database Administrator is responsible for managing Azure SQL and Snowflake functions with hands-on experience in ADP Pipelines and advanced database performance tuning. This role works with ADF Pipelines, monitoring tools and advanced database performance tuning to ensure the reliability, performance, and cost-effectiveness of our database and data integration environments.
PRINCIPAL ACCOUNTABILITIES AND KEY ACTIVITIES
Administer, Maintain, and Optimize Database Environments
- Monitor database health and system performance utilizing available tools
- Perform query optimization, indexing strategies, and performance tuning
- Manage and monitor Azure Data Factory (ADF) Pipelines for workflow and data integration
- Proactively monitor and manage Azure cost optimization for database and data services
- Troubleshoot complex database issues and provide timely resolutions
- Ensure database security, compliance, backup, and disaster recovery procedure are followed
- Document database configurations, processes, and performance metrics
Creates an Exceptional Customer Experience
- Collaborate with application developers, BI/Reporting teams, and infrastructure engineers to design scalable and cost-effective solutions
- Troubleshoot complex database issues and provide timely resolutions
EDUCATION, QUALIFICATIONS, AND EXPERIENCE
- High School Diploma or equivalent
- Expert level proficiency in SQL Server database management, performance tuning, and administration
- Hands-on experience with SQL, T-SQL, and advanced database queries for performance tuning and data analysis
- Proficiency in cloud computing platforms and data pipelines
- Hands-on experience with Snowflake data architecture, data modeling, ETL, and data warehouse optimization
- Familiarity with data governance frameworks and tools for data integrity and compliance
- Strong knowledge of database security protocols
- Strong problem-solving skills and analytical thinking
- Ability to work effectively in a hybrid work environment Self-motivated, detail oriented, and capable of managing competing priorities
- Strong communication skills (verbal / written)
- Advanced interpersonal relationship skills at a variety of levels and greatly differing social and business settings
- Demonstrate the ability to analyze relevant information and apply individual judgment
- A valid driver's license with the ability to operate an automobile