Redshift Database Administrator Location Durham,NC Duration 12 Months The Redshift 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 Departmentrsquos Business Intelligence Data Platform (BIDP). The Redshift DBA is responsible for bull Working with Data Architects, Analysts, and Scientist to aid in BIDP data modeling efforts bull General administration of Redshift within the BIDP environment bull Conduct regular reporting on the health and performance of Redshift environment and jobs bull Maintain ownership of activities around Redshift bull Provide consistent database maintenance, optimization and best practices inputs to existing Redshift bull Assist in discovering, evaluating, and qualifying new technologies around BIDP data lake functions bull Partner with BIDP stakeholders to establish and maintain policies, procedures, operational standards around the Redshift functions bull Develop, and assist in the development of polices, process, standards, and operational documents related to Redshift or the BIDP environment Description of Work - 25 Preform Redshift process management and lifecycle support by outlining the processes and setting the boundaries for Redshift data processing and operations within the BIDP environment. Provide architecture management and support for Redshift. Monitor and respond to Redshift audit logs, events and notifications. Ensure Redshift compliance with all regulatory standards. Prepare and report on Redshift activities, utilization, and health. 65 Develop and maintain clusters and nodes within the Redshift environment. Manage Redshift workloads i.e., Data integration, Workflow orchestration and Analysis. Assist with schema design, code review, query and general Redshift 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 environment. Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on Redshift. Document all test procedures for Redshift coordinate with stakeholders and exchange partners to resolve issues and maintain quality. Competencies, Knowledge, Skills and Abilities Required in this Position bull Experience with AWS Services, especially, Data Pipeline, Glue, Kinesis, Redshift Spectrum bull In depth experience Amazon Redshift, working knowledge of S3 data lake environment, AWS Certified Database (preferred) bull Experience in schema design and data modeling bull Knowledge of compliance frameworks PCI, SOX, SOC 2, ISO 27001 and the ability to apply their requirements and concepts to a complex environment bull Knowledge and hands-on expertise with Structured Query Language (SQL) bull Strong interpersonal communication and ability to solve complex problems bull Experience in debugging bull Strong technical experience, knowledge, and understanding of micro-services architecture bull Experience with enterprise level cloud-based development, deployment, and auditing, including PAAS, IAAS, and SAAS. (preferred) bull 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 bachelorrsquos 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.