AWS Redshift Administrator


  • PB
  • Storage
  • Performance tuning
  • Software development
  • Data integration
  • JSON
  • Insurance
  • Data
  • Slowly changing dimensions
  • Extract

Job Description

Kforce has a client in Juno Beach, FL that is seeking an AWS Redshift Administrator.

* The AWS Redshift Administrator is responsible for the design, implementation, management, and maintenance of data pipelines for AWS RedShift based solutions
* Administering, performance optimizing, and maintaining large (>1PB) RedShift environments
* Database administration and implementation of DB related scripts/jobs
* SQL analysis, troubleshooting activities and analytical applications support
* The AWS Redshift Administrator will be working on AWS technologies, AWS services, AWS CLI & S3 storage understanding

* Expertise in AWS
* Expertise in RedShift
* Hands-on experience in setting up Redshift cluster from the scratch and snapshot creation
* Hands-on experience in loading data, running complex queries, performance tuning
* Strong SQL and Unix skills experience working with modern ETL/ELT frameworks
* Strong experience of data warehouse best practices such as conforming dimensions, slowly changing dimensions, star and snowflake schema required
* Data Pipeline development experience leveraging industry standard tools like Git and Jira required
* Strong programming skills and data integration experience Python (or other applicable scripting)
* Experience dealing with processing and loading unstructured data (e.g., json, parquet, etc.)
* Experience with Continuous Integration and Continuous Delivery
* Strong experience with AWS technologies stack including S3, Redshift, Glue, Athena or similar solutions preferred

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

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