Database Engineer - SQL Server Advanced Performance Tuning

Northampton, MA
Contracted to Full Time
Experienced

The position

Location: Portland, OR & Northampton, MA | Type: (Contract-to-Hire, Hybrid Remote) | Experience Level: Mid to Senior
Are you ready to push SQL Server 2022 to its limits on massive, complex, and highly integrated databases? Join our forward-thinking team as a SQL Server Development & Advanced Database Performance Engineer, where you’ll design, optimize, and maintain critical data solutions that power enterprise-scale applications. This role begins as a contract position with the potential to transition to full-time, offering a hybrid remote work arrangement.

What You’ll Do
  • Architect & Develop: Design, implement, and maintain advanced T-SQL queries, stored procedures, functions, and other database objects in SQL Server 2022.
  • Optimize & Tune: Collaborate with cross-functional teams to analyze performance bottlenecks and deploy best-in-class optimization strategies (indexing, partitioning, query plan analysis, etc.).
  • Advanced Feature Utilization: Leverage the full set of SQL Server capabilities (e.g., in-memory tables, columnstore indexes, advanced replication, and more) to drive efficiency and robustness.
  • Monitoring & Troubleshooting: Implement performance monitoring solutions, analyze real-world workloads, and rapidly resolve issues to uphold strict SLAs and uptime requirements.
  • Documentation & Standards: Maintain best practices, create technical documentation, and promote coding standards for continuous improvement and knowledge sharing.

What We’re Looking For
  • Extensive SQL Server Expertise: Proven hands-on experience in SQL Server 2016+ (SQL Server 2022 strongly preferred) with a deep understanding of T-SQL, stored procedures, triggers, functions, and advanced query optimization.
  • Real-World Tuning Experience: Track record of tackling complex performance issues in production environments, using tools like SQL Profiler, Extended Events, and Performance Monitor.
  • In-Depth Knowledge: Familiarity with indexing strategies, partitioning, query plan analysis, memory-optimized tables, advanced replication, and various backup/recovery models.
  • Problem-Solving Mindset: Ability to dissect and resolve database challenges in high-traffic, high-volume data ecosystems.
  • Team Player: Strong collaboration and communication skills, capable of working with cross-functional teams and presenting complex concepts in an understandable manner.

Why Join Us?
  • Cutting-Edge Projects: Work on truly enormous, mission-critical databases that will keep your problem-solving skills sharp and your days exciting.
  • Growth & Development: Access to continuous learning opportunities, training, and certifications to help you stay on top of emerging database technologies and trends.
  • Hybrid Work Environment: Enjoy the balance of remote work flexibility with on-site collaboration to drive innovation alongside a talented and passionate team.
  • Contract-to-Hire Path: Showcase your expertise, expand your professional network, and pave your way to a full-time position with competitive compensation and benefits.
If you’re ready to push SQL Server 2022 to its limits, tackle massive databases, and elevate performance to new heights, we want to hear from you!
Apply now to join our forward-thinking team and embark on a rewarding journey shaping the future of enterprise-level database solutions.
 
Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Human Check*