Database Developer - Design & Maintenance

About the job :

Job Title : Database Developer (SQL Server & Oracle)

Work Location : Remote (Work from Home)

Work Shift : 2 PM 11 PM IST

Joining Timeline : Immediate to 23 weeks (sooner preferred)

Interview Process : 2 Virtual Rounds

Round 1 : US Team Interview

Round 2 : Final Client Interview

Key Responsibilities :

• Design, develop, and maintain SQL Server database objects (tables, views, stored procedures, functions, triggers).
• Optimize T-SQL queries, indexes, and execution plans for high performance.
• Support cross-platform integration with Oracle databases (PL / SQL).
• Build and maintain ETL pipelines (primarily using SSIS; Oracle ETL exposure is a plus).
• Implement and monitor database security, backup, recovery, and high availability (Always On Availability Groups, clustering).
• Troubleshoot and resolve performance issues, blocking / deadlocks, and optimize resource utilization.
• Collaborate with application developers to design normalized and scalable data structures.
• Support database upgrades, migrations, and integrations between SQL Server and Oracle.
• Document standards, best practices, and database architecture across SQL Server and Oracle environments.

Required Skills & Qualifications :

(ref : hirist.tech)