Sql Database Administrator

BayOne
United States
1 day ago
Apply on www.thejobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Working hours
Regular working hours

Tech stack

Artificial Intelligence Airflow Amazon S3 Information Systems Information Engineering Extract Transform Load (ETL) Data Warehousing Python (Programming Language) PostgreSQL Log Shipping Microsoft SQL Server SQL Azure
+23 more
MySQL Oracle Databases Performance Tuning Windows PowerShell Query Optimization Cloud Services Sqlprofiler SQL Databases Transact-SQL Scripting Google Cloud Enterprise Software Applications Snowflake Database Optimization Software Troubleshooting Scalability Testing Amazon Relational Database Service Information Technology SolarWinds (Software) Tools for Reporting Redgate Database Monitoring Data Pipelines

Job description

  • Well versed with database monitoring and analytics tools such as SolarWinds DPA, Redgate SQL Monitor, or SentryOne. Certifications such as Microsoft Certified: Azure Database Administrator Associate or SQL Server Performance Tuning Specialist., * Participation in performance benchmarking and scalability testing of enterprise applications.

Requirements

  • Excellent communication skills, attention to detail, and ability to prioritize in a fast paced, multi-database environment., * Bachelor’s degree in computer science, Information Systems, or a related field (or equivalent practical experience).

\n

  • 5-7 years of experience as a DBA with a strong emphasis on SQL Server performance tuning and optimization.

\n

  • Expertise in query tuning, indexing strategies, query store analysis, execution plan interpretation, and hardware resource analysis.

\n

  • Familiarity with dynamic management views (DMVs), SQL Profiler, Extended Events, and Query Store.

\n

  • 2+ years of experience with Snowflake and dbt for data warehousing.

\n

  • 3+ years of hands-on experience with AWS cloud services (S3, Glue, DMS, Lambda, Redshift, etc.).

\n

  • Solid understanding of ETL/ELT pipelines and data orchestration with strong focus on Airflow.

\n

  • Strong background in T-SQL and scripting for automation (e.g., PowerShell or Python).

\n

  • Experience with HA/DR design (Always On, log shipping, clustering) and its impact on performance.

\n

  • Ability to translate performance insights into actionable recommendations for developers and infrastructure teams.

\n

  • Ability to leverage AI for DBA tasks as well as implementing AI to improve current processes., n

  • Experience with CI/CD pipelines for data Engineering Workflows.

\n

  • Experience with cloud-based databases (Azure SQL, AWS RDS, or Google Cloud SQL).

\n

  • Working knowledge of Oracle, PostgreSQL, and MySQL administration and performance troubleshooting a plus.

Benefits & conditions

  • Analyze, tune, and optimize database performance for mission-critical SQL Server environments.

\n

  • Perform deep analysis of slow-running queries, indexes, and workloads using advanced performance monitoring tools.

\n

  • Partner with developers to improve SQL code efficiency, optimize schema design, and ensure scalable architecture.

\n

  • Implement, maintain, and support database monitoring tools for proactive detection and resolution of performance issues.

\n

  • Administer and support SQL Server databases, including user access, backups, patching, and replication.

\n

  • Provide performance reviews and configurations for Oracle, PostgreSQL, and MySQL systems as needed.

\n

  • Develop and maintain documentation for performance standards, baselines, and tuning methodologies.

\n

  • Participate in capacity planning, workload forecasting, and resource utilization reviews.

\n

  • Ensure high availability and disaster recovery strategies are performance-optimized and cost-effective.

\n

  • Manage multiple concurrent projects and tune databases supporting several enterprise products.

\n

  • Monitor and support data pipelines built in Airflow and dbt.

\n

  • Work on AWS to implement monitoring and error handling on ETL/ELT tools such as Glue and DMS.

\n

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.thejobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…