Oracle to PostgreSQL Subject Matter Expert (SME) jobs in United States
cer-icon
Apply on Employer Site
company-logo

Saicon · 5 hours ago

Oracle to PostgreSQL Subject Matter Expert (SME)

positionUnited States
timeContract
remoteRemote
senioritySenior Level, Lead/Staff
date10+ years exp

Saicon is a consulting company seeking an Oracle to PostgreSQL Subject Matter Expert (SME) to provide technical leadership in migrating enterprise Oracle databases to PostgreSQL. The role involves assessing current Oracle environments, defining migration strategies, and ensuring data integrity and performance throughout the transition.

AppsEnterprise Resource Planning (ERP)Information Technology
check
Growth Opportunities
check
H1B Sponsor Likelynote
Hiring Manager
Anand Swaroop
linkedin

Responsibilities

Lead end-to-end database migration initiatives from Oracle to PostgreSQL, including planning, design, execution, validation, and post-migration support
Conduct detailed current-state assessments of Oracle databases, schemas, PL/SQL code, dependencies, and integrations
Define migration approach and architecture, including re-platforming, re-engineering, or hybrid strategies
Analyze and convert Oracle-specific features (PL/SQL, packages, triggers, sequences, materialized views, partitioning, RAC, ASM, etc.) to PostgreSQL-compatible constructs
Recommend and implement schema, data, and code conversion strategies, including automation tools and manual remediation where required
Provide guidance on performance tuning, indexing strategies, query optimization, and workload benchmarking in PostgreSQL
Ensure data consistency, validation, and reconciliation between Oracle and PostgreSQL environments
Address security, compliance, and governance requirements, including role mappings, encryption, auditing, and access controls
Support application teams in resolving database-related issues arising from migration
Develop migration estimates, timelines, and risk mitigation plans to support RFP responses
Produce technical documentation including migration runbooks, architecture diagrams, and best practices
Mentor internal teams and transfer knowledge on PostgreSQL administration and operations

Qualification

Oracle databasesPostgreSQLDatabase migrationPL/SQLPerformance tuningMigration toolsRisk assessmentTechnical documentationMentoring

Required

10+ years of experience working with enterprise Oracle databases (11g, 12c, 19c or later)
5+ years of hands-on experience with PostgreSQL in production environments
Proven experience leading or supporting large-scale Oracle to PostgreSQL migration projects
Strong expertise in Oracle PL/SQL and PostgreSQL procedural languages (PL/pgSQL)
Strong expertise in schema and data migration strategies
Strong expertise in performance tuning and query optimization
Strong expertise in high availability, replication, and backup/recovery concepts
Experience with migration tools such as AWS DMS, Ora2Pg, pgLoader, Flyway, Liquibase, or similar
Strong understanding of application-to-database integration patterns
Ability to assess technical risks and propose pragmatic solutions under tight timelines

Company

Saicon

twittertwitter
company-logo
Saicon speclizes in ERP, application management, cybersecurity, automation and architecture services.
dateFounded in 1998
location
Overland Park, Kansas, USA
people-size201-500 employees
web-link
https://saiconinc.com

H1B Sponsorship

Saicon has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (21)

Funding

Current Stage
Growth Stage

Leadership Team

leader-logo
Ramesh Lokre
Co-Founder & CEO
linkedin
leader-logo
Raj Cherukumudi
Global Client Partner and SVP
linkedin
Company data provided by crunchbase