On-Prem SQL DBA

Compunnel

$80K — $120K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience with on-prem SQL databases, focusing on upgrades and migrations
  • Expertise in performance troubleshooting, backup management, and detailed system configuration
  • Skilled in T-SQL and PowerShell scripting for database management
  • Capability to analyze and address infrastructure issues spanning networks and storage
  • Proven experience managing large-scale SQL environments, with over 3,000 databases
  • Strong multitasking abilities and adept problem-solving skills
  • Effective communicator with a team-oriented approach

Responsibilities

  • Execute annual upgrades for over 3,000 SQL databases
  • Develop and configure new SQL environments tailored to application needs
  • Install, configure, patch, and maintain SQL Server instances expertly
  • Troubleshoot performance issues and manage backups and configurations effectively
  • Collaborate with application development teams to create and execute migration plans
  • Decommission legacy SQL environments while meeting project timelines
  • Write and adjust scripts in T-SQL and PowerShell for database operations

Benefits

  • Opportunities for professional development and continued education
  • Flexible working environment to adapt to personal productivity needs
  • Access to cutting-edge technology and tools
  • Supportive team culture emphasizing collaboration and communication
  • Comprehensive health and wellness programs
Full Job Description
Job Summary

We are seeking an experienced On-Prem SQL Database Administrator to support SQL database upgrades, performance tuning, and infrastructure management.

The role involves working in a fast-paced environment with a large volume of databases, ensuring legacy systems are decommissioned and new environments are built and maintained efficiently.

Key Responsibilities
  • Perform on-prem to on-prem SQL database upgrades, supporting over 3,000 databases annually.
  • Build and configure new SQL environments based on application team requirements.
  • Install, configure, patch, and maintain SQL Server instances.
  • Conduct performance troubleshooting, backup management, and system configuration.
  • Collaborate with application teams to create run plans and execute migrations.
  • Decommission legacy environments in alignment with project deadlines.
  • Write and execute scripts using T-SQL and PowerShell, making necessary adjustments.
  • Troubleshoot issues that may extend beyond SQL, including network and hardware-related concerns.
  • Monitor system performance and resolve latency or connectivity issues.
  • Manage multiple projects simultaneously in a dynamic and deadline-driven environment.


Required Qualifications
  • Proven experience with on-prem SQL databases, including upgrades and migrations.
  • Strong skills in performance troubleshooting, backups, and configuration.
  • Proficiency in T-SQL and PowerShell scripting.
  • Ability to analyze and resolve issues across infrastructure layers (e.g., network, storage).
  • Experience in managing large-scale SQL environments.
  • Strong problem-solving and multitasking abilities.
  • Excellent communication and collaboration skills.


Preferred Qualifications
  • Experience in enterprise environments with legacy system decommissioning.
  • Familiarity with infrastructure monitoring and diagnostic tools.


Education: Bachelors Degree

Similar Jobs

More Jobs at Compunnel

More Information Technology Jobs

Find similar On-Prem SQL DBA jobs: