Database Developer

Job Description

Exp-4-6 Years

• SQL Server Development/Programming, Performance Tuning, Indexing, Schema Design, TSQL(DDL & DML) scripts, stored procedures, functions and other database objects.
• Scripting and Code management.

Minimum : Minimum 3+ years' Experience on-

• Experienced in Database Design and Modelling. ER Diagram.
• Ability to understand Business requirements and design database accordingly
• Good in performance tuning especially tuning complex queries, procedure.
• Strong understanding of database design, troubleshooting, and management.
• Experienced in handling production support responsibilities, improving the support activities using automation tools where ever applicable.
• Designing and coding database tables to store the application's data
• Memory utilization, and alert log file for MSSQL Server.
• Refactoring of Old Design/code.

Minimum: Minimum 2+ years' Experience on-

• Modernizing the old code, Advance Database coding, best practice.
• Code review and SQL query tuning
• Basic on Project Architecture level and data flow knowledge.
• Project level Data Auditing.

Must have experience with-

• SQL Server 2019 & 2022 and T-SQL in both OLAP and OLTP environments
• Experience in support in MS SQL Server environments. Must have experience on Tracing/debugging tool like SQL Profiler.
• Database Tuning/optimization and Monitoring, Performance tuning strategies and implementation.
• Design databases, ensuring high availability, business continuity, scalability, stability, security, performance and reliability to support business applications using MSSQL Server.
• Monitoring, tuning and performance optimization of OS/Storage/DB configuration/databases and related parameters like, table space utilization, CPU utilization, Hard Disk Utilization,
• Performance tuning and query optimization experience using execution plans and performance tuning tools (e.g., Perfmon, Pssdiag, Profiler, Extended Events and DMVs)

Good To Have

• Experience with an agile development methodology, preferably Scrum.
• SSIS, SSRS other ETL, Good data Analysis skills and reporting knowledge.
• Experience in Data Modelling, Database design and well versed with SQL Server best practices
• Understand reporting requirements and map to Data Models
• Engage with ETL Developers to create or design extracts that feed visualizations
• Hands on experience in ETL tools for data flow transfer and management, Should have command on DDL and DML.
• Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.
• Worked in Data Warehousing, Data Modeling
• Data modeling to visualize database structure
• Design, plan, and develop programs to optimally extract, transform, and load data between data sources

What you will get

• Bi-Annual Salary Reviews
• Flexible working hour
• Three Day Hybrid Model
• Market competitive pay
• GMC (Group Mediclaim): Provides Insurance coverage of Rs. 3 lakhs + a corporate buffer of 2 Lakhs per family. This is a family floater policy, and the company covers all the employees, spouse, and up to two children
• Employee Wellness Program - HealthAsyst offers unlimited online doctor consultations for self and family from a range of 31 specialties for no cost to employees. And OPD consultations with GP Doctors are available in person for No Cost to employees
• GPA (Group Personal Accident): Provides insurance coverage of Rs. 20 lakhs to the employee against the risk of death/injury during the policy period sustained due to an accident
• GTL (Group Term Life): Provides life term insurance protection to employees in case of death. The coverage is one time of the employee's CTC
• Employee Assistance Program: HealthAsyst offers complete confidential counselling services to employees & family members for mental wellbeing
• Sponsored upskills program: The company will sponsor up to 1 Lakh for certifications/higher education/skill upskilling.
• Flexible Benefits Plan – covering a range of components like
• National Pension System.
• Internet/Mobile Reimbursements.
• Fuel Reimbursements.
• Professional Education Reimbursement