Senior Cloud Database Administrator (AWS RDS/Aurora)

Karsun Solutions, LLC; North Carolina; Hybrid; USD 150,000 - 165,000; Full time

Job summary

Karsun Solutions, LLC is seeking a Senior Database Administrator to support production applications, development, and maintenance projects. Local candidates may need to follow a hybrid schedule for the DMV area.

Responsibilities include managing RDS MySQL and PostgreSQL in AWS, configuring instances, ensuring security, and driving backups and performance tuning. Extensive Linux and open-source DB knowledge is essential.

Qualifications

• Bachelor's degree in Computer Science or other IT degree; Engineering, math, and/or science degrees are acceptable substitute degrees
• Minimum of 15 years of relevant experience
• Expertise in MySQL (v5.7, 8.0) and/or PostgreSQL (v12-16) administration in an enterprise environment
• Significant experience with Amazon RDS or Aurora managed services
• Deep understanding of Linux-based database environments and open-source database internals
• Experience in Database Lifecycle Management (DLM)
• Experience in Data Scrubbing, Data Masking, Data Compare and Review
• Experience in improving Database user / systems authentication robustness
• AWS and/or Azure experience
• Relevant certification
• The ability to successfully obtain and maintain a U.S. Suitability/Public Trust Background Clearance

Responsibilities

• Provide database administration to RDS MySQL and PostgreSQL databases engines within the AWS Cloud environment
• Install, configure, and maintain database instances, including managing RDS Parameter Groups, Option Groups and coordinating engine version upgrades/patches
• Manage database security and user permissions and privileges in accordance with application/database requirements including IAM Database authentication, VPC security groups and user permissions/privileges
• Develop and/or maintain database objects (tables, views, indexes) and optimize Vacuum (Postgres) or Buffer Pool (MySQL) settings
• Monitor and optimize database performance and tuning
• Manage and ensure compliance with database backup strategies
• Customer support to database and associated application development team, owners, and user stakeholders
• Maintain Database Lifecycle Management processes detailed by customer specifications
• Provide impact information on proposed changes to application and it's database structure
• Provide schedule and resource requirements to stakeholders concerning proposed changes to the application and associated database
• Provide sizing recommendations for any new databases or changes to existing databases, including user/data growth projection and the impact on the server memory and performance characteristics
• Participate in meetings with Solution Delivery Service staff and stakeholders
• Work with other database administrators to ensure optimal efficiency and optimization of databases, server clusters, replications, back-up strategies, and database services to customer and its customers.

Skills

MySQL administration

PostgreSQL administration

RDS/Aurora

Linux fundamentals

DLM

Data masking

Data scrubbing

Auth robustness

Cloud experience

Security clearance

Certification

Education

Bachelor's degree in Computer Science or related IT field

Tools

GIT

Ansible Tower

Artifactory

Jenkins

AWS DMS

Schema Conversion Tool

Job description

Karsun Solutions, LLC is seeking a Senior Database Administrator to support production applications, development, and maintenance projects. Local candidates may need to follow a hybrid schedule for the DMV area.

Responsibilities include managing RDS MySQL and PostgreSQL in AWS, configuring instances, ensuring security, and driving backups and performance tuning. Extensive Linux and open-source DB knowledge is essential.