Karsun Solutions

PostgreSQL/MySQL Database Admin/Developer


This job is now closed

Pay$160000.00 - $170000.00 / year
LocationHerndon/Virginia
Employment typeFull-Time
  • Job Description

      Req#: 3642

      Why Karsun?

      Join 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!

      Summary

      As a Senior Database Administrator/Developer, you will provide services for databases that support the Federal Aviation Administration (FAA) production applications, software development, and application maintenance projects.

      What You'll Be Doing:

      • Provide database administration to RDS POstgreSQL and MySQL 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 FAA 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 FAA and its customers.

      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 PostgreSQL (v12–16) and/or MySQL (v5.7, 8.0) 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 Qualifications:

      • Experience:
        • 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)

      Things to Know:

      Commitment to Non-Discrimination

      All 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 Range

      The proposed salary range for this role is $160,000.00 to $170,000.00 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.

      Third Party Resumes: Karsun does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Karsun and Karsun will not be obligated to pay a placement fee.

      Clearance Information

      This position requires the eligibility to obtain a security clearance. The Defense Industrial Security Clearance Office (DISCO), an agency of the Department of Defense, handles and adjudicates the security clearance process. More information about Security Clearances can be found on the US Department of State government website: https://www.state.gov/m/ds/clearances/c10978.htm

      Location

      To 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.

      Applicants must be authorized to work in the United States on a permanent basis. Due to recent federal changes impacting visa programs, we are not currently considering candidates who require employment-based visa sponsorship (including H-1B).


      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 PostgreSQL (v12–16) and/or MySQL (v5.7, 8.0) 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


      What You'll Be Doing:

      • Provide database administration to RDS POstgreSQL and MySQL 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 FAA 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 FAA and its customers.
  • About the company

      Karsun Solutions is a premier IT and consulting services company with a culture of innovation.  We offer a portfolio of Enterprise Modernization services to both Federal agencies and commercial clients. Our premier clients include the U.S. Department o...

Notice

Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.