Database Architect

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.