SQL Server/ SSIS Developer

Description

This role will be responsible for supporting multiple applications and data transfers between internal and client facing applications. The successful candidate will have handson experience in a multitude of domains; including, but not limited to; 24 x 7 x 365 enterprise and cloud database infrastructure design and management, security, business continuity, disaster recovery, database design, database development, database tuning, enterprise data storage and backup, service delivery, incident tracking, change management, and general database administration Skills/Experience Extensive knowledge of SQL Server including the writing of complex stored procedures, functions and SSIS packages as well as basic knowledge of database administrationStrong understanding and experience of database development methodologies (Agile and Scrum)Expert level knowledge of SQL administration, engineering, and monitoring toolsDemonstrated expertise in performance tuning including both query and server optimizationStrong knowledge and experience in data modeling, relational database design, optimization for performance, TSQL, stored procedures, SSIS packagesExpertise in understanding complex business needs, analyzing, designing and developing solutionsAdvanced knowledge of relational database design, testing and implementationAdvanced communication and professional skills and the ability to establish relationships across business unitsAbility to participate in an oncall support rotation and provide nonstandard work hour supportExtensive SQL Server performance tuning and troubleshooting experienceHandson development experience in SQL Server 2012/2016Experience with SSISFinancial technology domain knowledge would be a plusExperience with .NET, MVC, C# HTML5 CSS3 AJAX jQuery IIS and Java script would be a plusResponsibilitiesDesign strategies for database systems as well as set standards for operations, programming and security.Definition and governance of all structured and unstructured physical data models, data entities, supporting artifacts and metadata repositories.Develops physical modeling standards and strategies.Executes design sessions to gather requirements, review, approve, and communicate design artifacts with stakeholders.Creates and manages physical models to support Enterprise Data Warehouse domains that include Operational Data Stores, Staging, Integrated EDW, Data Mart, Business, Reference/Master Data and Extract Transform Load (ETL) environments.Ensures physical database features and capabilities are incorporated into data model designs to optimize performance.Designs deliverables that are defined with appropriate database platform and security context.Design and manage models using various Data Modeling tools.Maintains optimal Enterprise Architecture alignment with Solution Architecture, Technical Leads, Business Analysis, Infrastructure, and PMO roles. Design, Implementation and maintenance of database solutions, management of data access, and resolving database performance and capacity issues.Develop, implement, administrate, and maintain policies and procedures for ensuring the security and integrity of our databases.Perform problemsolving of application issues and production errors, including high level critical production issues that require immediate attention.Design and code a high volume of SQL Queries, stored procedures, and SSIS packagesImplement processes and procedures for the development and release of products/projects that facilitate high quality and rapid deploymentMonitor and perform performance tuning on stored procedures and ETL jobsMonitor and analyze SQL Server production metricsSupport complex service impacting issues with little to no supervisionParticipate in an oncall support rotation and provide nonstandard work hour supportTrouble shooting and resolving data issues