Senior Database Administrator

Senior Database AdministratorJoin Karsun Solutions to grow your career with the company transforming possible for the US Government.At Karsun, collaboration drives our community. We're committed to building an environment where team members from diverse backgrounds can innovate, learn and grow with us. Here at Karsun, the only limit to your potential is the limit of your curiosity.Join Team Karsun, and Find Your Next!As a Senior Database Administrator, you will provide services for databases that support the customer's production applications, software development, and application maintenance projects.Candidates local to the DMV area may be required to adhere to a hybrid schedule.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 tuningManage and ensure compliance with database backup strategiesCustomer support to database and associated application development team, owners, and user stakeholdersMaintain Database Lifecycle Management processes detailed by customer specificationsProvide impact information on proposed changes to application and it's database structureProvide schedule and resource requirements to stakeholders concerning proposed changes to the application and associated databaseProvide 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 characteristicsParticipate in meetings with Solution Delivery Service staff and stakeholdersWork 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.Required Qualifications:Bachelor's degree in Computer Science or other IT degree; Engineering, math, and/or science degrees are acceptable substitute degreesMinimum of 15 years of relevant experienceExpertise in MySQL (v5.7, 8.0) and/or PostgreSQL (v12–16) administration in an enterprise environmentSignificant 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 experienceRelevant certificationThe ability to successfully obtain and maintain a U.S. Suitability/Public Trust Background ClearancePreferred Qualifications:Operating in traditional and agile project modelsExperience 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)Things to Know:Commitment to Non-DiscriminationAll qualified applicants will receive consideration for employment without regard to disability, status as a protected veteran or any other status protected by applicable federal, state, local, or international law.Salary RangeThe proposed salary range for this role is $150,000 to $165,000 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.LocationTo be considered for this role, you must reside in one of the following states: CA, CO, DC, FL, GA, IL, MD, NJ, NY, NC, OH, OK, PA, SC, TX, VA, WV.Work AuthorizationApplicants must be authorized to work in the U.S.