Sr. Database Architect

Published: 6/14/2022

Technology

No C2C only on our W2...

Need local resumes who are open for Client In-Person interview.

Domain: Banking Domain experience is MUST.

Role Overview

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.

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