Apply on Employer Site

Blossom Tech Solutions · 15 hours ago

Oracle Database Administrator with scripts migration to Python

Austin, TX

Contract

Onsite

Mid Level

$50/hr - $55/hr

Blossom Tech Solutions is seeking an Oracle Database Administrator with extensive experience in database migration and optimization. The role involves migrating Oracle scripts to Python, managing database performance, and ensuring data integrity during migrations.

AppsInformation TechnologySoftwareTest and MeasurementWeb Design

H1B Sponsor Likely

Hiring Manager

Santosh Goud

Responsibilities

Oracle scripts migration to Python - Need python coding experience

Oracle- postgres migration experience

Oracle DB questions - Architecture, SGA, processes, control files, logical vs physical, different standby databases

Oracle SQL – good understanding and query optimization, hierarchical queries

Oracle PL/SQL – collections, implicit and explicit cursor, exceptions, custom exceptions, function and procedure, bulk collect and FORALL

APEX – Page process, Dynamic actions, oracle apex architecture, shared components and page components, performance in APEX applications, securing APEX applications, GTT

Performance tuning – AWR report, ADDM and ASH reports, Tuning steps, full table scan vs Index scan in Execution Plan, statistics in Execution Plan, SQL monitoring, ACID in databases

ERWIN and DB modelling – normalization and denormalization, which one, different types of relationships, components of ERWIN, reverse engineering and forward engineering, macros use, naming standards editor

UNIX Shell scripting – error handling, debug shell script, passing arguments, functions, scheduling scripts

Database Migrations – Oracle and PostgresSQL differences during migration, migrating Oracle sequences to PostgresSQL, data integrity during migration, tool used in migration

Design – normalization in db design, denormalization, many-to-many relationships, surrogate keys and natural keys, scalability in designing schema, database constraints

PostgreSQL - index scan and sequential scan, optimize quesries, concurrency, MVCC, partitioning, CTEs

Qualification

Oracle Database AdministrationPython codingOracle SQLPerformance tuningOracle PL/SQLDatabase MigrationsPostgreSQLUNIX Shell scriptingERWINDB modellingAPEXOracle-Postgres migration

Required

Oracle scripts migration to Python - Need python coding experience

oracle- postgres migration experience