Senior Database Administrator

Karsun Solutions, LLC•UNAVAILABLE, United States

1d•Remote

About The Position

As a Senior Database Administrator, you will provide services for databases that support the customer's production applications, software development, and application maintenance projects.

Requirements

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

Nice To Haves

Operating in traditional and agile project models
Experience with PostgreSQL extensions (e.g., 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 (Database Migration Service) and Schema Conversion Tool (SCT).
DevOps toolchain services (GIT, Ansible Tower, Artifactory, Jenkins)
Amazon Web Services familiarity (EC2, RDS, S3, Migration Services)

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.