Job Description
Requirements
- 5 or more years of experience in SQL Server database engineering and enterprise data architecture.
- Proficiency in advanced T-SQL programming, stored procedures, indexing, and complex query optimization.
- Experience with designing robust ETL data pipelines utilizing SSIS to support enterprise data warehousing.
- Experience in CI/CD deployment automation and version control utilizing tools such as Jenkins and Git.
- Experience with the Microsoft .NET technology stack, Visual Studio IDEs, and LAMP stack environments.
- Experience in healthcare IT data standards, PBM/PPO integrations, and agile tracking utilizing Jira.
- Excellent verbal and written communication skills to collaborate effectively with cross-functional stakeholders.
Responsibilities
- Architect and scale complex SQL Server database schemas to support mission-critical enterprise healthcare systems.
- Engineer advanced T-SQL programmatic solutions, triggers, and robust indexing strategies to maximize data throughput.
- Execute rigorous query profiling, execution plan analysis, and database refactoring to eliminate system latency.
- Build and automate scalable ETL pipelines via SSIS to seamlessly ingest and transform high-volume data payloads.
- Integrate database deployment workflows and rollback strategies into continuous integration and delivery pipelines.
- Monitor live production environments and resolve overnight automated job failures to ensure continuous data continuity.
- Mentor junior developers through comprehensive peer code reviews and establish strict database engineering standards.
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.
Resourcesoft is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
For more information about Resourcesoft and our services, please visit our website.
Numbers & Facts
| Location | NULL, MA (Remote) |
| Industry | Computer/IT Services |
| Company Size | 100 to 499 employees |
| Year Founded | 1999 |
| Website | http://resourcesoft.com/ |
Want to know if you’re a fit?
Upload your resume and let our AI show you.
Upload your resume and let our AI show you.
Skills
- Analysis Skillsunmatched
- Atlassian JIRAunmatched
- Automationunmatched
- Biotech and Pharmaceuticalunmatched
- Code Reviewsunmatched
- Communication Skillsunmatched
- Consultingunmatched
- Continuous Deployment/Deliveryunmatched
- Continuous Integrationunmatched
- Cross-Functionalunmatched
- Data Managementunmatched
- Data Warehousingunmatched
- Database Extract Transform and Load (ETL)unmatched
- Database Programmingunmatched
- Database Technologyunmatched
- Employee Relationsunmatched
- Enterprise Architectureunmatched
- Gitunmatched
- Governmentunmatched
- Health Information Technologyunmatched
- Healthcareunmatched
- Insuranceunmatched
- Jenkinsunmatched
- Leading Edge Technologyunmatched
- Mentoringunmatched
- Microsoft SQL Serverunmatched
- Microsoft Transact-SQL (T-SQL)unmatched
- Preferred Provider Organization (PPO)unmatched
- Presentation/Verbal Skillsunmatched
- Production Controlunmatched
- Production Systemsunmatched
- Professional Servicesunmatched
- Query Optimizationunmatched
- Refactoringunmatched
- SQL (Structured Query Language)unmatched
- SQL Databasesunmatched
- SQL Server Integration Services (SSIS)unmatched
- Source Code/Configuration Management (SCM)unmatched
- Stored Proceduresunmatched
- Team Playerunmatched
- Trend Analysisunmatched
- Writing Skillsunmatched
About Company
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. Resourcesoft partners with leading organizations to provide technology solutions within financial, insurance, education, government, publishing, healthcare and pharmaceutical domains. 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. We are committed to providing our employees with the tools necessary to accelerate their career growth, while maintaining a healthy,work-lifebalance.
Mission: Our mantra is “Innovation in Technology”. We want to be the link between technology and the people who define it. Our mission is to consistently provide exceptional service and industry expertise to meet the diverse business needs of our clients. Resourcesoft’s responsibility towards job seekers is to align their skills to the right job opportunity and enable excellence at the workplace.
Inspiring People for Greater Performance
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesFree resume builder
Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder