AWS Redshift DB Administrator

AWS Redshift DB Administrator

• Senior Redshift DBA will be responsible for managing Redshift clusters
• Support AWS services (EC2, RDS, Redshift, S3, ELB, NLB)
• Extensive experience with Database platform including AWS Redshift, AWS RDS, MySQL and Snowflake
• Expert understanding of best practices when it comes to usability and performance of the databases
• Possess communication skills necessary to act in advisory and mentorship role.
• Work closely with business stakeholders, data engineers, operations engineers, delivery managers and IT teams across the organization to ensure successful delivery of data
• Collaborate with architecture team to deliver and advocate for optimal system architecture and performance

Responsibilities:

• Administer and maintain scalable AWS cloud environments and applications for data organization
• Install and maintain software, services, and application by identifying system requirements
• Extensive database experience with, AWS Redshift, AWS RDS and MySQL
• Hands-on AWS Services and DB and Server troubleshooting experience
• Maintains environment by identifying system requirements, installing upgrades and monitoring system performance
• Knowledge of day-to-day database operations, deployments, and development
• Experienced in Snowflake
• Knowledge of SQL and Performance tuning
• Knowledge of Linux Shell Scripting or Python
• Migrate system from one AWS cloud to another AWS account
• Hands-on DB and Server troubleshooting experience
• Maintains system performance by performing system monitoring and analysis and performance tuning
• Troubleshooting system hardware, software, and operating and system management systems
• Incident and change management
• Release management and Code deployment
• After hour on-call support
• Testing disaster recovery policies and procedures; completing back-ups; and maintaining documentation
• Upgrades system and services and developing, testing, evaluating, and installing enhancements and new software
• Communicate with stakeholders