Senior Cloud Database Engineer - AWS & Postgres/MySQL

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

Job summary

Karsun Solutions, LLC is seeking a Senior Database Administrator to support databases underpinning customer production apps, development, and maintenance. The role involves AWS Cloud DBs (RDS MySQL/PostgreSQL), security, backups, and lifecycle management, with hybrid scheduling possible for DMV-area candidates.

Candidates should have 15+ years, deep Linux DB expertise, and AWS/Azure experience. The team collaborates across delivery staff to optimize performance and align with customer

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
• Preferred PostgreSQL extensions (PostGIS, pg_stat_statements) or MySQL storage engines
• Knowledge of High Availability architectures (RDS Multi-AZ) and Global Databases
• Setup and maintenance of AWS KMS encryption at rest and SSL/TLS in transit
• Proficiency with AWS DMS and SCT
• DevOps tools: Git, Ansible, Jenkins

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

AWS RDS/Aurora

Linux basics

Database security & IAM

Database lifecycle management

Data scrubbing/masking

Security clearance eligibility

Azure experience

Certification

Public Trust clearance readiness

Education

Bachelor's degree in Computer Science or IT

Tools

PostgreSQL

MySQL

Amazon RDS/Aurora

AWS IAM/VPC

Linux

Job description

Karsun Solutions, LLC is seeking a Senior Database Administrator to support databases underpinning customer production apps, development, and maintenance. The role involves AWS Cloud DBs (RDS MySQL/PostgreSQL), security, backups, and lifecycle management, with hybrid scheduling possible for DMV-area candidates.

Candidates should have 15+ years, deep Linux DB expertise, and AWS/Azure experience. The team collaborates across delivery staff to optimize performance and align with customer