Senior Database Administrator

We are adding a Senior Database Administrator to our team!

Since 1909, National Guardian Life Insurance Company (NGL) has been one of America’s most successful and highly rated independent life insurance companies. We specialize in a suite of innovative products for life’s journey, giving people the financial stability, careful guidance and peace of mind to lead a life filled with confidence, dignity and grace.

NGL's Core Values – integrity, dependability, collaboration, compassion and growth are a foundation of our company and help to build on the interactions we have with our policyholders, partners, funeral homes and each other. We believe in creating an inclusive, welcoming environment for all where diversity is celebrated, and everyone is encouraged to live their best, most authentic self. We offer Employee Resource Groups for employees to get involved, learn, network, and offer professional and personal development opportunities.

With over 100 years of experience, our passion is to serve people. Learn more.

Work Environment: NGL offers a flexible work environment where employees can work fully remote, hybrid or onsite at our Madison, Wis. office. We support virtual working arrangements in certain states outside of WI.

The Senior Database Administrator is responsible for performing and overseeing database administration and development of database systems, following best practices for development, testing, implementation and maintenance. Additional responsibilities include providing cloud-specific expertise, including database management (SQL/No

SQL), cloud platform proficiency (AWS, Azure, GCP), automation and scripting (Python, Shell, Terraform), and security and compliance. The Senior Database Administrator works closely with NGL’s Enterprise Architect, Developers, System Administrators, and Security to ensure high availability, performance, and security of databases that support NGL’s systems. Tasks assigned to this level require an in-depth understanding of the business processes and solution requirements, as well as the ability to identify and foresee problems, and the ability to perform analyses in order to recommend a resolution.

Incumbent must be able to work in a changing, fluid environment that is dedicated to continuous improvement. This position operates under minimal supervision in a team environment.

• Responsible for availability and performance of all databases.
• Plan and perform maintenance functions on databases and database applications including moves, rebuilds, backups, upgrades and restores.
• Proactively monitor database systems with tools to ensure secure services with minimum downtime.
• Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, and security issues.
• Install and configure new database servers.
• Upgrade existing database servers.
• Ensure all database servers are backed up, test backups, and document disaster recovery procedures to ensure we can meet the business’ Recovery Time Objectives (RTO).
• Setup and maintain Postgre
  
  SQL, SQL Server Enterprise, and Dynamo
  
  DB databases.
• Provision resources on AWS using Terraform.
• Evaluate and recommend tools and methods to improve Database Systems management and automation.
• Anticipate system/application challenges and propose solutions; recommend improvements to existing database servers and software as necessary.
• Implement and enforce security measures, manage access controls, and ensure the overall integrity, accuracy, and consistency of data.
• Ensure appropriate users/authority or self-service solutions are in place, grant authority to Local DBAs as necessary.
• Ensure all databases are patched with security updates according to the patching schedule.
• Provide trend analysis to management to enable decisions regarding resource management.
• Responsible for accountability on all projects, that proper communication is maintained with the appropriate contacts and that there is continued increase of knowledge.

• When performance issues arise,…