Database Architect

Title: Database Architect

Location NYC 3 days/week onsite

Note: Candidate needs to have exceptional T SQL skills Banking experience and local to NY/NJ

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.