Job description

Database Administrator V

Projected Start Date05-22-2023

Projected End Date05-23-2024

Position TypeContract

LocationChicago, IL

Remote WorkPartial

Branch

Primary SkillsSQL

Job Description:

Client is seeking for an AWS Redshift DBA who will help with our dataware house workload migration into AWS Redshift. This individual will have extensive, hands-on experience with database administration along with Query Tuning.

Responsibilities

• Experience: 8 to 10 years as a DBA that include Database & Query Performance Tuning

• Must have excellent Redshift experience along with DBA knowledge

• Optimizing and tuning the Redshift environment including Cluster, Database & SQL queries

• Good knowledge of analyzing explain plan and tune workloads to improve runtime

• Good knowledge of Workload Management within Redshift along with queue mgmt.

• Excellent understanding of the AWS architecture (RDS, S3)

• Redshift and Aurora Cluster & Database Administration support

• Knowledge of Data Replication, Data Sharing & Data Modelling including Logical and Physical data source

• Hands on experience with Python scripting & Automation

• Knowledge of ADFS and User Access management

• Knowledge of setting up Cloud Monitoring and Alert Metrics management

• Good to have Apache airflow experience

• Excellent communications and a Team player

• Good to have - AWS Certified Solution Architect

Experience:

• Database administration: 8 years

• Performance tuning: 5 years

• AWS Redshift & RDS Experience: 2-3 years

• Python: 1 year

• Scripting: 1 year

Education:

• Bachelor's degree required

Job Type: Contract

Salary: $65.00 per hour

Schedule:

• 8 hour shift

Work Location: One location

jjbodyshop.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, jjbodyshop.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, jjbodyshop.com is the ideal place to find your next job.