Database Admin- 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.

**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