Jobs · Engineering · Tennessee

SQL DBA Intern

Transcard · Chattanooga, TN · 2 wk ago
On-siteEngineeringFull-time

Payments, Orchestrated. 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.

About the role

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.

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.

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.

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.

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.

Skills

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

Qualifications

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

Benefits

Transcard offers benefits starting the first of the month following the month of hire for our full-time employees, including:

  • Medical, Dental, & Vision
  • 401(k) Match
  • Paid Time Off
  • Life-Disability Insurance

Similar jobs

Database Developer Intern

Desert Financial Credit UnionPhoenix, AZ· 2 mo ago
Information Technologyapply on jobs.desertfinancial.com