Responsible for design, development and management of high quality, efficient and effective solutions in Microsoft SQL Server, Integration Services and related tools to support a number of large-scale data migration projects.
In this role, you will design of complex databases models and creation of physical database objects from design, administering and controlling the organization's data resources, including multiple relational and non-relational db systems and servers.
Assist in development of the Windows Development and Production Environment (WDPE), which is a project that is mandated to establish standards for development and production support for application systems on a Windows platform.
In this role, you will write application software, data analysis, data access, data structures, data manipulation, databases, design, programming, testing and implementation, technical and user documentation, software conversions.
In this role, the selected candidate should be proficient in SQL to create Stored procedures, drill through Sub reports, summary and detailed reports; will work on enhancements to existing production code.
In this role, the selected candidate must have senior level engineering mindset analytical processing of the work to be done; excellent communication skills & a good personality very important to this team.
In this role, the selected candidate must have experience with designing SQL structures and procedures to support applications, administrative experience in performance tuning, query optimization, and troubleshooting with SQL Profiler, Performance Monitor, and other related tools.
The Software Engineer will develop and maintain extract/transform/load routines to gather data from various data sources and for developing applications to support the departments research and reporting needs.