Database Migration Team Lead

Job Description

Database Migration & Cloud Assessment Team Lead

\n

Remote

\n

US-based applicants only **Please no third party inquiries**

\n

\n

Position Summary

\n

TekStream is seeking an experienced Team Lead for a top client to drive enterprise database migration engagements on AWS. This is a client-facing, technically deep role operating at the intersection of Oracle and SQL Server database expertise, AWS architecture, and licensing strategy. The core of this role is leading the practice: owning client relationships, running delivery across multiple engagements at once, mentoring and directing the DB team, and being the senior technical voice in the room on sales pursuits.

\n

\n

The primary responsibility is leading hands-on database migration workstreams — planning, executing, and validating the migration of Oracle and SQL Server databases to AWS-native targets including RDS, Oracle View email address on ziprecruiter.com (ExaCS), and Aurora PostgreSQL.

\n

\n

You will serve as the technical lead on direct client engagements, owning the database and licensing track while coordinating with infrastructure, application modernization, and partner teams.

\n

Primary Responsibilities

\n

Database Migration Leadership

\n

\n
• Lead end-to-end migration of Oracle databases from on-premises environments to AWS.
\n
• Determine and validate migration targets per workload (RDS for Oracle/SQL Server, Oracle View email address on ziprecruiter.com ExaCS, Aurora PostgreSQL, EC2 self-managed).
\n
• Execute and oversee Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) workflows.
\n
• Conduct Oracle feature usage audits (RAC, Partitioning, Advanced Compression, Diagnostics/Tuning Packs) to determine RDS eligibility and SE2 conversion feasibility.
\n
• Perform PL/SQL complexity assessments for Oracle-to-PostgreSQL/Aurora migrations, including LOC analysis, Oracle-specific package identification, and effort estimation.
\n
• Manage cutover weekends including go/no-go decisions, rollback procedures, and post-migration validation.
\n
• Coordinate with AWS infrastructure and landing zone teams on networking and compute dependencies that gate database migrations.
\n
• Align database migration timing with application modernization partners (e.g., middleware replacement, container cutover) to ensure coordinated Oracle license drop schedules.
\n
• Maintain and enforce Oracle licensing compliance across migration phases — BYOL tracking, processor count validation, and management pack entitlements.
\n

\n

\n

Required Technical Skills

\n

Oracle Database

\n

\n
• Oracle Enterprise Edition and Standard Edition 2 — feature inventories, licensing rules, and migration blockers
\n
• RAC (Real Application Clusters) architecture and its implications for RDS eligibility
\n
• Oracle management packs: Diagnostics, Tuning, Partitioning, Advanced Compression
\n
• AWR/ASH report interpretation for workload characterization and right-sizing
\n
• Oracle RMAN, Data Guard, GoldenGate (familiarity required; hands-on preferred)
\n
• PL/SQL proficiency; ability to assess and execute Oracle-to-PostgreSQL conversion feasibility
\n

\n

\n

SQL Server

\n

\n
• SQL Server 2014–2022 across Enterprise, Standard, and Web editions
\n
• Feature audit methodology to determine RDS SQL Server compatibility
\n
• BYOL vs. License Included cost modeling on EC2 and RDS
\n
• Always On Availability Groups, mirroring, and replication — migration pathway implications
\n

\n

\n

AWS Platform

\n

\n
• Amazon RDS (Oracle, SQL Server, PostgreSQL, MySQL)
\n
• Oracle View email address on ziprecruiter.com (ExaCS) — architecture, pricing, and use cases
\n
• Amazon Aurora PostgreSQL — migration from Oracle and SQL Server
\n
• AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT)
\n
• EC2 instance families for database workloads (r6i, m6i, c6i) and right-sizing methodology
\n
• EBS volume types (gp3, io2) and IOPS/throughput configuration for database storage
\n
• AWS Pricing Calculator, instances.vantage.sh, and Reserved Instance economics
\n

\n

\n

OLA / Assessment Tooling

\n

\n
• RVTools data analysis (vInfo, vCPU, vMemory, vDisk sheets)
\n
• DBCSI output interpretation and cross-referencing against VM inventories
\n
• Excel-based cost modeling: openpyxl, pandas, or native Excel formula authoring
\n
• Python scripting for automated deliverable generation (python-docx, python-pptx)
\n
• PowerPoint and Word deliverable creation to executive-grade standards
\n

\n

Required Professional Skills

\n

\n
• Client-facing communication: ability to translate technical findings into executive-ready narratives
\n
• Scope gap identification: proactively flags missing data and documents risks before committing to cost models
\n
• Collaborative delivery: experienced working across multi-party teams (cloud platform teams, application modernization partners, client IT)
\n
• Formal documentation standards: produces risks, assumptions, and recommendations in structured, auditable formats
\n
• Deadline discipline: manages concurrent OLA and migration workstreams without sacrificing quality
\n
• Licensing integrity: accurately frames compliance gaps as validation findings, not accusations
\n

\n

Qualifications

\n

Required

\n

\n
• 7+ years of hands-on Oracle database administration or migration experience
\n
• 5+ years of AWS cloud architecture or migration delivery experience
\n
• Has led a database or cloud-migration practice or a multi-engagement program, client-facing and comfortable as the senior technical authority with a customer
\n
• Demonstrated experience leading database cutover events in enterprise environments
\n
• Strong working knowledge of Oracle licensing: processor licensing, SE2 limits, BYOL rules, and management pack entitlements
\n
• Experience producing or consuming cloud migration assessment deliverables (OLAs, TCO models, migration matrices)
\n

\n

\n

Preferred

\n

\n
• AWS Certified Database Specialty or AWS Certified Solutions Architect – Professional
\n
• Oracle Certified Professional (OCP) for Oracle Database 12c/19c
\n
• Experience delivering engagements in a consulting or professional services capacity
\n
• Familiarity with VMware environments and RVTools-based inventory analysis
\n
• Exposure to public sector clients (state/local government, healthcare) and associated compliance requirements
\n
• Experience with Oracle-to-Aurora PostgreSQL migrations using SCT/DMS
\n

\n