Lead Database Developer - SQL / ETL / Azure Migrations

Amtex Enterprises - Trenton, NJ

Full-time - Senior

Trenton, NJ

Professional, Scientific, and Technical Services

About the position

The Lead Database Developer will be responsible for maintaining, enhancing, designing, and administering data dictionaries, overseeing both physical and logical database models. This role requires strong expertise in ETL processes and migrations, particularly with MS SQL Server, as well as familiarity with Oracle databases and cloud platforms like Azure. The developer will design and develop secure data lake systems and ensure the migration of data from on-premises to cloud environments, while collaborating with various teams to build scalable and secure systems.

Responsibilities

• Maintain, enhance, design, and administer data dictionaries
• Oversee physical and logical database models
• Design and develop secure data lake systems
• Migrate data on MS SQL platforms
• Interpret Oracle scripts
• Build scalable and secure systems
• Work with disparate teams such as infrastructure, DBAs, cybersecurity, and outside agencies like SSA

Requirements

• 7 years of experience with SQL Server 2016 and above
• 7 years of experience with T-SQL and Stored Procedures
• 7 years of DB Troubleshooting, performance, and tuning experience
• Strong experience with ETL and migrations, predominantly with MS SQL Server
• Some background in Oracle
• Familiarity with cloud platforms, particularly Azure
• Strong scripting skills
• Understanding of legacy architecture, system dependencies, and data relationships
• Excellent communication skills, both written and spoken
• 7 years of team management experience

Nice-to-haves

• Experience with Oracle Database design