Explore Courses

• Strong Knowledge in SQL
• How to read a query plan
• Knowledge of normalization
• Basic optimizations
• Working with developers
• Storage systems
• Operating Systems
• Stored procedures and triggering
• Backup and restoration
• Database creation and configuration.

A database administrator, or DBA, is responsible for maintaining, securing, and operating databases and also ensures that data is correctly stored and retrieved. In addition, DBAs often work with developers to design and implement new features and troubleshoot any issues

• Assess database performance

• Implement security measures for Database Information

• Updating database setups

• Create databases to store data

• Set database parameters or specifications

• Develop performance standards

• Coordinate project activities with other personnel or clients

• Estimate time or monetary resources needed to complete projects

• Develop detailed project plans

• Develop models of information or communications systems

Database Administrator skills:

▪ Backup and recovery.

▪ Data modelling and design.

▪ Database systems.

▪ Data security.

▪ Database Management

▪ Monitoring and maintaining high performance of Database/p>

▪Creating and maintaining users.

▪ Profile management

▪ Tablespace management

▪ Database upgradation, migration activities

▪ Creating and maintaining Container Database (CDB) and Pluggable Database (PDB) as per client requirements.

▪ Woking with Multiple Database Instances.

▪ Working with Recovery Manager (RMAN)

▪ Database Backup and Recovery Scenarios.