Oracle Database Administrator scripts migration to Python

Responsibilities

• Oracle scripts migration to Python - Need python coding 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 Postgres
  
  SQL differences during migration, migrating Oracle sequences to Postgres
  
  SQL, 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
• Postgre
  
  SQL - index scan and sequential scan, optimize quesries, concurrency, MVCC, partitioning, CTEs

Please share your resume with