Senior SQL Database Administrator DBA (Brazil, Remote)

About NPS Prism

NPS Prism is a market-leading, cloud-based CX benchmarking and operational improvement platform, wholly owned by Bain & Company. We provide customers with actionable insights and analysis to create game-changing customer experiences, allowing them to compare their performance against competitors on overall NPS® and across the customer journey. Launched in 2019, NPS Prism has grown to over 200 employees and serves dozens of global clients. As part of Bain & Company, we uphold a commitment to diversity, inclusion, and collaboration, fostering an environment where talented individuals can thrive.

What You'll Do

We are seeking a Senior SQL Database Administrator (DBA) to manage our database infrastructure. The ideal candidate will ensure the security, integrity, and performance of our databases while implementing best practices for data management, backup, and recovery.

Key Responsibilities

• Design, install, configure, and maintain SQL Server databases to support business applications.
• Monitor database performance, implement tuning improvements, and optimize SQL queries.
• Develop and manage database security, ensuring data integrity and compliance.
• Perform regular database backups, recovery testing, and disaster recovery planning.
• Automate database processes and implement monitoring tools for proactive issue resolution.
• Troubleshoot database-related issues and provide timely resolutions.
• Implement and maintain high availability (HA) and disaster recovery (DR) solutions.
• Maintain detailed documentation of database configurations, procedures, and policies.
• Stay updated with the latest advancements in database technologies and best practices.
• Participate in strategic planning for database infrastructure improvements and scalability.

Requirements / Qualifications

• Education: Bachelor's degree in computer science, information technology, or a related field.
• Experience: 7+ years of experience as an SQL Database Administrator.
• Skills:
• Expertise in SQL Server (2016/2019/2022) and Azure SQL.
• Strong proficiency in T-SQL, stored procedures, indexing, and query optimization.
• Knowledge of backup and recovery strategies, high availability solutions (Always On, Mirroring, Replication).
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication, leadership, and teamwork abilities.

Preferred Skills

• Familiarity with cloud database services (Azure, AWS RDS).
• Experience with SSIS, SSRS, and SSAS.
• Experience with Databricks SQL Warehousing.
• Experience with DB Migration, especially between cloud platforms.