PostGreSQL Lead DBA

Location(s) Alpharetta, Georgia, Birmingham, Alabama, Chicago, Illinois, Dallas, Texas, Downers Grove, Illinois, Jacksonville, Florida, St.

Louis, Missouri Details Kemper is one of the nation's leading specialized insurers.

Our success is a direct reflection of the talented and diverse people who make a positive difference in the lives of our customers every day.

We believe a high-performing culture, valuable opportunities for personal development and professional challenge, and a healthy work-life balance can be highly motivating and productive.

Kemper's products and services are making a real difference to our customers, who have unique and evolving needs.

By joining our team, you are helping to provide an experience to our stakeholders that delivers on our promises.

Kemper is seeking a Lead-level DBA with experience in new technologies such as Aurora-PostgreSQL, Oracle, and AWS RDS.

Responsibilities * Install, configure, patch, migrate, maintain, and upgrade Oracle database to Open-source Database platforms Databases like Aurora-PostgreSQL, AWS RDS * Proactively monitor production databases for performance and stability.

* Participate in on-call production support on a rotation basis.

* Provide DBA support for Enterprise releases deployments and projects.

* Provide technical guidance to software developers, Architecture team in data modeling and performance optimization techniques.

* Automate administrative tasks using scripting languages and utilities.

* Follow established standards and for any gap create standards and implement * Document new processes and procedures when appropriate.

* Promptly create Incident Reports to build/update Knowledge Base.

* Perform administrative tasks like but not limited to, DDL creation, user creation, account level parameter changes etc.

within AWS Supported Databases Qualifications * 10+ years of experience working with Databases - PostgreSQL, Oracle, and AWS RDS.

* One to five migrations from Oracle to Aurora-PostgreSQL database end to end implementation required.

* Demonstrated experience knowledge of Amazon Web Services environments, including RDS, S3, EMR, SQS, and SNS.

* 3+ years' experience designing, executing, and supporting Cloud solutions for Databases * 2+ Years of hands-on experience on PostgreSQL, AWS Aurora-PostgreSQL, and AWS RDS * Experience setting up and managing PostgreSQL on AWS RDS and AWS EC2 Virtual Server * Hands-on experience managing databases both in private Data Centers as well as in the AWS cloud.

* Knowledge of AWS day to day operation on S3, EC2, etc.

* 2+ years of hands-on experience deploying and supporting databases in the Cloud (AWS) * Strong understanding and experience Administering and Optimizing TB databases on Linux systems.

* Experience automating, scripting, and streamlining processes for efficiency and accuracy.

* Database Migration tools like AWS DMS, SCT and Customer migration strategy * Familiarity with Database Monitoring & debugging tools like AppDynamics, Splunk, SolarWinds DPA, and Grafana Prometheus.

* Advanced experience writing scripts using Shell and/or Ansible * Knowledge of Oracle is a Plus.

* Ability to multitask and work independently on projects.

* Ability to effectively communicate, prioritize and execute tasks in high-pressure environments.

* Excellent communication and attention to detail skills, with an eagerness to provide outstanding Customer service to both internal and external clients.

* Ability to extract insight from large datasets.

* Bachelor's degree in Computer science or Information Systems or an equivalent.

* This position is a hybrid role and can work remote from a US based home in the Alpharetta, GA Birmingham, AL, Chicago, IL, or Jacksonville, FL areas.

Expectation is work if needed on occasion in the office.

The range for this position is $87400 to $150,000.

When determining candidate offers, we consider experience, skills, education, certifications, and geographic location among other factors.

This job is eligible for an annual discretionary bonus and Kemper benefits (Medical, Dental, Vision, PTO, 401k, etc.) Kemper is proud to be an equal opportunity employer.

All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, disability status or any other status protected by the laws or regulations in the locations where we operate.

We are committed to supporting diversity and equality across our organization and we work diligently to maintain a workplace free from discrimination.

Kemper does not accept unsolicited resumes through or from search firms or staffing agencies.

All unsolicited resumes will be considered the property of Kemper and Kemper will not be obligated to pay a placement fee.

Kemper will never request personal information, such as your social security number or banking information, via text or email.

Additionally, Kemper does not use external messaging applications like WireApp or Skype to communicate with candidates.

If you receive such a message, delete it.

#LI-AK-1 #LI-Hybrid