Note: The job is a remote job and is open to candidates in USA. RE Partners is a fast-growing business and technology consulting company that specializes in digital transformation. They are seeking a highly skilled SQL Server Database Optimization Engineer to lead efforts in auditing, analyzing, and optimizing complex database systems, focusing on performance improvement and maintainability.
Responsibilities
- 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
Skills
- 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
- 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
- This position may also be eligible for additional compensation, including bonuses, commissions, and/or benefits, as applicable.
Company Overview