▷ Urgent Expert

Schneider Electric is an Equal Opportunity Employer It is our policy to provide equal employment and advancement opportunities in the areas of recruiting hiring training transferring and promoting all qualified individuals regardless of race religion color gender disability national origin ancestry age military status sexual orientation marital status or any other legally protected characteristic or conductAbout the jobRole AWS Redshift Database administratorExperience Overall 5 - 8 years 4-5 years relevant Location Bangalore IndiaAs a database administrator you will work with diverse data analytics technologies on the cloud Technical Responsibilities include deploying managing and operating scalable highly available and fault-tolerant databases on AWS Strong verbal and written communication skills with ability to articulate results and issues to internal and client teams Proven ability to work creatively and analytically in a problem-solving environment Primary Responsibilities Includexc2xb7 Own the architecture for the AWS Redshift clusters across all environments xc2xb7 Own the database administration of the Enterprise Data Warehouse on AWS Redshift xc2xb7 Own the architecture for our Enterprise Data Warehouse on AWS Redshift including cluster and node topology configuration and sizing xc2xb7 Automate provisioning operation monitoring and troubleshooting of the database and data lake infrastructure xc2xb7 Determine enforce and document database policies procedures and standards xc2xb7 Keep up to date with emerging cloud technology trends on AWS Redshift xc2xb7 Define design standards for AWS Redshift for use by development and support teams Partner with the Data Architect to define data modeling standards xc2xb7 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 xc2xb7 Provide operational management for our Enterprise Data Warehouse EDW in AWS Redshift across all environments including configuration maintenance code migration and incident response xc2xb7 Identify and execute cost performance and uptime optimizations xc2xb7 Partner with the Analysts and Business Partners on data extracts as needed Technical Essentialsxc2xb7 Expertise in Redshift Administration for managing databases user tables indexes statistics managing permissions addressing the user issues xc2xb7 Experienced in core AWS services like EC2 S3 IAM and VPC xc2xb7 Experienced with the AWS console and basic command-line tools AWS CLI xc2xb7 Familiarity with data processing concepts like ETL ELT pipelines Basic experience with Python or Scala for data manipulation xc2xb7 Excellent and proven knowledge of AWS Redshift and SQL demonstrated through 4 years in a Redshift DBA role xc2xb7 Excellent knowledge of related AWS technologies included Aurora Redshift Spectrum S3 EMR DynamoDB and Athena AWS Lake formation Glue AWS data shares GitHub PySparkxc2xb7 AWS Certification is preferred xc2xb7 Experienced with generating various DB health statistics utilization and right sizing xc2xb7 Experienced with data sharing mechanisms like S3 Sharing and Redshift Sharing Sharing using Lake formation sharing between accounts regionsxc2xb7 Automating the repeated DBA tasks xc2xb7 An interest and ability to learn new technologies xc2xb7 Experience with data processing frameworks like Apache Spark or AWS Glue Understanding of data warehousing concepts and data quality practices xc2xb7 Experienced with AWS serverless services like Lambda Step Functions AWS Glue and Redshift Serverless xc2xb7 Experience with CI CD pipelines for automating infrastructure and code deployment xc2xb7 Experienced with cloud monitoring and logging services like CloudWatch Bonusesxc2xb7 Ability to multi-task organize prioritize research and resolve issues in a timely and effective manner xc2xb7 In-depth knowledge of S3 for object storage and data lakes xc2xb7 Understanding of data partitioning and file formats like Parquet or good to have knowledge on OTF Icebergxc2xb7 Understanding of data lineage and data quality tools Business Soft Skills xc2xb7 Proven ability and initiative to learn and research new concepts ideas and technologies quickly xc2xb7 Ability to communicate effectively both verbal and written excellent presentation skills xc2xb7 Ability to effectively move forward on tasks even with ambiguous or changing requirements xc2xb7 Ability to work in a team-oriented collaborative environment in a global context xc2xb7 Willingness and ability to train and teach others xc2xb7 Ability to facilitate meetings and follow up with resulting action items xc2xb7 Ability to self-manage prioritize and execute tasks in a high-pressure environment xc2xb7 Strong systems process orientation with demonstrated analytical thinking organization skills and problem-solving skills xc2xb7 The desire for growth and innovation to bring rapid solutions to business challenges opportunities xc2xb7 Strong consultancy orientation and experience with the ability to form collaborative productive working relationships across diverse teams and cultures is a must xc2xb7 The ability to work in a centralized decentralized operating model with varying implementation partners and implementation owners QualificationsAbout the jobRole AWS Redshift Database administratorExperience Overall 5 - 8 years 4-5 years relevant Location Bangalore IndiaAs a database administrator you will work with diverse data analytics technologies on the cloud Technical Responsibilities include deploying managing and operating scalable highly available and fault-tolerant databases on AWS Strong verbal and written communication skills with ability to articulate results and issues to internal and client teams Proven ability to work creatively and analytically in a problem-solving environment Primary Responsibilities Includexc2xb7 Own the architecture for the AWS Redshift clusters across all environments xc2xb7 Own the database administration of the Enterprise Data Warehouse on AWS Redshift xc2xb7 Own the architecture for our Enterprise Data Warehouse on AWS Redshift including cluster and node topology configuration and sizing xc2xb7 Automate provisioning operation monitoring and troubleshooting of the database and data lake infrastructure xc2xb7 Determine enforce and document database policies procedures and standards xc2xb7 Keep up to date with emerging cloud technology trends on AWS Redshift xc2xb7 Define design standards for AWS Redshift for use by development and support teams Partner with the Data Architect to define data modeling standards xc2xb7 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 xc2xb7 Provide operational management for our Enterprise Data Warehouse EDW in AWS Redshift across all environments including configuration maintenance code migration and incident response xc2xb7 Identify and execute cost performance and uptime optimizations xc2xb7 Partner with the Analysts and Business Partners on data extracts as needed Technical Essentialsxc2xb7 Expertise in Redshift Administration for managing databases user tables indexes statistics managing permissions addressing the user issues xc2xb7 Experienced in core AWS services like EC2 S3 IAM and VPC xc2xb7 Experienced with the AWS console and basic command-line tools AWS CLI xc2xb7 Familiarity with data processing concepts like ETL ELT pipelines Basic experience with Python or Scala for data manipulation xc2xb7 Excellent and proven knowledge of AWS Redshift and SQL demonstrated through 4 years in a Redshift DBA role xc2xb7 Excellent knowledge of related AWS technologies included Aurora Redshift Spectrum S3 EMR DynamoDB and Athena AWS Lake formation Glue AWS data shares GitHub PySparkxc2xb7 AWS Certification is preferred xc2xb7 Experienced with generating various DB health statistics utilization and right sizing xc2xb7 Experienced with data sharing mechanisms like S3 Sharing and Redshift Sharing Sharing using Lake formation sharing between accounts regionsxc2xb7 Automating the repeated DBA tasks xc2xb7 An interest and ability to learn new technologies xc2xb7 Experience with data processing frameworks like Apache Spark or AWS Glue Understanding of data warehousing concepts and data quality practices xc2xb7 Experienced with AWS serverless services like Lambda Step Functions AWS Glue and Redshift Serverless xc2xb7 Experience with CI CD pipelines for automating infrastructure and code deployment xc2xb7 Experienced with cloud monitoring and logging services like CloudWatch Bonusesxc2xb7 Ability to multi-task organize prioritize research and resolve issues in a timely and effective manner xc2xb7 In-depth knowledge of S3 for object storage and data lakes xc2xb7 Understanding of data partitioning and file formats like Parquet or good to have knowledge on OTF Icebergxc2xb7 Understanding of data lineage and data quality tools Business Soft Skills xc2xb7 Proven ability and initiative to learn and research new concepts ideas and technologies quickly xc2xb7 Ability to communicate effectively both verbal and written excellent presentation skills xc2xb7 Ability to effectively move forward on tasks even with ambiguous or changing requirements xc2xb7 Ability to work in a team-oriented collaborative environment in a global context xc2xb7 Willingness and ability to train and teach others xc2xb7 Ability to facilitate meetings and follow up with resulting action items xc2xb7 Ability to self-manage prioritize and execute tasks in a high-pressure environment xc2xb7 Strong systems process orientation with demonstrated analytical thinking organization skills and problem-solving skills xc2xb7 The desire for growth and innovation to bring rapid solutions to business challenges opportunities xc2xb7 Strong consultancy orientation and experience with the ability to form collaborative productive working relationships across diverse teams and cultures is a must xc2xb7 The ability to work in a centralized decentralized operating model with varying implementation partners and implementation owners Schedule Full-time Req 0090XX