Job Description

Position:

Database Admin- Redshift

Purpose of the Position:

You will be a critical member of the Infocepts Cloud Data Administrator Team. This position requires a deep understanding of Amazon Redshift, database performance tuning, and optimization techniques. Strong foundation in database concepts, SQL, and experience with AWS services is essential.

Location:

Nagpur/Pune/Bangalore/Chennai

Type of Employment:

Full-time

Key Result Areas and Activities:

Design and Development:

Design, implement, and manage Redshift clusters for high availability, performance, and security.

Performance Optimization:

Monitor and optimize database performance, including query tuning and resource management.

Backup and Recovery:

Develop and maintain database backup and recovery strategies.

Security Enforcement:

Implement and enforce database security policies and procedures.

Cost-Performance Balance:

Ensure an optimal balance between cost and performance.

Collaboration with Development Teams:

Work with development teams to design and optimize database schemas and queries. Perform database migrations, upgrades, and patching.

Issue Resolution:

Troubleshoot and resolve database-related issues, providing support to development and operations teams. Automate routine database tasks using scripting languages and tools.

Continuous Learning:

Stay updated with the latest Redshift features, best practices, and industry trends. Deliver technology-focused training sessions and conduct expert knowledge sharing with client stakeholders as needed.

Documentation and Proposals:

Assist in designing case study documents and collaborate with Centre of Excellence/Practice teams on proposals.

Mentorship and Recruitment:

Mentor and groom junior DBAs and participate in conducting interviews for the organization.

Value-Added Improvements:

Propose improvements to the existing database landscape.

Product Team Collaboration:

Collaborate effectively with product teams to ensure seamless integration and performance.

Essential Skills:

Strong understanding of database design, performance tuning, and optimization techniques Proficiency in SQL and experience with database scripting languages (e.g., Python, Shell) Experience with database backup and recovery, security, and high availability solutions Familiarity with AWS services and tools, including S3, EC2, IAM, and CloudWatch Operating System - Any flavor of Linux, Windows

Desirable Skills:

Knowledge of other database systems (e.g., Snowflake, SingleStore, PostgreSQL, MySQL) AWS Certified Database - Specialty or other relevant certifications Prior experience of working in a large media company would be added advantage

Qualifications:

Bachelor?s degree in computer science, engineering, or related field (Master?s degree is a plus) 7-10 years of experience as a Database Administrator, with at least 5 years of experience specifically with Amazon Redshift Demonstrated continued learning through one or more technical certifications or related methods Experience with data warehousing concepts and ETL processes

Qualities:

Should be a quick and self-learner and be ready to adapt to new technologies as and when required Should have the capability to deep dive and research in various technical related fields Able to communicate persuasively through speaking, writing, and client presentations Able to consult, write, and present persuasively Able to work in a self-organized and cross-functional team Able to iterate based on new information, peer reviews, and feedback

Location

India

Years Of Exp

7 to 10 years