Siox Tech LLC
Ashburn, VA
Post Resume to
View Contact Details &
Apply for Job
Job Description :

Required Skills and Experience:

  • 7-10 years’ experience in Oracle Exadata, SQL, PL/SQL
  • Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components and services that incorporate versioning, reconciliation and exception handling
  • 2-3 years’ experience in SQL Performance tuning. Perform application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR Reports. Should have a clear understanding of Oracle Server Process Architecture and memory structures PGA (Program Global Areas) & SGA (System Global Areas) to optimize memory usage.
  • Knowledge about Oracle VPD
  • Expertise in performance profiling, ability to identify performance improvements and memory optimizations
  • Strong coding, debugging, and analytical skills
  • Knowledge about Oracle architecture and process
  • Knowledge of computer science data structures and algorithms
  • Experience with Analytic reporting tools like Tableau
  • Analytical skills to perform technical and functional analysis with strong communication skills.

 

Desired Skills and Experience:

  • Experience working in regulatory projects is strongly desirable
  • Experience working in Containers
  • Knowledge about Python and Apache Airflow
  • Maintain high standard and follow best practices by re-factoring existing code to enhance readability, performance and general structure
  • Experience in CICD, Jenkins, Git
  • Experience working in Agile teams


Client : Direct Client
             

Similar Jobs you may be interested in ..