Data Warehouse-Admin

Job Requirements

a) Job Profile :

• Managing various Cloud Data warehouses & Data lakes - Redshift (mandatory) / RDS/DynamoDB / S3, etc
• Interaction with relevant Teams both internal and external partners for trouble-shooting and solutions.

b) Key Deliverables ( Quantifiable dimensions ) of the job :

• Manage, support and maintain database environments adhering to the architectural guidelines, policies, and best practices.
• Take a key role in understanding performance metrics, monitoring system performance, and troubleshooting issues
• Install and maintain the administrative and monitoring tools necessary for high levels of availability and performance of the client's system - Perform day to day and long term monitoring of system health as it relates to database usage and performance.
• Design & maintain procedures and putting them into operation.
• Diagnose and resolves database performance, capacity and replication issues. Perform research into database performance issues and come up with solutions to address those concerns.
• Produces reports on database systems related to availability, performance, capacity management and SLAs.
• Implement & maintain security for DW ( including row-level ,column level, encryption, masking ,etc).
• Able to create and implement effective Backup and Recovery plans .
• Defining procedure for critical activity and simulating such as restoring of backup etc
• Configuring and maintaining environment copies according to the Backup & DR strategy.
• Perform physical implementation of databases, storage structures, high-availability solutions such as multi-AZ, replication, and disaster recovery solutions.
• Work with engineering teams to optimize data costs for their products and domains.
• Identifying,, suggesting and initiating areas of improvements .
• Creation and maintenance of Operational manuals of all tasks associated with administration .

Work Experience

• a> Right Person

  Having minimum 4 years’ experience in above specified areas (Database Administrator role) , with Minimum of 2 years of experience working In AWS cloud data storage solutions ,including Redshift , Relational Database Service (RDS), or Aurora .
• Experience of managing landscapes end to end independently.
• Experience with design and implementation of database structures.
• Excellent ability to work collaboratively with distributed cross-functional teams in an Agile development environment.
• Certifications would be preferred.

• b> Educational Qualification

  BE,MCA, MSC-IT from any reputed/recognized university.

• c> Other Requirements

  Following are mandatory

  Energetic, proactive, high degree of ownership.
• Good at problem solving.
• Team player with good communication skills and ability to plan/meet deadlines.
• Adaptable, reliable, very well organized and able to work effectively under pressure.
• Strong documentation practice.
• Quality oriented mindset.