Advanced Search

Superior Jobs

 
Back to results

Principal Engineer - Oracle DBA

Apply
  • ID: 20137
  • Posted: 4/14/2023
  • Location: Bangalore, KA
  • Category: DBMS
  • Job Type: Permanent

Description
  • Work closely with the product development team from the design phase of application & throughout their Agile development journey, the future enhancements & releases
  • Be part of their Agile Squad planning, understand the priorities & roadmap
  • Participate in the application stress/load test & proactively identify & resolve the DB performance (batch/OLTP) issues that can potentially breach the SLA's when the code moves to production
  • Highlight the new DB features to the product teams that could be used in the application as future enhancements & releases
  • Support the Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards
  • Provide DB Capacity Analysis & provide insights to product teams on future storage & hardware requirements based on the current data growth & overall performance
  • Identify aging data, propose/develop/implement data archiving, purging & partitioning solutions to manage the data growth
  • Handling Database/Schema Refreshes for the lower database environments
  • Understand the RTO/RPO requirements for the application & databases to define the database backup and restore policy
  • Managing Database Security Audit violations & resolving them
  • DB User/Access/Roles management
  • Troubleshooting & fixing production DB/SQL performance issues
  • Providing Oncall support (12/7), working with vendor on DB issues, bugs & provide solution
  • Schedule and Co-ordinate various maintenance activities with Support teams.
  • Replication design and implementation using Golden Gate
  • Work on any new DB technology/new-features, POC requirements from application team
  • Help the application team in migrating their databases to public cloud (AWS).
 
Job Requirements
 
The Expertise we're looking for
  • 8 to 13 years of Oracle DBA (IT) experience
  • 3 + years of experience on Oracle DB/SQL Performance Tuning
  • 1 to 2 years of experience in managing other databases like MS SQL Server, MySQL, PostgresDB & RDS on AWS
  • Experience on automation using shell scripting or python programming or Oracle APEX
  • Bachelor's degree in any technology related field (e.g, Engineering, Computer Science, Maths, etc.) required.
  • Oracle Certification or other RDBMS certifications
  • AWS/Azure/OCI cloud Certified
Apply
 

Already have an account? Log in here