Senior Database Developer / DBA (Oracle & MS SQL Server Migration)
Location:
Onsite Airoli , Navi Mumbai
Employment Type:
Full Time
Experience Level: 6
+ years
About the Role
We are looking for an experienced
Database Developer/DBA
to lead and execute a migration project involving
Oracle and Microsoft SQL Server
databases. The ideal candidate will have hands-on experience in database migration, optimization, schema design, and performance tuning, along with strong analytical and troubleshooting skills.
Key Responsibilities
Lead the
migration of databases
from Oracle to MS SQL Server (or vice versa), ensuring data integrity, performance, and minimal downtime.
Analyze existing database schemas, stored procedures, functions, triggers, and packages for migration compatibility.
Design and implement
data migration scripts
, ETL processes, and automation pipelines.
Optimize and refactor SQL queries, indexes, and execution plans for performance improvements.
Manage database configuration, backups, recovery, and high-availability setups.
Collaborate with developers to refactor and rewrite application-level database interactions where necessary.
Conduct
testing, validation, and performance benchmarking
after migration.
Provide technical documentation and knowledge transfer to the internal team.
Required Skills & Qualifications
5+ years
of experience in
database development and administration
with Oracle and/or MS SQL Server.
Proven experience in
cross-platform migration
(Oracle ? MS SQL Server).
Strong knowledge of
PL/SQL
,
T-SQL
, and database scripting.
Hands-on experience with