Source description
About the role
Key Responsibilities:
Legacy Platform Ownership:
-
Maintain, refactor, and optimize T-SQL codebase (queries, stored procedures, functions) across OBMS modules.
-
Perform query tuning, indexing, and performance diagnostics for large/complex databases.
Reporting:
-
Design, develop, and deploy SSRS reports; ensure data accuracy, integrity, and security.
-
Troubleshoot reporting issues; document processes and provide user support for reporting tools.
Stakeholder Engagement:
-
Partner with internal client managers, operations, and finance to capture requirements and convert to technical solutions.
-
Work tickets triaged by lead; manage priorities and communicate status/risks clearly.
Design & Implementation:
- Contribute to database design patterns for new/enhanced modules; support ETL/data integration where applicable.
Governance & Quality:
- Document changes, follow change management, and uphold best practices for legacy environments.
Required Skills
Required Skills:
-
7-10+ years hands-on SQL Server in production environments with heavy stored procedure usage.
-
Demonstrated success in query tuning and performance optimization for large databases.
-
Solid SSRS development lifecycle experience.
-
T-SQL proficiency (queries, stored procedures, functions)
-
Query tuning and performance optimization (indexes, execution plans)
-
Demonstrated success in legacy, stored-procedure-centric systems
-
Pragmatic approach to enhancement vs. rebuild; comfort without modern ORMs
-
Ability to learn nuanced legacy domain quickly
-
Has an independence and consulting mindset
More at 3B Staffing