Senior Application DBA Engineer

At The Estée Lauder Companies (ELC), we believe that technology will power the future of beauty. Across more than 25 globally recognized brands sold in over 150 countries and territories, we use technology to reinvent and redefine how consumers worldwide explore and express their individual beauty. Infused throughout our organization is a passion for creativity and innovation and a desire to push the boundaries and invent the unexpected. Our Digital Technology Centers are made up of talented individuals who exemplify ELC’s heritage of high-performance, innovation, and family values. We’re looking for creators, leaders, and visionaries with the passion and imagination to shape the next generation of beauty products and experiences. We’re hiring technologists at all levels. The Application DBA / Engineer is a hands-on expert in analyzing and remediating performance issues across the Azure database landscape. This position is responsible for continual performance improvement and associated maintenance processes ensuring optimal performance of the EDL Consumption layer. The Application DBA / Engineer will lead the effort to establish performance standards and automate performance management. Through collaboration and demonstrations with data and project teams, this role will develop data integration (ETL) standards and guidelines and influence data integration design ensuring best practices are followed across projects delivering consistency and maximizing performance across solutions. Key Activities Performance and tuning of Azure databases Establish, automate and maintain database performance and maintenance processes Establish, automate and maintain database audit capabilities Work with data modeling lead and project teams developing and implementing standards and best practices for both physical data model design and SQL coding Work with data integration and EDL engineering teams developing and implementing ETL standards and best practices on Databricks platform and Azure databases Implement, manage & optimize row level security solutions in EDL consumption layer Perform functional analysis of new database systems guiding evolution of EDL Consumption layer Participate in the evaluation and implementation of data management technologies and solutions Qualifications Technical Competencies: Expertise with Azure SQL databases Deep understanding of Azure Cosmos and Synapse (Databricks Lakehouse is a plus) Database performance management expert Expert in database performance & tuning practices and concepts; proven hands-on performance and tuning expertise in Azure cloud environment; ability to tune physical data models across Azure cloud database offerings Expert experience automating database maintenance processes Excellent SQL coding skills Excellent Python coding skills Strong, proven experience developing ETL standards Strong, proven physical data modeling skills & experience defining and optimizing data access patterns Experience developing in Databricks environment Strong understanding of concepts in Data Management Functional Capabilities: Expert understanding of Cloud based database systems Expert understanding of relational databases and associated performance management techniques & solutions Expert understanding of SQL coding techniques, relational databases, and best practices, especially in regard to performance management Deep understanding of data integration (ETL) design and development Manages performance of EDL consumption platform Develops and maintains performance management standards and guidelines Develops and maintains data integration (ETL) standards and guidelines Supporting a federated community of data engineers loading data into the EDL consumption layer Solid understanding of row level security implementations, database functionality implementing row level security, and associated performance and & tuning considerations. Understands ELC EDL technical landscape and integration processes Drives automation and efficiencies of performance management and ETL solutions Experience installing and maintaining database and data management platforms (ETL, Master Data, Data Quality, etc.) Strong communications skills to collaborate with the virtual global team and drive consensus with project and technical teams Pragmatic approach to deliver incremental value to the organization Comfortable within a global, complex, highly matrixed organization Ability to establish credibility and be decisive – but able to recognize and support the organization’s preferences and priorities. Job: Information Technology Primary Location: RO-B-Bucharest Job Type: Standard Schedule: Full-time Shift: 1st (Day) Shift Job Number: 221762