Database Architect - Contractor

Corpay - Peachtree Corners, GA

Full-time - Mid Level

Peachtree Corners, GA

Personal and Laundry Services

About the position

Corpay is seeking a Database Architect - Contractor to join their lodging division in Atlanta, GA. This role focuses on database design, development, and management, emphasizing stored procedures, database architecture, and CI/CD pipeline integration for database changes. The Database Architect will play a crucial role in optimizing and automating database systems to ensure high performance, scalability, and security.

Responsibilities

• Designing and implementing efficient database architectures that align with business requirements.
• Quickly adapting to understand existing database schemas, including tables, relationships, stored procedures, and data types.
• Creating comprehensive documentation of current database setups, including schema designs, data flows, process flows, and architectural diagrams.
• Developing, optimizing, and maintaining stored procedures, triggers, and functions.
• Collaborating with application developers to create database solutions that enhance application performance.
• Implementing CI/CD pipelines to automate the deployment of SQL changes and ensure consistent database environments.
• Performing database modeling, data mapping, and data migration.
• Monitoring database performance, troubleshooting issues, and implementing necessary improvements.
• Ensuring data integrity, security, and compliance with industry standards.
• Creating documentation of database designs, procedures, and best practices for development and operational teams.
• Staying current with emerging database technologies and trends to inform strategic decisions.
• Providing guidance and mentorship to junior database team members.

Requirements

• Bachelor's degree in computer science, Information Technology, or a related field.
• Proven experience as a Database Architect or similar role, with a focus on relational databases.
• Strong proficiency in SQL and experience with stored procedure development.
• Familiarity with database management systems Microsoft SQL Server.
• Experience implementing CI/CD practices for database changes, including version control and automated testing.
• Knowledge of database design principles, data modeling, and normalization techniques.
• Experience with performance tuning and optimization of database queries.
• Understanding of database security best practices and compliance regulations.
• Understanding of hosting and monitoring best practices for DB in Azure cloud.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.

Nice-to-haves

• Background in the Airlines/Hospitality industry.

Benefits

• Company-issued equipment
• Formal, hands-on training