What are the responsibilities and job description for the Database Administrator position at Hire IT people?
Job Description:
The 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.
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
Job Type: Contract
Salary: $78.00 per hour
Ability to commute/relocate:
- North Chicago, IL 60064: Reliably commute or planning to relocate before starting work (Required)
Experience:
- AWS: 3 years (Preferred)
- Database administration: 8 years (Preferred)
- Performance tuning: 5 years (Preferred)
Work Location: In person
Database Administrator - DB2
Trianz -
Waukegan, IL
DB2 DBA - Database Administrator - LUW
Turing IT Labs -
Waukegan, IL
Administrator
Confidential -
Racine, WI
