SQL DBA Intern

Summary

Transcard is a Chattanooga-based company that offers comprehensive global payment orchestration solutions for banks, fintechs, and businesses. The SQL Database Administrator Intern role provides hands-on exposure to enterprise Microsoft SQL Server environments, focusing on database platform operations, system health monitoring, and general SQL tasks under the guidance of experienced Database Administrators.

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

Skills

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

Must Haves

• 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

Nice to Haves

• 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

Benefits

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