- Design, develop, implement and maintain our core Oracle applications.
- Maintain our SQL / PLSQL processes.
- Ensure DB availability.
- Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.
- Actively seek to optimise and simplify our architecture.
- Take ownership of performance and capacity monitoring aspects of the DB.
- Execution of data migration jobs and scripts as required.
- Assist the infrastructure team in sizing hardware used for the DB.
- Support and collaborate with product developers.
- Contribute to the creation and maintenance of disaster recovery plans.
- Work closely with the application vendors, co-ordinate and manage the DBA activities.
- Own and follow up with Vendors/Stakeholders & their DBAs when required.
- Create a reliable backup strategy. Ensure database backups are appropriately
- executed and periodic restorations are exercised to ensure backup quality.
- Determine and document DB policies, procedures and standards.
- Performance testing and evaluation to ensure data security, privacy and integrity.
- Identification of bottle necks and deadlock issues.
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
- Install upgrades and security patches.
- Alter storage structures to meet the evolving needs of the company.
- Set up database user accounts.
- Train users on how to access the information in the database.
- Find and debug malfunctioning programs affecting the database integrity.
- Create autonomous database backups.
- Regularly update the database security protocols.
Desired Skills:
- Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
- Technical degree preferable (B.E. / B. Tech).
- Must experience with an organisation that has 24x7 reliability on its database.
- Must have experience with Oracle Exadata.
- Must Operating system experience in Linux.
- Must hands on knowledge of Shell scripting on Linux Platform
- Must hands on knowledge of Oracle management tools (Data Guard, RMAN).
- Must hands on knowledge of SQL / PLSQL.
- Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
- Knowledge of Partitioning.
- Knowledge of architecture design principles.
- Good problem solver, focused and dedicated developer with ability to work on
- your own as well as with a team.
- Hands on experience with DB standards and end user applications-translating
- capacity requirements into infrastructure deployment technology.
- Strong practical experience of ORACLE in a production environment (Ver 19c).
- Must be a self-starter with a solid attention to detail.
Skills:- DBA, Databases, Shell Scripting, SQL and PL/SQL
📌 Database Administrator (Mumbai)
🏢 HR India Solutions
📍 Mumbai
Reply to this offer
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.