Senior Data Warehousing Administrator

4 weeks ago

Bangalore, Karnataka, India WIZALTIA ENTERPRISES Full time

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

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.

(ref:hirist.tech)

  • Senior Data Engineer

    4 weeks ago

    Bangalore, Karnataka, 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

    Bangalore, Karnataka, 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,...

  • Data Architect

    4 weeks ago

    Bangalore, Karnataka, India Coders Brain Pvt Ltd Full time

    Job Overview :We are seeking a highly skilled Data Architect with expertise in modeling data lake and data warehouse environments, as well as extensive experience in database analysis, optimization, and query performance optimization. The ideal candidate will have a strong understanding of database table retrievals, partitions, indexing, and query...

  • ETL/ODI Developer

    4 weeks ago

    Bangalore, Karnataka, 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...

  • Snowflake Developer

    1 week ago

    Bangalore, Karnataka, 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 Warehousing Adminitrator

    4 weeks ago

    Bangalore, Karnataka, 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...

  • Junior Data Engineer

    3 weeks ago

    Bangalore, Karnataka, India Aceseekers Full time

    Location : Bangalore (Hybrid mode of work. Must visit office 4 days in a week)Experience : 5 - 6 YearsSnowflake is mustMust-Have :- 5 years' experience in ETL, analytics, business intelligence, and data architecture, including data modeling (logical & physical), data visualization, data warehousing, and analytical enablement- 4 years' experience in...

  • SnapLogic Engineer

    4 weeks ago

    Bangalore, Karnataka, India Growel Softech Pvt. Ltd. Full time

    Job Description :- 8 Years of experience in Data warehouse implementation- Design, build, and maintain data pipelines to collect, store, and process data from various sources.- Create and manage data warehousing.- Has Strong hands-on experience in Snaplogic Design/Development.- 3 Years hands-on experience in SnapLogic development is mandatory.- Experience in...

  • Senior Data Warehouse Administrator

    4 weeks ago

    Bangalore, Karnataka, India Sourcingxpress Full time

    Company Overview : We are hiring for one of our product clients, a leading player in Customer Experience Automation- .Our client specializes in revolutionizing how enterprises interact with customers, offering cutting-edge solutions that automate and enhance customer engagement processes. They are at the forefront of innovation in customer experience,...

  • Business Intelligence Developer

    4 weeks ago

    Bangalore, Karnataka, India Chadwick Professional Services Private Limited Full time

    Company Description :Chadwick is a Bengaluru-based company specializing in IT Permanent and Temporary Staffing, Leadership/Executive Hiring, Recruitment Process Outsourcing (RPO) Services, and Market Insight. With approvals from MSME and Start-up India, Chadwick- is committed to providing innovative solutions in the industry. By hiring and managing great...

  • ETL ODI Developer

    4 weeks ago

    Bangalore/Hyderabad, Karnataka, India Whizz HR Full time

    Job Description :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...

  • Power BI Developer

    3 days ago

    Bangalore/Hyderabad, Karnataka, India Chane Leaders Full time

    JD for Power BI :- BI experience like ETL, Data warehousing management, Data Mining, Report Designer, or developer- Heterogeneous Database Management Systems like Oracle, MySQL, SAP etc., Power BI- Programming language such as DAX, MDX, SQL- Conceptual knowledge of Azure/AWS cloud architecture or any Cloud SaaS experience- Computer Science or Engineering...

  • UsefulBI Corporation

    3 weeks ago

    Bangalore, Karnataka, India USEFULBI CORPORATION Full time

    Company Description : UsefulBI Corporation is a leading provider of comprehensive solutions in Data Engineering, Data Science, AI/ML, and Business Intelligence. Our mission is to empower astute business decisions through the integration of data insights and cutting-edge AI. We excel in utilizing the latest tools and technologies, ranging from data...

  • Business Insights Analyst

    4 weeks ago

    Bangalore, Karnataka, India Cortex Consulting Pvt. Ltd. Full time

    Summary:We are seeking a highly skilled and experienced Business Insights Analyst to join our team. You will play a key role in extracting valuable insights from data to support informed business decisions. Your expertise in data management, analytics, and a strong foundation in SQL (particularly with Snowflake) will be instrumental in transforming raw data...

  • Data Modeler

    4 weeks ago

    Bangalore/Hyderabad, Karnataka, India Talent500 Full time

    As a Data Modeler, you will create and maintain conceptual, logical, and physical data models for efficient and high-performance storage and retrieval of data from Cloud-based, enterprise-grade, Big Data environments that enable Data Science, Data Analytics, and Reporting functions on multi-sourced, multi-branded data. You will work with both Business users...

  • Azure Data Engineer

    3 weeks ago

    Bangalore, Karnataka, India Talent Bee Consulting Pvt Ltd Full time

    About the job :Ideal Candidate :- 3+ years in Azure Data Engineering- Very good at ADF (Azure Data Factory)- Hands-on experience in designing and implementing data solutions on AzureOrganization :A global provider of Automation solutions in Assembly, Inspection, and Testing for manufacturing industries. With a mission to enhance the efficiency of the...

  • Senior Business Analyst

    4 weeks ago

    Bangalore, Karnataka, India Careernet Full time

    Roles and Responsibilities :Data Analysis and Visualization : - Work with large and complex datasets using SQL, Python, Tableau, and Power BI.- Clean, aggregate, analyze, interpret, and ensure the quality of data.- Prepare data for predictive and prescriptive analysis.- Translate analyzed data into actionable business insights.- Develop compelling data...

  • Tableau Developer

    4 weeks ago

    Bangalore, Karnataka, India Gallop Research Full time

    Role : Tableau DeveloperJob Description :Responsibilities :This is a strong technology and solution delivery role, accountable for the successful design, development, and delivery of Analytics solutions integrated with the corporate Data Platform - not only for self, also for a team of developers working on specific projects. - Perform data analysis, design...

  • Power BI Developer

    4 weeks ago

    Bangalore, Karnataka, India Sourceone Staffing & Consulting Pvt Ltd Full time

    Job Description :- Expertise in developing BI applications utilizing SQL/PLSQL, BI stack, Power BI.- Expertise in using MS Power BI to design and create dashboards and reports .- Create Power BI reports based on business requirements with linked content, drilldowns, and nested parameters.- Optimize Microsoft Power BI dashboards with a focus on usability,...

  • Senior Data Architect

    4 weeks ago

    Bangalore, Karnataka, India HuQuo Consulting Pvt. Ltd. Full time

    Job Title : Senior Data ArchitectExperience : 10-15 yearsJob 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...