Job Summary
Job Title: Oracle and MSSQL Database Admin L2
Location:Gurgaon / Gurugram
Work Experience: 4 – 7 years
Position Type: Full Time, Employee
Industry: IT/Computers – Software
Ref Code:
Key Skills: MSSQL ,Ms Sql Server,Ms Sql,SQL Server DBA,SQL Database,SQL Database Engineer,SQL Database Administrator (DBA),SQL Server Database,SQL DBA Admin,Oracle,Oracle Database,Oracle Database Administrator,Oracle DBA
Wipro Limited (NYSE: WIT, BSE: 507685, NSE: WIPRO) is a leading global information technology, consulting and business process services company. We harness the power of cognitive computing, hyper-automation, robotics, cloud, analytics and emerging technologies to help our clients adapt to the digital world and make them successful. A company recognized globally for its comprehensive portfolio of services, strong commitment to sustainability and good corporate citizenship, we have over 160,000 dedicated employees serving clients across six continents. Together, we discover ideas and connect the dots to build a better and a bold new future.
For more information, please visit www.wipro.com
Job Description
Job Description of Oracle & MSSQL Database L2 Engineer:-
• Database creation
• Addition of data or log file
• Addition secondary file group/steam
• Database properties change
• Instance properties change
• SP, View or any object creation with in the DB based on the request from application.
• Full Backup plan configuration using the maintenance plan.
• Backup plan configuration using the T-SQL statement Rebuild/ Re-organize index configuration using the maintenance plan DB maintenance and I/O error report Checking the Lock and block on the instance.
• Taking manual backup based on the request.
• Running jobs based on the request.
• Database restoration based on the request for support assets.
• Start up and shutdown of database instances Data file and log file movement.
• Application PATCH execution.
• Incident and Request fulfillment management.
• Vendor coordination.
• Service pack /PATCH updates on cluster server.
• Linked server creation and configuration on SQL server.
• DR reconfiguration and setup in case of failure due to incident.
• Service account change and password reset.
• TCP/ IP port configuration.
• Named pipe configuration.
• Memory configuration.
• Trouble shoot all jobs and maintenance plan issue.
• Trouble shoot login/instance connectivity issues.
• Log Shipping configuration in standby mode/no recovery mode/ different domain.
• Mirroring configuration in asynchronous mode/synchronous mode without automatic fail-over/ synchronous mode with automatic fail-over/ different domain.
• Trouble shoot mirroring issue
• Configuration and setup DB cluster
• Trouble shoot DB cluster issue.
• Change the recovery model
Source link
