Specialist, Technology Engineer - SQL DBA

Nationwide Insurance; Scottsdale (AZ); On-site; USD 80,000 - 100,000; Full time

Job summary

Nationwide Insurance is seeking a skilled SQL Server Database Administrator to join their IT team in Scottsdale, Arizona. The role involves managing and optimizing SQL Server databases, ensuring high availability and performance, and collaborating with development teams. Ideal candidates will possess strong SQL Server knowledge and a continuous improvement mindset, with a focus on automation and efficiency.

Qualifications

• Deep SQL Server database knowledge required.
• Strong communication and problem-solving skills needed.
• Experience with database security and backup/recovery processes.

Responsibilities

• Conduct database capacity planning and scalability.
• Provide 24x7 on-call support for critical production systems.
• Develop and maintain comprehensive documentation for database processes.

Skills

SQL Server

Communication

Problem Solving

Attention to Detail

Tools

PowerShell

SSIS

SSRS

SSAS

Oracle

Postgres

VMWare

Azure

AWS

Job description

If you’re passionate about innovation and love working in an environment where you can constantly improve and adopt new technologies to drive business results, then Nationwide’s Information Technology team could be the place for you! At Nationwide, “on your side” goes beyond just words. Our customers are at the center of everything we do, and we’re looking for associates who are passionate about delivering extraordinary care.

We are seeking a skilled SQL Server DBA to join our dynamic team and help us manage and optimize our database systems.

The SQL Server Database Administrator will be responsible for the installation, configuration, maintenance, and performance tuning of SQL Server databases. The ideal candidate will ensure the availability and consistent performance of our applications and databases. This role requires deep SQL Server database knowledge, strong communication and problem-solving skills, and attention to detail. The candidate will have a continuous improvement mindset, with the desire to automate processes and reduce manual effort wherever possible.

Database Experience:

1. Installation and Configuration: Install and configure SQL Server databases to meet business requirements.
2. Performance Monitoring: Monitor system performance and identify potential issues.
3. Optimization: Perform database tuning using T-SQL and optimize queries.
4. Security Management: Implement and manage database security measures to protect sensitive data.
5. Backup and Recovery: Conduct regular backups and ensure reliable recovery processes.
6. High Availability: Manage SQL AlwaysOn configurations.
7. Change Tracking: Implement and manage Change Tracking and Change Data Capture.
8. Integration Services: Familiarity with SSIS, SSRS, and SSAS.
9. Scripting: Utilize PowerShell or other scripting languages (a plus).
10. Additional Database Knowledge: Knowledge of Oracle and Postgres (a plus).

Key Responsibilities:

1. Conduct database capacity planning to ensure scalability.
2. Work closely with development teams to design and implement effective database solutions.
3. Use DPA for database monitoring and SQL tuning.
4. Provide 24x7 on-call support for critical production systems.
5. Manage application and infrastructure releases.
6. Develop and maintain comprehensive documentation for database processes.
7. Implement backup and recovery strategies using native and third-party tools (e.g., Cohesity).
8. Create and manage new database servers in a virtual environment (VMWare).
9. Perform server migrations as needed.
10. Support SQL databases in public cloud environments (Azure and AWS).

Compensation grade: F5