Senior Database Developer

Senior Database Developer. Experience : 9 years. Location : Pune(WFO). Notice Period - Immediate joiner. Job Description : Senior- Database Developer" (Having 8-10 years of experience in MySQL, SQL & ORACLE). Responsibilities : - Design & Implement the database and data modelling. - Creating Indexes, Views, complex Triggers, Stored Procedures, effective Functions, and appropriate store procedures to facilitate efficient data manipulation and data consistency. - Designing Database, writing sequences, jobs, complex and dynamic queries in SQL, MySQL, ORACLE. - Should have good grip on Keys, Constraints, Indexes, Joins, CTEs, Partitioning, Row Number() and Windows function, Temporary Tables, UDTs, Types of Union, Metalized views etc. - Strong analytical and problem solving skills. - Database Normalization & De-normalization. - Good command in writing the complex logic. - Troubleshoot, optimize, and tune SQL processes and complex SQL queries. - Should Know how to write unit test cases. - Understanding of Database Transactions and states. - Design, implement and monitor queries and stored procedure and their performance. - Able to debug programs and integrate the applications with third-party web services. - Identify opportunities for improved performance in SQL operations and implementations. - Understanding of database Backup, Restore & Maintenance. - Should have the knowledge about development, testing, UAT and production environments and their databases. - Knowledge of Working on SSRS and SSIS. - Experience in SSAS will be plus. - Good communication skills. (ref:hirist.tech)

Location: pune, IN

Posted Date: 1/15/2025