SQL Database Administrator

Brown & Brown - Addison, TX

Full-time - Mid Level

Addison, TX

Insurance Carriers and Related Activities

About the position

The SQL Server DBA position at Brown & Brown involves providing internal support for technology used by the organization to enhance services for internal users. The role requires a blend of technical skills across various technologies and necessitates interaction with both user and technical communities to ensure that application business needs and performance requirements are met.

Responsibilities

• Collaboration 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.

Requirements

• A bachelor's degree in computer science or information technology
• 4+ years of experience as a Database Administrator
• Proficiency in Microsoft Office Products including Visio
• 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.
• Ability to work independently, with limited required direction and guidance.

Nice-to-haves

• Microsoft Certified: Azure Database Administrator Associate
• Microsoft Certified: Data Administrator Associate
• Microsoft Certified: Azure Fundamentals

Benefits

• Excellent growth and advancement opportunities
• Competitive pay based on experience
• Discretionary Time Off (DTO)
• Generous benefits package: health, dental, vision, 401(k), etc.
• Employee Stock Purchase Plan
• Tuition Reimbursement and Student Loan Repayment Assistance
• Mental Health Resources