Offer summary

Qualifications:

Minimum 10+ years of general database administration tasks, 7+ years experience as a SQL Server DBA, 5+ years administering advanced database features, 4+ years experience with Azure Data Factory (ADF), 3+ years experience with Databricks.

Key responsabilities:

Lead data engineering estimating efforts

Perform detailed data analysis and design

Implement data warehousing design and dimensional modeling

Optimize database queries and stored procedures

Adhere to data governance standards and best practices

Job description

Azure Database Administrator Associate Developer to Lead the data engineering estimating effort related to new capabilities, defect fixes and enhancements.

In this role of should have knowledge of and experience with:

Azure SQL Database
Azure SQL Managed Instance
SQL Server on Azure Virtual Machines (Windows and Linux)

Job Descriptions

Must have a Minimum of 10+ years conducting general database administration tasks (e.g. DB implementation, DB code deployments, DB backups, creation of DB user accounts).
Minimum of 7+ years experience working as a SQL Server DBA.
Must have experience as an Functional & Application DBA.
Must have at least 5 years administering database platform specific advanced features (e.g. clustering, encryption, logical/physical standby, ETL, replication) and performance optimizing server database servers and SQL code.
Minimum of 5+ years experience working in a SQL DBA Role with multiple databases and SQL development experience.
Proficient in MS SQL Server 2008 2022
Proficient in MS SQL Server Management Studio
SSIS Package creation and debugging skills.
Stored procedure development and tuning.
Data replication exposure.
5+ years of database design, SSIS packages, Transact SQL, and query optimization experience
4+ years AZURE experience with Azure Data Factory (ADF) and
3+ years Databricks required
4+ years Experience with Python, M/L R-programming
Database and data warehousing design and implementation as well as dimensional modeling required
Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
Understand and transform technical specifications into a data model, and database deliverables for the build out of a compliance data warehouse and metrics data warehouse

Solve complex data engineering problems and lead system design and development activities including understanding the business processes/requirements while adhering to the data quality control framework
Work in the Agile framework (including JIRA and GIT (for code management)) and collaborate with business and technology teams on the delivery of our strategic data platforms
Optimize database queries, build out complex stored procedures, database objects, indices, triggers, data import and export routines, support user and role management, grants, schema, object management and session monitoring and other logging capabilities
Code, test, deploy and maintain your code while supporting team members with training, code reviews, developing dev best practices, code management processes and procedures
Understanding and commitment to data governance standards and data management best practices
Performance tune SQL and identify technical deficiencies in queries and resolve them
Apply strong knowledge in Python and Shell Scripting required for file processing and database connections

Industry Experience: Healthcare/Insurance Carrier, FinTech, Pharma, Retail, Supply Chain/Manufacturing

Demonstrated Experience.