Key Responsibilities
Database Migration & Modernization
- Lead end-to-end migration and modernization of legacy databases to up-to-date 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