The Senior Database Developer will create and implement database solutions, optimize queries, troubleshoot issues, and maintain documentation. Required skills include extensive SQL development experience and familiarity with data integration tools.
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
Top Skills
Dts
Microsoft Sql Server
SQL
Ssas
Ssis
Ssrs
T-Sql
Similar Jobs
Software
Design, implement, and manage multi-region cloud-based database solutions, focusing on MySQL and AWS technologies. Ensure security, performance, and compliance across deployments.
Top Skills:
ArgocdAws AuroraCloudFormationCrossplaneDocumentdbHelmKubernetesMySQLTerraform
.jpg)
Software
The Senior Software Engineer will automate databases and build a database-as-a-service platform, focusing on high availability and performance with Go and Kubernetes.
Top Skills:
AWSAzureGoGCPKubernetesMySQLPostgresRedisTerraform
Fintech • Information Technology • Payments
The Senior Database Engineer will design, engineer, deploy, and support Oracle and PostgreSQL databases, ensuring high performance and availability while managing database infrastructure and automation.
Top Skills:
AnsibleCi/Cd ToolsGitInfrastructure As CodeJavaLinux ShellOraclePostgresPythonTerraform
What you need to know about the Bengaluru Tech Scene
Dubbed the "Silicon Valley of India," Bengaluru has emerged as the nation's leading hub for information technology and a go-to destination for startups. Home to tech giants like ISRO, Infosys, Wipro and HAL, the city attracts and cultivates a rich pool of tech talent, supported by numerous educational and research institutions including the Indian Institute of Science, Bangalore Institute of Technology, and the International Institute of Information Technology.
