Database Engineer II - Onsite

Overview

Are you a skilled Database Engineer looking for an opportunity to make an impact? Join our team as a Database Engineer II and take on the challenge of designing, optimizing, and maintaining cutting-edge data systems! Reporting to the Director of Data Services, you'll lead the charge in optimizing ETL/ELT pipelines, ensuring data integrity, and mentoring junior engineers. Collaborating across teams, you'll work with cloud technologies like AWS, Snowflake, and Azure SQL, while automating deployments and supporting high-availability solutions. This is your chance to drive innovation, optimize performance, and shape the future of data systems at scale. Ready to lead the way?

 

**This position will work on-site at our headquarters in Franklin, TN.**

 

Here's some of what you will be doing:

• Responsible for designing, optimizing, and maintaining data pipelines to support efficient data extraction, transformation, and loading (ETL/ELT) processes. Ensure data integrity, quality, and reliability through validation techniques and best practices.
• Collaborate with software engineers and data teams to enhance data models and streamline data flow between applications.
• Refine existing data pipelines by improving query efficiency, indexing strategies, and automating repetitive tasks to reduce processing times and optimize resource utilization.
• Follow established standards for data flow, storage, and integration under close supervision, including best practices for using programming languages like Python and R in data engineering workflows. Actively seek mentorship and training to strengthen foundational data engineering skills.
• Proactively monitors database and data pipeline performance, identifying and addressing inefficiencies, query bottlenecks, and latency issues. Use advanced diagnostic tools to analyze execution plans, optimize SQL queries, and ensure high database availability.
• Troubleshoot complex connectivity, replication, and system performance issues, working closely with infrastructure and DevOps teams to maintain database health and stability.
• Enforce database security best practices by managing user roles, permissions, and encryption protocols to protect sensitive data.
• Plays a key role in ensuring compliance with security policies, audits, and regulatory requirements. Maintain and improve backup and disaster recovery strategies, regularly testing recovery procedures to minimize downtime and data loss in the event of system failures. Includes supporting high-availability (HA) and disaster recovery (DR) solutions across on-premises and cloud environments.
• Extract and analyze data to support business intelligence, generating reports that provide meaningful insights into system performance, data quality, and trends.
• Work with stakeholders to develop efficient reporting solutions that align with business needs, ensuring accuracy and clarity. Using SQL and scripting languages, automate reporting processes and build scalable data visualization tools that improve accessibility and decision-making across teams.
• Maintain comprehensive documentation for database configurations, optimization strategies, and troubleshooting procedures. They ensure that data pipelines, security protocols, and system performance tuning efforts are well-documented for both technical and non-technical stakeholders. Additionally, they contribute to team discussions, project meetings, and cross-functional collaborations by clearly articulating database-related issues and recommendations.
• Automate database maintenance, monitoring, and administrative tasks to improve efficiency and reduce manual workload. They develop and refine scripts using SQL, Python, PowerShell, or similar technologies to streamline database operations.
• Evaluate emerging database technologies and automation tools, recommending and implementing improvements to enhance system scalability and performance.
• Stay current with industry trends, best practices, and new technologies in database engineering, cloud computing, and data security. Apply this knowledge to optimize database structures, ETL processes, and security measures. Participate in knowledge-sharing sessions, mentoring junior team members, and refining internal procedures to align with industry standards.
• Ensure alignment with project objectives by delivering high-quality database solutions that meet performance, security, and business requirements. Proactively track their progress on assigned tasks, meet deadlines, and collaborate effectively with other teams. Additionally, seek professional development opportunities, including certifications, technical training, and mentorship, to expand their expertise in database engineering and architecture.

Here's some expe