Snowflake And Mssql

Company Name VARITE India Private Limited About The Client Visionet is a premier digital technology solutions company built on the premise of disruptive innovation For over 27 years our innovation-centric and engineering-first approach has unlocked digital-driven success to over 350 global enterprises across Client Retail Banking Financial Services Food Beverage Manufacturing Distribution and Life Sciences industries Our strategic technological alliances with Microsoft Google Salesforce Adobe and AWS as well as accolades like Microsoft Partner of the Year 2021 and EY Entrepreneur of the Year 2021 are a testament to our expertise in delivering seamless digital transition With a talent pool of more than 9 500 passionate engineers and digital consultants across 14 distinct locations around the world we engineer agility and provide innovation-driven value to our clients About The Job We re hiring a Senior Production DBA who lives at the intersection of precision and speed owning Snowflake our MPP backbone for Customer360 Article360 and all other master data business data marts and our SQL Server farm 15-20 servers that will form the Operational Data Store feeding a real-time API stack Java Python You ll tune long-running queries prevent costly shuffles harden HA DR and keep data flowing smoothly across AWS and Microsoft ecosystems Retail experience is a plus Essential Job Functions Snowflake Stewardship MPP Operate and optimize warehouses scaling policies resource monitors tasks streams SnowPipe enforce RBAC masking row access policies object tagging and auditing Investigate query slowness using in-built tools like QUERY HISTORY WAREHOUSE LOAD HISTORY GET QUERY OPERATOR STATS and profile views drive fixes for spills skew poor pruning and high network bytes Reduce cost latency via clustering choices micro-partition awareness result cache strategy and workload isolation dev test prod SQL Server ODS 15-20 servers Own HA DR Always On AGs backup restore strategy full diff log RPO RTO adherence index partition strategies filegroup layout TempDB configuration Troubleshoot live issues with Query Store Extended Events DMVs sys dm exec waits plan cache and tools like sp WhoIsActive SQL Sentry Design for real-time API read patterns connection pooling read replicas hot indexes SLOs for p95 p99 Performance engineering firefighting Triage long-running queries e g TB-scale reshuffles from BI tools eliminate Cartesian blow-ups push selective filters early and right-size warehouses You will be part of Data Engineering and help other teams pre-aggregate or materialize heavy joins codify repeatable fix-patterns Streaming change data capture Enable low-latency data flows via CDC Change Tracking SQL Server and ingestion to Snowflake Snowpipe Streams Tasks Kafka Debezium where applicable Validate end-to-end freshness and reconcile API-facing SLAs Observability incident response Build dashboards alerts CloudWatch Azure Monitor Datadog for queue times spills credits CPU I O waits AG health and API dependency health Part of on-call rotations run blameless postmortems and track remediation to closure Security compliance and governance Enforce least privilege encryption network policies privatelink audit trails partner with Security on SOX PII safeguards and data retention Snowflake Time Travel Fail-Safe SQL Server retention policies Automation DevOps Infrastructure-as-Code for database objects and platform config Terraform Cloud Formation CI CD for schema changes gated releases and drift detection Script the boring away PowerShell Python Bash create self-service runbooks for common ops Capacity cost management Forecast growth manage warehouse instance sizing credits and licensing propose right-tiering and reservation strategies Retail analytics partnership Collaborate with BI Analytics e g MicroStrategy Looker Power BI to shape SQL that prunes early limits width and aligns to clustering join keys common in retail KPIs traffic conversion basket promo returns AI-adjacent data readiness nice to have Support data reliability for Applied AI workloads feature refresh SLAs inference-safe schemas guardrails for LLM-driven SQL generation and performance baselines Qualifications Soft Skills Calm under pressure and decisive in incidents moves gracefully from symptom to root cause Systems thinker with a builder s mindset automates fixes documents standards raises the bar Fast learner who thrives in a fast-changing data landscape comfortable across AWS and Microsoft ecosystems Team player teacher partners with engineers analysts and SREs writes crisp runbooks and shares knowledge Owner mentality proactive self-motivated and grounded in production DBA fundamentals Years Of Experience Experience Level 7 to 10 Years How to Apply Interested candidates are encouraged to respond submit their updated resumes and for additional job opportunities please visit Unlock Rewards Refer Candidates and Earn If you re not available or interested in this opportunity please pass this along to anyone in your network who might be a good fit and interested in our open positions VARITE offers a Candidate Referral program where you ll receive a one-time referral bonus based on the following scale if the referred candidate completes a three-month assignment with VARITE Experience Level Bonus Referral 0-2 years INR 5 000 2-6 years INR 7 500 6 years INR 10 000 About VARITE VARITE is a global staffing and IT consulting company providing technical consulting and team augmentation services to Fortune 500 Companies in USA UK CANADA and INDIA VARITE is currently a primary and direct vendor to the leading corporations in the verticals of Networking Cloud Infrastructure Hardware and Software Digital Marketing and Media Solutions Clinical Diagnostics Utilities Gaming and Entertainment and Financial Services Equal Opportunity Employer VARITE is an equal opportunity employer We celebrate diversity and are committed to creating an inclusive environment for all employees We do not discriminate on the basis of race color religion sex sexual orientation gender identity or expression national origin age marital status veteran status or disability status