SQL Lead
Role details
Job location
Tech stack
Job description
- Lead the development and implementation of high availability architecture for critical databases, ensuring minimal downtime and maximum system uptime through advanced tuning and clustering strategies.
- Design, develop, and optimize complex SQL queries, stored procedures, and PL/SQL scripts to enhance system performance and data processing efficiency.
- Manage database security protocols to safeguard sensitive information while supporting compliance with data management standards.
- Oversee database migration projects, including data model design, data recovery planning, and disaster recovery architecture to ensure business continuity.
- Collaborate with cross-functional teams to develop scalable ETL (Extract, Transform, Load) processes using tools such as SSIS (SQL Server Integration Services) for seamless data integration.
- Conduct system troubleshooting support by diagnosing performance issues, executing system tuning measures, and resolving technical challenges promptly.
- Implement best practices in database architecture design for systems utilizing Oracle, Microsoft SQL Server, MySQL, or Linux-based environments with Bash scripting expertise.
Requirements
We are seeking a dynamic and highly skilled SQL Lead to join our team and drive excellence in database management and architecture. In this pivotal role, you will oversee the design, implementation, and maintenance of robust database solutions that support our business operations. This individual must have a large understanding of the insurance sector, specifically wholesale brokerage., * Extensive experience with SQL databases including Oracle, Microsoft SQL Server, MySQL, and related technologies such as T-SQL and PL/SQL.
- Strong knowledge of high availability solutions like database clustering and replication techniques.
- Proficiency in Linux operating systems and shell scripting (Bash/Unix shell) for automation and system management tasks.
- Expertise in performance tuning strategies to improve system uptime through effective database tuning methods.
- Skilled in data model design, data migration strategies, and implementing disaster recovery architectures for resilient systems.
- Familiarity with ETL processes using tools like SSIS to facilitate efficient data integration workflows.
- Ability to troubleshoot complex technical issues related to database administration and system performance.
- Understanding of data management security principles to protect sensitive information against unauthorized access or breaches.
Join us as a SQL Lead where your technical prowess will directly influence our operational efficiency! We value proactive problem-solving, innovative thinking, and a passion for building reliable data solutions that empower our organization's growth.
Benefits & conditions
Pulled from the full job description
- Health insurance
- Flexible schedule