Database Administrator Engineer

RE Partners; New York (NY); On-site; USD 150,000 - 170,000; Full time

Job summary

RE Partners in New York City is seeking a seasoned Database Administrator Engineer to lead auditing, analyzing and optimizing our SQL Server environment. You will tackle millions of procedures, identify bottlenecks, and improve performance, structure and maintainability across complex databases.

The role requires 5+ years of hands-on SQL Server experience, deep knowledge of T-SQL, indexing, and execution plans.

Qualifications

• 5+ years of hands-on SQL Server experience (2016+).
• Proven performance tuning and troubleshooting for locks and bottlenecks.
• Deep knowledge of SQL, T-SQL, indexing strategies, and plans.
• Experience reverse engineering large-scale legacy logic.
• Ability to communicate findings to technical and non-technical stakeholders.

Responsibilities

• Database Analysis & Audit of existing SQL Server environment.
• Identify bottlenecks, locking, and inefficient query patterns.
• Refactor and optimize stored procedures and queries.
• Educate developers on performant SQL and best practices.
• Governance: define standards and change management.

Skills

SQL Server

Performance tuning

T-SQL

Execution plans

Stakeholder communication

Reverse engineering

Tools

SQL Profiler

Extended Events

DMVs

Redgate

Job description

Hello from RE Partners!

Who We Are:

We are a fast growing business and technology consultant company co-founded in 2019. We offer a custom-tailored, white-glove engineering service fit for our clients, because a digital transformation is more than just technology. With a successful track record of being a preferred vendor for Fortune 500 companies and as a trusted partner for some of the industry’s leading companies, our global talent has helped many clients achieve their goals.

The 3 G’s Of RE

• “Get Shit Done.”


• “Get Over Shit.”


• “Give a Shit.”

Join Our Global Team:

We invite you to apply for the position at RE Partners. Join us in shaping the future of business technology consulting and transforming the way organizations thrive in a digital world. As a diverse, woman-owned global business, we pride ourselves on keeping talent happy – our 7% attrition rate speaks volumes. Bring your talented friends along and earn a referral bonus

Equal Opportunity Employer:

We are an equal opportunity employer and welcome applications from all qualified individuals regardless of race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, or veteran status.

Database Administrator Engineer

We are seeking a highly skilled SQL Server Database Optimization Engineer to lead our efforts in auditing, analyzing, and optimizing our complex database systems. Our current SQL Server environment has accumulated significant technical debt—millions of stored procedures, inefficient joins, frequent query locks, and performance bottlenecks. This role is perfect for someone who thrives on solving tough database challenges, understands the intricacies of SQL Server internals, and can work cross-functionally to improve performance, structure, and maintainability.

Key Responsibilities

• Database Analysis & Audit


• Analyze existing SQL Server schema, stored procedures, indexes, and relationships.


• Identify performance bottlenecks, frequent locking/blocking issues, and inefficient query patterns.


• Query Optimization


• Refactor and optimize poorly written SQL queries and stored procedures.


• Educate developers on writing performant SQL and best practices.


• Database Clean-Up & Refactoring


• Rationalize and refactor redundant or obsolete stored procedures and tables.


• Simplify overly complex joins and table relationships.


• Performance Tuning


• Implement and monitor indexing strategies, query plans, and partitioning as needed.


• Use tools like SQL Profiler, Extended Events, and DMVs for diagnostics.


• Governance & Best Practices


• Define and implement database standards and governance procedures.


• Contribute to database documentation and change management protocols.

Qualifications

• 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.

The base salary range for this position is $150,000.00 – $170,000.00 annually. This range represents the good‑faith minimum and maximum salary the Company believes it would pay for this role at the time of this posting.

Actual compensation will be determined based on factors such as experience, skills, qualifications, geographic location, internal equity, and business needs. This position may also be eligible for additional compensation, including bonuses, commissions, and/or benefits, as applicable.