Vacancy expired!
- Working with Data Architects, Analysts, and Scientist to aid in BIDP data modeling efforts
- General administration of Redshift and Aurora within the BIDP environment
- Conduct regular reporting on the health and performance of Redshift and Aurora environments 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 and Aurora functions
- Develop, and assist in the development of polices, process, standards, and operational documents related to Redshift, Aurora, or the BIDP environment
- Experience with AWS Services, especially, Data Pipeline, Glue, Kinesis, Redshift Spectrum.
- In depth experience with Amazon Redshift, and AWS Aurora, 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.
- Bachelor's degree in Computer Science, Computer Information Systems, Computer Engineering, or other technical degree from accredited institution.
- 4 years of progressive expertise with Redshift, Aurora, or another analytic column store, or external columnar data format, Parquet or ORC
- ID: #41498875
- State: North Carolina Raleigh / durham / CH 27601 Raleigh / durham / CH USA
- City: Raleigh / durham / CH
- Salary: Depends on Experience
- Job type: Contract
- Showed: 2022-05-24
- Deadline: 2022-07-22
- Category: Et cetera