Database Developer - Design & Maintenance

<p><p><b>About the job :</b><br/><br/>Job Title : Database Developer (SQL Server & Oracle)<br/><br/>Work Location : Remote (Work from Home)<br/><br/>Work Shift : 2 PM 11 PM IST<br/><br/>Joining Timeline : Immediate to 23 weeks (sooner preferred)<br/><br/>Interview Process : 2 Virtual Rounds<br/><br/>Round 1 : US Team Interview<br/><br/>Round 2 : Final Client Interview<br/><br/><b>Key Responsibilities :</b><br/><br/>- Design, develop, and maintain SQL Server database objects (tables, views, stored procedures, functions, triggers).<br/><br/>- Optimize T-SQL queries, indexes, and execution plans for high performance.<br/><br/>- Support cross-platform integration with Oracle databases (PL/SQL).<br/><br/>- Build and maintain ETL pipelines (primarily using SSIS; Oracle ETL exposure is a plus).<br/><br/>- Implement and monitor database security, backup, recovery, and high availability (Always On Availability Groups, clustering).<br/><br/>- Troubleshoot and resolve performance issues, blocking/deadlocks, and optimize resource utilization.<br/><br/>- Collaborate with application developers to design normalized and scalable data structures.<br/><br/>- Support database upgrades, migrations, and integrations between SQL Server and Oracle.<br/><br/>- Document standards, best practices, and database architecture across SQL Server and Oracle environments.<br/><br/><b>Required Skills & Qualifications : </b><br/><br/>- 6 to 7 years of total IT experience with 56 years in SQL Server database development.<br/><br/>- Strong expertise in Microsoft SQL Server (2016/2019/2022).<br/><br/>- Hands-on T-SQL development (stored procedures, triggers, functions, views).<br/><br/>- Proven skills in performance tuning, indexing, and execution plan analysis.<br/><br/>- Working knowledge of Oracle PL/SQL (procedures, packages, functions).<br/><br/>- Hands-on experience with SSIS or equivalent ETL tools.<br/><br/>- Strong knowledge of backup/recovery strategies, high availability, and disaster recovery.<br/><br/>- Experience with database version control and CI/CD deployment practices.<br/><br/></p><br/></p> (ref:hirist.tech)