Techligent Systems Inc.
Vienna, VA
Post Resume to
View Contact Details &
Apply for Job
Job Description :
Responsibilities:
Create / Modify and optimize database schemas, stored procedures and SQL queries.
Analyzing, troubleshooting, and resolving data issues.
Write Complex Stored Procedures.
Understanding of 3rd party software APIs in order to integrate them with your solutions.
Working closely with business stakeholders and assist with data analysis with regard to SQL.
Preparing the mapping documents for the existing stored procedures.
Should be able to perform SQL profiling.
Analyze the performance issues of existing stored procedure and fine tune performance of the system.
Identifies and proposes database system improvements and changes.
Builds and executes data queries for business partners.
Implements systems changes, upgrades, and modifications according to business needs.
Maintain active relationships with stakeholders to understand business requirements, lead requirement gathering meetings and review designs with the stake holders.
Perform technical design reviews and code reviews.
Perform peer reviews on source code to ensure reuse, scalability and the use of best practices.
Participate in collaborative technical discussions that focus on design, architecture, and development.
Identify opportunities that can improve efficiency of business processes.
Troubleshoot software application and technical issues - identify modifications needed in existing applications to meet changing user requirements.
Prior experience on executing offshore model project.

Requirements:
7+ years of experience working with Microsoft SQL Server, MS SQL.
7+ years of strong hands on background as a SQL developer.
Excellent knowledge on writing complex SQL stored procedures in an application development environment.
Design database tables, views, indexes, functions and develop the various reports using SQL and Stored Procedures.
Work with other front-end developers in completing the database modules end to end (experience in parsing of JSON in Stored Procedures would be an added advantage
Query optimization for performance improvement.
Should be proficient in creating database triggers.
Should maintain data quality and oversee database security.
Must be excellent in writing complex SQL queries.
Working experience in .Net technologies is an added advantage.
             

Similar Jobs you may be interested in ..