Oracle & SQL Database Administrator

Oracle & SQL Database Administrator

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, etc. Apply changes to the schema during application upgrades or deployments.
• Performance Tuning:
  Monitor query performance using tools like SQL Profiler, Execution Plans, or DMVs. Recommend and implement indexing strategies. Assist 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 needs. Ensure application users follow the principle of least privilege.
• Backup, Recovery, and Data Integrity:
  Perform backup and restore in the various databases. Support 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.