Company Overview
Bridgestone Americas, Inc. (BSAM), headquartered in Nashville, Tennessee, and Bridgestone Europe, Middle East and Africa (BSEMEA), headquartered in Brussels, Belgium, operate collectively as a "Bridgestone West" strategic region. This region services the strategic business needs of teams across the Americas, Europe, Middle East and Africa. BSAM and BSEMEA are subsidiaries of Bridgestone Corporation, globally headquartered in Japan. Bridgestone and its subsidiaries develop, manufacture and market a wide range of Bridgestone, Firestone and associate brand products and solutions to address the needs of a broad range of customers and industries. At Bridgestone, you are Free to Be We believe people can only provide superior service and quality to others when they bring their whole self to work. We believe in championing all perspectives, individuals and teams because we understand the importance of seeing the world and our business through many different lenses. We are building a team as diverse as the world we serve. So, show us what you are made of, because who you are is what we need.
Position Summary
We are seeking an experienced AWS SQL Architect with expertise in Microsoft SQL Server (MSSQL) to design, implement, and optimize scalable database solutions in the AWS cloud. This role will focus on architecting and migrating MSSQL databases to AWS while ensuring high performance, security, and reliability.
As a key technical leader, you will work closely with data engineers, cloud architects, and business stakeholders to define data strategies, database migrations, ETL pipelines, and performance optimization solutions. This is an excellent opportunity for a data professional with deep expertise in SQL Server, AWS cloud services, and database architecture best practices to shape the foundation of a cloud-first data ecosystem.
We believe in being part of a team that energizes you while respecting what drives you and that at the end of the day having a great work experience will create a great experience for our customers and the society we serve at large.
Responsibilities
In this role, your primary responsibilities include:
* 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.
Core Qualifications:
* 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.
Personal Attributes:
* Strong and comprehensive verbal and written communications.
* Responsive and alert to new learning opportunities, growth and development of technical, interpersonal and business skills; able to recognize and address areas needing improvement.
* Motivated and competent to contribute appropriate time and effort to work needing attention.
* Attentive to detail with focus on accurate and timely results.
* Organized and able to prioritize tasks, responding effectively to competing needs.
* Attentive and reactive to customer needs and concerns.
* Strong analytical and problem-solving abilities.
* Strong customer service orientation.
* Able to contribute to team effort and individual achievement.
Nice to have:
* 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).
Typically requires a minimum of 5 years of related experience with a bachelor's degree; or 3 years and a master's degree; or a PhD without experience; or equivalent work experience.
We are building a team as diverse as the world we serve. We believe in championing all perspectives, individuals, and teams. If you find this opportunity compelling, we encourage to apply.