Infocepts - Database Administrator - Amazon Redshift

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.

Roles & Responsibilities :

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 (Masters degree is a plus).

- 3 to 7 years of experience as a Database Administrator, with at least 3 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.