RDBMS & AWS Redshift Administrator

Karsun Solutions LLC - Herndon, VA (30+ days ago)


Overview This position supports the General Services Administration (GSA) DMS program. The Karsun team is responsible for the operations, maintenance, and modernization of the middleware and database environment. All employees must be able to pass a Federal Suitability Check for a position of public trust. Successful candidates have previous database administrators experience in managing and maintaining databases in an AWS environment. In addition to administrations will have had previous either experience maintaining or migrating databases from a legacy environment. Position location is in Herndon, VA however remote work is an option.

A successful candidate should be able to work with the Modernization Architect and DBA 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.

Responsibilities 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
NOTE : US Citizens, Green Card Holders & H1B Visa Holders are eligible for Public Trust Clearance required by the GSA

JOB TYPE : Full Time & Remote

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

Qualifications
  • Bachelor's degree in Computer Science 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