SQL Server Database Administrator

Brown & Brown Insurance • Plano, TX

1d

About The Position

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers. Brown & Brown is seeking an SQL Server Database Administrator to join our growing team in Plano, TX. How You Will Contribute: Collaborate with developers, system administrators, and other IT professionals to ensure the database meets organizational needs. Install and configure SQL database systems. Create and modify database objects, including tables, views, functions and stored procedures. Implement and maintain regular database backups. Develop and test disaster recovery plans. Monitor database performance and identify bottlenecks. Optimize SQL queries and database configurations for improved efficiency. Implement database security measures to protect sensitive data. Manage user access and permissions, ensuring data confidentiality. Apply software patches and updates to maintain system stability. Perform routine database maintenance tasks, such as index optimization and data purging. Scale database systems as needed to accommodate growth. Set up monitoring tools to proactively detect and resolve database issues. Maintain documentation of database configurations, processes, procedures, & schema diagrams. Provide technical support and guidance to colleagues as needed. Strong analytical and problem-solving skills to diagnose and resolve database-related issues. The ability to adapt to new technologies and keep up with industry trends and best practices. Efficiently manage multiple tasks, prioritize work, and meet deadlines. Work within a DevOps environment or similar environment. Perform other duties as assigned.

Requirements

• Bachelor's degree in computer science or information technology
• Four or more years of experience as a Database Administrator
• Ability to participate in daily meetings
• Proficiency in Microsoft Office Products
• Ability to work independently, with limited required direction and guidance.
• In-depth knowledge of Microsoft SQL Server, including various versions such as SQL Server and Azure SQL Database.
• Familiarity with Microsoft Azure services related to SQL databases, such as Azure SQL Database, Azure SQL Managed Instance, Data Bricks, Azure Blob Storage, and Azure Data Factory.
• Understanding of database design principles, normalization, denormalization, and SQL Query Plan Optimization.
• Proficiency in query optimization, indexing, and performance tuning to ensure optimal database performance.
• Strong knowledge of T-SQL for automating database tasks and maintenance.
• Knowledge of database backup and recovery strategies, with Transparent Data Encryption (TDE), including both on-premises and Azure-based solutions.
• Understanding of database security best practices, including role-based access control, encryption, and auditing.
• Experience with setting up and managing high availability solutions and disaster recovery solutions.
• Ability to use monitoring tools and troubleshoot database-related issues effectively.
• Understanding of cloud computing concepts and experience working with Azure services and resource management.

Nice To Haves

• Microsoft Certified (preferred): Azure Database Administrator Associate Data Administrator Associate Azure Fundamentals Azure Solutions Architect Expert (for those responsible for designing Azure solutions)
• Oracle experience (preferred)

Responsibilities

• Collaborate with developers, system administrators, and other IT professionals to ensure the database meets organizational needs.
• Install and configure SQL database systems.
• Create and modify database objects, including tables, views, functions and stored procedures.
• Implement and maintain regular database backups.
• Develop and test disaster recovery plans.
• Monitor database performance and identify bottlenecks.
• Optimize SQL queries and database configurations for improved efficiency.
• Implement database security measures to protect sensitive data.
• Manage user access and permissions, ensuring data confidentiality.
• Apply software patches and updates to maintain system stability.
• Perform routine database maintenance tasks, such as index optimization and data purging.
• Scale database systems as needed to accommodate growth.
• Set up monitoring tools to proactively detect and resolve database issues.
• Maintain documentation of database configurations, processes, procedures, & schema diagrams.
• Provide technical support and guidance to colleagues as needed.
• Strong analytical and problem-solving skills to diagnose and resolve database-related issues.
• The ability to adapt to new technologies and keep up with industry trends and best practices.
• Efficiently manage multiple tasks, prioritize work, and meet deadlines.
• Work within a DevOps environment or similar environment.
• Perform other duties as assigned.

Benefits

• Health Benefits: Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance
• Financial Benefits: ESPP; 401k; Student Loan Assistance; Tuition Reimbursement
• Mental Health & Wellness: Free Mental Health & Enhanced Advocacy Services
• Beyond Benefits: Paid Time Off, Holidays, Preferred Partner Discounts and more.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level