SQL DBA Intern

Transcard; Chattanooga (TN); On-site; USD 20,664,000 - 30,307,000; Full time

Benefits offered by this job

Paid internship

Job summary

Transcard in Chattanooga, TN is seeking an entry-level SQL Database Administrator Intern to support the Database Administration team. You will gain hands-on exposure to enterprise Microsoft SQL Server environments, focusing on operations, health monitoring, performance basics, and standard SQL tasks under supervision.

Work Monday–Friday during standard business hours as part of a developmental pathway toward a junior DBA role.

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

• Assist in monitoring 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.

Job description

Chattanooga-based Transcard offers comprehensive global payment orchestration solutions for banks, fintechs, and businesses. Our embedded payment solutions enable seamless transactions, collaboration, and data sharing with customers and suppliers worldwide. Features include disbursements, receivables, account-to-account payments, cross-border payments, AI insights, and supply chain financing.

Transcard’s solutions combine multi-rail capabilities, embedded workflows, system of record integration, effortless reconciliation, and bank-grade security to support B2B and B2C payments for businesses of all sizes. Streamline financial operations with digital payments, monitor real-time activity, reduce fraud risk, and improve customer and vendor experience with an all-in-one payment portal.

Transcard offers an internship program in the FinTech industry. Our program is designed to provide you with meaningful projects utilized by the business. You’ll see the direct impact of your contribution and get an inside perspective of your desired field while working alongside some of the best in our industry.

We continually strive to identify qualified individuals for post-graduate opportunities beyond the internship program.

This intern position will operate Monday-Friday during standard business hours. This position is a paid internship, compensation will be based on the qualifications of the applicant.

Our goal is to allow you to gain a better understanding of the day-to-day responsibilities within the Information Technology department while working toward your professional goals as related to your academic coursework.

Location:

Our corporate office is located in Chattanooga, TN.

We prefer our interns to be onsite in Chattanooga, TN. We do offer remote capabilities for qualified individuals. Candidate must reside in the US. We are unable to offer visa sponsorship.

Transcard offers benefits starting the first of the month following the month of hire for our full-time employees (Medical, Dental, & Vision, 401(k) Match!, Paid Time Off, Life-Disability Insurance, and more)

Essential Duties and Responsibilities:

The SQL Database Administrator Intern is an entry-level developmental role supporting the Database Administration team. This internship provides hands‑on exposure to enterprise Microsoft SQL Server environments with a primary focus on database platform operations, system health monitoring, performance fundamentals, and general SQL tasks. Working under the guidance of experienced Database Administrators, the intern will assist with daily operational activities while learning industry best practices related to database operations, availability, reliability, security, performance, and diagnostic workflows. All work is performed under direct supervision and in accordance with established procedures. The internship is designed as a development pathway toward a future Junior Database Administrator position.

• Assist in monitoring 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.

Requirements

• 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.

Preferred Qualifications

• Academic or personal experience with Microsoft SQL Server.
• Experience with SQL Server Management Studio (SSMS) or Azure Portal.
• Exposure to T‑SQL, indexes, stored procedures, or views.
• Familiarity with Windows Server concepts.
• Coursework involving database systems or data management.

Education and/or Certifications:

• Bachelor's degree preferred or equivalent work experience.
• Preferred Computer Science, Software Development, Information Technology, Information Systems.

The above statements are intended to describe the general nature and level of work performed by people assigned to this classification. They are not intended to be a complete list of duties performed.