Description
Full–time
Job Description
Location: Chennai/ Bangalore/Pune
Notice Period: Max 60 days
Skill: MSSQL+ORACLE
• Total 8+ years hands on experience in MSSQL and 2 + years’ experience in Oracle
• experience in maintaining Production, Development and Test Servers.
• experience on all kind of Backup, Restoring and moving of Databases.
• Good working experience on all SQL Server versions from version 2000 to version 2024
• Technical and logical understanding on import & export, detach/attach, copy wizard and Script databases.
• Experience in script based monitoring, tool based monitoring ,troubleshooting , automation on SQL Server Performance.
• Experience in using SQL Server Profiler, Change data capture and other Operating system and MSSQL server performance related parameters
• Expertise in applying patches on standalone as well as on Replication, Mirroring, Always on and Cluster setup.
• Experience in carrying out DR Activity, IMW patching , server Decommissions, Server consolidation
• Experience in troubleshooting Database Corruption issues.
• Ability to understand and write TSQL, Power shell scripts, link server scripting, Service account changes , AD groups and Domain entry
• Worked on Incident reduction program ,Standardization of change implementation process ,Templet designing for standard changes
• Developed in house Power shell based Monitoring and Automation script
• * MSSQL Version 2012 and above DBA certification is must
• Oracle version 19C and above DBA certification is must
• Any Cloud computing certification is preferable