• Develop SSIS projects to handle ETL, transmission, encryption, and archiving of files received and generated.
• SQL Database Tuning and Performance
• 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.
• 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.
  
  

• Requires a four-year degree in Computer Science/Information Technology
• Minimum five years working as a Database engineer or a related role.
• Minimum of three years SSIS experience
• Minimum of two years’ experience with C# and\or VB.NET
• 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 2012 or later
• Extensive knowledge with SSRS\SSIS\T-SQL
• Experience with C# and\or VB.NET.
• Technical knowledge of MS SQL Server internals with emphasis on query performance.
• Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations.
• Require ability to work independently with minimal supervision
• Ability to multi-task with several complex and demanding Projects
  
  

• Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear.
• Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress.
• Work Environment: The noise level in the work environment is usually minimal.
  
  

Please refer to job description.