Company Overview
Credit First National Association is a private label credit card bank and the consumer credit division of Bridgestone Americas. The Bridgestone Americas family of enterprises, including CFNA, is comprised of more than 50 production facilities and 55K employees throughout the Americas. We provide the consumer credit solution for the Firestone Complete Auto Care, Tires Plus, and Wheel Works brands, in addition to customized retail credit services for more than 8,000 other tire and automotive retailers nationwide. At our office in Cleveland, OH, more than 300 professionals gather each day to run a successful private label credit card program. We invest in our community and strongly believe that meaningful commitment to a wide variety of philanthropic organizations builds a better world and a brand that makes us proud.
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.
Bridgestone is proud to be an Equal Employment Opportunity / Affirmative Action employer. It is our policy to consider for employment all individuals regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, gender, sex, sexual orientation, gender identity and/or expression, genetic information, veteran status, or any other characteristic protected by federal, state or local law.
Employment Eligibility
If hired, a Form I-9 Employment Eligibility Verification must be completed at the start of employment. Temporary work authorization or the need for sponsorship may disqualify you from employment.