JD970 - Sr SQL developer / SQL developer
Key Skills : MS SQL SERVER 2008-2017,SQL Reporting Services / Report Builder. Exp : 7 - 10 Sal : Loc : Bangalore Client of Bloom Consulting Services email : hiring bloomsolutions.com
About the Job
Qualification : BCA / BSE / B.Tech
Well Versed on T-SQL
Expert in Stored Procedure and Query Language programming
SQL Reporting Services / Report Builder
SQL Performance Profiling (both indexing and performance optimization of large datasets
Advanced database troubleshooting
Should work on performance Tuning
Design database for new modules
Identify loop holes in existing DB architecture and provide resolution.
Ensure performance, security, and availability of databases
Create complex functions, scripts, stored procedures and triggers to support application development.
Evaluate and optimize existing database systems for performance efficiency
Responsible for implementation and release of database changes according to agreed timescales and costs
Utilize and Build Known Error Database for issues where root cause is available or if the root cause is already established.
Must have worked on Log shipping, Replication, DB Mirroring, Migration, performance tuning, Indexing, Cluster environment and DTS / SSIS.
Ability to utilize various tools to provide system management functions such as : system backup / recovery, code promotion, system monitoring, DB comparison.
Skill sets :
Strong proficiency withMS SQL SERVER 2008-2017.
Skilled at optimizinglarge complicated SQL statement.
Should be able to meetSLAs as per the priorities.
Should be able to assisttechnical development teams in advising them to implement best database usagepractices.
Should maintainDocumentation as per the Industry Standards.
Strong communicationsskills and ability to document and present complex designs to a wider audience.
DB Design Knowledge
NoSql knowledge would bea plus
What You Need for this Position
You should have knowledge of :
MS SQL SERVER 2008-2017
SQL Reporting Services / Report Builder.