Oracle SQL DATABASE
- Oracle SQL DATABASE Knowledge of Azure
- Creation of Link services and Datasets in ADF
Scripting and scheduling Jobs in ADF
Worked in designing Databases
Must-Have
Oracle SQL DATABASE
- Installation of Patches
- Configuring and maintaining all types of Database Backups and Recovery operations
- Regularly monitor database growth, Jobs, SQL services & Resolving Space Management issues like TempDB contention, Data and log file space issues
- Enrolling users, controlling and monitoring User Access to the database, and maintaining system
- Security
- Hands-on experience on high availability solutions like Log Shipping, Database Mirroring, Always ON & Clustering
- Identifying and Resolving Blocking and Deadlock issues by using System Stored Procedures,
- Activity Monitor and Profiler.
- Identifying and Resolving fragmentation and performance issues.
- Knowledge of Azure
Good-to-Have
- Upgradation and Migration of databases.
- Ability to flex work schedule to accommodate project or product team needs
- Ability to communicate with Solution Architects, Technical Leads, Project Managers
Creation of Link services and Datasets in ADF
Scripting and scheduling Jobs in ADF.
Skills: database,communication,adf,performance tuning,high availability,scheduling,security,database maintenance,oracle sql database,upgradation,sql,azure,database design,oracle,migration,datasets,scripting
