Database Administrator Engineer

RE Partners

SQL Server Database Optimization Engineer at RE Partners, leading database audit and optimization efforts for complex systems. Engaging in performance tuning and best practices implementation.

Posted 7/23/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $150,000 - $170,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Expertise in SQL Server performance tuning, including optimization of queries and stored procedures, along with the ability to communicate technical findings to diverse stakeholders. Proficient in implementing database standards and governance while utilizing diagnostic tools for effective monitoring.

Highest-signal resume keywords

SQL Server (2016+)Performance TuningT-SQLIndexing StrategiesDatabase Documentation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLStored ProceduresQuery OptimizationExecution PlansDatabase GovernanceData ModelingSchema RedesignReverse EngineeringPerformance DiagnosticsAgile Practices

Soft Skills

CommunicationCollaboration

Tools & Technologies

SQL ProfilerExtended EventsDMVsRedgateSolarWindsSQL Sentry

Industry Keywords

Change ManagementDatabase StandardsCI/CD PracticesLegacy Systems

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Analyze existing SQL Server schema, stored procedures, indexes, and relationships
Identify performance bottlenecks, frequent locking/blocking issues, and inefficient query patterns
Refactor and optimize poorly written SQL queries and stored procedures
Educate developers on writing performant SQL and best practices
Rationalize and refactor redundant or obsolete stored procedures and tables
Simplify overly complex joins and table relationships
Implement and monitor indexing strategies, query plans, and partitioning as needed
Use tools like SQL Profiler, Extended Events, and DMVs for diagnostics
Define and implement database standards and governance procedures
Contribute to database documentation and change management protocols

Requirements

What you’ll need

5+ years of hands-on experience with SQL Server (2016+)
Proven experience in performance tuning and troubleshooting SQL locks, deadlocks, and query bottlenecks
Deep knowledge of SQL, T-SQL, indexing strategies, and execution plans
Experience in reverse engineering large-scale, legacy stored procedure logic
Ability to communicate findings and improvement plans to both technical and non-technical stakeholders
Nice to Have: Experience with data modeling and schema redesign, Familiarity with database monitoring tools (e.g., Redgate, SolarWinds, or SQL Sentry), Understanding of CI/CD practices for database changes, Experience working in an Agile or DevOps environment

Benefits

Comp & perks

Healthcare benefits
Flexible scheduling
Referral bonus for bringing in talented friends