Database Migration Team Lead

Database Migration & Cloud Assessment Team LeadRemoteUS-based applicants only **Please no third party inquiries**Position SummaryTekStream 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.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 Database@AWS (ExaCS), and Aurora PostgreSQL.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.Primary ResponsibilitiesDatabase Migration LeadershipLead end-to-end migration of Oracle databases from on-premises environments to AWS.Determine and validate migration targets per workload (RDS for Oracle/SQL Server, Oracle Database@AWS ExaCS, Aurora PostgreSQL, EC2 self-managed).Execute and oversee Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) workflows.Conduct Oracle feature usage audits (RAC, Partitioning, Advanced Compression, Diagnostics/Tuning Packs) to determine RDS eligibility and SE2 conversion feasibility.Perform PL/SQL complexity assessments for Oracle-to-PostgreSQL/Aurora migrations, including LOC analysis, Oracle-specific package identification, and effort estimation.Manage cutover weekends including go/no-go decisions, rollback procedures, and post-migration validation.Coordinate with AWS infrastructure and landing zone teams on networking and compute dependencies that gate database migrations.Align database migration timing with application modernization partners (e.g., middleware replacement, container cutover) to ensure coordinated Oracle license drop schedules.Maintain and enforce Oracle licensing compliance across migration phases — BYOL tracking, processor count validation, and management pack entitlements.Required Technical SkillsOracle DatabaseOracle Enterprise Edition and Standard Edition 2 — feature inventories, licensing rules, and migration blockersRAC (Real Application Clusters) architecture and its implications for RDS eligibilityOracle management packs: Diagnostics, Tuning, Partitioning, Advanced CompressionAWR/ASH report interpretation for workload characterization and right-sizingOracle RMAN, Data Guard, GoldenGate (familiarity required; hands-on preferred)PL/SQL proficiency; ability to assess and execute Oracle-to-PostgreSQL conversion feasibilitySQL ServerSQL Server 2014–2022 across Enterprise, Standard, and Web editionsFeature audit methodology to determine RDS SQL Server compatibilityBYOL vs. License Included cost modeling on EC2 and RDSAlways On Availability Groups, mirroring, and replication — migration pathway implicationsAWS PlatformAmazon RDS (Oracle, SQL Server, PostgreSQL, MySQL)Oracle Database@AWS (ExaCS) — architecture, pricing, and use casesAmazon Aurora PostgreSQL — migration from Oracle and SQL ServerAWS Database Migration Service (DMS) and Schema Conversion Tool (SCT)EC2 instance families for database workloads (r6i, m6i, c6i) and right-sizing methodologyEBS volume types (gp3, io2) and IOPS/throughput configuration for database storageAWS Pricing Calculator, instances.vantage.sh, and Reserved Instance economicsOLA / Assessment ToolingRVTools data analysis (vInfo, vCPU, vMemory, vDisk sheets)DBCSI output interpretation and cross-referencing against VM inventoriesExcel-based cost modeling: openpyxl, pandas, or native Excel formula authoringPython scripting for automated deliverable generation (python-docx, python-pptx)PowerPoint and Word deliverable creation to executive-grade standardsRequired Professional SkillsClient-facing communication: ability to translate technical findings into executive-ready narrativesScope gap identification: proactively flags missing data and documents risks before committing to cost modelsCollaborative delivery: experienced working across multi-party teams (cloud platform teams, application modernization partners, client IT)Formal documentation standards: produces risks, assumptions, and recommendations in structured, auditable formatsDeadline discipline: manages concurrent OLA and migration workstreams without sacrificing qualityLicensing integrity: accurately frames compliance gaps as validation findings, not accusationsQualificationsRequired7+ years of hands-on Oracle database administration or migration experience5+ years of AWS cloud architecture or migration delivery experienceHas led a database or cloud-migration practice or a multi-engagement program, client-facing and comfortable as the senior technical authority with a customerDemonstrated experience leading database cutover events in enterprise environmentsStrong working knowledge of Oracle licensing: processor licensing, SE2 limits, BYOL rules, and management pack entitlementsExperience producing or consuming cloud migration assessment deliverables (OLAs, TCO models, migration matrices)PreferredAWS Certified Database Specialty or AWS Certified Solutions Architect – ProfessionalOracle Certified Professional (OCP) for Oracle Database 12c/19cExperience delivering engagements in a consulting or professional services capacityFamiliarity with VMware environments and RVTools-based inventory analysisExposure to public sector clients (state/local government, healthcare) and associated compliance requirementsExperience with Oracle-to-Aurora PostgreSQL migrations using SCT/DMS