SQL DBA Intern

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.

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.

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.

Learning Opportunities

• 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

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