Karsun Solutions LLC

  • RDBMS & AWS Redshift Administrator

    Job Locations US-VA-Herndon
    Posted Date 4 weeks ago(7/19/2018 2:47 PM)
    # of Openings
    Information Technology
  • Overview

    This position supports the General Services Administration (GSA) CAMEO program. The Karsun team is responsible for the development, maintenance, and enhancement (DM&E) and operation of selected GSA Federal Acquisition IT Systems. All employees must be able to pass a Federal Suitability Check for a position of public trust. The GSA CAMEO program supports the operations of multiple business applications, as well as development of new applications across different technologies. The Karsun software development team is responsible for the software design and implementation of web applications supporting multiple Business Lines within GSA. Successful candidates are modern web development specialists experienced in translating business requirements into software architecture.  In addition to strong software development skills, ideal candidates have demonstrated experience in working on an Agile Scrum team. Position location is in Herndon, VA.


    A successful candidate should be able to work with the Technical Architects and BI lead to document scope, tasks, risks, dependencies and mitigation plans, create and update support documentation and review of work product, establish and continuously enhance SOPs for all aspects of database operations for a federal customer in GSA



    The ideal candidate will be responsible for:

    • Implementation and administration of AWS Redshift and AWS RDS Aurora, Postgres, MySQL and MS SQL server infrastructure
    • Automate provisioning, monitoring of the database infrastructure
    • Experience in setting up AWS RDS based HA clusters
    • Cluster maintenance including administrating, monitoring, tuning and troubleshooting
    • Provide consistent database maintenance, optimization and best practices inputs to existing Redshift, and SQL databases and applications
    • Experience in DR planning and execution with RPO/RTO objectives and SLAs
    • Experience with SQL and/or any ETL rools such as SAP DS, Pentaho PDI, Alteryx, Apache NiFi

    Required Skills:

    • 8+ years of work experience, with a minimum of 2 yrs with AWS Redshift or AWS RDS Aurora, Postgres, mySQL, with at least 2 full lifecycle database implementations
    • 2+ years in SQL analysis, development and troubleshooting activities, including data warehousing, analytical applications development and support
    • 2+ years of enterprise database operations experience as primary DBA
    • Linux BASH/shell scripting skills are expected
    • AWS CLI basics and experience to work and administer AWS RDS and Redshift via AWS CLI is expected
    • Demonstrated understanding of data modeling and strong data analysis skills
    • Ability to work under challenging deadlines and constraints, to deliver

    Desired Skills:

    • Hands on development with either Scala or Python
    • Functional experience in government related business around acquisition and contracts
    • Technically strong, R&D oriented working with motivation for self-driven learning will be an advantage
    • Experience with or exposure to CI/CD tools such as Puppet, Chef and/or Ansible is an advantage


    • Bachelor's degree in Engineering or related discipline
    • Ability to obtain a Public Trust Clearance

    For more information on this or any other position, chat one-on-one with our recruiters during our weekly virtual chat event every Thursday at 12:00pm EST. 


    Karsun Solutions is an Equal Employment Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed