Senior Database Developer

Pyramid Consulting, Inc; Village of Nyack (NY); Hybrid; USD 110,000 - 140,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Paid sick leave

Job summary

Pyramid Consulting, Inc is seeking a Senior Database Developer for a 12+ months contract in New York, NY. The role is hybrid and requires strong T-SQL/ETL skills and SQL Server development expertise.

You will translate business needs into technical specs, design scalable database solutions, and collaborate across time zones to deliver production-ready changes. Experience with Informatica and AI-assisted tools is a plus.

Qualifications

• 6–8 years of experience with T-SQL and Informatica ETL.
• Strong SQL Server development and data modeling skills.
• Experience with enterprise batch processing, scheduling, and file-based feeds.
• Excellent communication across time zones and SDLC discipline.
• Experience with Agile Scrum and Jira.
• Bachelor's degree in Computer Science or related field; master's a plus.

Responsibilities

• Translate business needs into clear technical specs.
• Develop scalable T-SQL procedures and database components.
• Adhere to enterprise development standards in a process-driven environment.
• Collaborate with business, QA, infra, and applications teams for controlled changes and production support.
• Centralize and streamline production requests.
• Improve data access, performance, and maintainability through database design.
• Support batch workflows across ingestion, validation, reconciliation, monitoring, and downstream delivery.
• Leverage AI-assisted tools to boost productivity and quality.

Skills

T-SQL

Informatica ETL

SQL Server development

Data modeling

Agile Scrum

AI-assisted tools

Communication skills

Education

Bachelor's degree in Computer Science / Information Systems / Business Administration

Master's degree or MBA is a plus

Tools

Informatica

GitHub Copilot

Claude

Job description

Immediate need for a talented Senior Database Developer . This is a 12+months contract opportunity with long‑term potential and is located in New York, NY (Hybrid).

Job ID:26-26357

Pay Rate: $60/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

• Translating business needs into clear technical specifications
• Developing scalable T‑SQL stored procedures and database components
• Working in a process‑oriented delivery model and adhering to enterprise development standards
• Partnering with business, QA, infrastructure, and application teams to deliver controlled changes and production support
• Centralizing and streamlining production requests
• Working on database design to improve data access, performance, and maintainability
• Supporting batch workflows across ingestion, validation, reconciliation, monitoring, exception management, and downstream delivery
• Leveraging approved AI‑assisted engineering tools, including GitHub Copilot and Claude, to improve productivity, analysis, documentation, and delivery quality

Key Requirements and Technology Experience:

• 6–8 years of experience developing batch processes using T‑SQL and ETL tools such as Informatica
• Strong SQL Server development experience, including stored procedures and database components
• Strong database design and data‑modeling skills
• Hands‑on experience with Informatica and enterprise ETL processes
• Experience supporting enterprise batch processing, including scheduling, dependencies, file‑based feeds, exception handling, reconciliation, and production support
• Strong data analysis and data quality assessment capabilities
• Excellent verbal and written communication skills with the ability to collaborate across time zones
• Strong SDLC discipline with a track record of improving operational efficiency
• Experience delivering in Agile Scrum models, including planning, backlog refinement, estimation, stand‑Client, reviews, retrospectives, and Jira execution
• Practical experience using AI‑assisted engineering tools such as GitHub Copilot and Claude for development, troubleshooting, unit‑test support, documentation, and productivity improvement
• Ability to follow change management practices that support consistent, maintainable release.
• Bachelor’s degree in computer science, Information Systems, Business Administration, or related field.
• Master's degree or MBA is a plus.

Our client is a leading IT Industry, and we are currently interviewing to fill this and other similar contract positions.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.