Senior SQL Server Developer

Dew Softech - Trenton, NJ

Full-time - Senior

Trenton, NJ

Professional, Scientific, and Technical Services

About the position

The Senior SQL Server Developer will be responsible for maintaining, enhancing, designing, and administering data dictionaries and database models. This hybrid position requires strong expertise in SQL Server and Oracle, with a focus on developing secure data lake systems and managing data migrations. The role involves collaboration with various teams to ensure effective data management and system integration.

Responsibilities

• Maintain, enhance, design, and administer data dictionaries and database models.
• Collaborate with different teams to understand and assimilate data.
• Design and develop secure data lake systems.
• Migrate data on MS SQL platforms and interpret Oracle scripts.
• Build scalable and secure systems.

Requirements

• Strong experience with ETL and migrations, predominantly with MS SQL Server, with some Oracle background.
• Familiarity with cloud platforms, particularly Azure and data migration from on-prem to cloud.
• Very strong scripting skills necessary.
• Understanding of legacy architecture, system dependencies, and data relationships.
• Ability to work with disparate teams including infrastructure, DBAs, cybersecurity, and outside agencies.
• Excellent communication skills, both written and spoken.
• 7 years of team management experience.
• 7 years of experience with SQL Server 2016 and above.
• 7 years of T-SQL and Stored Procedures experience.
• 7 years of DB troubleshooting, performance, and tuning experience.
• Experience with Oracle Database design.