"• 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"