Senior Database Developer

Ansira is a global, independent marketing technology and services firm that empowers brands to drive growth through their partner ecosystems. Ansira offers a comprehensive suite of solutionsto help brands synchronize their distributed networks and deliver seamless brand-to-local marketing at scale. Their platform enables partners to create brand-compliant campaigns, manage digital assets, and engage consumers through personalized experiences. Ansira supports over 500 brands across various industries, including automotive, retail, healthcare, and telecommunications. For more information, visit ansira.com.

Experience: 4+years

Position: Senior Database Developer

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 individuallyRole & responsibilities

Preferred candidate profile