Oracle & SQL Database Administrator

Brief JD:
Key Responsibilities of an Oracle Database Professional:

• Database Design and Implementation 19c database
• Creating database structures designing database objects (like tables indexes etc.) and ensuring the database architecture meets organizational needs.
• Performance Tuning
• Identifying and resolving performance bottlenecks optimizing database queries and ensuring efficient data access.
• Backup and Recovery Rman export datapump import datapump
• Security Management Implementing and maintaining access controls user authentication and data encryption to protect sensitive data.
• Troubleshooting and Support- Identifying and resolving database-related issues providing support to users and ensuring smooth operation of the database environment.
• Database Administration Installing configuring upgrading and patching Oracle database software.
• Monitoring and Maintenance.

Key Responsibilities of an SQL Database Professional:

• Database Support for Applications: Understand how applications use the database (schema queries procedures).Work with developers to optimize SQL queries and database access patterns.
• Ensure the database design supports business functionality and performance goals.
• Schema and Object Management: manage database objects: tables views indexes stored procedures triggers changes to the schema during application upgrades or deployments.
• Performance Tuning :Monitor query performance using tools like SQL Profiler Execution Plans or and implement indexing in resolving performance issues affecting applications.
• Release and Deployment Support :Review and execute database scripts as part of application release cycles.
• Security and Access Control: Manage roles users and permissions aligned with application application users follow the principle of least privilege.
• Backup Recovery and Data Integrity : To Perform backup and restore in the various data recovery for application-level issues (e.g. restore a single table or record). Validate integrity of business-critical data.
• Monitoring and Incident Response :Monitor database health and respond to incidents affecting application performance. Help troubleshoot application errors related to the database.
• Provide support during outages or maintenance windows.

Skills Required:

• Strong knowledge of Oracle database concepts and architecture 19c database.
• Strong knowledge of SQL database concepts and architecture of database.
• Strong knowledge of APEX EBS.
• Proficiency in SQL Server.
• Experience with database performance tuning and optimization.
• Familiarity with database security best practices.
• Experience with backup and recovery procedures.
• Excellent problem-solving and troubleshooting skills.
• Strong communication and collaboration skills.
• Experience with specific Oracle tools and technologies (e.g. Oracle RAC Data Guard) SSMS and Azure may also be required.