Requirements
-
6 or more years of experience in Microsoft SQL Server database administration and T-SQL development.
-
Proficiency in SQL Server Integration Services (SSIS) packages and automated ETL workflows.
-
Experience with SQL Server Reporting Services (SSRS) and Power BI dashboard creation.
-
Experience in SQL database performance monitoring, index tuning, and maintenance execution.
-
Experience with application backend integration, schema architecture, and stored procedure optimization.
-
Experience in configuring database backups, disaster recovery routines, and user security permissions.
-
Excellent verbal and written communication skills.
Responsibilities
-
Monitor database health, uptime, and performance metrics across production SQL Server instances.
-
Develop, troubleshoot, and maintain ETL data pipelines and transformation packages using SSIS.
-
Build and support operational enterprise reports and interactive visualizations in SSRS and Power BI.
-
Optimize complex T-SQL scripts, views, triggers, and query execution plans for maximum efficiency.
-
Collaborate with application engineering teams to support software deployments and database integrations.
-
Execute routine database administration tasks including patching, disaster recovery testing, and backups.
-
Identify and remediate database bottlenecks, blocking queries, deadlocks, and system errors.
Founded in 1999, Resourcesoft, Inc. is a leading Technology Consulting and Professional Services organization. Headquartered in Marlborough, MA, the company serves the technology needs of its clients nationwide. Resourcesoft has often been recognized by prominent rating agencies for its exemplary growth and stability. With over two decades of industry experience, the Company has evolved as a front runner in enabling project optimization. We partner with leading organizations to provide technology solutions within the financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. We take pride in mentoring a workforce that is well positioned to respond to the emerging IT trends and needs. With the employees at the crux of every business endeavor, our success is driven by our expertise in pairing the right talent with the best jobs in the technology sector. We forge long term, personalized relationships with our employees to advance their career to the next level. We engage them in technology centric client projects that provide opportunities for them to evolve, innovate and deliver world class products and services. Our career opportunities offer challenging assignments and exposure to emerging and cutting edge technologies. We are committed to providing our employees with the tools necessary to accelerate their career progression, while maintaining a healthy, work-life balance. We are deeply committed to providing a workplace ambience that is both challenging and fulfilling.