RedShift DBA

Key Skills

Amazon RedShift, AWS, Azure, Data Lake, Data Warehousing, Docker, Elasticsearch, Linux Operating system, MongoDB, MySQL, Oracle, REDIS

Job Description

A little about us...

LTIMindtree is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 750 clients, LTIMindtree brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world.

We provide our employees with a learning environment that promotes growth and creativity.

To learn more plase visit us at https://www.ltimindtree.com/Twitter @ https://twitter.com/ltimindtree

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

How will you grow?

• Role-based Training programs
• Continuing Education Programs (CEP) to enhance your knowledge, skills, and attitude as a professional
• We encourage you to acquire various beneficial international certifications, with costs s reimbursed
• Our role-based workshop helps us groom future leaders for LTI

What's in it for you?

Excellent benefits plan: medical, dental, vision, life, FSA, & PTO

• Roll over vacation days
• Commuter benefits
• Excellent growth and advancement opportunities
• Certification reimbursement
• Rewards and recognition programs
• Innovative and collaborative company culture

We are an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, gender identity, sexual orientation, disability status, protected veteran status, or any other characteristic protected by law.

Nearest Major Market: Nashville

Job Segment: Database, DBA, Data Warehouse, Open Source, Cloud, Technology