Key Responsibilities
Database Migration & Modernization
Lead end-to-end migration and modernization of legacy databases to contemporary database platforms.
Perform schema conversion, database object migration, and data validation.
Refactor database schemas, stored procedures, functions, triggers, and views to improve maintainability and performance.
Collaborate with application development teams to ensure seamless application compatibility during migration.

SQL Development & Performance Optimization
Develop and optimize complex SQL queries, stored procedures, functions, triggers, and packages.
Analyze execution plans and resolve SQL performance bottlenecks.
Design and implement indexing, partitioning, and query optimization strategies.
Improve database and application performance for high-volume transactional systems.

Database Engineering
Design scalable and normalized database schemas based on application requirements.
Implement database version control and automated deployment practices.
Support zero-downtime database releases and production deployments.




Ensure data integrity, consistency, and optimal database performance.

Migration Tools & Automation
Utilize migration tools to automate schema conversion and data movement.
Develop migration scripts and validation processes for enterprise-scale migrations.
Integrate database deployments into CI/CD pipelines.

Required Technical Skills
Databases
Oracle Database
Microsoft SQL Server (MSSQL)
PostgreSQL
MySQL

Programming & Database Development
SQL
PL/SQL
T-SQL
Stored Procedures
Functions
Triggers
Views
Packages

Performance Tuning
SQL Performance Tuning
Query Optimization
Execution Plan Analysis
Indexing
Partitioning
Database Profiling

Database Modernization
Schema Refactoring
Database Object Migration
Schema Conversion
Legacy Database Modernization
Data Migration

Migration Tools (Preferred)
Oracle GoldenGate
Oracle Data Integrator (ODI)
-

📌 Database Engineer Thane
🏢 3i Infotech
📍 Thane