SQL Database Administrator
| Company | Bridgestone |
|---|---|
| Location | Cleveland, OH, USA |
| Salary | $Not Provided – $Not Provided |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior |
Requirements
- 8+ years of experience in SQL Server database architecture, design, and administration.
- Strong expertise in Microsoft SQL Server (MSSQL) and query performance tuning.
- Hands-on experience with AWS database services, including Amazon RDS for SQL Server and EC2-hosted MSSQL instances.
- Strong understanding of SQL Server high-availability solutions, such as Always-On, Availability Groups, Failover Clustering, and Replication.
- Experience in ETL development and data integration using SSIS, AWS Glue, or other pipeline tools.
- Familiarity with AWS networking, VPCs, security groups, and hybrid cloud connectivity.
- Hands-on experience with DevOps and Infrastructure-as-Code (IaC) tools, such as Terraform, CloudFormation, or Ansible.
- Strong troubleshooting and analytical skills with the ability to resolve complex database performance issues.
- Familiarity with containerization (Docker, Kubernetes) and serverless computing (AWS Lambda, Fargate).
- Hands-on technical experience designing, building, installing, configuring and supporting database servers using SQL Server required.
- Hands-on database tuning and troubleshooting experience.
- Experience with data processing flowcharting techniques.
- Project management experience.
- Knowledge of applicable data privacy practices and laws.
Responsibilities
- Design and optimize SQL Server solutions on AWS, including Amazon RDS for SQL Server, EC2-hosted MSSQL, and AWS SQL Server Always On Availability Groups.
- Experience performing/leading server migrations to AWS using AWS Database Migration Service (DMS), Schema Conversion Tool (SCT), and custom automation scripts.
- Design high-performance database schemas, indexing strategies, partitioning, and query optimization techniques for SQL Server workloads as well as optimizing complex SQL queries, stored procedures, views, and functions to improve database performance.
- Implement high-availability and disaster recovery (HA/DR) solutions, including Always on Failover Clusters, Log Shipping, and Replication.
- Establish and enforce data security best practices, including encryption, IAM-based access control, and compliance with industry standards.
- Work closely with DevOps teams to implement Infrastructure-as-Code (IaC) solutions using Terraform, CloudFormation, or AWS CDK.
- Work with application development staff to develop database architectures, tuning & coding standards, and quality assurance policies and procedures where applicable.
- Design and implement redundant systems, policies, and procedures for backup/recovery, disaster/recovery and data archiving to ensure effective protection and integrity of data assets.
- Respond to and resolve database access and performance issues.
- Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
- Responsible for and contributes to generating appropriate reports and supplying evidence to satisfy all audit and or compliance requests.
- Monitor SQL Server performance using tools like CloudWatch, Performance Insights, Query Store, and Dynamic Management Views (DMVs).
- Collaborate with software engineers and data teams to integrate AWS-hosted SQL Server databases with enterprise applications and analytics platforms.
Preferred Qualifications
- AWS certifications such as AWS Certified Database – Specialty or AWS Certified Solutions Architect – Professional.
- Bachelor degree or equivalent experience
- MCDBA certification preferred
- Experience with NoSQL databases and hybrid cloud database architectures.
- Knowledge of big data and analytics technologies (Redshift, Athena, Snowflake, Power BI, Tableau).