Logo
Saxon Global

Database Administrator V

Saxon Global, Chicago, Illinois, United States, 60290


Job Title: AWS Redshift DBA Work Location: Required to be onsite 2 days a week

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

Required Skills : AWS, Redshift, Basic Qualification : Additional Skills : Background Check :Yes Drug Screen :Yes Notes : Selling points for candidate : Project Verification Info : Candidate must be your W2 Employee :Yes Exclusive to Apex :No Face to face interview required :No Candidate must be local :Yes Candidate must be authorized to work without sponsorship ::No Interview times set : :No Type of project :Administration/Support Master Job Title :DBA: Other Branch Code :Chicago