*software sr. Engineer*
*duties & responsibilities*:
- complete research and problem-solving tasks with mínimal supervision
- design and develop tables with appropriate constraints and indexes
- create/update stored procedures, functions, views, triggers and other sql server objects
- develop, modify and debug complex ssis packages with control and data flows - both package and project deployment
- maintain existing database objects and systems
- prepare documentations and specifications which include file layouts, data mapping
- collaborate with other team members and business stakeholders
- work in a fast-paced environment with competing priorities to meet goals and deadlines
*required skill and experience*:
- fluent in english
- 7+ years of applied experience in sql server programming
- t-sql programming - analysis of complex stored procedures, views, functions, triggers
- etl design and development using ssis
- development of high-quality database solutions
- skilled at optimizing large, complicated sql statements
- capable of troubleshooting common database issues
- familiar with tools that can aid with profiling server resource usage and optimizing it
- hands-on development using.net technologies
- review and interpret ongoing business needs
- analyze existing sql queries for performance improvements
- strong organizational, detail-oriented skills
- strong experience in microsoft sql server, t-sql and ssrs
- experience in performance tuning of complex stored procedures
- experience in creating/enhancing sql server reports (rdls)
- experience with sql server management studio and ms visual studio
- ability to write complex sql queries/scripts and develop processes leveraging ssis
- experience in file transfer mechanisms such as ftp
*desired skill and experience*:
- 7 to 10 years of experience as a sql developer or similar role
- experience using jira and microsoft tfs
- 5 to 7 years of experience with sql server and sql server data tools (ssis, ssrs) or similar sql and etl
- 5 to 7 years of hands-on experience in c#,.net, web api, json,
- sense of ownership and pride in your performance and its impact on the company's success
- critical thinker and problem-solving skills
- team player
- good time-management skills
- great interpersonal and communication skills