PostGreSQL Lead DBA
Details
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 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