Senior Azure and on-prem SQL Database Administrator

Representative Office of DAI Global LLC

Beograd
Senior
23.01.2021.

Hiring entity: Representative Office of DAI Global LLC in Belgrade
Reports to: Senior Principal Database Administrator
Job Title:  Senior Azure and on-prem SQL DBA
Department: Information Technology
Work Location: Serbia

This position will develop and support DAI’s Azure and on-prem SQL Server database infrastructure for new data initiatives involving database design, development, automation, and administration. 

Duties and Responsibilities

Primary Responsibilities: SQL Server and Azure Administration (On-prem and Azure) - 70%

SQL server database administration and management. This includes but not limited to:

  • Database setup & database security administration
  • Administer logins & database users
  • Generate SQL audit reports
  • Configure alerts
  • Manage firewalls rules
  • Manage backup/restore
  • Database encryption
  • Develop complex queries, stored procedures, triggers, user defined functions 
  • Performance tuning of T-SQL queries
  • Monitoring and troubleshooting
  • Manage and reduce costs
  • Manage elastic pools
  • Create ETL/ELT jobs Azure Data Factory V2, databricks and SSIS
  • Manage SSIS packages, SQL agent, proxy accounts, agent scheduled jobs
  • Manage SSAS MDX and Tabular instances
  • Setup dev/test environment for developers and integrate with DevOps and setup automated pipelines
  • Assist developers with support requests and issues and recommend best practices.

Secondary Responsibilities - 30%

Support and troubleshoot on-prem legacy apps including:

  • IIS and azure web apps
  • SharePoint
  • Power Platform including Power BI, Power Apps, Flow
  • Manage office 365 licenses and feature management
  • Support and troubleshoot O365 applications and Dynamics365, PowerApps, Power Platform, Enterprise data gateways, Microsoft Azure subscriptions.
  • Other responsibilities as needed (server maintenance, etc.)

Job Requirements

  • Bachelor’s degree or higher
  • 7+ years of experience with administering SQL servers (may be combined for on-prem SQL and Azure SQL), Azure services, building and implementing BI solutions with Azure data lake, Data lake Analytics, Databricks, with MDX and DAX skills with multidimensional and tabular models
  • Experience with dimensional modeling and creating Star / Snowflake schemas
  • Strong SQL DBA and troubleshooting skills
  • Strong SQL Server knowledge across multiple versions including Azure SQL
  • Understanding of database tuning and troubleshooting
  • Must be proficient with end-to-end Azure SQL databases, Azure managed instances and On-prem
  • Must have solid knowledge and expertise on Azure services. This includes creating, configuring and the administration of: Azure Data lake Gen2, storage accounts and containers, folder security; Data lake analytics, building data models for curated data scenarios; Azure functions; Application registrations, clients, certificates, secrets; Azure Key vaults, access policies, secret management; Azure Databricks, workspaces, Python and Scala scripts; Managed identities; Azure roles, Azure Active Directory and DevOps.
  • Solid experience with SSIS BIDS/SQL server data tools and data security best practices
  • Proficient with writing PowerShell, Python or other scripting languages for automating different tasks. 
  • Experience with Design and Development of OLAP and BI solutions that include development and the administration of: 
    • Azure analysis services and Azure SQL data warehouse, Cubes and Models 
    • MDX multi-dimensional models and DAX for PowerPivot and Tabular models for use in Power BI reports. 
    • Develop Star and Snowflake schemas
    • Creating ETL and ELT jobs in ADF and SSIS, Databricks etc.
  • Nice to have: .net developer experience and knowledge of different frameworks. 
  • Able to work in different time zones if needed to support offshore teams and projects located in different countries and time zones
Prijavi se
Copyright © 2021 ·
Made with in Subotica.
Sadržaj sajta je u vlasništvu kompanije HelloWorld. Zabranjeno je njegovo preuzimanje bez dozvole.

Postavi pitanje poslodavcu

Prosledićemo tvoj upit poslodavcu samo ako je u vezi sa oglasima za posao na našem sajtu, apliciranjem na iste, praksom u datoj kompaniji i slično.
Čim dobijemo odgovor, poslaćemo ti ga na e-mail.
Uspešno
Neuspešno urađena operacija
Prijavi se u svoj nalog
Zaboravljena šifra?

Nisi registrovani korisnik? Napravi nalog ili se prijavi putem društvenih mreža.



Prijava putem društvenih mreža
Facebook LinkedIn Google

Kontaktiraj nas

Tvoja poruka će biti prosleđena timu HelloWorld.rs, a ne poslodavcu.

Potvrdi

Greška