Senior Database Architect

Senior Database Architect
New York NY (Need Onsite day 1 hybrid 3 days from office).
Position type: W2 contract

Job Description:

We are seeking an experienced Database Architect 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.

• 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.

• 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.

• Familiarity with AWS services and cloud technologies (e.g. EC2 RDS Lambda S3).
• Exposure to modern data pipelines orchestration tools or CI/CD practices.