Advertisement
Job Description:
Job Role
Designing Database, writing stored procedures, complex and dynamic queries in SQL.
Creating Indexes, Views, complex Triggers, effective Functions, and appropriate store procedures to facilitate efficient data manipulation and data consistency.
Producing sample sites, creating web site designs and demonstrating and receiving feedback about draft sites.
Implementing database architecture, ETL and development activities.
Good knowledge of Working on SSRS and SSIS. Experience in SSAS will be plus.
Experienced and versed in creating SQL Server databases to quickly handle complex queries, query optimization.
Troubleshooting data load, ETL and application support related issues.
Demonstrates ability to communicate effectively in both technical and business environments.
Troubleshooting failed batch jobs, correcting outstanding issues and resubmitting scheduled jobs to ensure completion.
Troubleshoot, optimize, and tune SQL processes and complex SQL queries.
Experience
3 years to 5 years
Technical Skills
General database development using MSSQL up through SQL 2008.
Advanced level of writing stored procedures, reading query plans, tuning indexes and troubleshooting performance bottlenecks.
Proficient in SSIS, SSRS, reporting services, ETL.
Experience with SQL databases utilizing SQL Server Reporting Services implementations and SSRS report writing.
Troubleshoot, optimize, and tune SQL processes and complex SQL queries.
Experienced and versed in creating sophisticated SQL Server databases to quickly handle complex queries.
Problem solving, analytical and fluent communication.
About Company:
