Senior Database Administrator

Syms Strategic Group, LLC (SSG)
Full_time•Charleston, United States

📍 Job Overview

  • Job Title: Senior Database Administrator
  • Company: Syms Strategic Group, LLC (SSG)
  • Location: Remote (United States)
  • Job Type: Full Time
  • Category: Database Administration
  • Date Posted: June 27, 2025

🚀 Role Summary

  • Lead data modeling and database creation efforts, creating data marts and managing databases in virtual and clustered environments.
  • Oversee database operations and perform SQL Server performance tuning, query optimization, and backup management.
  • Collaborate with cross-functional teams to ensure data consistency and accuracy across the organization.
  • Troubleshoot SQL Server issues and provide technical guidance to junior team members.
  • Maintain expertise in Microsoft SQL Server, SSAS, SSRS, SSIS, XML, ODS, ETL, DWH, and scripting languages such as Shell, PowerShell, and Bash.

💻 Primary Responsibilities

  • 🌟 Lead Database Creation and Management: Lead the database creation and management effort through data modeling and create data marts. Manage all operations consistently with database management.
  • 🔧 Perform SQL Server Administration: Perform and troubleshoot SQL Server Backups, Restore Strategies, Replication, SQL Server Performance Tuning, and Query Optimization.
  • 🔎 Collaborate with Cross-Functional Teams: Work closely with cross-functional teams to ensure data consistency and accuracy across the organization.
  • 🛠 Troubleshoot SQL Server Issues: Troubleshoot SQL Server issues and provide technical guidance to junior team members.
  • 📈 Maintain Technical Expertise: Maintain expertise in Microsoft SQL Server, SSAS, SSRS, SSIS, XML, ODS, ETL, DWH, and scripting languages such as Shell, PowerShell, and Bash.

🎓 Skills & Qualifications

Education: Bachelor's degree or higher in Computer Science, Information Technology, or a related field.

Experience: 8+ years of professional experience in database administration, with a strong focus on Microsoft SQL Server and data modeling.

Required Skills:

  • Expertise in creating data marts and setting up Microsoft SQL Server databases.
  • Proficiency in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
  • Strong knowledge of SQL Server Integration Services (SSIS), XML, Operational Data Store (ODS), Extract, Transform, and Load (ETL), and Data Warehouse (DWH) concepts.
  • Experience with Shell, PowerShell, and Bash scripting.

Preferred Skills: None specified.

📊 Web Portfolio & Project Requirements

  • 📊 Portfolio Essentials: Not applicable for this role.
  • 📊 Technical Documentation: Not applicable for this role.

💵 Compensation & Benefits

Salary Range: $120,000 - $160,000 per year (based on industry standards for senior database administrators with the required experience and skills)

Benefits:

  • Competitive salary and benefits package.
  • Opportunities for professional growth and development.
  • Remote work flexibility with some travel required.
  • W-2 position with full-time employment.

Working Hours: 40 hours per week, with some flexibility for project deadlines and maintenance windows.

🎯 Team & Company Context

🏢 Company Culture

Industry: Information Technology and Services.

Company Size: Medium-sized company with multiple teams and projects.

Founded: 2001 (as Syms Consulting, LLC; rebranded as Syms Strategic Group, LLC in 2015).

Team Structure:

  • Database Administration team, responsible for database creation, management, and maintenance.
  • Cross-functional teams, including software development, data analysis, and project management.

Development Methodology:

  • Agile/Scrum methodologies for software development and project management.
  • Collaborative development processes, including code reviews and pair programming.

Company Website: Syms Strategic Group, LLC

📈 Career & Growth Analysis

Web Technology Career Level: Senior Database Administrator, responsible for leading database creation and management efforts, overseeing database operations, and providing technical guidance to junior team members.

Reporting Structure: Reports directly to the Database Administration Manager or a similar role, depending on the organization's structure.

Technical Impact: Oversees database operations, ensuring data consistency, accuracy, and performance across the organization. Collaborates with cross-functional teams to implement data-driven solutions and improve overall system performance.

Growth Opportunities:

  • Technical leadership roles, such as Database Architecture or Database Engineering.
  • Management roles, such as Database Administration Manager or Database Operations Manager.
  • Specialization in emerging technologies, such as cloud-based database management or big data processing.

🌐 Work Environment

Office Type: Remote work environment with some travel required for on-site client meetings and project deployments.

Office Location(s): Remote work with a primary focus on the United States.

Workspace Context:

  • Remote work environment with access to necessary hardware, software, and network resources.
  • Collaborative workspaces with virtual meeting tools and project management platforms.
  • Opportunities for professional development and training resources.

Work Schedule: Flexible work schedule with core hours and some overlap with team members in different time zones. Availability for project deadlines and maintenance windows as needed.

📄 Application & Technical Interview Process

Interview Process:

  1. Screening: Phone or video call to assess communication skills, technical knowledge, and cultural fit.
  2. Technical Assessment: Hands-on assessment of SQL Server administration, data modeling, and performance tuning skills.
  3. Final Interview: In-depth discussion of technical expertise, problem-solving skills, and career goals.

Portfolio Review Tips: Not applicable for this role.

Technical Challenge Preparation:

  1. SQL Server Administration: Brush up on SQL Server administration, including backup strategies, performance tuning, and query optimization.
  2. Data Modeling: Review data modeling techniques and best practices for creating data marts and managing databases.
  3. Scripting Languages: Familiarize yourself with Shell, PowerShell, and Bash scripting for database management and automation tasks.

ATS Keywords: Database Administration, SQL Server, Data Modeling, Data Marts, SSAS, SSRS, SSIS, XML, ODS, ETL, DWH, Shell, PowerShell, Bash, Remote Work, Senior Database Administrator, Database Management, Data Warehouse, Data Marts, SQL Server Performance Tuning, Query Optimization.

📌 Application Steps

To apply for this Senior Database Administrator position:

  1. Submit your application through the application link.
  2. Prepare for the screening process by reviewing the required skills and experience listed in the job description.
  3. Research the company and its projects to demonstrate your understanding and enthusiasm for the role.
  4. Prepare for the technical assessment by brushing up on your SQL Server administration, data modeling, and performance tuning skills.
  5. Practice problem-solving techniques and be ready to discuss your approach to database management and optimization.

📝 Enhancement Note:

The salary range provided is based on industry standards for senior database administrators with the required experience and skills. However, the actual salary may vary depending on the candidate's qualifications, experience, and negotiation. The benefits package and working hours may also be subject to change based on the company's policies and the candidate's agreement.

Application Requirements

Candidates must have 8+ years of professional experience and expertise in creating data marts and setting up Microsoft SQL Server databases. A bachelor's degree or higher is required, along with U.S. citizenship for this opportunity.