RedShift DBA
Apply NowCompany: Futran Tech Solutions Pvt. Ltd.
Location: Franklin, TN 37064
Description:
Roles & Responsibilities:
Refine and implement multi-terabyte Data Warehouse and Data Lake infrastructure in support of large scale Data Analytics and Data Science applications
Work with our stakeholders, Devops and Data Engineering teams to implement and maintain data products including Master Data Management
Monitor, identify and resolve performance issues within AWS database technologies
Establish and maintain a produce/consume redshift architecture across redshift serverless, dedicated redshift, and spectrum/glue clusters
Optimize and tune Redshift clusters and queries to support multiple Analytics and Visualization platforms
Extend Redshift Workload Management (WML) to prioritize workloads and manage concurrency issues
Configure, test and implement database software/services and apply patches
Automate access management in alignment with our data policies and governance
Establish controls needed to comply with company Cybersecurity and Data Loss Prevention policies, standards, and industry best practices
Provide timely support in response to Performance issues
Design and Implement Monitoring and Alerting system for AWS Redshift cluster performance and uptime within our Devops framework
Implement and maintain CI/CD for ddl/dml changes using our Jenkins stack in alignment with our Devops and Data Engineering staff
Maintain and Improve Redshift Disaster Recovery Plan
Contribute to global Redshift support and design community
Required Qualifications:
Expert Database Administration skills using AWS Redshift including the following:
SQL Performance tuning and optimization
Concurrency scaling and monitoring
Data distribution monitoring and optimization
Stored Procedures, Materialized view, User Defined Functions - Optimization & Tuning
Disaster recovery design/implementation - snapshots & recovery points
Large scale Data Warehouse & Data Lake workloads optimization based on Spark, Lambda Functions, S3, Glue, WLM, and best practices in Data Migration, Data Warehouse, Data Lake, ETL, ELT Database design, capacity planning and analysis of growth patterns of data to plan for future storage requirements
Parameter Group management
Data Governance & Security - Data Encryption, Redshift User Roles & Groups, Role Based Data Access Controls (row level data security), IAM integration, AWS Security Groups, AWS Cloud Watch event monitoring
Expert DBA skills using RDBMS and/or NoSQL platforms such as:
Working knowledge of DevOps best practices: Advanced knowledge and experience in the development of Linux Shell scripting in combination with AWS SAM / AWS-CLI,AWS CloudFormation and/or Terraform templates for Deployment automation
Advanced knowledge and experience in the Design and implementation of Data Warehouse, Data Lake - with Data Mesh as a plus
Advanced knowledge and experience in maintenance of Metadata repositories such as AWS Glue Catalog, Glue crawler for data stored in: S3, AWS Redshift, AWS RDS for access thru Redshift Spectrum
Valued Skills:
Experience with other database technologies such as Postgres, AWS RDS, AWS Aurora, MySQL, SQL Server, Oracle, AWS DynamoDB, AWS Glue Metastor, MongoDB, Redis, AWS ElastiCache or AWS OpenSearch
Experienced in Metadata classification, lineage, and discovery based on AWS technologies or equivalent open source frameworks
Experienced in use of AWS IAM, AWS Security Groups, AWS Web Application Firewall
Bachelor's degree in technology, engineering, or related field
Strong interpersonal and customer service skills
Strong English communications skills - written and verbal
Strong analytical and trouble-shooting skills
Refine and implement multi-terabyte Data Warehouse and Data Lake infrastructure in support of large scale Data Analytics and Data Science applications
Work with our stakeholders, Devops and Data Engineering teams to implement and maintain data products including Master Data Management
Monitor, identify and resolve performance issues within AWS database technologies
Establish and maintain a produce/consume redshift architecture across redshift serverless, dedicated redshift, and spectrum/glue clusters
Optimize and tune Redshift clusters and queries to support multiple Analytics and Visualization platforms
Extend Redshift Workload Management (WML) to prioritize workloads and manage concurrency issues
Configure, test and implement database software/services and apply patches
Automate access management in alignment with our data policies and governance
Establish controls needed to comply with company Cybersecurity and Data Loss Prevention policies, standards, and industry best practices
Provide timely support in response to Performance issues
Design and Implement Monitoring and Alerting system for AWS Redshift cluster performance and uptime within our Devops framework
Implement and maintain CI/CD for ddl/dml changes using our Jenkins stack in alignment with our Devops and Data Engineering staff
Maintain and Improve Redshift Disaster Recovery Plan
Contribute to global Redshift support and design community
Required Qualifications:
Expert Database Administration skills using AWS Redshift including the following:
SQL Performance tuning and optimization
Concurrency scaling and monitoring
Data distribution monitoring and optimization
Stored Procedures, Materialized view, User Defined Functions - Optimization & Tuning
Disaster recovery design/implementation - snapshots & recovery points
Large scale Data Warehouse & Data Lake workloads optimization based on Spark, Lambda Functions, S3, Glue, WLM, and best practices in Data Migration, Data Warehouse, Data Lake, ETL, ELT Database design, capacity planning and analysis of growth patterns of data to plan for future storage requirements
Parameter Group management
Data Governance & Security - Data Encryption, Redshift User Roles & Groups, Role Based Data Access Controls (row level data security), IAM integration, AWS Security Groups, AWS Cloud Watch event monitoring
Expert DBA skills using RDBMS and/or NoSQL platforms such as:
Working knowledge of DevOps best practices: Advanced knowledge and experience in the development of Linux Shell scripting in combination with AWS SAM / AWS-CLI,AWS CloudFormation and/or Terraform templates for Deployment automation
Advanced knowledge and experience in the Design and implementation of Data Warehouse, Data Lake - with Data Mesh as a plus
Advanced knowledge and experience in maintenance of Metadata repositories such as AWS Glue Catalog, Glue crawler for data stored in: S3, AWS Redshift, AWS RDS for access thru Redshift Spectrum
Valued Skills:
Experience with other database technologies such as Postgres, AWS RDS, AWS Aurora, MySQL, SQL Server, Oracle, AWS DynamoDB, AWS Glue Metastor, MongoDB, Redis, AWS ElastiCache or AWS OpenSearch
Experienced in Metadata classification, lineage, and discovery based on AWS technologies or equivalent open source frameworks
Experienced in use of AWS IAM, AWS Security Groups, AWS Web Application Firewall
Bachelor's degree in technology, engineering, or related field
Strong interpersonal and customer service skills
Strong English communications skills - written and verbal
Strong analytical and trouble-shooting skills