smartShift Technologies is looking for a seasoned Database Administrator - Oracle to join our Bangalore team.
Responsibilities
Perform regular Database administration tasks.
Perform HA and DR setup maintenance tasks
Analyze the performance metrics and provide tuning recommendations
Analyze the repetitive support requests and provide the automation feasibility
Handle incidents and problems
Perform trend analysis of the incidents/events and help in finding the resolution
Skills & Experience
Solid experience in Database Administration in Oracle database
Have robust knowledge on Oracle SQL and PL/SQL
Expertise in writing and analysing Stored procedure , packages and triggers.
Exposure to AWS Cloud RDS is required
Experience in Database Patching/Upgrade/Migrations
Experience in managing the HA and DR setups ( Standby, DataGuard)
Experience in performance tuning ,query optimisation
Experience with client interaction is preferred
Exposure to other MySQL database is preferred
Excellent written and verbal communication skills.
Real time experience in DB administration (Installation/Tablespace Management/Object Management
Expertise in RMAN and other backup(Expdp/Impdp) methodology implementations
Experience in Database Patching/Upgrade/Migrations
Knowledge on GoldenGate is desirable
Knowledge on Oracle 12C/19C recent features
Experience with client interaction is preferred
Knowledge on RAC & ASM is desirable
Exposure to AWS Cloud is desirable
Excellent written and verbal communication skills
Skills:- Oracle, Oracle DBA, Oracle GoldenGate, Oracle Data Guard and PL/SQL