Redshift & Aurora Database Developer/Admininistrator

25 May 2024

Vacancy expired!

Primary Purpose of the Position:The Redshift and Aurora Database Administrator (DBA) is responsible for the data workload management, query prioritization, capacity management, data warehouse tuning, designing and creating data warehouse schemas, tables, adding users, groups, other administrative tasks around the Department’s Business Intelligence Data Platform (BIDP) and Master Patient Index Hub.

Responsibilities:
  • 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
(25%) Perform Redshift and Aurora process management and lifecycle support by outlining the processes and setting the boundaries for data processing and operations within the BIDP environment. Provide architecture management and support for Redshift and Aurora. Monitor and respond to audit logs, events and notifications. Ensure Redshift compliance with all regulatory standards. Prepare and report on Redshift and Aurora activities, utilization, and health.(65%) Develop and maintain clusters and nodes within the BIDP environment. Manage database workloads i.e., Data integration, Workflow orchestration and Analysis. Assist with schema design, code review, query and general database tuning. Minimize database downtime and manage parameters to provide fast query responses. Provide proactive and reactive data management support and training to users. Work with stakeholders to determine, enforce and document database policies, procedures and standards.(10%) Conduct testing of the Redshift based workloads and the ingestion of data pipelines into the Redshift and Aurora environment. Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on Redshift and Aurora. Document all test procedures for Redshift coordinate with stakeholders and exchange partners to resolve issues and maintain quality.

Skills Required:
  • 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: #41544524
  • 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-25
  • Deadline: 2022-07-22
  • Category: Et cetera