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