Oracle Database Administration

"• Proven working experience in Oracle Database Administration with Oracle 19c

• Installation, configuration, and maintenance of Oracle database instances on Linux operating system.

• Database performance tuning and optimization.

• Implementing security and access controls for Oracle databases

• Capacity Planning: Estimating future database growth and resource requirements. Ensuring sufficient resources are available to meet the performance demands of the database.

• Compliance and Auditing: Ensuring that databases comply with industry regulations and internal policies. Participating in audits as needed.

"

"

• Expertise in Oracle Recovery Manager (RMAN) for database backups and recovery.

• Creating and managing RMAN backup scripts for full and incremental backups

• Implementing backup strategies and disaster recovery plans using RMAN."

"• Proficiency in Oracle Data Pump for exporting database objects and data.

• Performing full database exports and schema-level exports using Data Pump.

• Importing data using Data Pump and handling data transformations."

"• Database Design and Schema Management: Collaborating with developers to design efficient database schemas and maintaining data integrity

• Strong expertise in PL/SQL programming language.

• Writing stored procedures, functions, triggers, and packages in Oracle.

• Query optimization and data manipulation using PL/SQL

• Working with cursors, exceptions, and dynamic SQL in PL/SQL

"

Skill

"• Experience in Microsoft SQL Server database administration and maintenance.

• Writing T-SQL queries, stored procedures, and views in SQL Server.

• Database performance monitoring and optimization in SQL Server.

• Handling data backups, restores, and disaster recovery for SQL Server databases"

Posted Date
2023-08-04 14:54:45
Experience
5 -10 years
Primary Skills
Oracle Recovery Manager, PL/SQL, SQL Server database administration and maintenance.
Required Documents
Resume
Contact
bhawya@lorventech.com,diana@lorventech.com,ashwiny@lorventech.com,geetha@lorventech.com,fathih@lorventech.com,ganeshk@lorventech.com,sarga@lorventech.com,naresh@lorventech.com,jeevitha@lorventech.com
Bootstrap Example