Database Admin - Amazon Redshift
- InfoCepts
- 7 - 10 years
- India
- 8 months ago
- Email to a friend
- Report this job
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.
Roles and 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 (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
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: Database AdministratorEmployement Type: Full timeContact Details:
Company: InfoCeptsLocation(s): India
Keyskills: snowflake python aws iam performance tuning amazon redshift database performance tuning data warehousing database administration sql database design amazon ec2 postgresql iam database creation optimization techniques linux mysql shell scripting aws etl amazon cloudwatch
Similar positions
InfoCepts
Part of the global G4S security conglomerate, this Delhi-based entity has been operating since 1996. It provides business services such as facilities management, staffing for corporate and administrative roles, and security solutions. It reported revenue of around 31.4 crore in FY 2022 and functions...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in