Microsoft Certified: Azure Database Administrator Associate Developer

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.

• Azue DevOps + MS Projects
• M365 TEAMS + MS Visio
• 
  

Certification required.

• MCDBA, or
• MCSA; and,
• DP-300, or
• DP-900
• Confluence + Cert

Jira Work Management + Cert