K
Senior Database Administrator
Karsun Solutions
1 month ago
Full-time
Remote
United States
Administrative
Overview
Summary
As a Senior Database Administrator, you will provide services for databases that support the customer's production applications, software development, and application maintenance projects.
Â
Responsibilities
What You'll Be Doing:
- 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.
Qualifications and Education
Required 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
Compensation
The proposed salary range for this role is $****** to $******* USD. The salary range provided is a good faith estimate representative of all experience levels. Karsun considers several factors when extending an offer, including but not limited to, the role, function and associated responsibilities, a candidate’s work experience, location, education/training, and key skills.