SQL Application DBA Engineer

Job Description

The ASD Service organization is looking for a passionate, high performing IT technologist to join the team as a SQL Application DBA Engineer . The ideal candidate will have a proven track record of guiding development teams through implementations of large-scale SQL database implementations for enterprise class applications. The selected candidate will be a best-practice expert, and strong mentor capable of educating the .Net developer staff with a focus on SQL best-practices.

Additional expectations will be to:

• Establish and promote SQL best practices guidelines and coding standards for all ASD application teams
• Performance monitoring and tuning of application SQL code for multiple ASD applications
• Participate in design and architecture review of application design, providing optimal design recommendations for application-to-database interaction
• Assist developers with complex query tuning and schema refinement
• Design, troubleshoot and optimize SSIS packages, and SSRS reports to meet business needs
• Review system DBA maintenance procedures and ensure they are appropriate for each application database
• Define and educate the application teams on proper schema update strategies that minimize application impact and allow for easy release role back
• Serve as escalation point for troubleshooting minor to major problems on an as-needed basis; often requiring time sensitive response and pro-active communication to technical audiences

Requirements:

• 5+ years as a SQL Application DBA, with emphasis on SQL query performance tuning
• Advanced skills in resolving database locking conflicts/blocking and resource utilization contention
• Ability to work with database developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and SQL server statistics
• Advanced experience in database health monitoring, performance monitoring, and troubleshooting
• A thorough understanding of Performance Monitoring, Tuning and Optimization, using native and third-party monitoring and troubleshooting tools is required
• Experience defining hardware requirements and storage capacity planning for development, testing, QA and production for capacity planning and performance optimization
• A thorough understanding of SQL Server AlwaysOn availability group technology
• In depth experience with SSIS packages and SSRS reports, and experience with Power BI is a plus
• A thorough understanding of the SQL DacPac deployment process
• Advanced PowerShell scripting experience with ability to write automation scripts is required
• Must be self-motivated, able to work in a team-oriented environment as well as possess the ability to organize, plan and lead projects independently
• Ability to share new ideas with the team and be able to think on your feet and recommend solutions
• Ability to work in a fast-paced environment, rapidly develop proficiency in new skills with a strong work ethic and a professional demeanor

Additional Preferred Skills:

• Bachelor’s degree in Computer Science or related field - Master’s degree a plus
• Knowledge of PowerShell for SQL is a plus
• Working knowledge of Windows Server Management such as disk administration, general performance health counters and overall server configuration.

Note: The safety of our associates, both current and future, is GEICO’s highest priority. Currently, most of our associates are working remotely due to the current COVID-19 pandemic. Candidates who are selected for this position will be trained remotely and must be able to work from home in a designated work area. Once GEICO determines it is safe for associates to return to the office, candidates may be required to work in our Chevy Chase, MD or Indianapolis, IN office. About GEICO For more than 75 years, GEICO has stood out from the rest of the insurance industry! We are one of the nation's largest and fastest-growing auto insurers thanks to our low rates, outstanding service and clever marketing. We're an industry leader employing thousands of dedicated and hard-working associates. As a wholly owned subsidiary of Berkshire Hathaway, we offer associates training and career advancement in a financially stable and rewarding workplace. Our associates' quality of life is important to us. Full-time GEICO associates are offered a comprehensive Total Rewards Program*, including:

• 401(k) and profit-sharing plans
• Medical, dental, vision and life insurance
• Paid vacation, holidays and leave programs
• Tuition reimbursement
• Associate assistance program
• Flexible spending accounts
• Business casual dress
• Fitness and dining facilities (at most locations)
• Associate clubs and sports teams
• Volunteer opportunities
• GEICO Federal Credit Union

* Benefit offerings for positions other than full-time may vary. GEICO is an equal opportunity employer. GEICO conducts drug screens and background checks on applicants who accept employment offers. How to Apply Click "Apply for Job" to complete your application. You will need an active email address and phone number. Please upload your resume, preferably as Word .doc files or PDF. Once you begin your application you can save it and access it later. Your application should include any work and/or internship experience from at least the past five years. #LI-JW1 #DI-JW