Job description
NPS Prism is a market-leading, cloud-based CX benchmarking and operational improvement platform owned by Bain & Company. NPS Prism provides its customers with actionable insights and analysis that guide the creation of game-changing customer experiences. 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 with industry standards. - 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. - Participate in strategic planning for database infrastructure improvements and scalability.
Requirements
- Bachelor's degree in computer science, information technology, or a related field. - 7+ years of experience as an SQL Database Administrator. - 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. - Familiarity with cloud database services (Azure, AWS RDS) is preferred. - Experience with SSIS, SSRS, and SSAS is a plus. - Experience with Databricks SQL Warehousing is a plus. - Experience with DB Migration is a plus, specially from one cloud to another.