Add office photos
All Filters
345 Schneider Electric Jobs
Expert - AWS Redshift Operations
5-8 years
Bangalore / Bengaluru
1 vacancy
Expert - AWS Redshift Operations
Schneider Electric
posted 1d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
Own the architecture for the AWS Redshift clusters across all environments.
Own the database administration of the Enterprise Data Warehouse on AWS Redshift.
Own the architecture for our Enterprise Data Warehouse on AWS Redshift including cluster and node topology, configuration, and sizing.
Automate provisioning, operation, monitoring and troubleshooting of the database and data lake infrastructure.
Determine, enforce and document database policies, procedures and standards.
Keep up to date with emerging cloud technology trends on AWS Redshift.
Define design standards for AWS Redshift for use by development and support teams. Partner with the Data Architect to define data modeling standards.
Partner with data engineers on query design during projects and while performing analytics, and to analyze, troubleshoot and optimize application and ad-hoc queries in production.
Provide operational management for our Enterprise Data Warehouse (EDW) in AWS Redshift across all environments, including configuration, maintenance, code migration, and incident response.
Identify and execute cost, performance, and uptime optimizations.
Partner with the Analysts and Business Partners on data extracts as needed.
Technical Essentials
Expertise in Redshift Administration for managing databases, user tables, indexes, statistics, managing permissions addressing the user issues.
Experienced in core AWS services like EC2, S3, IAM, and VPC.
Experienced with the AWS console and basic command-line tools (AWS CLI).
Familiarity with data processing concepts like ETL/ELT pipelines. Basic experience with Python or Scala for data manipulation.
Excellent and proven knowledge of AWS Redshift and SQL demonstrated through 4+ years in a Redshift DBA role.
Excellent knowledge of related AWS technologies included Aurora, Redshift Spectrum, S3, EMR, DynamoDB and Athena, AWS Lake formation, Glue, AWS data shares, GitHub, PySpark
AWS Certification is preferred.
Experienced with generating various DB health statistics, utilization and right sizing.
Experienced with data sharing mechanisms like S3 Sharing and Redshift Sharing. Sharing using Lake formation. sharing between accounts, regions
Automating the repeated DBA tasks.
An interest and ability to learn new technologies.
Experience with data processing frameworks like Apache Spark or AWS Glue. Understanding of data warehousing concepts and data quality practices.
Experienced with AWS serverless services like Lambda, Step Functions, AWS Glue and Redshift Serverless.
Experience with CI/CD pipelines for automating infrastructure and code deployment.
Experienced with cloud monitoring and logging services like CloudWatch.
Bonuses
Ability to multi-task, organize, prioritize, research and resolve issues in a timely and effective manner.
In-depth knowledge of S3 for object storage and data lakes.
Understanding of data partitioning and file formats like Parquet or good to have knowledge on OTF / Iceberg
Understanding of data lineage and data quality tools.
Business / Soft Skills:
Proven ability and initiative to learn and research new concepts, ideas, and technologies quickly.
Ability to communicate effectively, both verbal and written, excellent presentation skills.
Ability to effectively move forward on tasks even with ambiguous or changing requirements.
Ability to work in a team-oriented, collaborative environment in a global context.
Willingness and ability to train and teach others.
Ability to facilitate meetings and follow up with resulting action items.
Ability to self-manage, prioritize and execute tasks in a high-pressure environment.
Strong systems/process orientation with demonstrated analytical thinking, organization skills and problem-solving skills.
The desire for growth and innovation, to bring rapid solutions to business challenges/opportunities.
Strong consultancy orientation and experience, with the ability to form collaborative, productive working relationships across diverse teams and cultures is a must.
The ability to work in a centralized/decentralized operating model, with varying implementation partners and implementation owners.
Role: AWS Redshift Database administrator
Experience: Overall 5 - 8
Employment Type: Full Time, Permanent
Read full job descriptionPrepare for Operations roles with real interview advice
What people at Schneider Electric are saying
Operations salary at Schneider Electric
reported by
2
employees
₹20.7
L/yr - ₹26.4
L/yr
550%
more
than the average Operations Salary in India
View more details
What Schneider Electric employees are saying about work life
based on 3.6k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Schneider Electric Benefits
View more benefits
Compare Schneider Electric with
Siemens
Compare
ABB
Compare
Honeywell Automation
Compare
Emerson Electric Co.
Compare
Eaton Corporation
Compare
Legrand
Compare
Rockwell Automation
Compare
Johnson Controls
Compare
Bosch
Compare
Wipro PARI
Compare
Addverb Technologies
Compare
Titan Engineering & Automation
Compare
Falcon Autotech
Compare
Technosoft Engineering Projects Limited
Compare
Festo
Compare
TMEIC
Compare
Cotmac Electronics
Compare
Marine Electricals
Compare
Utthunga Technologies
Compare
Siemens PLM Software
Compare
Similar Jobs for you
Schneider Electric Bangalore / Bengaluru Office Location
Bengaluru Office
401-403, Prestige Meridian-1, Near-City Bank, Mahatma Gandhi Road
Bengaluru
Karnataka 560001
Karnataka 560001
Share an Interview