Senior SQL Database Developer

Job Title: Senior SQL Database Developer

Location: Remote

Job Type: Fulltime

YoE: 5 to 10 years relevant experience

Shift: Shift: 6.30pm to 3.30am / 2.30pm to 11.30pm

Responsibilities:

• 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.

Requirements:

• 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.