Database Modernization Specialist
AscendionPune, Republic Of India, IN3 hours ago
Job descriptionRedesign database schema by applying normalization principles (1NF through BCNF) to eliminate redundancy and improve data integrity Create optimized conceptual, logical, and physical data models for the target state architecture Design migration paths that maintain referential integrity and business rule enforcement Identify opportunities for strategic denormalization where justified by performance requirements Develop comprehensive migration strategies with minimal or zero downtime requirements Design data transformation logic to migrate from denormalized to normalized structures Create phased migration approaches using patterns such as strangler fig, dual-write, or shadow databases Implement data validation and reconciliation frameworks to ensure migration accuracy Develop rollback strategies and contingency plans for migration phases Coordinate database deployment using CI / CD pipelines and migration tools Benchmark existing system performance to establish baselines Optimize new schema design through indexing strategies, partitioning, and query optimization Conduct load testing and performance validation pre and post-migration Fine-tune database configuration, connection pooling, and caching strategies for AWS Aurora PostgreSQL Ensure normalized design meets or exceeds current performance benchmarks Ensure redesigned data model maintains compliance with relevant standards (GDPR, HIPAA, FERPA for EdTech) Implement data governance policies, access controls, and security measures in new architecture Define and enforce data quality standards throughout migration process Establish data lineage and metadata management for new structures Create comprehensive documentation including data models, schema specifications, migration procedures, and data dictionaries Develop data flow diagrams, entity-relationship diagrams, and architecture decision records Document rationale for normalization decisions and any strategic denormalization Create runbooks for migration execution and rollback procedures Provide knowledge transfer sessions to technical teams 10+ years of hands-on experience in data modeling and database design 5+ years of experience reverse engineering and refactoring large-scale OLTP databases Expert-level understanding of database normalization theory and practical application (1NF through 5NF, BCNF) Deep expertise in both forward and reverse engineering of data models Proven track record of successful database modernization and schema refactoring projects In-depth knowledge of relational database design principles, patterns, and anti-patterns Expert-level SQL skills and extensive experience with PostgreSQL (required) Proficiency with additional RDBMS platforms (SQL Server, Oracle, MySQL) Hands-on experience with AWS Aurora PostgreSQL or similar cloud-based database platforms Strong expertise in data modeling tools ( erwin, SqlDBM, ER / Studio, or similar ) Experience with database migration and version control tools Familiarity with database comparison and schema diff tools Knowledge of database DevOps practices and CI / CD pipeline integration Experience with cloud platforms (AWS, Azure, GCP) and cloud-native database services Relevant certifications (AWS Certified Database Specialty, PostgreSQL certifications) are advantageous
The Principal Data Modeler / Architect will lead a critical database modernization initiative to reverse engineer, redesign, and normalize our existing OLTP data architecture. This role requires a seasoned data professional who can analyze complex legacy systems, identify architectural debt, and execute a comprehensive schema refactoring strategy while ensuring zero business disruption. The ideal candidate combines deep expertise in data modeling, normalization principles, and large-scale database migration with strong collaboration skills to coordinate cross-functional teams through this transformation.
Experience in the EdTech domain is a plus.
Primary Objective
Reverse engineer our existing large-scale OLTP database, analyze current denormalized structures, and redesign the data model following normalization best practices while optimizing for performance, maintainability, and scalability in a modern SaaS environment.
Key Responsibilities
Database Analysis & Reverse Engineering
- Reverse engineer existing OLTP databases to create comprehensive conceptual, logical, and physical data models
- Analyze current schema design to identify denormalization patterns, data redundancies, integrity issues, and architectural debt
- Profile existing data quality, identify anomalies, inconsistencies, and constraint violations
- Document current state architecture, data flows, and integration points
Schema Redesign & Normalization
Migration Strategy & Execution
Performance Optimization & Tuning
Data Governance, Security & Compliance
Documentation & Knowledge Transfer
Required Skills & Qualifications
Data Modeling & Database Expertise
Technical Proficiency
Create a job alert for this search
Database Specialist • Pune, Republic Of India, IN
Related jobs
- Promoted
Senior Oracle DBA and EBS Applications Specialist
Litmus7India Highly skilled Senior Oracle DBA with deep experience in Oracle EBS administration, DataGuard, and performance optimization.
Should support our complex Oracle landscape, including Oracle 19c, Oracle...Show moreLast updated: 30+ days ago
- Promoted
Database Developer
AVASO Technology Solutionsnagpur, maharashtra, in AVASO Technology is a global leader in providing IT solutions and services, specializing in offering top-tier support and managed services.
We are committed to delivering cutting-edge technology sol...Show moreLast updated: 3 days ago
- Promoted
SAP HANA Database Specialist
Tata Consultancy ServicesRepublic Of India, IN Analyze and implement SAP support methodology.Bring comprehensive knowledge on SAP S / 4HANA architecture, conversion, and migration path.
Understand the SAP high availability or disaster recovery arc...Show moreLast updated: 30+ days ago
- Promoted
Database Modernization Engineer
OptiSol Business SolutionsChennai, Republic Of India, IN Hiring : Database Administrator (Modernization & Migration | GenAI Exposure).Chennai | Coimbatore | Madurai (Hybrid).We’re seeking professionals with hands-on experience in.Oracle, SQL Server, or Po...Show moreLast updated: 6 days ago
- Promoted
HANA Database Solutions Architect
Tata Consultancy ServicesRepublic Of India, IN Analyze and implement SAP support methodology.Bring comprehensive knowledge on SAP S / 4HANA architecture, conversion, and migration path.
Understand the SAP high availability or disaster recovery arc...Show moreLast updated: 30+ days ago
- Promoted
Senior Database Specialist
Star Union Dai-ichi Life Insurance Company LimitedRepublic Of India, IN SQL Server 2016–2022 Administration (Installation, Maintenance, HA / DR, Security).Strong expertise in T-SQL scripting, query tuning, and index management.
Hands-on experience with Azure SQL Database,...Show moreLast updated: 27 days ago
- Promoted
Senior Database Specialist
LearningMateRepublic Of India, IN Role : Senior Database(MSSQL Server) Developer.Experience administering Microsoft SQL Server.Proficiency in writing complex SQL queries.
Strong experience in schema design and index optimization.Han...Show moreLast updated: 30+ days ago
- Promoted
Cloud Database Specialist
LTIMindtreeRepublic Of India, IN Azure SQL (DB & MI), MySQL, PostgreSQL, and Cosmos DB(API & vCore) : .Design and implement resilient architectures for Azure database services including Azure SQL( DB & MI), MySQL, PostgreSQL, and Co...Show moreLast updated: 30+ days ago
- Promoted
Senior Database Specialist
Exela TechnologiesPune, Republic Of India, IN SQL Server Database Administrator.Collaborate closely with Application Developers to design, test, implement, optimize, and maintain efficient transactional and analytical data models.Lead and enga...Show moreLast updated: 6 days ago
- Promoted
Configuration Management Specialist
PeoplePlusTech Inc.Nagpur, IN Hardware Asset Management & CMDB Specialist.Costa Rica, Mexico, Argentina, South Africa, Eastern Europe, India, Philippines, Vietnam, Malaysia, Indonesia,.
We are looking for an experienced.Hardware...Show moreLast updated: 6 days ago
- Promoted
- New!
Database Engineer
Neo Wealth and Asset ManagementIndia Position Title : Database Engineer.As a Database Engineer, you will be responsible for designing, implementing, and maintaining scalable databases and ETL pipelines for large volumes of time-series ...Show moreLast updated: 11 hours ago
- Promoted
Senior Database Specialist
Tata Consultancy ServicesChennai, Republic Of India, IN Oracle DBA versions, primarily Oracle 19c,.Experience in Database Production Support.Exposure to various Oracle DBA versions, primarily Oracle 19c.
Exposure to MS SQL server administration.Good know...Show moreLast updated: 30+ days ago
- Promoted
Senior Database Management Expert (Oracle)
Tata Consultancy ServicesChennai, Republic Of India, IN All functions associated with maintenance of Oracle Server databases including security, back-up, reporting, and recovery procedures.
Core Oracle DBA activities for Oracle 9i / 10G / 11g & 12c including...Show moreLast updated: 1 day ago
- Promoted
Cloud Database Specialist
ALIANDORepublic Of India, IN Job Title : Cloud Database Administrator.ALIANDO is an award-winning Azure Expert Managed Service solutions company focused on selling and deploying Microsoft technologies for U.For over 20 years, M...Show moreLast updated: 6 days ago
- Promoted
- New!
Database Specialist - IBM AS400
Infibeam SofttechNagpur, IN We are looking for a highly experienced and technically proficient DB Specialist IBM AS400 professional to join our growing technology team.
The ideal candidate should bring deep expertise in IBM i ...Show moreLast updated: 13 hours ago
- Promoted
Configuration Management Database (Cmdb) Manager
AVASO Technology SolutionsChennai, Republic Of India, IN Job Opportunity : Configuration Management Database (CMDB) Manager.Employment Type : Full-Time Employment.AVASO Technology is a global leader in providing IT solutions and services, specializing in o...Show moreLast updated: 16 days ago
- Promoted
- New!
AS400 Database Modernization Specialist
Infibeam SofttechRepublic Of India, IN We are looking for a highly experienced and technically proficient DB Specialist IBM AS400 professional to join our growing technology team.
The ideal candidate should bring deep expertise in IBM i ...Show moreLast updated: 3 hours ago
- Promoted
AWS Database Specialist
Tata Consultancy ServicesPune, Republic Of India, IN Desired Competencies (Technical / Behavioral Competency).Should have expertise in creating data warehouses in AWS utilizing the following tools : EC2, S3, EMR, Athena, Sagemaker, Aurora and Snowflake....Show moreLast updated: 30+ days ago