Senior Database Developer
Job Summary
Job Description
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.
Must have:
- 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
- 5+ 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
- Database analysis and designing & database design methodologies
Good to have:
- Familiarity with .net technologies (No development experience required)
- Good problem-solving abilities
- Good written and verbal communication skills
- Ability to work in a team and individually
6 skills required
Job Details
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:
- 5+ 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
Similar Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Similar Skill Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Jobs in Bengaluru, Karnataka, India
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
Programming Jobs
Looks like we're out of matches
Set up an alert and we'll send you similar jobs the moment they appear!
About The Company
Ansira is the leading marketing platform for brands that operate in distributed ecosystems. By orchestrating the entire brand-to-local value chain, Ansira synchronizes global companies’ internal and external teams across channels, markets and regions. Ansira leverages AI-powered technology, vertical expertise, local insights and strategic partnerships to optimize marketing performance and empower partner growth at scale.
Get notified when new jobs are added by ansira
