Senior Oracle Development DBALocation: Parsippany NJ - Hybrid Duration: Direct HireEssential Duties & ResponsibilitiesDesign, 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 upgradesDesign 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 practicesDatabase design for new features.
Optimizing the database designArchitect solutions by collaborating with development teamsData analysis and coming up with archiving and cleanup solutionsYou will be working with the data set at a large scale (100s of terabytes to petabytes) and designing solutions for thatProduction support for keeping the databases with five nine availabilityPromote the standardization of database and infrastructure componentsDesign, 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 automationSupport DevOps team when necessary, in an expert capacity
Senior Oracle Architect/ DBA- Parsippany, NJ / Alpharetta in alpharetta at Unknown Company
This position is listed as full time and hybrid.