Overview:
We’re looking for a SQL Server DBA to join our Data team. You’ll keep our database environment reliable, fast, and secure. You’ll work closely with the Data Engineering, BI, Development, and Infrastructure teams in an Agile environment.
Responsibilities:
- Administer and maintain SQL Server databases, covering monitoring, backup/recovery, and routine maintenance.
- Analyze and optimize queries, stored procedures, indexes, and overall database performance.
- Develop, monitor, and troubleshoot SSIS packages, ETL processes, and SQL Server Agent jobs.
- Support Data Warehouse operations, data integration, and database migrations.
- Implement and manage table partitioning for large datasets.
- Support high availability (HA) solutions and make sure the database environment stays stable.
- Manage database access, permissions, and security according to internal policies.
- Monitor resource usage, find bottlenecks, and contribute to capacity planning.
- Automate routine DBA tasks and manage database changes through Git and CI/CD pipelines.
Qualifications:
- 3+ years of hands-on experience with Microsoft SQL Server and T-SQL.
- Strong knowledge of performance tuning, indexing, and query optimization.
- Experience with backup/restore, SQL Server Agent jobs, and production troubleshooting.
- Solid hands-on experience with SSIS, ETL processes, and Data Warehouse concepts.
- Strong knowledge of SQL Server partitioning.
- Familiarity with HA solutions (e.g., Always On AG, Failover Clustering, Log Shipping).
- Experience with database monitoring tools (e.g., Redgate, SolarWinds, Grafana, or similar).
- Proficiency with Git and hands-on experience with CI/CD concepts.
- Experience working in an Agile/Scrum environment.
- Strong analytical and problem-solving skills, with the ability to work independently and in a team.
- Nice to Have:
- Familiarity with Kafka, Spark, and ClickHouse.
- Familiarity with Python and R for automation and data processing.
- Experience with large databases and PBIRS/SSAS.