TransCore
Join to apply for the
Sr Database Administrator
role at
TransCore Continue with Google Continue with Google Join to apply for the
Sr Database Administrator
role at
TransCore TransCore (TRN), a subsidiary of ST Engineering, is seeking a full-time Sr SQL Database Administrator/Developer join our team in Union, New Jersey or Germantown, Maryland.
About Us:
We are a leading SaaS company built on the Microsoft Technology stack, delivering high-performance applications to our clients. As our business scales, we are undertaking a major database transformation to ensure our systems can process up to 5 million transactions per day, compared to our current capability of 1 million transactions. We are seeking a highly skilled Software Architect with prior experience in redesigning databases to contribute from day one. Our Back Office System is cloud-agnostic and databases are self-hosted on virtual machines (VMs).
Job Summary:
The SQL Database Administrator/Senior Database Developer will be responsible for analyzing, designing, and implementing a scalable and high-performance database solution. The ideal candidate should have extensive experience with SQL Server, performance tuning, and designing scalable database architectures that support microservices-based applications and AI-driven systems.
** Sponsorship is not available for this position **
Essential Duties and Responsibilities
include the following. Other duties may be assigned.
Assess the current SQL Server database architecture and identify areas for improvement in scalability, performance, and maintainability. Design and implement a new high-performance, future-ready database architecture to support a 5M daily transaction load and integration with microservices and AI-driven systems. Develop and implement a comprehensive archival strategy for cold, warm, and hot data storage to efficiently manage a large-scale system of 100TB. Work closely with application developers to ensure database design aligns with the microservices architecture. Optimize database performance by identifying and resolving bottlenecks, indexing strategies, and query tuning. Develop and implement best practices for database design, partitioning, indexing, and data archiving. Ensure high availability and disaster recovery strategies with near-zero RPO and RTO, considering the multi-agency information handled by the system. Collaborate with DevOps teams to automate deployment, backup, and monitoring processes. Implement data security measures and ensure compliance with industry standards. Provide technical guidance and mentorship to the development and operations teams. Stay up-to-date with the latest SQL Server technologies and industry trends. Perform Bulk Insert, import, export from different data sources. Develop scripts to create constraints, defaults, rules, tables, indexes, vies, stored procedures, functions, triggers, cursors and dynamic TSQL queries.
Required Qualifications
Bachelor's or Master's degree in Computer Science, Information Technology, or a related field. 8+ years of experience in SQL Server database design, development, and administration. Proven experience in redesigning and implementing large-scale, high-performance SQL Server databases, with the ability to contribute from day one. Strong understanding of database scalability techniques such as sharding, partitioning, and indexing. Experience in handling large-volume databases (100TB+) and implementing efficient archival strategies. Proficiency in performance tuning, query optimization, and troubleshooting database issues. Experience with self-hosted SQL Server databases on virtual machines (VMs). Hands-on experience with database migration, backup, and recovery processes. Familiarity with data modeling techniques and tools such as ERwin or PowerDesigner. Strong knowledge of T-SQL, stored procedures, and triggers. Experience with microservices architecture and integrating databases within distributed systems. Excellent problem-solving skills and the ability to work in a fast-paced environment. Strong communication and collaboration skills.
Preferred Qualifications
Tolling Experience is strong plus Any relevant SQL Server certification is preferred. Experience with NoSQL databases and hybrid database solutions. Knowledge of AI-driven database optimization and predictive analytics. Knowledge of ETL processes and data warehousing concepts.
What We Offer
Competitive salary and benefits package. Opportunity to work on innovative, high-impact software systems. A collaborative and supportive team environment. Career growth and development opportunities. Health, dental, and vision insurance. The chance to contribute to cutting edge technology stack including GenAI and Agentic AI
TransCore offers competitive compensation and an excellent benefit package that includes medical, dental and vision coverage, flexible savings accounts, 401K, Life and AD&D insurance, a comprehensive Paid Leave program, and a Tuition Reimbursement program.
TransCore is proud to support workforce diversity and is a committed equal opportunity/affirmative action employer. To learn more about TransCore please visit us at www.transcore.com.
All referrals and rsums are managed exclusively through the Human Resources Department. TransCore will not consider unsolicited rsums from vendors including search firms, fee-based referral services and/or recruitment agencies.
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
IT Services and IT Consulting Referrals increase your chances of interviewing at TransCore by 2x Sign in to set job alerts for Senior Database Administrator roles.
Continue with Google Continue with Google Continue with Google Continue with Google Senior Database Administrator (Secret Clearance & 4 days onsite)
Senior Database Administrator - Arlington, VA - Current SECRET and above security clearance applicants only
Database Administrator, Conservative Politics
Vienna, VA $157,000.00 - $190,000.00 1 month ago Database Administrator (OBA) (TS/SCI with Poly)
Database Administrator (OBA) (TS/SCI with Poly)
SQL Database Administrator (Top Secret Clearance Required)
District of Columbia, United States 4 days ago Washington, DC $115,000.00 - $145,000.00 6 days ago Washington, DC $100,000 - $130,000 1 month ago SQL Database Administrator (Top Secret Clearance Required)
Database AdministratorIII and IV (Contingent) - Remote
Falls Church, VA $140,000 - $150,000 3 weeks ago Washington, DC $115,000 - $120,000 5 days ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr
Sr Database Administrator
role at
TransCore Continue with Google Continue with Google Join to apply for the
Sr Database Administrator
role at
TransCore TransCore (TRN), a subsidiary of ST Engineering, is seeking a full-time Sr SQL Database Administrator/Developer join our team in Union, New Jersey or Germantown, Maryland.
About Us:
We are a leading SaaS company built on the Microsoft Technology stack, delivering high-performance applications to our clients. As our business scales, we are undertaking a major database transformation to ensure our systems can process up to 5 million transactions per day, compared to our current capability of 1 million transactions. We are seeking a highly skilled Software Architect with prior experience in redesigning databases to contribute from day one. Our Back Office System is cloud-agnostic and databases are self-hosted on virtual machines (VMs).
Job Summary:
The SQL Database Administrator/Senior Database Developer will be responsible for analyzing, designing, and implementing a scalable and high-performance database solution. The ideal candidate should have extensive experience with SQL Server, performance tuning, and designing scalable database architectures that support microservices-based applications and AI-driven systems.
** Sponsorship is not available for this position **
Essential Duties and Responsibilities
include the following. Other duties may be assigned.
Assess the current SQL Server database architecture and identify areas for improvement in scalability, performance, and maintainability. Design and implement a new high-performance, future-ready database architecture to support a 5M daily transaction load and integration with microservices and AI-driven systems. Develop and implement a comprehensive archival strategy for cold, warm, and hot data storage to efficiently manage a large-scale system of 100TB. Work closely with application developers to ensure database design aligns with the microservices architecture. Optimize database performance by identifying and resolving bottlenecks, indexing strategies, and query tuning. Develop and implement best practices for database design, partitioning, indexing, and data archiving. Ensure high availability and disaster recovery strategies with near-zero RPO and RTO, considering the multi-agency information handled by the system. Collaborate with DevOps teams to automate deployment, backup, and monitoring processes. Implement data security measures and ensure compliance with industry standards. Provide technical guidance and mentorship to the development and operations teams. Stay up-to-date with the latest SQL Server technologies and industry trends. Perform Bulk Insert, import, export from different data sources. Develop scripts to create constraints, defaults, rules, tables, indexes, vies, stored procedures, functions, triggers, cursors and dynamic TSQL queries.
Required Qualifications
Bachelor's or Master's degree in Computer Science, Information Technology, or a related field. 8+ years of experience in SQL Server database design, development, and administration. Proven experience in redesigning and implementing large-scale, high-performance SQL Server databases, with the ability to contribute from day one. Strong understanding of database scalability techniques such as sharding, partitioning, and indexing. Experience in handling large-volume databases (100TB+) and implementing efficient archival strategies. Proficiency in performance tuning, query optimization, and troubleshooting database issues. Experience with self-hosted SQL Server databases on virtual machines (VMs). Hands-on experience with database migration, backup, and recovery processes. Familiarity with data modeling techniques and tools such as ERwin or PowerDesigner. Strong knowledge of T-SQL, stored procedures, and triggers. Experience with microservices architecture and integrating databases within distributed systems. Excellent problem-solving skills and the ability to work in a fast-paced environment. Strong communication and collaboration skills.
Preferred Qualifications
Tolling Experience is strong plus Any relevant SQL Server certification is preferred. Experience with NoSQL databases and hybrid database solutions. Knowledge of AI-driven database optimization and predictive analytics. Knowledge of ETL processes and data warehousing concepts.
What We Offer
Competitive salary and benefits package. Opportunity to work on innovative, high-impact software systems. A collaborative and supportive team environment. Career growth and development opportunities. Health, dental, and vision insurance. The chance to contribute to cutting edge technology stack including GenAI and Agentic AI
TransCore offers competitive compensation and an excellent benefit package that includes medical, dental and vision coverage, flexible savings accounts, 401K, Life and AD&D insurance, a comprehensive Paid Leave program, and a Tuition Reimbursement program.
TransCore is proud to support workforce diversity and is a committed equal opportunity/affirmative action employer. To learn more about TransCore please visit us at www.transcore.com.
All referrals and rsums are managed exclusively through the Human Resources Department. TransCore will not consider unsolicited rsums from vendors including search firms, fee-based referral services and/or recruitment agencies.
Seniority level
Seniority level
Mid-Senior level Employment type
Employment type
Full-time Job function
Job function
Information Technology Industries
IT Services and IT Consulting Referrals increase your chances of interviewing at TransCore by 2x Sign in to set job alerts for Senior Database Administrator roles.
Continue with Google Continue with Google Continue with Google Continue with Google Senior Database Administrator (Secret Clearance & 4 days onsite)
Senior Database Administrator - Arlington, VA - Current SECRET and above security clearance applicants only
Database Administrator, Conservative Politics
Vienna, VA $157,000.00 - $190,000.00 1 month ago Database Administrator (OBA) (TS/SCI with Poly)
Database Administrator (OBA) (TS/SCI with Poly)
SQL Database Administrator (Top Secret Clearance Required)
District of Columbia, United States 4 days ago Washington, DC $115,000.00 - $145,000.00 6 days ago Washington, DC $100,000 - $130,000 1 month ago SQL Database Administrator (Top Secret Clearance Required)
Database AdministratorIII and IV (Contingent) - Remote
Falls Church, VA $140,000 - $150,000 3 weeks ago Washington, DC $115,000 - $120,000 5 days ago Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr