7-Eleven - Lead Data Engineer - OLTP/SQL Server

Why Join 7-Eleven Global Solution Center ? When you join us, you'll embrace ownership as teams within specific product areas take responsibility for end-to-end solution delivery, supporting local teams and integrating new digital assets. Challenge yourself by contributing to products deployed across our extensive network of convenience stores, processing over a billion transactions annually. Build solutions for scale, addressing the diverse needs of our 84,000+ stores in 19 countries. Experience growth through cross-functional learning, encouraged and applauded at 7-Eleven GSC. With our size, stability, and resources, you can navigate a rewarding career. Embody leadership and service as 7-Eleven GSC remains dedicated to meeting the needs of customers and communities. Why We Exist, Our Purpose and Our Transformation ? 7-Eleven is dedicated to being a customer-centric, digitally empowered organization that seamlessly integrates our physical stores with digital offerings. Our goal is to redefine convenience by consistently providing top-notch customer experiences and solutions in a rapidly evolving consumer landscape. Anticipating customer preferences, we create and implement platforms that empower customers to shop, pay, and access products and services according to their preferences. To achieve success, we are driving a cultural shift anchored in leadership principles, supported by the realignment of organizational resources and processes. At 7-Eleven we are guided by our Leadership Principles. Each principle has a defined set of behaviours which help guide the 7-Eleven GSC team to Serve Customers and Support Stores. 1. Be Customer Obsessed 2. Be Courageous with Your Point of View 3. Challenge the Status Quo 4. Act Like an Entrepreneur 5. Have an "It Can Be Done" Attitude 6. Do the Right Thing 7. Be Accountable Lead Engineer - SQL Server & OLTP Database Platforms About the Role : We are seeking an experienced Lead Engineer - SQL Server & OLTP Database Platforms to design, implement, optimize, secure, and govern enterprise database solutions for high-volume, mission-critical applications. The role is primarily focused on SQL Server-based online transaction processing (OLTP), database reliability, performance engineering, cloud adoption, automation, and operational excellence. The successful candidate will provide technical leadership for SQL Server, with supporting experience across PostgreSQL, MongoDB, DocumentDB, and cloud-managed database platforms. This role will partner closely with application engineering, architecture, DevOps, SRE, RunOps, and security teams to deliver resilient, scalable, and cost-effective database platforms. Key Responsibilities : - Lead the architecture, design, and operational governance of enterprise OLTP database platforms. - Design highly available and scalable database solutions for customer-facing and business-critical applications. - Lead the administration, optimization, troubleshooting, and modernization of SQL Server environments, with supporting responsibility for PostgreSQL, MongoDB, DocumentDB, and other database technologies. - Perform query tuning, execution-plan analysis, indexing, partitioning, connection-management optimization, and capacity planning. - Define and implement high availability, replication, backup, recovery, disaster recovery, and failover strategies. - Establish database standards for schema design, naming conventions, access controls, security, deployment, monitoring, and operational support. - Drive database modernization and migration initiatives across on-premises and cloud environments. - Design and support cloud-native database solutions using AWS and/or Azure services. - Automate database provisioning, configuration, schema changes, monitoring, maintenance, and operational workflows. - Implement database DevOps practices using Liquibase, Flyway, GitHub Actions, Jenkins, Azure DevOps, GitLab CI/CD, or similar tools. - Implement reusable database automation, operational tooling, and platform workflows using approved enterprise tools and automation frameworks. - Implement monitoring, alerting, logging, observability, and operational dashboards for database platforms. - Support production incidents, lead root-cause analysis, and drive permanent corrective actions. - Identify opportunities for cloud cost optimization, resource right-sizing, and improved operational efficiency. - Mentor database engineers and serve as the primary technical subject-matter expert for OLTP database platforms. - Collaborate with architects, developers, product teams, and business stakeholders to translate requirements into reliable technical solutions. Required Experience : - 7+ years of overall IT experience with a strong focus on database engineering, administration, development, or platform engineering. - 4+ years of hands-on experience designing, implementing, and supporting enterprise OLTP database environments. - Strong hands-on experience with SQL Server administration, database development, troubleshooting, performance optimization, high availability, and production operations. - Working experience with PostgreSQL administration, development, troubleshooting, and performance optimization. - Experience with MongoDB, Amazon DocumentDB, or other document-oriented databases. - Experience supporting highly available, high-volume, mission-critical production applications. - Strong knowledge of database architecture, data modeling, indexing, partitioning, query optimization, and capacity planning. - Experience implementing backup, recovery, high availability, replication, and disaster recovery solutions. - Experience with AWS and/or Azure cloud platforms and cloud-managed database services. - Hands-on experience with database security, authentication, authorization, encryption, auditing, and secrets management. - Experience establishing database governance, standards, reusable frameworks, and operational best practices. - Experience with schema version control and deployment automation using Liquibase, Flyway, or similar tools. - Experience supporting CI/CD pipelines and infrastructure or platform automation. Technical Skills : OLTP Database Engineering : - SQL Server architecture, administration, performance tuning, high availability, backup, recovery, and disaster recovery - PostgreSQL administration and performance optimization - MongoDB and DocumentDB operations and platform support - Database schema design and transactional data modeling - Query optimization and execution-plan analysis - Indexing, partitioning, connection management, and concurrency - Replication, failover, backup, recovery, and disaster recovery - Database monitoring, observability, alerting, and capacity planning Cloud and Platform Engineering : - AWS RDS, DocumentDB, Lambda, IAM, CloudWatch, S3, and Secrets Manager - Azure database and monitoring services - Cloud security, networking, identity, and access management - Infrastructure as Code using Terraform, CloudFormation, ARM templates, or similar tools - Cloud migration, modernization, right-sizing, and cost optimization Automation and DevOps : - Liquibase, Flyway, or similar database change-management tools - GitHub Actions, Jenkins, Azure DevOps, GitLab CI/CD, or similar platforms - REST APIs, microservices, and integration patterns - Automated testing, deployment, monitoring, and operational tooling Preferred Qualifications : - MongoDB certification or equivalent demonstrated expertise. - Experience with DynamoDB, Cassandra, Couchbase, or other NoSQL technologies. - Experience supporting retail, e-commerce, payments, loyalty, or other high-transaction platforms. - Experience with Kafka, Amazon EventBridge, Kinesis, or other streaming technologies. - Experience leading database modernization, standardization, or platform engineering programs. - Experience implem