RDBMS & AWS Redshift Administrator

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

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