Senior Engineer – DBA (SQL)

GEICO is seeking an experienced Engineer with a passion for building high-performance, low maintenance, zero-downtime platforms, and applications. You will help drive our insurance business transformation as we transition from a traditional IT model to a tech organization with engineering excellence as its mission, while co-creating the culture of psychological safety and continuous improvement.

Position Description:
Our Senior Engineer is a key member of the engineering staff working across the organization to provide a friction-less experience to our customers and maintain the highest standards of protection and availability. Our team thrives and succeeds in delivering high quality technology products and services in a hyper-growth environment where priorities shift quickly. The ideal candidate has broad and deep technical knowledge with Microsoft SQL Server and will make meaningful enhancements to the company’s databases.

Position Responsibilities:
As a Senior Engineer, you will:
• Develop and implement stored producers and functions
• Monitor database, identify bottlenecks and implement optimization strategies to ensure optimal performance
• Collaborate with development teams to optimize SQL queries, database code, and stored procedures
• Perform database design, data modeling and schema management to support application requirements and performance goals
• Identify, design, and develop data archiving strategies
• Develop and/or publish key performance metrics to track data archiving progress of activate initiatives
• Assist in educating developers on the finer points of database development
• Familiar with programming languages like SSIS, Java, C# or other object-oriented languages, Python, SQL, and NoSQL databases
• Mentor other engineers
• Consistently share best practices and improve processes within and across teams

Qualifications:
• Deep theoretical database knowledge
• Expert level skills in SQL Development with ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, constraints)
• Expert knowledge in creating complex SQL queries, performance tuning and optimization, using native monitoring and troubleshooting tools
• Expert knowledge of indexes, index management and statistics
• Proficient with Query Store or equivalent tools
• Hands-on experience with the programming languages Java, C# or other object-oriented languages is preferred
• Knowledge of the Microsoft development platform
• Knowledge of troubleshooting and resolving database integrity, blocking and deadlocking, performance, connectivity, and security issues
• Ability to detect and troubleshoot SQL Server related I/O, memory, disk space, CPU, and other resource issues
• Significant experience working with large databases
• Significant experience using SSIS/SSRS
• Experience in the complete software development life cycle
• Advanced understanding of DevOps concepts including Azure DevOps framework and tools
• Advanced PowerShell scripting skills
• Knowledge of Mirco-services architecture and extensible REST APIs
• Advanced understanding of monitoring concepts and tooling
• Advanced understanding of security protocols and products
• Experience with continuous delivery and infrastructure as code
• In-depth knowledge of CS data structures and algorithms
• Knowledge of developer tooling across the software development life cycle (task management, source code, building, deployment, operations, real-time communication)
• Strong analytical and problem-solving ability
• Excellent verbal and written communication skills
• Ability to excel in a fast-paced environment

Experience:
• 4+ years of professional experience with Microsoft SQL server performance tuning, and data archiving and development of quality database archiving solutions
• 3+ years of experience with architecture and design
• 3+ years of experience with AWS, GCP, Azure, or another cloud service
• 2+ years of experience in open-source frameworks

Education:
•Bachelor’s degree in Computer Science, Information Systems, or equivalent education or work experience

BENEFITS: 
At GEICO, we make sure you have the support and resources to leverage and develop your skills, secure your financial future, and take care of your health and well-being. GEICO continually seeks to provide a workplace where everyone can be their authentic self. To help achieve this goal, we support associate-led Employee Resource Groups that foster a true sense of community. Through GEICO’s competitive benefits offerings and various training and development opportunities, we have you covered with our Total Rewards Program* that includes: 
  
Premier Medical, Dental and Vision Insurance with no waiting period** 
Pai