Core Responsibilities :
- Database Installation and Configuration
- Installing configuring and upgrading Oracle database software and related tools
Database Creation and Management
Creating new databases managing storage structures and defining database objects like tables indexes and viewsUser Management and Security
Creating and managing user accounts assigning roles and privileges and implementing security policies to protect sensitive dataPerformance Tuning and Optimization
Monitoring database performance identifying bottlenecks and implementing solutions to improve efficiencyBackup and Recovery
Developing and implementing backup and recovery strategies to ensure data availability and recoverability in case of failuresTroubleshooting and Issue Resolution
Diagnosing and resolving database-related issues including performance problems errors and security breachesDatabase Monitoring
Continuously monitoring database health performance and resource usage to proactively identify and address potential problemsCapacity Planning
Evaluating database server hardware storage needs and planning for future capacity requirementsCollaboration
Working closely with application developers system administrators and other IT professionals to ensure seamless database operationsDocumentation
Creating and maintaining documentation related to database design configuration and proceduresAdditional Responsibilities may vary based on the organizationDatabase Design and Architecture
Designing the logical and physical structure of databases to meet specific business requirementsData Modeling
Developing and maintaining data models to represent the structure and relationships of data within the databaseScripting and Automation
Developing scripts and automation tools to streamline database administration tasksNew Technology Implementation
Evaluating and implementing new database technologies and tools to improve performance security or functionalityDisaster Recovery Planning
Developing and testing disaster recovery plans to ensure business continuity in the event of a major outageReporting and Analytics
Generating reports and dashboards to track database performance usage and other key metricsTraining and Support
Providing guidance and training to other users on databaserelated topicsMandatory Skills : OCI Database Migration, EXADATA, Oracle DBCS, Oracle RAC, ORACLE RMAN, DATAGUARD, Oracle DB Administration
Good to Have Skills : Oracle DB Administration