Senior DWH Admin

• About Us
• Client is transforming the way enterprises communicate and engage with customers. Fueled by consumer s selfservice demands enterprises are modernizing customer engagement and experience
• models. Client is fast becoming the platform of choice for Customer Experience AutomationTM enabling these enterprises to leapfrog their digital native counterparts and deliver delightful customer and
• employee experiences. With cuttingedge Conversational AI Machine Learning and Intelligent Process Automation technologies Client has enabled Fortune 100 enterprises including some of the world s most well known brands in healthcare insurance banking and financial services sectors to automate their customer engagement. Cloudnative 100% nocode and purely workflowdriven Client empowers citizen developers within business operations teams to build AIpowered fullyautomated and omnichannel experience to digitally transform customer journeys endtoend.

• Role: Senior DataWarehouse Administrator
• Location: Bangalore

• We are in search of an adept and seasoned Database Administrator (DBA) specializing in columnar data warehousing NoSQL databases and demonstrating proficiency in Kubernetes to join our forward thinking team. The ideal candidate will take charge of managing optimizing and securing our columnar data warehouse environment showcasing prowess in resource pool management subcluster configuration and a robust foundation in database administration. Additionally the candidate will play a
• vital role in integrating NoSQL databases and overseeing Kubernetes orchestration. A holistic skill set in database administration NoSQL technologies and containerized environments is essential.

• Columnar Data Warehouse Management:
• Administer and optimize columnar data warehouse systems for high performance reliability and scalability.
• Implement best practices for data modeling distribution sorting and partitioning in a columnar database environment.
• Resource Pool Configuration:
• Design configure and manage resource pools to efficiently allocate computing resources based on workload priorities.
• Monitor and adjust resource pool settings for optimal query performance and resource utilization.
• Subcluster Administration:
• Set up and maintain subclusters within the data warehouse environment to isolate workloads and enhance overall system efficiency.
• Implement and manage subcluster configurations to meet performance and isolation requirements.
• User Access Administration:
• Create modify and delete user accounts in accordance with access requests and organizational changes.
• Manage user access privileges based on job roles and responsibilities ensuring compliance with security policies and regulatory requirements.
• Permission Management:
• Define and implement rolebased access controls (RBAC) to restrict access to sensitive data and functionalities.
• Regularly review and update permissions in collaboration with data owners and stakeholders.
• Security Audits and Monitoring:
• Conduct regular security audits to identify and mitigate potential risks.
• Monitor user activity and access logs implementing proactive measures to prevent unauthorized access and data breaches.
• NoSQL Database Integration:
• Evaluate implement and manage NoSQL databases to complement data warehousing capabilities.
• Ensure seamless integration between columnar and NoSQL databases for diverse data types and use cases.
• MongoDB Cluster and Replica Set Management:
• Design implement and manage MongoDB shared clusters for high availability and fault tolerance.
• Set up and maintain MongoDB replica sets to ensure data redundancy and failover capabilities.
• MongoDB Scaling and Sharding:
• Implement and manage MongoDB sharding for horizontal scaling.
• Monitor and adjust sharding configurations to accommodate growing data volumes.
• Kubernetes Orchestration:
• Implement and manage Kubernetes clusters for containerized deployment of database systems.
• Collaborate with DevOps teams to optimize database performance in a containerized environment.
• User Training and Awareness:
• Provide training on data security best practices and proper use of access privileges.
• Foster a culture of data security awareness within the organization.
• Documentation:
• Maintain accurate documentation of user access policies and procedures.
• Document changes to user access permissions and maintain an audit trail for compliance purposes.
• Performance Tuning:
• Proactively identify and address performance bottlenecks through query optimization and index tuning.
• Collaborate with development teams to ensure optimal database design for
• performance.
• Backup and Recovery:
• Implement robust backup and recovery strategies to ensure data integrity and availability.
• Regularly test and update backup and recovery procedures to meet business continuity requirements.
• Monitoring and Alerting:
• Set up monitoring tools to track system health resource utilization and performance metrics.
• Establish proactive alerting mechanisms to promptly address potential issues.

• Proficiency in columnar database technologies (e.g. Yellowbrick Vertica Snowflake Redshift).
• Strong SQL skills and expertise in query optimization.
• Experience with NoSQL databases (e.g. MongoDB Cassandra Couchbase).
• Proficient in Kubernetes orchestration and containerized deployment.
• Knowledge of resource pool configuration and subcluster management.
• Expertise in database security best practices.
• Familiarity with backup and recovery strategies for largescale databases.
• Troubleshooting and resolution of complex database and Kubernetes issues
• Excellent problemsolving and criticalthinking skills
• Strong communication and collaboration skills for effective crossfunctional teamwork.
• Detailoriented with a commitment to delivering highquality results.
• Ability to adapt to a fastpaced and evolving work environment.
• Proactive and selfmotivated with a focus on continuous improvement.
• Bachelors degree in Computer Science Information Technology or a related field.
• Proven experience as a Database Administrator focusing on columnar data warehousing NoSQL databases and Kubernetes.
• Handson working experience with cloud platforms like AWS .

• Relevant certifications (e.g. AWS Certified Database Specialty MongoDB Certified Database Administrator Kubernetes Certified Administrator) are advantageous.

• Great Company Culture. We pride ourselves on having a valuesbased culture that is welcoming intentional and respectful. Our internal NPS of over 65 speaks for itself employees recommend Client as a great place to work!
• Bring your whole self to work. We are focused on building a diverse culture with innovative ideas where you and your ideas are valued. We are a startup and know that every person has a significant impact!
• Rest and Relaxation. 20 days of flexible leaves per year quarterly Wellness Friday (aka a day off to care for yourself) and more!
• Health Benefits. Preventive health checkups Medical Insurance covering the dependents wellness sessions and health talks at the office
• Keep learning. One of our core values is Growth Mindset we believe in lifelong learning.
• Certification courses are reimbursed. Client Community offers wide resources for our employees to learn and grow.
• Flexible Work. Inoffice or hybrid working model depending on position and location. We seek to create an environment for all our employees where they can thrive in both their profession and personal life.

informatica administration,extract, transform, load (etl),database security,dwh,nosql database integration,columnar data warehouse management,query optimization,kubernetes orchestration,backup and recovery strategies,data warehouse,sql,analysis services