SQL Database Administrator - Phoenix, United States - U-Haul

Description

Location:
2721 N Central Ave, Phoenix, Arizona 85036 United States of America


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,

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 Holding Company, and its family of companies including U-Haul International, Inc. ("U-Haul"), continually strives to create a culture of health and wellness. Consistent with applicable state law, U-Haul will not hire or re-hire individuals who use nicotine products.

The states in which U-Haul will decline to hire nicotine users are:

Alabama, Alaska, Arizona, Arkansas, Delaware, Florida, Georgia, Hawaii, Idaho, Iowa, Kansas, Maryland, Massachusetts, Michigan, Nebraska, Pennsylvania, Texas, Utah, Vermont, Virginia, and Washington.

U-Haul has observed this hiring practice since February 1, 2020 as part of our commitment to a healthy work environment for our team.

U-Haul is an equal opportunity employer.

All applicants 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.

Since 1945, U-Haul has been serving do-it-yourself movers and their households. Like many other successful ventures, the concept for U-Haul was generated out of need.

After World War II, there existed the widespread need for do-it-yourself moving equipment that would be available on a one-way, nationwide basis.

U-Haul co-founders L.S. "Sam" Shoen and his wife, Anna Mary Carty Shoen, recognized that need and acted upon it.

Their visionary approach spread the cost of ownership among many users, facilitating the mobility of the populations of the U.S.

and Canada. The covered wagon of the pioneers morphed into orange U-Haul trailers. In the process, an industry was born.