Job Description
The Database Developer II will collaborate with a team to design, implement, and optimize database solutions for various products. Key responsibilities include developing SQL queries, stored procedures, and triggers, as well as diagnosing and resolving production issues. The role also involves designing, testing, and deploying database schemas, and enhancing the performance of existing queries and procedures.
Good To Have:
- Familiarity with .net technologies (no development experience required)
Must Have:
- Create and normalize databases by applying rules of Normalization
- Write T-SQL queries, stored procedures, functions, and triggers
- Perform ETL from various SQL and No-SQL data stores
- Diagnose and resolve production issues
- Design, test, and deploy database schemas
- Perform database performance tuning and optimization
- 3 years of Microsoft SQL Server Development experience (2008 and/or 2014)
- Strong experience in T-SQL, Indexing, Functions & Stored Procedures
- Ability to write SQL scripts for data migration from various sources
- Experience with SQL Profiler, DTS, SSIS, SSRS, SSAS
- Database analysis, designing, and design methodologies
- Good problem-solving, written, and verbal communication skills
- Ability to work effectively in a team and independently
The Database Developer works closely with the team of database developers to create and implement solutions for various products. The ideal candidate will have experience working in SQL queries ,writing stored procedures and triggers. Also will be responsible for diagnose and resolve production issues, design, test and deploy database schemas and to optimize of existing database queries and procedures.
Responsibilities:
- Create a database and normalize the database into small tables by applying rules of Normalization, define check constraints and apply business rules
- Write T-SQL queries
- Create stored procedures, functions and triggers
- ETL from various sql and no-sql data stores to Operational Data Stores
- Verify and execute scripts developed by teams in staging and production environments
- Diagnose and resolve production issues
- Design, test and deploy database schemas
- Database performance tuning including identifying bottlenecks with suitable fixes
- Create & implement custom sql scripts to automate various database operations including data migration
- Create and maintain database documentation
- Create performance benchmark conformance report for newly developed and altered functions
- Assist software developers to achieve performance benchmark
- Optimization of existing database queries and procedures
Required Skills:
- 3 years of Microsoft SQL Server Development experience including 2008 and/or 2014
- Strong experience in T-SQL, Indexing, Functions & Stored Procedures
- Ability to write sql scripts for data migration from sources like excel, oracle, MySql, MS Access, csv/text file etc.
- Should be able to troubleshoot SQL queries for performance tuning
- Experience with SQL Profiler
- Experience in DTS, SSIS, SSRS, SSAS
- Familiarity with .net technologies (No development experience required)
- Database analysis and designing & database design methodologies
- Good problem-solving abilities
- Good written and verbal communication skills
- Ability to work in a team and individually
Set alerts for more jobs like Database Developer -II
Set alerts for new jobs by ansira
Set alerts for new Programming jobs in India
Set alerts for new jobs in India
Set alerts for Programming (Remote) jobs
