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
Paid Vacation, Sick and Parental Leave
401(k) Plan
Tuition Reimbursement
Paid Training and Licensures
*Benefits may be different by location. Benefit eligibility requirements vary and may include length of service.
Coverage begins on the date of hire. Must enroll in New Hire Benefits within 30 days of the date of hire for coverage to take effect.
GEICO is proud to be an equal opportunity employer. We are committed to cultivating an environment where equal employment opportunities are available to all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. GEICO celebrates diversity and believes it is critical to our success. As such, we are committed to recruit, develop and retain the most talented individuals to join our team.
#LI-PK1
#Dice
Annual Salary
$82,000.00 - $185,000.00
The above annual salary range is a general guideline. Multiple factors are taken into consideration to arrive at the final hourly rate/ annual salary to be offered to the selected candidate. Factors include, but are not limited to, the scope and responsibilities of the role, the selected candidate's work experience, education and training, the work location as well as market and business considerations.
At this time, GEICO will not sponsor a new applicant for employment authorization for this position.
Benefits:
As an Associate, you'll enjoy our Total Rewards Program * to help secure your financial future and preserve your health and well-being, including:
- Premier Medical, Dental and Vision Insurance with no waiting period
- Paid Vacation, Sick and Parental Leave
- 401(k) Plan
- Tuition Reimbursement
- Paid Training and Licensures
Coverage begins on the date of hire. Must enroll in New Hire Benefits within 30 days of the date of hire for coverage to take effect.
The equal employment opportunity policy of the GEICO Companies provides for a fair and equal employment opportunity for all associates and job applicants regardless of race, color, religious creed, national origin, ancestry, age, gender, pregnancy, sexual orientation, gender identity, marital status, familial status, disability or genetic information, in compliance with applicable federal, state and local law. GEICO hires and promotes individuals solely on the basis of their qualifications for the job to be filled.
GEICO reasonably accommodates qualified individuals with disabilities to enable them to receive equal employment opportunity and/or perform the essential functions of the job, unless the accommodation would impose an undue hardship to the Company. This applies to all applicants and associates. GEICO also provides a work environment in which each associate is able to be productive and work to the best of their ability. We do not condone or tolerate an atmosphere of intimidation or harassment. We expect and require the cooperation of all associates in maintaining an atmosphere free from discrimination and harassment with mutual respect by and for all associates and applicants.