Database Engineer- Iii (Haryana)

Database Engineer- Iii (Haryana)

07 Aug
|
trek bicycle
|
Haryana

07 Aug

trek bicycle

Haryana

A bit about us Trek is an awesome place to work with amazing benefits for all employees We build only products we love provide incredible hospitality to our customers and change the world by getting more people on bikes When you re on our team you re taken care of encouraged to learn and grow and given lots of opportunities to do so Give us your best and we ll give it right back Sound pretty sweet Then come join us Company Summary Trek Bicycle is a global leader in the design and manufacture of bicycles and related products Trek believes the bicycle can be a simple solution to many of the world s most complex problems and is committed to breaking down the barriers that prevent people from using bicycles more often for transportation recreation and inspiration Our mission is to create products we love and take care of our customers We value our team making sure the best is on the field We value new ideas from anywhere inspiring others with our positive energy dealing with reality to make the tough calls and getting things done fast- turning ideas into reality Position Description Database Engineering Trek s Infrastructure Engineering team runs a hybrid estate spanning on prem SQL Server and Azure including Azure SQL Database Hyperscale We re standardizing observability on Grafana Loki modernizing automation and CI CD and migrating selected databases across our environments You ll help operate secure and evolve these data platforms for mission critical apps including BI ERP JDE and other enterprise systems This role is part of a collaborative cross-functional team that spans infrastructure engineering development and functional areas and supports Trek s global headquarters in Waterloo WI Responsibilities Operate optimize databasesAdminister Microsoft SQL Server on prem Windows Server and Azure SQL Hyperscale and or Managed Instance across our environments Tune performance end to end indexing plan analysis Query Store waits I O and deliver measurable improvements on targeted workloads Manage capacity and cost compute sizing file layouts storage growth and backups retention Reliability HA DR and changeEngineer and run HA DR Always On AG FCI replication log shipping with defined RPO RTO execute quarterly DR tests with complete documentation Plan and execute database upgrades and migrations on prem Azure version upgrades with minimal downtime and explicit rollback Patch harden and maintain fleets with automation and low rollback rates Integrations Analytics plus Support and enhance SQL Server Integration Services SSIS packages and scheduling orchestration patterns help modernize or migrate when appropriate Administer and optimize SQL Server Analysis Services SSAS processing strategies partitioning and cube model performance Qlik Replicate Skilled in installing configuring and administering Qlik Replicate with expertise in CDC endpoint management and task monitoring Proficient in managing Qlik Replicate to ensure reliable real time data replication supporting seamless integration Observability Incident ResponseStand up and maintain database health dashboards in Grafana centralize SQL logs into Loki author actionable alerting Participate in the on call rotation triage incidents quickly lead assist RCAs and close the loop with documentation Collaboration enablementWork closely with application teams ERP JDE stakeholders BI Analytics and Cloud Network Systems engineers Mentor junior engineers and contribute to internal guilds tech talks RequirementsBachelor s degree in Computer Science Information Systems or equivalent experience Proficiency in T SQL and SQL Server internals query plans indexes waits DMVs transaction log tempdb concurrency Hands on experience with Azure SQL Hyperscale MI preferred connectivity patterns Private Endpoints backups restore security monitoring HA DR experience with Always On AG FCI and DR testing clear understanding of RPO RTO and failover mechanics Operational excellence backup restore strategies patching access control and documentation Scripting automation with PowerShell and T SQL Git workflows branching PRs code reviews Familiarity with PostgreSQL and or MongoDB concepts and tooling enough to complete onboarding and basic operations Ability to collaborate with cross-functional teams including Infrastructure Security BI ERP and Business users Strong written and verbal communication skills including the ability to document procedures train users and explain technical concepts Additional SkillsSystems networking fluency big plus Comfortable troubleshooting across layers DNS routing load balancers WAF proxies TLS PKI firewalls NSGs Private Endpoints and hybrid connectivity Qlik Replicate CDC patterns endpoint sizing tuning job reliability and monitoring alerting experience integrating Replicate logs metrics into Grafana Loki SSIS SSAS Package lifecycle and performance SSIS Tabular Multi D admin and model tuning SSAS Automation pipelines GitHub Actions Azure DevOps or Jenkins database CI CD with SSDT Flyway Liquibase test automation for schema changes Observability Grafana panels alerting Loki log pipelines exporters agents for SQL metrics Security Always Encrypted with secure enclaves Azure Key Vault Managed Identity RBAC design auditing and least privilege patterns Data platform breadth SQL Server replication Postgres streaming replication partitioning MongoDB sharding replica sets Infra networking Windows Server 2022 storage fundamentals DNS PKI Private Link firewalls NSGs performance across hybrid links SRE mindset SLA SLO design error budgets incident command post incident reviews ToolsDatabases SQL Server on prem Azure Azure SQL Hyperscale MI exposure to PostgreSQL MongoDB Automation PowerShell T SQL optionally Python Terraform CI CD GitHub primary Azure DevOps Jenkins during transitions Observability Grafana Loki logs optionally Mimir Prometheus exporters If you like wild growth and working with happy enthusiastic over-achievers you ll enjoy your career with us

📌 Database Engineer- Iii (Haryana)
🏢 trek bicycle
📍 Haryana

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: database engineer- iii (haryana) / haryana

Subscribe to this job alert:

Get the latest job offers by email for: database engineer- iii (haryana) / haryana