This role is for a true database leader — someone who has designed, scaled, and maintained mission-critical MS SQL Server environments that handle terabytes of data and thousands of concurrent users. You'll own every aspect of the SQL Server stack — from core engine tuning and HA/DR setup to schema optimization and security hardening. This is a pure on-premises DBA role, built for those who understand the cost of downtime and the value of precision. You’ll work closely with engineering, DevOps, support, and business teams to ensure our data layer is fast, available, secure, and future-ready. Key Responsibilities Architecture & Design Design, implement, and support enterprise-scale SQL Server infrastructure (SQL Server 2014 through 2022) Architect and maintain Always On Availability Groups, clustering, log shipping, and replication across data centers Build fault-tolerant database clusters optimized for low-latency and high-throughput use cases Evaluate and recommend hardware, disk I/O strategies, and storage tiers for OLTP and OLAP workloads Performance & Optimization Analyze execution plans and wait stats to optimize server, query, and index performance Implement and refine indexing, partitioning, and compression strategies for very large databases (1TB+) Tune system-wide performance across tempdb, memory grants, parallelism, and disk subsystems Automate performance monitoring and anomaly detection Operations & Automation Own and manage all backup, restore, and recovery strategies using native tools and scripting Automate maintenance plans using SQL Agent, PowerShell, and in-house tooling Implement robust alerting and health checks across 24x7 production environments Lead patching, version upgrades, and schema deployments with zero downtime Security & Compliance Define and enforce least-privilege access, authentication protocols, and encryption policies Implement row-level security, auditing, data masking, and compliance controls (HIPAA, GDPR, ISO) Conduct periodic vulnerability scans and participate in audit reviews Incident Management & Troubleshooting Lead RCA efforts on slowdowns, deadlocks, blocking, I/O contention, and unplanned outages Coordinate escalation with vendors and internal teams for resolution and knowledge sharing Document incident runbooks and create preventive SOPs Collaboration & Mentorship Act as the primary DBA resource for application development, DevOps, and infrastructure teams Guide developers on query design, execution plans, indexing, and transaction control Mentor junior DBAs and create a knowledge-driven culture of continuous improvement Required Experience & Skills 10+ years in hands-on SQL Server DBA roles in high-volume, on-prem environments Expertise in HA/DR solutions: Always On AGs, failover clustering, log shipping, replication In-depth understanding of SQL Server internals: memory architecture, query engine, locking, wait types Proficiency in T-SQL, dynamic SQL, and procedural development Strong in performance troubleshooting using DMVs, Extended Events, Query Store, Profiler Advanced PowerShell scripting for task automation and orchestration Proven experience with backup tools (native, Redgate, Quest) and enterprise monitoring solutions Experience managing databases over 1TB with more than 1000 concurrent sessions Solid understanding of Windows Server, Active Directory, and storage subsystems Strong documentation, incident reporting, and change management discipline Nice to Have Experience with SSIS, SSRS (maintenance and troubleshooting) Familiarity with SAN/NAS storage tuning Basic understanding of DevOps pipelines for DB changes (Liquibase, Redgate, etc.) What You’ll Get Competitive pay with bonus structure linked to uptime, performance, and ownership A chance to lead high-availability database systems with real impact Work with senior engineering and infrastructure teams in a flat, collaborative culture Clear promotion paths and quarterly reviews Training budget and paid certifications to stay ahead in SQL Server and automation An environment that values accountability, craftsmanship, and clarity

Job Summary: We are looking for an experienced and proactive HR Manager to oversee key HR functions, including talent acquisition, onboarding, offboarding, exit interviews, document management, and support for payroll and employee engagement initiatives. The ideal candidate will play a critical role in enhancing the employee experience and ensuring smooth HR operations. Key Responsibilities: Talent Acquisition Lead end-to-end recruitment across various departments Manage job postings, sourcing, screening, interviews, and selection processes Onboarding Design and manage a structured onboarding process Ensure all new hire documentation and system access are completed accurately and on time Conduct employee orientations and monitor onboarding milestones Offboarding and Exit Interviews Manage the offboarding process, including documentation, clearances, and final settlements Conduct exit interviews and analyze feedback to support continuous improvement Ensure timely recovery of company assets and revocation of access Document Management Maintain accurate and compliant employee records (both digital and physical) Support audits by ensuring organized and up-to-date documentation Payroll Assistance Coordinate with payroll teams to ensure accurate and timely payroll processing Verify employee attendance, leave records, and deductions Respond to employee payroll-related queries Employee Engagement Support planning and execution of employee engagement initiatives and internal events Assist with recognition programs and feedback mechanisms Help foster a positive and inclusive workplace culture Requirements: Bachelor’s or master’s degree in human resources, Business Administration, or a related field Experience in recruitment, onboarding, and employee lifecycle processes Familiarity with HR software (e.g., HRMS, ATS) Knowledge of labor laws and HR compliance requirements Excellent communication, organization, and problem-solving skills High level of integrity and discretion when handling confidential information Preferred Qualifications: Experience in a fast-paced or growing organization Exposure to payroll and employee engagement systems

Summary: Open Rainbow is seeking an experienced Senior MS SQL Developer to join our on-site team in Hyderabad. The ideal candidate will have deep expertise in writing complex SQL queries and extensive experience in query optimisation and performance tuning. This role is critical to ensuring the performance, reliability, and scalability of our database systems. Success in this role requires a strong ability to analyze execution plans, identify bottlenecks, and implement solutions that enhance database efficiency. You will work closely with cross-functional teams to support data-driven decision-making and ensure high standards of data performance across the organization. Responsibilities: Design, develop, and maintain complex T-SQL queries, stored procedures, views, functions, and triggers. Analyze and interpret SQL Server execution plans to identify inefficiencies and implement performance improvements. Conduct query tuning, indexing strategies, and database refactoring to improve overall system performance. Collaborate with application developers, data analysts, and system architects to support data-related initiatives. Perform root cause analysis for performance issues and provide long-term, scalable solutions. Monitor database performance metrics and proactively address areas for improvement. Ensure high standards of data integrity, availability, and security within SQL Server environments. Participate in code reviews and mentor junior team members on SQL development best practices. Support ongoing database maintenance, including index management, statistics updates, and performance monitoring. Qualifications: Minimum 5 years of experience in MS SQL Server development with a focus on performance optimization. Strong proficiency in writing and tuning complex T-SQL queries. Expert-level knowledge in analysing and improving SQL execution plans. Hands-on experience with indexing, partitioning, and optimization techniques. Familiarity with performance monitoring tools and dynamic management views (DMVs). Solid understanding of database design, normalization, and transactional processing. Strong analytical and problem-solving skills with attention to detail. Effective verbal and written communication skills. Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent practical experience.