at Alight Solutions LLC in Chicago, Illinois, United States
At Alight, we believe a company's success starts with its people. At our core, we Champion People, help our colleagues Grow with Purpose and true to our name we encourage colleagues to "Be Alight."
Champion People - be empathetic and help create a place where everyone belongs.
Grow with purpose - Be inspired by our higher calling of improving lives.
Be Alight - act with integrity, be real and empower others.
It's why we're so driven to connect passion with purpose. Our team's expertise in human insights and cloud technology gives companies and employees around the world the ability to power confident decisions, for life.
With a comprehensive total rewards package, continuing education and training, and tremendous potential with a growing global organization, Alight is the perfect place to put your passion to work.
Join our team if you Champion People, want to Grow with Purpose through acting with integrity and if you embody the meaning of Be Alight.
Learn more at careers.alight.com.
What You'll Do:
Design, implement, and monitor databases, schemas, tables, and associated data objects, with a focus on optimizing performance and efficiency.
Designing, creating, and implementing regular maintenance procedures to ensure the stability and reliability of the database clusters.
Establish guidelines, standards, and procedures for database management and integration of systems through effective database design.
Leverage AWS design principles, data access patterns, and relevant AWS services to enhance the efficiency and performance of the database management process.
End-to-end platform support, infrastructure issues troubleshooting, installation and configuration of applications, platform version upgrades, fixing vulnerabilities in co-ordination with vendors, incident management and change management, working with multiple infrastructure teams and vendors for RCA and Remediation for P1/P2/P3 incidents.
Responsible for supporting the platform primarily during US CST time zone by following a rotational support roaster.
Responsible for platform high availability, devising and executing on the DR strategy.
Provide support for Application development & Production teams.
What you'll Need:
Strong expertise in AWS RedShift database administration, including cluster management and optimization.
Strong experience with AWS Services - S3, Athena, IAM, CLI, EC2, Glue, Lambda, Sagemaker, LakeFormation.
Hands on experience with troubleshooting performance issues and implement best practices.
Ability to understand ETL pipelines and BI reporting needs.
Build integrations with Identity providers - Ping, Okta etc.
Strong SQL skills
Advanced knowledge and experience in the development of Python or Linux Shell scripting in combination with d.
Working knowledge of DevOps best practices.
Expertise in 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.
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
Good to have - AWS Certified Solution Architect
Experience handling patches and fixing vulnerabilities.
Experience in Agile and DevOps development process
Maintain regular communication with users regarding best practices, policies, procedures, and scheduled maintenance.
Documents and maintain work-instructions, complete audit required tasks.
**US Citizenship requirements- as this role supports services provided to the federal government and/or a federal government contractor, proof will be required to verify US citizenship status at time of hire.**
So that you can be your best at work and home, we consider flexible working arrangements wherever possible. Alight has been a leader in the flexible workspace and "Top 100 Company for Remote Jobs" 5 years in a row.
We offer programs and plans for a healthy mind, body, wallet and life because it's important our benefits care for the whole person. Options include a variety of health coverage options, wellbeing and support programs, retirement, vacation and sick leave, maternity, paternity & adoption leave, continuing education and training as well... For full info follow application link.
Alight Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, pregnancy, childbirth or related medical condition, veteran, marital, parental, citizenship, or domestic partner status, or any other status protected by applicable national, federal, state or local law. Alight Solutions is committed to a diverse workforce and is an