Azure Database Administrator

**Overview**:
Guidepoint's Engineering team thrives on delivering innovative technology solutions that accelerate revenue growth, reduce costs, and increase efficiency and productivity. As Guidepoint achieves its mission of making individuals, businesses, and the world smarter through personalized knowledge-sharing solutions, the engineering team is taking on challenges to create new products and improve existing platforms to optimize the seamless delivery of our services.

**What You'll Do**:
Azure SQL Database Management
- Design, implement, and manage Azure SQL Databases to ensure performance, scalability, and reliability.
- Optimize database performance, including query tuning, indexing, and partitioning strategies.
- Set up and manage disaster recovery and backup processes for Azure SQL environments.
- Ensure high availability through replication, failover, and other redundancy measures.

Cosmos DB and SQL Server Administration
- Manage and optimize Cosmos DB instances, focusing on throughput, latency, and cost management.
- Administer SQL Server VMs and SQL Server clusters, performing regular patching, upgrades, and performance monitoring.
- Implement security measures, including encryption, authentication, and access control for databases.

Database Security & Compliance
- Enforce best practices for database security, including data masking, encryption, and role-based access control.
- Ensure compliance with relevant data regulations (e.g., GDPR, HIPAA) and internal policies.
- Conduct regular audits and implement solutions for data governance and security.

Leadership & Mentorship
- Lead a team of database administrators and engineers, guiding best practices and technical solutions.

Monitoring & Automation
- Set up monitoring solutions for database health, performance, and capacity planning using Azure Monitor and other tools.
- Automate routine database administration tasks using PowerShell, Azure CLI, and ARM templates.
- Implement database infrastructure as code (IAAS, PAAS,) using Terraform or similar tools.

Collaboration & Support
- Provide 24/7 support for critical database systems and assist with troubleshooting complex database issues.
- Collaborate with stakeholders to design and implement database solutions that align with business objectives.

Documentation & Reporting
- Maintain comprehensive documentation for database architecture, processes, and configurations.
- Produce regular reports on database performance, availability, and usage metrics.
- Present technical updates and recommendations to senior management.

**Required Technical Qualifications**:

- Minimum of 10 years of experience as a Database Administrator, with at least 5 years working with Azure SQL Databases.
- Microsoft Azure certifications (e.g., Azure Database Administrator Associate, Azure Solutions Architect) are preferred.
- Deep knowledge of Azure SQL Database architecture, Cosmos DB, and SQL Server.
- Proficiency in T-SQL, PowerShell, and database management tools.
- Experience with cloud platforms (Azure) and automation tools (Azure CLI, ARM templates).
- Familiarity with ETL processes, data pipeline development, and big data processing.
- Knowledge of database security best practices and compliance requirements.

**Preferred Qualifications**:

- Bachelor's degree in computer science, Information Technology, or a related field.
- Expertise in Cosmos DB, SQL Server VMs, and Windows Clustering.
- Extensive experience in high availability, disaster recovery, and performance tuning.

**Competencies**:

- Strong problem-solving and analytical skills.
- Excellent leadership and mentorship abilities.
- Effective communication and interpersonal skills.
- Ability to work in a fast-paced, dynamic environment and manage multiple priorities.

**What We Offer**:

- Competitive compensation
- Employee medical coverage
- Central office location
- Entrepreneurial environment, autonomy, and fast decisions
- Casual work environment

**About Guidepoint**

Guidepoint is a leading research enablement platform designed to advance understanding and empower our clients' decision-making process. Powered by innovative technology, real-time data, and hard-to-source expertise, we help our clients to turn answers into action.

Backed by a network of nearly 1.5 million experts and Guidepoint's 1,300 employees worldwide, we inform leading organizations' research by delivering on-demand intelligence and research on request. With Guidepoint, companies and investors can better navigate the abundance of information available today, making it both more useful and more powerful.

At Guidepoint, our success relies on the diversity of our employees, advisors, and client base, which allows us to create connections that offer a wealth of perspectives. We are committed to upholding policies that contribute to an equitable and welcoming environment for our community, regardless of background, identity, or experience.

LI-NJ1

LI-HYBRID