Systems Architect Intern Jobs in Tennessee (NOW HIRING)

Description

Who We Are:

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

Position Details:

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.

Benefits:

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)

Please apply and see more job requisitions at:

https://www.transcard.com/careers

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.

Please do not contact hiring managers directly or attempt to inquire outside of the application portal. Only applications submitted through the official process will be considered.

No resumes from 3rd party vendors will be accepted at this time.