Database Developer, Senior

Hirebridge; New York (NY); Hybrid; USD 134,000 - 166,000; Full time

Job summary

An established industry player is seeking a Senior Database Developer to lead the modernization of data infrastructure. This role involves designing scalable SQL Server databases to replace outdated systems, ensuring data integrity, and enhancing performance. The ideal candidate will collaborate with cross-functional teams to implement robust data structures and optimize queries for high reliability. Join a dynamic environment that values innovation and offers a comprehensive benefits package, while contributing to impactful projects that modernize data systems in the public sector.

Benefits

Health Insurance

Dental Insurance

Vision Insurance

Life Insurance

Disability Insurance

Retirement Plan Contributions

Paid Leave

Professional Development

Lifestyle Benefits

Qualifications

• 7+ years of experience in database development with Microsoft SQL Server.
• Strong understanding of data modeling and performance optimization techniques.

Responsibilities

• Design and implement SQL Server databases to replace legacy DB2 systems.
• Optimize SQL queries and ensure database integrity and compliance.

Skills

SQL Server Development

Data Modeling

Performance Optimization

ETL Operations

Agile Methodologies

Problem-Solving

Education

Bachelor's Degree in Computer Science

Relevant Certifications

Tools

SQL Server Data Tools

SSRS

Power BI

Microsoft Visual Studio

Job description

Job Title:Database Developer, Senior

Onsite Requirement: A couple of days onsite required and travel to different sites.

Job Summary:LCG is seeking a Database Developer, Senior to support an Applications Modernization Project. This position involves designing and building modern, scalable, and secure SQL Server databases to replace legacy DB2 systems. The ideal candidate will play a key role in creating robust data structures, writing optimized queries, ensuring data integrity, and contributing to system integration and performance improvements.

The Database Developer, Senior will collaborate with application developers, system architects, business analysts, and client stakeholders to modernize the data infrastructure for both the Applicant and Administrator applications used in the client programs.

Key Responsibilities

• Design, develop, and implement SQL Server databases to replace existing DB2-based structures.
• Create scalable database schemas to support modern web-based .NET applications across devices and browsers.
• Write, test, and optimize SQL queries, stored procedures, triggers, and functions for high performance and reliability.
• Perform ETL operations to migrate and transform legacy data into the new SQL database structures.
• Ensure database integrity, security, and compliance with DOE’s data protection standards.
• Conduct database performance tuning, indexing, and optimization activities to support peak hiring periods.
• Implement and manage data backup, disaster recovery, and auditing strategies.
• Support integration of the new database system with existing DOE systems (e.g., Payroll, Collections).
• Collaborate with the DevOps team to implement continuous integration and deployment (CI/CD) practices for data layers.
• Participate in reporting requirements, creating both ad hoc and standardized reports using SQL Server Reporting Services (SSRS) and Power BI.
• Maintain detailed documentation for database design, procedures, and configurations.

Qualifications

• A minimum of 7+ years of experience in database development, with a strong focus on Microsoft SQL Server (2014/2016/2019).
• Proficient in SQL Server Data Tools, SSRS, and Power BI.
• Strong understanding of data modeling, relational databases, and performance optimization techniques.
• Experience migrating from legacy systems (DB2) to SQL Server in a large-scale public sector or enterprise environment.
• Demonstrated ability to work in Agile or hybrid Agile environments, collaborating with cross-functional teams.
• Knowledge of security best practices and data privacy standards in public sector environments.
• Excellent problem-solving skills and the ability to manage multiple priorities in a fast-paced environment.
• Experience with Microsoft Visual Studio for database development and integration with application layers.
• Familiarity with .NET-based web applications and integration considerations.
• Experience working on government or education sector modernization projects.
• Understanding of CI/CD pipelines and DevOps practices as applied to database deployment.

Compensation and Benefits

The projected compensation range for this position is $134,400 to $165,300 per year benchmarked in the New York area. The target salary is $150,100 for this role. The salary range provided is a good faith estimate representative of all experience levels. Salary at LCG is determined by various factors, including but not limited to role, location, the combination of education/training, knowledge, skills, competencies, certifications, and work experience.

LCG offers a competitive, comprehensive benefits package which includes health insurance options (medical, dental, vision), life and disability insurance, retirement plan contributions, as well as paid leave, federal holidays, professional development, and lifestyle benefits.

Devoted to Fair and Inclusive Practices

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law.

If you are interested in applying for employment with LCG and need special assistance or an accommodation to apply for a posted position, contact our Human Resources department by email at [e-mail].

Securing Your Data

Beware of fraudulent job offers using LCG's name. LCG will never request payment-related details or advancement of money during the application process. Legitimate communication will only come from lcginc.com or [e-mail] emails, not free commercial services like Gmail or WhatsApp. If you receive suspicious emails asking for payment or personal information, contact us immediately at [e-mail].

If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.