SQL Database Administrator
Company: Oxford Life Insurance Company
Oxford Life Insurance Company was founded in 1965 and is a member of AMERCO, a publicly traded financial holding network. AMERCO's other significant holdings including U-Haul International and Republic Western Insurance Company. Our fast paced, growing company is seeking eager, qualified, customer-centric individuals to join our team in Phoenix, AZ.
Job Overview:
Oxford Life Insurance is looking for a SQL Database Administrator to be responsible for working with a team of Web Developers. In this challenging role you will be responsible for comprehensively overseeing projects, designing and developing web architecture, and guiding and mentoring a team. In exchange, this rewarding position comes with excellent benefits.
To be successful as a DBA, you should be comfortable working within a team, have a keen eye for detail, and have excellent organizational skills. Ultimately, a top-notch DBA should have strong technical qualities, be able to provide guidance and support, and be highly accurate.
The SQL team does end to end care of a large-scale enterprise MS SQL Servers.
Assist the application teams and developers with requests for anything from new users/roles, to standing up an entire new clustered instance, which is fully compliant with security standards.
Actively support our internal IT teams as well as our vendors performing regular maintenance/patching for a wide variety of MS SQL server deployment.
The ideal candidate is a self-motivated, multi-tasker, and demonstrated team player. You will be a lead developer responsible for the development of new software products and enhancements to existing products. You should excel in working with large-scale applications and frameworks and have outstanding communication and leadership skills.
Understanding and familiarity with WCF, and web service development using the .Net platform with VB.Net, C# and XML., experience with C# and VB.NET 4.0, XML, WCF, and business to business integration using SOAP or REST, as well as knowledge of Domain Driven Development, Service Oriented Architectures, and experience in backend service development will be helpful.
Monitor performance and health; complete regular internal system audits; prepare for upgrades; implement changes; and apply patches when required. Design and maintain reports to monitor the health, use deduplication tools to scrub duplicate data from the database, and use Apex tests, field utilization reports. Troubleshooting application key selection, creation of appropriate indexes, and queries as needed.
Responsibilities
Managing SQL Server & Database access
Monitor and respond to SQL server performance degradation
Make optimization recommendations to SQL queries
Troubleshoot issues with applications connecting to SQL databases
Perform SQL server and database maintenance
Monitor database backups
Respond to capacity issues on database servers
Collaborate with other team members to ensure project meets business objectives and compliance standards
Support test and deployment of new products and features
Participate in code reviews
Qualifications
Bachelor's degree in Computer Science (or related field)
5+ years of relevant work experience can be substituted for education
Expertise in Object-Oriented Design, Database Design, and XML Schema
Experience with Agile or Scrum software development methodologies
Ability to multi-task, organize, and prioritize work
Experience unit testing
Experience with / understanding of modern Design Patterns
Azure Experience (Wiki, Pipelines, continuous integration)
Preferred Qualifications
Experience working with SQL in multiple datacenters
Experience running SQL in Azure
Experience with Grafana
Preferred certifications: SQL MCSA
Languages & Technologies:
.NET Framework, .NET Core, C#,
ASP.NET WebApi, MVC, Web Forms
AJAX, SOAP, XML, JSON
SQL (T-SQL), HTML, CSS,
JavaScript & Common JavaScript Libraries: Angular, jQuery, pdf.js
Agile / Scrum, Continuous Integration / Continuous Delivery
OAuth Libraries for C# (implementation/deployment experience), IdentityServer4
Perks of joining the U-Haul fleet:
Get your career moving with a company who empowers team members to the healthiest version of themselves! We provide robust wellness benefits, events, and resources to help team members becomes the happiest and healthiest they can be.
Here are just some of the programs U-Haul has available:
- Full Medical coverage
- Prescription plans
- Dental & Vision Plans
- New indoor fitness gym
- Gym Reimbursement Program
- Registered Dietitian Program
- Weight Watchers
- Onsite medical clinic for you and your family
- Career stability
- Opportunities for advancement
- Valuable on-the-job training
- Tuition reimbursement program
- Free online courses for personal and professional development at U-Haul University®
- Business and travel insurance
- You Matter Employee Assistance Program
- Paid holidays, vacation, and sick days
- Employee Stock Ownership Plan (ESOP)
- 401(k) Savings Plan
- Life insurance
- Critical Illness/Group Accident
- 24-hour physician available for kids
- Subsidized gym/ membership
- MetLaw Legal program
- MetLife auto and home insurance
- Mindset App Program
- Discounts on cell phone plans, hotels, and more
- LifeLock identity Theft
- Savvy consumer wellness programs- from health care tips to financial wellness
- Dave Ramsey’s SmartDollar Program
- U-Haul federal credit union
- Wellness Program
U-Haul is an equal opportunity employer. All applications for employment will be considered without regard to race, color, religion, sex, national origin, physical or mental disability, veteran status, or any other basis protected by applicable federal, provincial, state, or local law. Individual accommodations are available on requests for applicants taking part in all aspects of the selection process. Information obtained during this process will only be shared on a need to know basis.