Job Description :
VDart We are a Global Information Technology Services & Workforce Solutions firm headquartered out of Atlanta, GA with presence in US, Canada, MX, UK, Belgium, Japan & India. Founded in 2007, Our team of over 2550+ professionals continually create impact for our customers worldwide in solving complex technology challenges with cutting edge technologies. We specialize in providing the Fortune 1000 companies, niche hard to find skills in technologies including Social, Mobile, Big Data Analytics, Data Sciences, Cyber Security, IoT, Cloud, Machine Learning, and Artificial Intelligence. With delivery centers in the UK, Mexico, Canada, and India, we provide global workforce solutions to our customers covering EMEA, APAC & Americas. VDart is an award-winning organization recognized by Inc 5000 Hall of Fame; Atlanta Business Chronicle*s Fastest Growing Companies; NMSDC*s National Supplier of the Year; Ernst & Young*s Regional Entrepreneur of the Year and more. Title: Oracle Developer/Lead Location: Atlanta, GA Duration: Contract Job description: What will you be doing? 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 hot fixes for the existing system. What do we require from you? 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 If your skills match our requirements, Share resume to Be sure to reference the job number and title in the subject line. Referral Program: Ask our recruiting team about how you can be a part of our referral program. If you refer a candidate with this background and if the candidate accepts the role our team pays a generous referral. We are keen on networking and establishing a long-term, mutually beneficial partnership with you. We are Equal Employment Opportunity Employer. VDart Inc Alpharetta, GA Click here to Apply Follow us on Twitter for the hottest positions: @VDart_Jobs Follow us on Twitter: @vdartinc