Apply on Employer Site

Brown & Brown · 3 hours ago

SQL Database Administrator

Addison, TX

Full-time

Onsite

Mid, Senior Level

4+ years exp

Brown & Brown is an independent insurance intermediary providing a variety of insurance and reinsurance products. The SQL Server DBA will support internal technology services, ensuring that application business needs and performance requirements are met while collaborating with IT professionals.

Insurance

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

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

Qualification

Microsoft SQL ServerT-SQLDatabase backup strategiesQuery optimizationMicrosoft Azure servicesDatabase design principlesDatabase security best practicesProblem-solving skillsAdaptabilityTime managementCollaboration

Required

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