CTG is seeking to fill an AWS Redshift Database Administrator (DBA) opening for our client in Newark, NJ. Location: Remote Duration: 12 months Duties: Manage day-to-day administration of Amazon Redshift clusters, including user access, permissions, and security configurations. Monitor database performance, analyze query workloads, and optimize Redshift cluster performance using workload management (WLM) and query tuning techniques. Perform backup, snapshot, and recovery operations to ensure data integrity and availability. Handle cluster resizing, scaling, and maintenance tasks such as vacuuming and analyzing tables. Troubleshoot ETL/ELT processes and optimize data ingestion workflows integrating with Amazon S3, Redshift Spectrum, and Athena. Automate DBA tasks and workflows using Python and orchestration tools like Airflow. Implement security and compliance configurations including IAM roles, VPC security, and data governance frameworks (e.g., GDPR, HIPAA). Support Redshift Serverless design, deployment, and best practices. Use CloudWatch to monitor Redshift clusters and set up alarms for proactive issue detection. Collaborate on AWS account design and management alongside other AWS services such as Lambda and Glue. Assist in disaster recovery planning with cross-region strategies. Maintain data retention policies, partition management, and schema design best practices in Redshift environments. Skills: Expertise with Amazon Redshift administration, including traditional and serverless architectures. Strong SQL skills with deep understanding of database design, schema management, and data distribution strategies. Proficiency in performance tuning, query optimization, and workload management. Familiarity with AWS ecosystem tools such as Lambda, Glue, Airflow, and CloudWatch. Ability to automate DBA tasks using Python scripting. Knowledge of security best practices for AWS and Redshift, including IAM, VPCs, and compliance frameworks. Excellent problem-solving and troubleshooting skills related to ETL workflows and data ingestion. Understanding of data lake architecture and integration with Redshift. Experience: Minimum 6 years overall experience as a Database Administrator. At least 3 years of hands-on experience working with AWS services. Minimum 2 years of focused experience managing Amazon Redshift clusters and related services. Proven experience with Redshift backup, recovery, scaling, and security configurations. Experience with automation, monitoring, and alerting using AWS CloudWatch and scripting tools. Exposure to data governance and compliance in cloud data environments. Education: Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent work experience. Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required. CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role. To Apply: To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Laura Dominguez at Laura.Domniguez@ctg.com. Kindly forward this to any other interested parties. Thank you! The expected base salary for this position ranges from $ 86,000 to $ 90,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, market factors, and where applicable, licensure or certifications obtained. In addition to salary, a competitive benefit package is also offered. About CTG CTG, a Cegeka company, is at the forefront of digital transformation, providing IT and business solutions that accelerate project momentum and deliver desired value. Over nearly 60 years, we have earned a reputation as a faster and more reliable, results-driven partner. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG leverages the expertise of over 9,000 team members in 19 countries to provide innovative solutions. Together, we operate across the Americas, Europe, and India, working in close cooperation with over 3,000 clients in many of today's highest-growth industries. For more information, visit www.ctg.com. Our culture is a direct result of the people who work at CTG, the values we hold, and the actions we take. In other words, our people define our culture. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. Part of our mission is to cultivate a workplace that attracts and develops the best people, reflected by our recognition as a Great Place to Work Certified™ company across many of our global operations. CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws. CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.