Database Engineer - SQL Server Advanced Performance Tuning
Portland, OR
Contracted to Full Time
Experienced
The position
Location: Portland, OR & Northampton, MA | Type: (Contract-to-Hire, Hybrid Remote) | Experience Level: Mid to SeniorAre 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.
- 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.
- 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.
Apply now to join our forward-thinking team and embark on a rewarding journey shaping the future of enterprise-level database solutions.
Apply for this position
Required*