Search jobs > Boston, MA > Sql server developer

SQL Server Developer

Dexian - Signature Consultants
Boston, MA, United States
Full-time

Key Responsibilities :

  • Design, develop, and maintain SQL Server databases, including tables, views, stored procedures, functions, and triggers.
  • Optimize database performance, including query tuning and indexing strategies, to ensure fast and efficient data processing.
  • Collaborate with investment professionals, portfolio managers, and analysts to understand data requirements and implement database solutions.
  • Develop and maintain data integration processes for importing, transforming, and exporting data across multiple systems.
  • Implement and maintain data security protocols in line with industry standards and regulations.
  • Provide support for data-related issues, troubleshooting, and resolution of SQL Server performance bottlenecks.
  • Ensure data accuracy, integrity, and consistency across the investment management systems.
  • Participate in the development of reporting solutions using SSRS, SSIS, or other reporting tools.
  • Stay updated with emerging trends and technologies in SQL Server and database development.

Qualifications :

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • 5+ years of experience as a SQL Server Developer.
  • Proven experience in the investment management industry, with a solid understanding of financial instruments, portfolio management, and investment operations.
  • Strong proficiency in SQL Server (2016 or higher) and T-SQL.
  • Experience with SSIS, SSRS, and ETL processes.
  • Knowledge of database performance tuning, optimization, and best practices.
  • Familiarity with data modeling concepts and experience with relational databases.
  • Experience working with large datasets and complex queries.
  • Knowledge of cloud-based database solutions (Azure SQL, AWS RDS) is a plus.
  • Strong analytical and problem-solving skills.
  • Excellent communication skills with the ability to work closely with both technical and non-technical stakeholders.

Key Responsibilities :

  • Design, develop, and maintain SQL Server databases, including tables, views, stored procedures, functions, and triggers.
  • Optimize database performance, including query tuning and indexing strategies, to ensure fast and efficient data processing.
  • Collaborate with investment professionals, portfolio managers, and analysts to understand data requirements and implement database solutions.
  • Develop and maintain data integration processes for importing, transforming, and exporting data across multiple systems.
  • Implement and maintain data security protocols in line with industry standards and regulations.
  • Provide support for data-related issues, troubleshooting, and resolution of SQL Server performance bottlenecks.
  • Ensure data accuracy, integrity, and consistency across the investment management systems.
  • Participate in the development of reporting solutions using SSRS, SSIS, or other reporting tools.
  • Stay updated with emerging trends and technologies in SQL Server and database development.

Qualifications :

  • Bachelor's degree in Computer Science, Information Systems, or a related field.
  • 5+ years of experience as a SQL Server Developer.
  • Proven experience in the investment management industry, with a solid understanding of financial instruments, portfolio management, and investment operations.
  • Strong proficiency in SQL Server (2016 or higher) and T-SQL.
  • Experience with SSIS, SSRS, and ETL processes.
  • Knowledge of database performance tuning, optimization, and best practices.
  • Familiarity with data modeling concepts and experience with relational databases.
  • Experience working with large datasets and complex queries.
  • Knowledge of cloud-based database solutions (Azure SQL, AWS RDS) is a plus.
  • Strong analytical and problem-solving skills.
  • Excellent communication skills with the ability to work closely with both technical and non-technical stakeholders.

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide.

As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants.

Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit

https : / / dexian.com /

to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.

10 hours ago
Related jobs
Promoted
Dexian - Signature Consultants
Boston, Massachusetts

Strong proficiency in SQL Server (2016 or higher) and T-SQL. Strong proficiency in SQL Server (2016 or higher) and T-SQL. Design, develop, and maintain SQL Server databases, including tables, views, stored procedures, functions, and triggers. Provide support for data-related issues, troubleshooting,...

Dexian - Signature Consultants
Boston, Massachusetts

Strong proficiency in SQL Server (2016 or higher) and T-SQL. Strong proficiency in SQL Server (2016 or higher) and T-SQL. Design, develop, and maintain SQL Server databases, including tables, views, stored procedures, functions, and triggers. Provide support for data-related issues, troubleshooting,...

Promoted
Capital One
Wakefield, Massachusetts

West Creek 6 (12076), United States of America, Richmond, VirginiaSenior Software Engineer - Finance Tech Card Data TransformationDo you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, collaborative, inclusive, and iterative deliv...

Promoted
Bright Horizons Children's Centers
Newton, Massachusetts

Develop software to deliver features and enhancements to applications and systems, and test and correct deficiencies in the software in a controlled environment. Work with members of the software team to execute code, design reviews, and maintain code quality, organization, and automation. Act as a ...

Promoted
BrainWave Professionals
Boston, Massachusetts

Oracle Database Developer/Oracle PLSQL Developer/Database Design/DB2 Database Developer. The ideal candidate should be proficient in designing databases and ensuring their stability, reliability, and performance. Designing and developing database schemas, stored procedures, functions, views and trig...

Promoted
Chief of Staff USA
Saugus, Massachusetts

Exciting Food Service & Hospitality Opportunities in Boston & Cambridge! 🌟.We have immediate openings for .Earn a great wage while doing what you love!.Our digital onboarding process gets you started quickly.Enjoy direct deposit every week.Explore growth opportunities within our team.Don’t miss out—...

Promoted
Buyers Edge Platform, LLC
Waltham, Massachusetts

Our commitment to foodservice excellence is proven in four distinct areas of value: Digital Procurement Network, Fresh Solutions, Supply Chain Management, and Software. ...

Promoted
Capital One Careers
Cambridge, Massachusetts

Senior Software Engineer - Finance Tech Card Data Transformation. As a Capital One Senior Software Engineer in Card Data Transformation, you’ll have the opportunity to be on the forefront of driving a major transformation within Capital One. Share your passion for staying on top of tech trends, expe...

Promoted
Canonical - Jobs
Boston, Massachusetts

Our platform, Ubuntu, is very widely used in breakthrough enterprise initiatives such as public cloud, data science, AI, engineering innovation and IoT. Python and Kubernetes Specialist Engineers focused on Data, AI/ML and Analytics Solutions. As a software engineer on the team, you'll collabora...

Promoted
Flexcompute Inc.
Boston, Massachusetts

Flexcompute is seeking an experienced software developer to contribute to a modern electromagnetism simulation software designed for multi-node CPUs and GPUs. Over time, the strong collaborative nature of this role offers exposure to Flexcompute's sophisticated parallel computing simulation soft...