SQL DB Intern: Hands-On DBA Training & Monitoring

Transcard; Chattanooga (TN); Hybrid; USD 25,000 - 34,000; Full time

Benefits offered by this job

Onsite internship

Remote-capable for qualified

Paid internship

Job summary

Transcard, based in Chattanooga, TN, is offering a paid SQL Database Administrator Intern position within the Information Technology department. The role provides hands-on exposure to enterprise SQL Server environments, learning database operations, performance tuning, backups, and DR concepts under supervision.

Ideal candidates will have foundational SQL knowledge, strong analytical skills, and a desire to learn DBA practices in a real-world setting.

Qualifications

• Fundamental understanding of relational database concepts.
• Introductory knowledge of SQL querying.
• Strong analytical and problem-solving skills.
• Ability to follow documented procedures accurately.
• Strong written and verbal communication skills.
• High attention to detail and organizational skills.
• Demonstrated interest in database administration or infrastructure operations.
• Ability to work both independently and within a team environment.

Responsibilities

• Monitor SQL Server environments for availability and system health.
• Review database monitoring dashboards and alerting tools.
• Validate successful execution of SQL Server Agent jobs.
• Assist in verifying database backup operations.
• Participate in supervised database restore testing in non-production environments.
• Monitor disk utilization, storage growth, CPU usage, and memory trends.
• Support capacity tracking and utilization reporting.
• Assist in maintaining database inventories and environment documentation.
• Review performance metrics and learn to identify potential tuning opportunities.
• Participate in analysis of slow-running queries under DBA guidance.
• Support routine database maintenance and health reviews.
• Assist with security access reviews and documentation.
• Maintain runbooks, operational procedures, and standard documentation.
• Escalate identified issues in accordance with documented processes.
• The intern will not perform independent production changes, deployments, or schema modifications.
• Microsoft SQL Server architecture, internals, and core components.
• T‑SQL fundamentals.
• Indexing concepts and execution plan analysis.
• Query performance troubleshooting techniques.
• SQL Server monitoring and diagnostic tools.
• Backup and recovery strategies.
• Capacity planning fundamentals.
• High availability and disaster recovery concepts (observational).
• Infrastructure, Windows Server, and storage fundamentals.

Skills

Relational DB concepts

SQL querying basics

Analytical problem solving

Procedural compliance

Written and verbal communication

Attention to detail

Interest in DBA/infra

Teamwork & independence

Education

Bachelor's degree preferred or equivalent

CS/IT field degrees preferred

Job description

Transcard, based in Chattanooga, TN, is offering a paid SQL Database Administrator Intern position within the Information Technology department. The role provides hands-on exposure to enterprise SQL Server environments, learning database operations, performance tuning, backups, and DR concepts under supervision.

Ideal candidates will have foundational SQL knowledge, strong analytical skills, and a desire to learn DBA practices in a real-world setting.