AWS Architect / Senior Technical Lead in Pittsburgh

Energy Jobline ZR; Pittsburgh (Allegheny County); Remote; USD 140,000 - 210,000; Full time

Job summary

CEI America is seeking an AWS Architect or Senior Technical Lead to guide cloud modernization for client engagements. You will own technical direction from design through delivery, starting with a Lambda remediation project and advancing Oracle ODS modernization and migration to AWS, while also supporting ongoing SysOps.

The role requires hands-on leadership, strong Oracle/PLSQL, experience with DMS/SCT, and expertise in infrastructure as code (CloudFormation/Terraform).

Qualifications

• 8+ years in software or cloud engineering with at least 4 years designing on AWS.
• Proven experience modernizing Oracle databases and migrating to AWS.
• Strong Oracle background including PL/SQL, performance tuning, and data modeling.
• Hands-on experience with Lambda and serverless services (API Gateway, Step Functions, EventBridge, SQS/SNS).
• Infrastructure as code expertise (CloudFormation, Terraform, or CDK).
• Experience with AWS DMS and SCT for data migrations.

Responsibilities

• Lead the assessment and remediation of existing AWS Lambda functions, including runtime upgrades and security fixes.
• Architect the modernization of an Oracle ODS and its migration to AWS (RDS/ Aurora/ Redshift).
• Plan and execute migrations using DMS and SCT with minimal downtime and clear cutover plans.
• Mentor engineers and review designs and code; produce architecture diagrams and runbooks.
• Partner with clients to translate business needs into technical plans and standards.

Skills

AWS architecture

Oracle database modernization

PL/SQL

Lambda & serverless

Infrastructure as code

DMS & SCT

Data modeling

Python/Node.js/Java

Leading technical teams

Client-facing communication

Tools

CloudFormation

Terraform

CDK

CodePipeline

GitHub Actions

Jenkins

Job description

Job DescriptionJob Description

AWS Architect / Senior Technical Lead

CEI America | Remote| Full-Time

About CEI America

CEI America is a Digital Tech and AI Transformation Consulting firm helping organizations modernize their platforms, operations, and data. We're growing our cloud practice and looking for a hands-on AWS leader to guide several client projects from design through delivery.

The Role

We're looking for an AWS Architect or Senior Technical Lead to own the technical direction on a set of active and upcoming engagements. You'll start on a Lambda remediation project and then lead the modernization of an Oracle-based Operational Data Store (ODS) and its migration to AWS, along with ongoing SysOps support and additional modernization initiatives. This is a great fit for someone who enjoys designing the solution and also rolling up their sleeves to help the team build it.

What You'll Do

• Lead the assessment and remediation of existing AWS Lambda functions, including runtime upgrades, refactoring, performance tuning, and security fixes
• Architect the modernization of an Oracle ODS and its migration to AWS, including target platform selection (such as Amazon RDS for Oracle, Aurora PostgreSQL, or Redshift), schema conversion, and data migration strategy
• Plan and execute migrations using tools like AWS Database Migration Service (DMS) and the Schema Conversion Tool (SCT), with a focus on data integrity, minimal downtime, and cutover planning
• Optimize PL/SQL, stored procedures, and ETL processes as part of the move to cloud services
• Support day-to-day AWS operations: monitoring, alerting, patching, cost optimization, and incident response
• Build and maintain infrastructure as code using CloudFormation or Terraform
• Set architecture standards and best practices across security, reliability, and scalability
• Partner with client stakeholders to translate business needs into clear technical plans
• Mentor engineers and review their designs and code
• Produce architecture diagrams, runbooks, and technical documentation

What You Bring

• 8+ years in software or cloud engineering, with at least 4 years designing solutions on AWS
• Proven experience leading Oracle database modernization and migration to AWS
• Strong Oracle background, including PL/SQL, performance tuning, and data modeling
• Hands-on experience with AWS DMS and SCT, and with AWS data services such as RDS, Aurora, DynamoDB, or Redshift
• Strong hands-on experience with Lambda and serverless services (API Gateway, Step Functions, EventBridge, SQS/SNS)
• Solid SysOps background: CloudWatch, Systems Manager, IAM, VPC networking, and backup and recovery
• Infrastructure as code experience (CloudFormation, Terraform, or CDK)
• Proficiency in at least one commonly used with Lambda, such as Python, Node.js, or Java
• Experience leading technical teams or serving as the technical point of contact on client projects
• Clear communication skills and comfort working directly with clients

Nice to Have

• AWS Certified Solutions Architect (Associate or Professional), AWS Certified Database Specialty, or AWS Certified SysOps Administrator
• Oracle certifications (OCP or similar)
• Experience migrating from Oracle to open source databases such as PostgreSQL
• Consulting or professional services experience
• CI/CD experience with tools like CodePipeline, GitHub Actions, or Jenkins
• Familiarity with data catalog or data governance tools

Why Join Us

You'll work on meaningful modernization projects with a team that values ownership and good engineering. There's real room to shape how our cloud practice grows, and a steady pipeline of new work ahead.

#ZR #INDCEI