Location: New York,NY, USA
Provide development and design assistance to development and other application support teams. Help developers improve the performance of that query by tweaking it or modifying indexes. Develops performance/tuning evaluation reports. Perform SQL administrative tasks.Creating maintenance plans, and creating database objects Performance turning, monitoring, troubleshooting and optimization of the databases Prepares users by conducting training; providing information; resolving problems Escalating application problems to vendors Responsible for working on annual releases and providing operational support Monitors operating efficiency of existing application systems Developing unit tests and coordinating with our client to achieve the best blend of error prevention and error detection possible Identify and resolve project issues, including issue tracking and escalation Maintain and develop new features in existing applications Analyzing, designing, developing, implementing and maintaining application code in a variety of contexts including existing applications Design, development, and maintenance of WAVE components Specifications, architecture, wiki pages, and other design documents Cross-training and mentoring Providing accurate estimates and meeting your scheduled commitments Primarily acts as a multiplier by building systems, authoring tools, or introducing policies or patterns that raise the level of productivity of the entire organization Maintaining, tuning and repairing applications; providing user support Working on writing T-SQL scripts to configure the UI of the application and developing new configurations using Metadata-Driven development approach Working knowledge of data mapping, extraction, data migration, decision support systems, data marts/data warehousing and relational and dimensional modeling Designs, codes, tests, debugs, and documents the developed solutions Apply development best practices as test-driven development (TDD) techniques and integration tests for all developed software Created databases and schema objects including tables, indexes, stored procedures and functions as a part of the data migration initiative Built SSIS packages and scheduled jobs to migrate data from disparate sources into SQL server and vice versa Performed root cause analysis on failures. Resolve performance tuning related issues and queries. Daily checks of CCTV Cameras and report issues in TEC Now. Follow up with Vendor to ensure the issue gets resolved on priority.