Database Developer

Job Description

Position : Database Developer (MS SQL) Position. Total Experience : 2 Years Location : Gandhinagar (Work from office) Shift timings : 2 PM to 11.30 PM Skill Set . Extensive experience designing, writing, and troubleshooting complex queries, stored procedures, functions, tables, and indexes Optimize large complicated SQL statements Diagnose and resolve database performance issues Development and maintenance of all T-SQL objects Ensure all database systems meet business and performance requirements Good to have experience with SSRS, SSIS, and PowerShell Experience in SQL 2008R2/2012/2014/2016 database management and related products from Microsoft Competency Technical documentation skills Ability to work within a team environment Familiar with upgrades, migrations, backup and recovery options Excellent verbal and written English skills Roles & responsibilities Work with the Technology Department to develop and enhance the centralized BI & Reporting Data Structure Collaborate with internal developers and product managers regarding database requirements, data stability, and other matters related to the databases Design, develop, test, and implement databases and database components related to internal and external systems integrated with the Reporting system Generation of complex views /material views for reporting and analytics Identify coding issues and provide fixes where necessary etc. Design and deploy various database components including schemas, queries, functions/stored procedures, views/materialized views, triggers identify opportunities to improve processes and procedures and suggest solutions to the problem Produce and maintain documentation including user guides for all systems developed