Database Engineer

South College of Tennessee, LLC
Knoxville, TN, United States
about 1 month ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Query Performance Amazon Web Services Microsoft Azure Big Data Cloud Computing Information Systems Databases Learning Management Systems Data Architecture Data Validation Information Engineering Data Integration
+29 more
Data Integrity Extract Transform Load (ETL) Data Security Data Systems Data Visualization Data Warehousing Relational Databases Apache Hadoop Python (Programming Language) PostgreSQL Microsoft SQL Server MySQL NoSQL Operational Databases Oracle (Applications) Performance Tuning Systems Development Life Cycle Power BI SQL Databases Tableau (Software) Data Processing Google Cloud Apache Spark Indexer Information Technology Statistics Packages Apache Kafka Data Management Data Pipelines

Job description

At South College, we are committed to providing a high-quality education that prepares students for success in their careers. As a data engineer on our team, you’ll play a key role in helping us harness the power of data to improve student outcomes, optimize operations, and drive innovation. You’ll have the opportunity to work in a dynamic and collaborative environment while continuing to grow and advance in your career. The Database Engineer (DBA) is responsible for the design, implementation, security, maintenance, and performance optimization of the college’s databases and related systems. This role supports administrative, academic, and student-facing systems by ensuring data integrity, availability, and security. The DBA will collaborate with IT staff, institutional research, and various campus departments to ensure that data systems effectively support institutional goals and compliance requirements., Data Warehouse Management & Architecture

  • Design, build, and maintain the college’s data warehouse (schemas, dimensions, fact tables) to support institutional reporting and analytics.
  • Develop and manage ETL/ELT pipelines to consolidate data from source systems into the warehouse.
  • Install, configure, and maintain database management systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL) supporting the warehouse and operational databases.

Query Performance Tuning & Optimization

  • Analyze query execution plans and implement indexing, partitioning, and query rewrite strategies to resolve bottlenecks.
  • Tune database and warehouse performance to support high-volume reporting and analytics workloads.
  • Establish performance benchmarks and monitoring to detect and address degradation proactively.

Data Security & Integrity

  • Implement and maintain security protocols safeguarding student, employee, and institutional data per FERPA and other regulations.
  • Manage access controls and monitor database/warehouse activity for unauthorized use.
  • Ensure compliance with institutional policies and accreditation requirements.

Data Integration & Reporting

  • Support integrations between the SIS, LMS, CRM, and other applications, feeding the MDM framework and data warehouse.
  • Maintain documentation for warehouse architecture, MDM processes, and database procedures.
  • Partner with BI/reporting teams to ensure the warehouse supports dashboards and institutional research needs.

System Development & Collaboration

  • Work with developers and vendors to optimize database-driven applications and warehouse performance.
  • Participate in system upgrades, migrations, and new software implementations affecting the warehouse and MDM.
  • Automate data quality checks, ETL jobs, and MDM matching routines.

Requirements

  • Bachelor’s degree in computer science, Information Systems, Statistics, or a related field., * 3-5 years’ experience as a Database Engineer, Data Architect, or similar role, with hands-on experience in designing and implementing data solutions.
  • Proficiency in programming languages such as Python, SQL, or Scala, with experience in data manipulation, transformation, and analysis.
  • Strong understanding of database systems, data modeling, and ETL principles, with experience in relational databases (e.g., MS SQL Server, MySQL) and NoSQL databases
  • Experience working with cloud platforms and services (e.g., AWS, Azure, Google Cloud) and big data technologies (e.g., Hadoop, Spark, Kafka).
  • Familiarity with data visualization tools and BI platforms (e.g., Tableau, Power BI) and statistical analysis tools (e.g., R, Python libraries).
  • Excellent problem-solving skills, attention to detail, and ability to manage complex data engineering projects.
  • Effective communication and interpersonal skills, with the ability to collaborate with diverse stakeholders.

Preferred

  • Experience in the education sector or knowledge of academic systems and processes is a plus

Benefits & conditions

Pulled from the full job description

  • Tuition reimbursement
  • 401(k)
  • Health insurance
  • Paid time off
  • Vision insurance
  • Dental insurance, * Front Loaded PTO
  • Tuition Assistance
  • Medical, Dental, Vision
  • 401(k) - with Employer Contribution

South College - We are one of the nation’s fastest growing institutions of higher learning … come grow your career with us. In order to fully meet our Mission to our students, we require a diverse combination of perspectives, backgrounds, life experiences, and ideas from our faculty and staff and will provide them with an equitable and inclusive work environment -where respect and open interchange of ideas are at the heart of that culture.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

2:37 min

Comparing traditional SQL tables versus NoSQL non-tabular databases

Stanimira Vlaeva · JS Congress

2:36 min

Analyzing limitations with PostgreSQL bitmap heap scans

Dharin Shah Dharin Shah · WWC 2025

3:09 min

Balancing data science skillings alongside systems engineering rigor

Nico Schmidt · LIVE

1:48 min

Analyzing network packets with database protocol tools

Daniël van Eeden Daniël van Eeden · WWC Europe 2026

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

Videos

See all

Related articles

See all