Position: Senior Database Developer
Company: deventor.io
Category: SQL
Experience required: 3y
English level: intermediate
Published: 2021-08-01T00:00:00+03:00

**Responsibilities:**

● Manage SSIS developers
● Perform complex database programming by writing SQL procedures on large-scale databases
● Design and implement data solutions including data partitioning, data normalizing/de-normalizing, data aggregations, and ETL to support data warehouse environment
● Work closely with our business teams to understand business reporting and analytic requirements
● Develop new database schema/objects and/or review existing objects to improve storage efficiency and access
● Creating, reviewing, analyzing, and modifying SQL scripts, procedures and supporting programs to ensure proper execution, efficient operation, and sustainable coding constructs.
● Proven ability to perform technical troubleshooting to diagnose, isolate and correct data and database issues.
● Conducting data analysis to identify data integrity issues within databases, interfaces, or other data related repositories.
● Making design recommendations for database functions that meet business operating standards while improving the efficiency of business processes.
● Applying quality controls to work functions including appropriate testing and validation of new or modified programs prior to deployment.
● Demonstrating and applying reasonable and practical security controls within the SQL and database environments to minimize security risks.
● Providing technical expertise in assessing software projects and related initiatives to enhance or support the Fitness BI software environment.
● Writing technical procedures and/or supporting documentation for the applications including operational usage or procedures, user guides, etc.
● Strictly adhering to programming / security standards or similar protocols that seek to reduce or eliminate risks associated with the introduction of program and/or data modifications.
● Serving as a liaison and facilitator between departments to assist in addressing and resolving database related issues.

**Requirements:**

● SQL Development experience in environments that may include a combination of SQL Server, Oracle, MySQL and Postgres environments.
● 6+ years experience with SQL Server Integration Services (SSIS).
● Able to navigate unfamiliar data models of all types and to develop methods for reliably and accurately extracting data from them.
● SQL performance tuning expertise and other SQL Server DBA skills preferred.
● Windows Systems Administration or scripting preferred.
● Knowledge of Microsoft SQL Server Integration Services (SSIS) 2014 and above
● Knowledge of Microsoft SQL Server 2014 and above
● Knowledge of Source Control (GIT or TFS)
● Knowledge of Azure SQL Data Warehouse (nice to have)
● Knowledge of Microsoft SQL Server Analysis Services (SSAS) / Azure Analysis Services
● Experience in processing various source and destination types Flat Files SQL databases Web APIs (SOAP, REST)
● Experience in complex ETL transformations, including using C# for SSIS scripting
● Experience in third party SSIS tools
● Knowledge of Agile development methodology

**Nice to Have:**

● Availability on call when support is required or if the app is down