Database Architect
Experion Developers · Kochi · hybrid · Posted 28d ago
Undisclosed10–20 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
- Expert in database architecture and data engineering, with deep expertise in SQL Server/Azure SQL (T SQL) and large-scale data migration/conversion projects.
- Design, architect, and implement robust ETL/ELT pipelines for converting legacy into cloud-native data model.
- Strong expertise in data mapping, source-to-target transformation logic, and reconciliation frameworks for multi-terabyte dealer datasets.
- Collaborate with cross-functional teams including application architects, business analysts, QA, and clients to define conversion scope and cutover plans.
- Hands-on experience designing and optimizing SQL Server stored procedures, indexes, and partitioning strategies for high-volume OLTP/OLAP workloads.
- Proficiency with ETL tooling such as SSIS, Azure Data Factory, or equivalent, along with scripting (PowerShell/Python) for data validation and automation.
- Deep understanding of data quality, de-duplication, cleansing, and validation techniques for legacy-to cloud migrations.
- Experience with cloud data platforms (Azure SQL, ADF) and hybrid on-prem-to-cloud migration patterns.
- Strong knowledge of data security, PII masking, and compliance considerations during migration, including encryption at rest/in transit and access controls.
- Experience defining rollback, dry-run, and phased/parallel-run cutover strategies to minimize downtime.
- Ability to build and maintain data lineage, mapping documentation, and audit trails for regulatory and client sign-off purposes.
- Strong debugging and performance-tuning skills, with experience resolving bottlenecks in large batch conversion jobs.
- Proficiency in writing unit/integration tests and validation scripts for data reconciliation (row counts, checksums, referential integrity).
- Experience with version-controlled database change management (Flyway, Liquibase, or equivalent) and CI/CD for database deployments.
- Experience presenting conversion readiness, risk, and cutover-plan status to client and internal delivery leadership.
Sourced from naukri
Skills
performance optimizationAzure SQLDatabase ArchitectData MigrationSQL Server
About Experion Developers
Experion Developers
Real Estate
51
employees
2006
20 years old
Gurgaon,Haryana
India
₹12.2L PA avg
Avg at Experion Developers
About
Experion Developers is engaged in real estate, focusing on creating diverse developments across India while emphasizing customer relationships and transparency in transactions.
Industries
Real EstateFinancial Services
Employee ratings
10 reviews
4.5/ 5
Culture
4.6
Career growth
4.5
Work-life
4.9
Employees rate it well for
Work-Life Balance46Company Culture45
Find them on