Note: The job is a remote job and is open to candidates in USA. Karsun Solutions is hiring a Senior Database Administrator to support databases used by customer production applications, software development, and application maintenance projects. The role administers and optimizes AWS-hosted RDS MySQL and PostgreSQL databases, manages security, backups, lifecycle processes, and supports application teams and stakeholders.

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

• 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

Benefits

• Remote; candidates local to the DMV area may be required to adhere to a hybrid schedule.

Company Overview