Brilliant
Database Engineer
Brilliant, Hollywood, Florida, United States, 33024
Responsibilities
Collaboration with developers, system administrators, and other IT professionals to ensure the database meets organizational needs.Create and modify database objects, including tables, views, functions, and stored procedures.Experience designing and delivering solutions for data pipelines, data integration, data transformation, analytics, reporting and modeling.Strong understanding of designing and delivering solutions in a cloud environment.Understanding of data modeling, data management and data governance principles.Experience in end-to-end Software Development Life Cycle (SDLC) projects.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.Manage user access and permissions, ensuring data confidentiality.Perform routine database maintenance tasks, such as index optimization and data purging.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.Passion for learning new technologies and enhancing existing skills.Work within a DevOps environment or similar environment.Perform other duties as assigned.
Required
A bachelor's degree in computer science or information technology7+ years of experience as a Database ProfessionalProficiency in Microsoft Office Products including VisioIn-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.Knowledge of database backup and recovery strategies, with Transparent Data Encryption (TDE), including Azure-based solutions.Understanding of database security best practices, including role-based access control, encryption, and auditingAbility to work independently, with limited required direction and guidance.
Preferred
Experience engineering, implementing, and supporting data solutions in Azure.Experience working with Agile/Scrum methodologies.12+ years of related work experience.Microsoft Azure Solutions Architect Expert, Azure Data Engineer Associate, Azure Database Administrator Associate, or equivalent certification(s).Experience in the insurance industry and/or basic knowledge of insurance.
#tech2023#J-18808-Ljbffr
Collaboration with developers, system administrators, and other IT professionals to ensure the database meets organizational needs.Create and modify database objects, including tables, views, functions, and stored procedures.Experience designing and delivering solutions for data pipelines, data integration, data transformation, analytics, reporting and modeling.Strong understanding of designing and delivering solutions in a cloud environment.Understanding of data modeling, data management and data governance principles.Experience in end-to-end Software Development Life Cycle (SDLC) projects.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.Manage user access and permissions, ensuring data confidentiality.Perform routine database maintenance tasks, such as index optimization and data purging.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.Passion for learning new technologies and enhancing existing skills.Work within a DevOps environment or similar environment.Perform other duties as assigned.
Required
A bachelor's degree in computer science or information technology7+ years of experience as a Database ProfessionalProficiency in Microsoft Office Products including VisioIn-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.Knowledge of database backup and recovery strategies, with Transparent Data Encryption (TDE), including Azure-based solutions.Understanding of database security best practices, including role-based access control, encryption, and auditingAbility to work independently, with limited required direction and guidance.
Preferred
Experience engineering, implementing, and supporting data solutions in Azure.Experience working with Agile/Scrum methodologies.12+ years of related work experience.Microsoft Azure Solutions Architect Expert, Azure Data Engineer Associate, Azure Database Administrator Associate, or equivalent certification(s).Experience in the insurance industry and/or basic knowledge of insurance.
#tech2023#J-18808-Ljbffr