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
MustHave
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
Handson 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
GoodtoHave
- 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.
database,communication,adf,performance tuning,high availability,scheduling,security,database maintenance,oracle sql database,upgradation,sql,azure,database design,oracle,migration,datasets,scripting