Senior Database Administrator

NielsenIQ; Colombia; Híbrido; COP 60.000.000 - 90.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible working environment

Volunteer time off

Descripción de la vacante

NielsenIQ is seeking a Database Administrator to support SQL Server databases hosted in Microsoft Azure across multiple environments. The role focuses on performance, incident investigation, configuration, integrity, and high-availability.

Responsibilities include roadmap contribution for cloud adoption, backup procedures, DR/HADR, and code deployments, with an emphasis on security and least privilege across environments.

Formación

• Significant experience of Microsoft SQL Server administration with Production support.
• Knowledge of Microsoft Clustering and virtualisation concepts.
• Experience with AlwaysOn Availability Groups.
• Strong understanding of T-SQL languages.
• Good knowledge of source control/versioning approaches.

Responsabilidades

• Contribute to SQL Database roadmap and cloud technology adoption.
• Maintain integrity and performance of all database platforms across environments.
• Ensure backups and disaster recovery procedures are in place.
• Maintain high-availability and disaster recovery (HADR) systems including failover/failback.
• Provide administration and support for security, SQL Agent Jobs, SSIS Packages.
• Deliver database-related code deployments across platforms and environments.

Conocimientos

SQL Server

AlwaysOn Availability Groups

PowerShell

T-SQL

Azure

Clustering

English communication

Herramientas

SQL Server Management Studio

Descripción del empleo

Nielsen Brandbank’s database estate consists of SQL Server databases in several different environments, hosted in Microsoft Azure. The Database Administrator will be responsible for providing support for multiple Database platforms across different environments. Areas of focus will consist of: maintaining performance; incident investigation; configuration and administration; integrity and high-availability.

Job Description

• Contribute to the SQL Database roadmap and strategy for the adoption of cloud technologies.
• Maintain the integrity and performance of all Database platforms across all environments through regular maintenance and monitoring.
• Ensure Backup procedures are in place and available for Disaster Recovery procedures.
• Maintain the high-availability and disaster recovery (HADR) systems including performing failover and failback.
• Provide administration and support for areas surrounding Security, SQL Agent Jobs, SSIS Packages.
• Provide consultancy and code reviews to other areas of the IT department regarding Database design and performance whilst adhering to industry-standard best practices and community recommendations.
• Support and deliver Database related code deployments across all platforms and environments for other IT teams.
• Ensuring adherence to Principle of Least Privilege with regards to security and access permissions in all environments.
• Provide continual performance tuning and optimisation ideas/solution with relevant information/understanding to support them.
• Govern and control Database Source Control policies and adherence.
• Responsible for providing regular Database environment refreshes.
• Working on Projects ranging from small to medium relating to Database platforms.
• Create, maintain and improve upon all Database documentation and processes.
• Provide very occasional Database support outside of normal working hours.

Qualifications

• Significant experience of Microsoft SQL Server administration with Production support.
• Knowledge of Microsoft Clustering and virtualisation concepts.
• Experience of working with and supporting AlwaysOn Availability Groups.
• Strong understanding and experience of using T-SQL languages.
• Good understanding and experience of source control and versioning methodologies and technologies.
• Able to work within a team environment and also independently.
• Good understanding and experience of using PowerShell.
• Good communication skills, both written and verbal in English.
• Strong drive to learn, develop, and continually improve and automate the estate.
• Good analytical and problem solving skills.
• Ability to work in a global cross-functional team environment.

Additional Information

• Preferred but not essential
• Experience in other Database platforms, i.e. MySQL, MariaDB, CosmosDB, Postgres.
• Experience of managing Power BI solutions on-premise.
• Experience with RedGate tools.
• ITIL and Agile practices.
• Experience with cloud-hosted database platforms.

• Flexible working environment
• Volunteer time off

About NIQ

NIQ is the world’s leading consumer intelligence company, delivering the most complete understanding of consumer buying behavior and revealing new pathways to growth. In 2023, NIQ combined with GfK, bringing together the two industry leaders with unparalleled global reach. With a holistic retail read and the most comprehensive consumer insights—delivered with advanced analytics through state-of-the-art platforms - NIQ delivers the Full View. NIQ is an Advent International portfolio company with operations in 100+ markets, covering more than 90% of the world’s population.

For more information, visit NIQ.com

Want to keep up with our latest updates?

Our commitment to Diversity, Equity, and Inclusion

NIQ is committed to reflecting the diversity of the clients, communities, and markets we measure within our own workforce. We exist to count everyone and are on a mission to systematically embed inclusion and diversity into all aspects of our workforce, measurement, and products. We enthusiastically invite candidates who share that mission to join us. We are proud to be an Equal Opportunity/Affirmative Action-Employer, making decisions without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, protected veteran status or any other protected class. Our global non-discrimination policy covers these protected classes in every market in which we do business worldwide. Learn more about how we are driving diversity and inclusion in everything we do by visiting the NIQ News Center:https://nielseniq.com/global/en/news-center/diversity-inclusion