Database Developer - SQL Server

<p>Key Responsibilities : <br/><br/>- Design and develop logical and physical database models based on business requirements.<br/><br/>- Write efficient and complex SQL queries, ETL using stored procedures, functions, and triggers.<br/><br/>- Closely collaborate with AWS Team to help build the Data Pipelines/Orchestration.<br/><br/>- Optimize and tune query performance for processing high volume of data ensuring scalability.<br/><br/>- Collaborate with other cross functional teams to timely deliver quality database solutions.<br/><br/>- Ensure data integrity, consistency, security, and availability across systems.<br/><br/>- Supporting Testing activities by analysing defects and troubleshooting issues as they arise.<br/><br/>- Performing and supporting DB deployments during Testing and Release cycles.<br/><br/>- Document database structures and data flows.<br/><br/>Required Qualifications : <br/><br/>- 6+ years of professional experience in database development.<br/><br/>- Expert-level proficiency in SQL and hands-on experience with major RDBMS platforms such as SQL Server, PostgreSQL, Oracle, or MySQL.<br/><br/>- Experience writing complex SQL queries, Procedures and Functions.<br/><br/>- Proven expertise in query optimization and performance tuning.<br/><br/>- Solid experience in implementing and managing ETL processes and data pipelines.<br/><br/>- Working Experience in Data Warehousing and Data Migration projects, definite plus.<br/><br/>Soft Skills : <br/><br/>- Strong analytical and problem-solving skills.<br/><br/>- Excellent communication and collaboration abilities with technical as well as non-technical teams.<br/><br/>- Attention to detail and commitment to data accuracy.<br/><br/>- Ability to work independently and manage multiple tasks simultaneously.<br/><br/>- Ability to take complete ownership of targeted deliveries.<br/> </p> (ref:hirist.tech)