The Oracle Database Administrator manages Oracle databases and applications, performs installations/upgrades, monitors performance, ensures data security, and supports clients during migrations and troubleshooting.
Experiences, Education and Professional Qualification
To have some experience working with the below products.
- Oracle Databases (EBS & Non EBS Databases)
- Oracle Enterprise Manager
- Oracle Application Server
- Oracle e-Business Suite
- Oracle Golden Gate / Label Security / Data Masking / Oracle encryption
- Oracle SOA / Web logic
- Other Oracle related Product
- PL/SQL and shell scrip programming
- Microsoft SQL Server Databases
- My SQL Databases
Job Roles & Responsibilities
Administer the databases and Oracle Applications in Production, Test, and Development. - Monitor, manage and maintain the database and ensure optimisation of performance
- Responsible for the installation / migration or upgrade of databases based on Client’s requirement.
- Responsible for the hardening of Database in accordance with Client company policies, processes, and guidelines.
- Coordinate with Client’s data centre team and business application team to perform the monthly maintenance activity.
- Provide technical database administration support to the application developers and business super users.
- Monitor several database components through Oracle Enterprise Manager (OEM) and resolve issue identified.
- Clone Oracle Databases and Non-Oracle Databases
- Apply patches to Databases and applications based on Client’s requirement.
- Troubleshoot problems related to applications and databases and provide support including tar logging.
- System health check and data management – defragmentation, export/import, relocation of data files, and database refreshes.
- To support the Client in the backup and recovery of databases and applications.
- Participate in and support Client in scheduled DR exercises
- To change password periodically for default database users used by Oracle application as Client’s security policies.
- Housekeeping of databases and applications in scope as per Client’s policies.
- Configuring of OEM alerts for Databases.
- To support client on program deployments and code migrations.
- Provide necessary documentations as per Client’s requirement
- Liaising and working with Oracle Customer Success Services team to support Client projects and initiatives.
- Prepare weekly and Monthly report.
- To participate in Oracle Cloud migration and Oracle upgrade projects, providing support in database administration activities according to project schedule.
Top Skills
Microsoft Sql Server
My Sql
Oracle Application Server
Oracle Databases
Oracle E-Business Suite
Oracle Enterprise Manager
Oracle Golden Gate
Pl/Sql
Similar Jobs
Information Technology • Consulting
Administer and optimize Oracle databases and applications, support migrations and upgrades, troubleshoot issues, perform maintenance, and ensure security compliance.
Top Skills:
Data MaskingLabel SecurityMicrosoft Sql ServerMySQLOracle Application ServerOracle ApplicationsOracle DatabaseOracle E-Business SuiteOracle EncryptionOracle Enterprise ManagerOracle Golden GateOracle SoaPl/SqlShell ScriptingWeb Logic
Information Technology • Consulting
Manage and optimize Oracle database environments, implement Oracle RAC, oversee installations and upgrades, ensure database security, and collaborate with development teams for efficient design.
Top Skills:
MySQLOracleOracle RacPerlPostgresPythonShell
Information Technology • Consulting
Manage Oracle databases including performance tuning, backups, security, and user support in a large OLTP and OLAP environment.
Top Skills:
AddmAwrBatch ScriptsExplain PlanOracle 11GOracle 12COracle 19COracle Enterprise ManagerRmanShell ScriptsSqltraceStatspackTkprof
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
