Job Purpose:

Analyzing, developing SSIS projects, custom reports, and work closely with the team on any SQL issues. Manage new implementations, resolve any integration issues timely manner.

Duties and responsibilities:

• Manage data projects by being a liaison between client and database developers.
• Develop time estimates for assigned tasks.
• Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated.
• Design, develop, and maintain database tables, stored procedures, and supporting objects.
• Build and support operational reports for company and clients.
• Work with data team to provide operational support, resolve recurring problems.
• Document database topology, architecture, processes, and procedures.
• Develop SQL queries and support ad hoc requests for data.
• Assist with capacity planning and resource expansion through data aggregation and analysis.
• Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement.
• Identify inefficiencies in the database platform and provide solutions to the management.
• Develop time estimates for assigned tasks.
• Use problem-solving skills to assist in resolution of business problems.
• Develop analytical skills to resolve technical problems.
• Identify root causes for problems and propose solutions to prevent recurring.

Qualifications:

• BSCS with 3+ years MS SQL experience.
• Thorough understanding of database structures, theories, principles, & practices.
• Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints.
• Extensive knowledge of MS SQL Server 2005/2008/2012/2014.
• Knowledge of SSIS/SSRS is a plus.
• Experience with C# or VB.NET.
• Technical knowledge of MS SQL Server internals with emphasis on query performance.