Senior Database Warehousing Adminitrator

4 weeks ago

Bengaluru, India The HRBPs Full time

Sr Database Warehouse Admin- Bangalore|7 to 12 years|Salary- 36 from Delivery/ Ride Sharing Edtech Industries and Bangalore Local Candidates ONLY APPLY. (no other applicants consider)


What You'll do:

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 role-based 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 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.

The experience you need:

- 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 large-scale databases.

- Troubleshooting and resolution of complex database and Kubernetes issues

- Excellent problem-solving and critical-thinking skills

- Strong communication and collaboration skills for effective cross-functional teamwork.

- Detail-oriented with a commitment to delivering high-quality results.

- Ability to adapt to a fast-paced and evolving work environment.

- Proactive and self-motivated with a focus on continuous improvement.

- Bachelor's 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.

- Hands-on working experience with cloud platforms like AWS .

- Relevant certifications (e.g., AWS Certified Database - Specialty, MongoDB Certified Database Administrator, Kubernetes Certified Administrator) are Great Company Culture. We pride ourselves on having a values-based culture that is welcoming, intentional, and respectful. Our internal NPS of over 65 speaks for itself - employees recommend Ushur 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 start-up 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. Ushur Community offers wide resources for our employees to learn and grow.

- Flexible Work. In-office 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.

Skills: Candidates with Data Warehousing (DWH) skills-2+ years, prioritizing those who possess comprehensive coding proficiency in SQL and can effectively handle routine operations, including:

- Migration

- Query tuning/Profiling

- Workload isolation

- Role-Based Access Control (RBAC)

- Observability/Monitoring

- Backup/restore

- Effective communication is essential; candidates should demonstrate a strong command of English.

- Basically strong DBA with 2+ years into DWH range: 7-12 years

Interviews: 3-2 over zoom video call and 1 in person

Considering candidates that are based in Bangalore only

2+ years or more in each current role

(ref:hirist.tech)

  • Database Adminitrator

    1 month ago

    Bengaluru, India SKS Enterpprise Full time

    **Position Name -** **Database Administrator** **Location -** **HSR layout-Bangalore (WFO)** **Experience -** **Min. 3 yrs** **Mandatory Requirement**: - Responsible for the design, implementation, maintenance, and optimization of our databases. - Strong SQL skills and ability to write complex SQL queries and stored procedures. - A minimum of 3+ years of...

  • Principal Data Architect, Data Warehousing

    4 weeks ago

    Bengaluru, India Idexcel Technologies Full time

    **Title : Principal Data Architect, Data Warehousing & MPP** At Idexcel, we’re hiring highly technical cloud computing architects to collaborate with our customers on key engagements. Our consultants will develop and deliver proof-of-concept projects, technical workshops, and support implementation projects. These professional services engagements will...

  • BigQuery/Database Engineer

    2 weeks ago

    Bengaluru, India Radhamani Textiles Pvt Ltd Full time

    Job Summary :We are seeking a highly skilled BigQuery and Database Engineer to join our team. The ideal candidate will have extensive experience in managing and optimizing databases, with a specific focus on Google BigQuery. You will be responsible for designing, implementing, and maintaining our data infrastructure to ensure high performance, scalability,...

  • Senior Business Intelligence Developer

    4 weeks ago

    Bengaluru, India Swift Strategic Staff Solutions INC Full time

    We are looking for a highly skilled and experienced Senior Business Intelligence (BI) Developer to join our growing team. You will play a critical role in transforming raw data into actionable insights by designing, developing, and deploying robust BI solutions that empower data-driven decision making across the Bachelor's degree in Computer Science,...

  • Data Engineer

    1 week ago

    Bengaluru, India VY Systems Pvt Ltd. Full time

    Job Description : The role described here is for a seasoned data engineer with 8 to 13 years of experience, showcasing proficiency across various aspects of data management and engineering. Let's delve deeper into each requirement :1. Data Engineering Experience :- Candidates should possess a solid foundation in data engineering, indicating a...

  • Senior Data Warehousing Administrator

    4 weeks ago

    Bengaluru, India WIZALTIA ENTERPRISES Full time

    Role: Senior DataWarehouse BangaloreWe 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...

  • Database Architect

    4 days ago

    Bengaluru, India ValGenesis Full time

    We are looking for an experienced database architect who could join our engineering team to build the next-gen applications for our global customers. If you are a technology enthusiast and have a passion for developing enterprise cloud products with quality, security, and performance, we are eager to discuss with you about the potential...

  • Senior Manager

    1 month ago

    Bengaluru, Karnataka, India Tata Motors Finance Full time

    Job Requirements Job Title: Senior Manager - SCM Warehousing at Tata Motors Finance, BangaloreCompany Name: Tata Motors FinanceLocation: BangaloreSalary: Best in IndustryEmployment Type: Full Time, PermanentJob Description:Are you an experienced Supply Chain Management professional looking to take the next step in your career? We have a fantastic opportunity...

  • Senior Data Architect

    2 months ago

    Bengaluru, India Swift Strategic Staff Solutions INC Full time

    About the Role :We are seeking a highly experienced and visionary Senior Data Architect to join our growing data team. You will be responsible for leading the design, development, and implementation of our enterprise data architecture. You will play a critical role in defining and implementing strategies to ensure our data infrastructure is scalable, secure,...

  • Database Architect

    5 days ago

    Bengaluru, India ValGenesis Full time

    We are looking for an experienced database architect who could join our engineering team to build the next-gen applications for our global customers. If you are a technology enthusiast and have a passion for developing enterprise cloud products with quality, security, and performance, we are eager to discuss with you about the potential...

  • Database Developer

    4 weeks ago

    Bengaluru, Karnataka, India timesjobs Full time

    Proficiency in Backup and Recovery, Database AdministrationExpert in database backup and recovery (RMAN) best practicesExperience with Database Migration, Installation, Upgrades and PatchingDefine the required Oracle patch level (based on Oracle support and the requirements of our clients)Oracle RAC (Real Application Clusters)Knowledge of Advanced...

  • Senior Data Engineer

    4 weeks ago

    Bengaluru, India Talent Corner HR Services Full time

    Skills and Qualifications :- Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent experience).- Experience as a Data Engineer or similar role.- Strong proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL).- Experience with cloud-based data platforms (e.g., AWS, Azure, GCP).-...

  • Power BI Developer

    4 weeks ago

    Bengaluru, India IBU Consulting Full time

    About the job :Our client is seeking a talented Power BI Developer with expertise in data warehousing to join their dynamic team. The ideal candidate will be responsible for crafting and delivering insightful Power BI reports and dashboards, leveraging robust data warehousing principles and practices. This role demands a deep understanding of data modeling,...

  • Idexcel Technologies

    2 months ago

    Bengaluru, India Idexcel Technologies Pvt Ltd Full time

    We are looking for Senior database developer for the Database team. Role & Responsibilities : We are looking for a passionate hands-on DB Developer who is willing to spend most of the time in code and delivering quality code by working closely with development leads and architecture teams in understanding and designing the solution. The candidate should be...

  • Snowflake Developer

    3 weeks ago

    Bengaluru, India RapidBraiins Full time

    Job Description :We are seeking a highly skilled and motivated Snowflake Developer with 2 to 5 years of experience to join our team. The ideal candidate will have a strong background in data warehousing and hands-on experience with Snowflake cloud data platform. As a Snowflake Developer, you will be responsible for designing, developing, and maintaining data...

  • Senior Database Developer

    2 months ago

    Bengaluru, India TIGI HR Solution Pvt. Ltd. Full time

    We are hiring for Senior Database Developer for our esteemed client an US based company who can join us Immediately.Position : Senior Database Developer. Experience : 7 Years - 10 Years. CTC : Open to discuss. Notice Period : Immediate to 15 Days. Job Location : Remote. Job Time : 2:00 PM - 11:00 PM IST (Client base is Canada). Requirements and Skills :-...

  • Senior Data Architect

    4 weeks ago

    Bengaluru, India HuQuo Full time

    Job Description :We are seeking a highly skilled and experienced Senior Data Architect to join our dynamic team. The ideal candidate will play a crucial role in designing and implementing robust data solutions for our clients on cloud and on-premises platforms. As a Senior Data Architect, you will be responsible for driving the development of scalable and...

  • ETL/ODI Developer

    4 weeks ago

    Bengaluru, India TalentPulse Consultant Full time

    Overview :The ETL ODI Developer plays a critical role in designing, developing, and implementing ETL processes using Oracle Data Integrator (ODI). They are responsible for ensuring the efficient flow of data from various sources to data warehouses and maintaining data integrity throughout the process.Key Responsibilities :- Designing and developing ETL...

  • Senior Developer

    5 days ago

    Bengaluru, India Unisys Full time

    What success looks like in this role: Design and implement complex database solutions using modern database technologies such as NoSQL, NewSQL, Graph databases, and cloud databases to support our organization's needs. • Develop and maintain database architecture and standards for our organization, including implementing best practices for data...

  • Data Integration Expert-etl,data Warehousing

    1 month ago

    Bengaluru, India Siemens Healthineers Full time

    As a Data Integration Expert, you are required to: - Develop prototypes and proof of concepts using multiple data-sources, AI/ML methods and big-data technologies - Implement / Deploy large, structured and unstructured databases based on scalable cloud infrastructures - Port data across data-sources /DB systems in order to improve performance, scalability...