Industry Consulting Snr. Consultant at NTT DATA

Bengaluru, karnataka, India -

Full Time

Start Date

Immediate

Expiry Date

14 Jan, 26

Salary

0.0

Posted On

16 Oct, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Management, Data Ingestion, Performance Tuning, Monitoring & Troubleshooting, Backup & Recovery, Security, Automation, SingleStore Expertise, SQL Proficiency, Scripting, High Availability, Cloud Knowledge, Problem-Solving, Communication, Ownership, Fast-Paced Environment

Industry

IT Services and IT Consulting

Description

Database Management: Install, configure, and maintain SingleStore database systems. Data ingestion: Manage SingleStore Pipelines for streaming and load utility for batch data ingestion. Performance Tuning: Optimize queries, indexes, and database design for speed and scalability. Monitoring & Troubleshooting: Set up monitoring tools, diagnose performance issues, and resolve database-related problems. Backup & Recovery: Implement and test disaster recovery strategies and backup plans. Security: Apply database security best practices, manage user roles, and ensure compliance. Automation: Develop scripts (often in Python) to automate routine DBA tasks. Collaboration: Work with developers, DevOps, and infrastructure teams to ensure smooth integration. SingleStore Expertise: Good understanding of SingleStore's (or other columnar stores, such as ClickHouse, Snowflake) distributed architecture, pipelines, and query engine. Knowledge of columnstore vs rowstore optimizations: and how to balance them in Single StoreStrong SQL proficiency: writing complex queries, stored procedures, and optimizing query performance. Scripting: Python and Unix (Shell) skills for automation. Experience with other RDBMS platforms: such as PostgreSQL, SQL Server, or DB2. High Availability: Knowledge of clustering, replication, and failover strategies. Backup & Disaster Recovery: Proven experience in backup/restore processes. Security: Familiarity with encryption, access controls. Cloud Knowledge: Experience with AWS, Azure, or GCP for cloud-based deployments is a plus. Strong problem-solving, communication, sense of ownership, and ability to work in a fast-paced environment. Education: Bachelor's degree in Computer Science, IT, or related field. Experience: 3-5+ years as a DBA, with at least 1-2 years on SingleStore (or similar distributed SQL systems).

Responsibilities

The role involves installing, configuring, and maintaining SingleStore database systems, as well as managing data ingestion and optimizing database performance. Additionally, the consultant will collaborate with developers and infrastructure teams to ensure smooth integration and implement security best practices.