Database Architect

Database Architect

Location NYC 3 days/week onsite

Long Term Contract

We are seeking an experienced Senior Database Developer / Technical Lead with 12 15 years of hands-on expertise in ETL development, SQL Server, Python, and Linux. The ideal candidate will play a key leadership role in designing, developing, and optimizing data solutions while working closely with cross-functional teams across onshore and offshore environments. This individual must be self-driven, highly analytical, and capable of driving end-to-end technical solutions.

Key Responsibilities

Lead and deliver end-to-end ETL development using SQL Server, Python, and Linux-based components.

Architect, design, and optimize database systems, ensuring scalability, performance, and reliability.

Develop T-SQL queries, stored procedures, functions, and database structures following best practices.

Work extensively in Unix/Linux environments, including shell scripting for automation and system tasks.

Drive Python-based scripting, automation, and integration workflows.

Collaborate with analysts, SMEs, and business partners to understand requirements and translate them into technical solutions.

Act as a technical lead for onshore-offshore teams, ensuring smooth coordination and high-quality deliverables.

Troubleshoot complex data and performance issues; identify root causes and implement effective solutions.

Maintain and enhance technical documentation, coding standards, and design guidelines.

Ensure adherence to organizational best practices, data governance, and compliance requirements.

Required Skills & Experience

12 15 years of experience in ETL development with a strong focus on SQL Server, Python, and Linux.

Deep expertise in Microsoft SQL Server (MSSQL), including:

T-SQL

Stored procedures

Data modeling & architecture patterns

Performance tuning and optimization

Strong understanding of Unix/Linux environments and shell scripting.

Hands-on experience with Python for scripting, automation, and data integration tasks.

Ability to work independently and collaboratively in fast-paced environments.

Strong analytical and problem-solving skills with a proven ability to resolve complex technical issues.

Excellent verbal and written communication skills for engaging with technical and non-technical stakeholders.

Prior experience working in engineering roles focused on database and data integration.

Proven experience with onshore-offshore coordination.

Experience in preparing and maintaining technical documentation.

Nice-to-Have Skills

Familiarity with AWS services and cloud technologies (e.g., EC2, RDS, Lambda, S3).

Exposure to modern data pipelines, orchestration tools, or CI/CD practices.

Personal Attributes

Self-motivated and proactive.

Strong sense of ownership and accountability.

Ability to multitask and manage priorities effectively.

Excellent interpersonal and leadership skills.

Good behavior.