SQL Server Database Administrator
Share
Job Location:
Monthly Salary:
Posted on:
12 hours ago
Vacancies:
1 Vacancy
Job Summary
Role Summary:
We are looking for an experienced SQL Server DBA for an IC role.
The OSTTRA Database Team is responsible for supporting and managing a diverse portfolio of database technologies-Oracle PostgreSQL SQL Server MySQL and others. While the majority of our infrastructure is deployed on AWS and GCP SQL Server workloads remain hosted within on-premise datacenters.
We are looking for an experienced hands-on SQL Server DBA that can work independently with application teams for their issues and new requirements.
Key Accountabilities:
- Database Operational Support Work in shift model and providing on-call support during weekends and holidays.
- Support application release activities.
- Handling day-to-day issues like user access performance tuning backup and recovery HA migrations upgrade patching etc
Required Skill Sets
Primary -
6-12 years of experience as a SQL Server DBA and experience in
- Managing SQL Server on Windows Server
- SQL Server Installation and Configuration
- Monitoring and optimizing database performance using SQL Profiler Performance Monitor and Query Analyzer
- Implementing and managing backup and recovery strategies
- Setting up and managing high availability solutions like Always On Availability Groups Failover Clustering and Log Shipping.
- Routine maintenance tasks such as index rebuilding updating statistics and database consistency checks. Automating maintenance tasks using SQL Server Agent.
- Diagnosing issues Using Event Viewer SQL Server Logs and Error Logs.
- Writing and optimizing T-SQL queries stored procedures triggers and functions. Understanding query execution plans and how to optimize them.
- Automating repetitive tasks using PowerShell SQL Server Agent Jobs and other scripting languages.
Secondary
- Any experience in Oracle or Postgres (Optional
