QA Automation Engineer - Parsippany, United States - ATech Placement

Description

Senior Oracle Development DBA

Location:
Parsippany NJ - Hybrid

Duration:
Direct Hire

Essential Duties & Responsibilities

Design, Build and Support high quality and performant SQL and PL/SQL for mission critical product development. This will include new features as well as modifying existing features.
Design and Support application and infrastructure upgrades
Design and Develop database automations for various application batch functions in the backend using SQL, Shell scripts and Python.
Performance tuning and providing optimal solution for application SQLs. Review database performance reports, address bottlenecks and provide best practices
Database design for new features. Optimizing the database design
Architect solutions by collaborating with development teams
Data analysis and coming up with archiving and cleanup solutions
You will be working with the data set at a large scale (100s of terabytes to petabytes) and designing solutions for that
Production Support for keeping the databases with five nine availability
Promote the standardization of database and infrastructure components
Design, build and maintain replication between different systems (rdbms to rdbms, rdbms to Kafka using Golden Gate)
Support in-memory solutions such as GemFire/Geode and Redis.
Spot opportunities for process simplification and automation
Support DevOps team when necessary, in an expert capacity

#J-18808-Ljbffr