Dirección
forma de trabajoCloud Database Administrator
-
008T2B
Schneider Electric has an opportunity for a Cloud DBA in our Monterrey, Nuevo Leon location.
Schneider Digital is the Digital Arm of one of the most successful companies around the World. We are applying cutting edge technologies to improve business processes and infrastructure to enhance our competitive advantage in the market.
We are looking for a new member to become a Cloud DBA to work with the DevOps and Data Engineering teams. The team is expanding, and we are looking for a professional with solid skills, who is energetic, self-motivated, talented, and passionate about technology, who can help us grow and optimize our current cloud environment, and pivot into solution design and deployment. We want someone that is eager to further grow his / her capabilities and being part of an awesome team that delivers high value.
You will be joining a team of DevOps and Data Engineers responsible of creating solutions for the Cloud environment and supporting the migration of legacy apps and solutions as well as building new ones.
Schneider Electric creates connected technologies that reshape industries, transform cities and enrich lives. Our 135,000+ employees thrive in more than 100 countries. From the simplest of switches to complex operational systems, our technology, software and services improve the way our customers manage and automate their operations. Help us deliver solutions that ensure Life Is On everywhere, for everyone and at every moment.
Great people make Schneider Electric a great company.
What do you get to do in this position?
- 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
Qualifications
We know skills and competencies show up in many different ways and can be based on your life experience. If you do not necessarily meet all the requirements that are listed, we still encourage you to apply for the position.
This job might be for you if:
- 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 Cloud Formation 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, 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
Schneider Electric offers a robust benefits package to support our employees such as flexible work arrangements, paid family leave, a culture of wellness, and more great benefits above and beyond a typical employer. Click to find out more about working with us: http://se.com/mx/carreras.
We seek out and reward people for putting the customer first, being disruptive to the status quo, embracing different perspectives, continuously learning, and acting like owners. We’re recognized around the world for welcoming people as they are. We create an inclusive culture where all forms of diversity are seen as a real value for the company. See what our people have to say about working for Schneider Electric.
Let us learn about you! Apply today.
You must submit an online application to be considered for any position with us. This position will be posted until filled.
It is the policy of Schneider Electric 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 conduct.
Concerning agencies: Schneider Electric does not accept unsolicited resumes and will not be responsible for fees related to such.
Schneider Electric is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.
Primary Location
:
MX-Nuevo León-Monterrey
Schedule
:
Full-time
Unposting Date
:
Ongoing
