Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+


Job Id : 15007

Jobtitle : Oracle Developer

Location : Atlanta, GA

Company Name : Tekfortune Inc.

Industry : Information Technology

Salary : $62,000 - $88,000  PER YEAR

Job type : Contractor

Posted on: 2020-07-28


Required Skills : Oracle, SQL Server/MongoDB, ETL, Oracle Packages, Cron Jobs, SSIS

Benefits : No benefits are available


Job Description:

  • Writing Complex SQL queries, structure hierarchy by using analytical functions, data validation using Regular Expressions, Performance tuning, and data analysis,
  • Data optimization, scrubbing, and manipulation of staged data using PL/SQL packages.
  • Developing Stored Procedures / Triggers / Functions & Optimization of SQL Queries using Oracle 11g/12c/ SQL Server 2014.
  • Working on query optimization, performance-tuned several Oracle SQL statements using Explain plan, Auto Trace utilities and Worked on using external hints during the SQL optimization to fast up the SQL process.
  • Optimization of ETL (Extract, Transformation, and Load) & Data sanity.
  • Working on continuous enhancements and fixing of production problems.
  • Designed, implemented, and tuned interfaces and batch jobs using PL/SQL.
  • Involved in data replication and high availability design scenarios with Oracle Streams.
  • Work on MongoDB database concepts such as locking, transactions, indexes, Shading, replication, schema design and retrieving data from Mongo DB.
  • Troubleshooting of bugs in the system and provide hotfixes for the existing system.

Required Skills & Experience:

  • 8+ years Oracle and 3+ years of SQL Server/MongoDB (preferably both).
  • Extensive PL/SQL expertise.
  • NoSQL capabilities
  • ETL process
  • Oracle Packages/ Cron jobs
  • Knowledge of SSIS is desired

Latest jobs for you

  • Hadoop Developer

    Scepter Technologies, Inc Phoenix,, AZ

    Job Description: Good Knowledge of HDFS Architecture and Hadoop Shell Commands. Experience ...

    View Job
  • Big Data – Hadoop Admin / Support

    ateeca Tarentum, PA

    Job Description: This position is a Hadoop Support Engineer They are looking for someone who...

    View Job
  • Senior DevOps Engineer

    Irvine Technology Corporation Austin, TX

    Responsibilities: Establish DevOps best practices within the company Research and implement...

    View Job
  • DevOps Engineer AWS

    Vaco Technology Raleigh, NC

    Responsibilities: You must not only possess superb tech capabilities - but also have excellent...

    View Job
  • DevOps Engineer

    Computer Resource Solutions Chicago, IL

    Job Description: Deliver container-based solutions utilizing the Kubernetes orchestrator in ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First