Senior Database Developer (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
with strong expertise in
Oracle
and
Microsoft SQL Server
to join our team. The candidate will be responsible for developing, optimizing, and migrating database solutions as part of a large-scale
database modernization and migration project
.
This role requires solid experience in
database programming (PL/SQL, T-SQL)
,
schema design
, and
data migration techniques
.
Key Responsibilities
Design, develop, and maintain
database objects
(tables, views, procedures, functions, triggers) in Oracle and SQL Server.
Participate in
end-to-end database migration projects
-- assessment, conversion, testing, and deployment.
Use tools such as
SQL Server Migration Assistant (SSMA)
,
Oracle Data Pump
, and
ETL utilities
for schema and data migration.
Analyze existing database structures and recommend improvements or conversion strategies.
Optimize SQL queries, indexing strategies, and stored procedures for performance and scalability.
Ensure
data integrity, consistency, and quality
during migration and post-migration phases.
Collaborate with application developers, DBAs, and infrastructure teams to ensure smooth migration and integration.
Develop automation scripts for recurring migration or data transformation tasks.
Prepare technical documentation and provide post-migration support and validation.
Required Skills & Qualifications
6+ years
of professional experience as a
Database Developer
.
Strong expertise in
Oracle (PL/SQL)
and
MS SQL Server (T-SQL)
.
Proven experience in
database migration
between Oracle and SQL Server.
In-depth understanding of
schema design
,
constraints
,
indexes
, and
query optimization
.
Hands-on experience with migration tools like:
SQL Server Migration Assistant (SSMA)
Oracle Data Pump (expdp/impdp)
BCP / BULK INSERT
Experience working with
ETL pipelines
and
data validation
post-migration.
Knowledge of
performance tuning
and
execution plan analysis
.
Familiarity with
version control (Git)
and
scripting languages (PowerShell, Python, or Shell)
for automation.
Excellent problem-solving and analytical skills.
Strong communication skills and ability to work in cross-functional teams.
Nice to Have
Experience with
Azure SQL
,
AWS RDS
, or
cloud migration projects
.
Exposure to
data warehousing
or
BI tools
(e.g., SSIS, Informatica, Power BI).
Knowledge of
DevOps
,
CI/CD
, or
containerization
concepts.
Certifications like
Microsoft Certified: SQL Database Developer
or
Oracle Certified Professional (OCP)
.
Education
Bachelor's or Master's degree in
Computer Science
,
Information Technology
, or related field.
.
Job Type: Full-time
Pay: ₹1,027,509.21 - ₹2,039,029.05 per year
Benefits:
Provident Fund
Work Location: In person
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.