The Redshift DBA is responsible for:

  • Working with Data Architects, Analysts, and Scientist to aid in BIDP data modeling efforts
  • General administration of Redshift within the BIDP environment
  • Conduct regular reporting on the health and performance of Redshift environment and jobs
  • Maintain ownership of activities around Redshift
  • Provide consistent database maintenance, optimization and best practices inputs to existing Redshift
  • Assist in discovering, evaluating, and qualifying new technologies around BIDP data lake functions
  • Partner with BIDP stakeholders to establish and maintain policies, procedures, operational standards around the Redshift functions
  • Develop, and assist in the development of polices, process, standards, and operational documents related to Redshift or the BIDP environment

Experience with AWS Services, especially, Data Pipeline, Glue, Kinesis, Redshift Spectrum

  • In depth experience Amazon Redshift, working knowledge of S3 data lake environment, AWS Certified Database (preferred)
  • Experience in schema design and data modeling
  • Knowledge of compliance frameworks PCI, SOX, SOC 2, ISO 27001 and the ability to apply their requirements and concepts to a complex environment
  • Knowledge and hands-on expertise with Structured Query Language (SQL)
  • Strong interpersonal communication and ability to solve complex problems
  • Experience in debugging
  • Strong technical experience, knowledge, and understanding of micro-services architecture
  • Experience with enterprise level cloud-based development, deployment, and auditing, including: PAAS, IAAS, and SAAS. (preferred)
  • Excellent knowledge of data backup, recovery, integrity for database solutions

Education and Experience Required

– Bachelor’s degree in Computer Science, Computer Information Systems, Computer Engineering, or other related technical degree from an appropriately accredited institution and 4 years of progressive expertise with Redshift or another analytic column store, or external columnar data format, like Parquet or ORC, combined with a SQL engine, like Hive, Presto, or Impala.; or bachelor’s degree from an appropriately accredited institution and eight years progressive experience in the field of information technology; or an equivalent combination of education and experience.

eSystems (the “Company”) is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.

To apply for this job email your details to monica@esystems-inc.com