Senior Oracle Architect/ DBA- Parsippany, NJ - Georgia IT Inc

Description

• 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