SQL Database Administrator

Dear Candidate Greetings from TCS !!! TCS has been a great pioneer in feeding the fire of young Techies like you. We are a global leader in the technology arena and there's nothing that can stop us from growing together. Role: SQL Database Administrator Location: Pune / Chennai / Bangalore / Delhi Experience Range: 8 - 12 years Educational Qualification : 15 Years of Full Time Education Job Description: Essential:

• Strong SQL DB Administration skills on SQL Server 2012 and above.
• Strong skill set on Database disaster recovery, backup restore.
• Install, patch and upgrade existing SQL Server, Sybase infrastructure.
• Manage SQL implementations, ranging from small departmental systems to large scale and global critical mission with ability to support large number of servers using virtualization.
• Should have expertise on CIS Hardening, security vulnerability fixes.
• Should have strong experience/background in Windows PowerShell.
• Performance monitoring and tuning using Dynamic Views, SQL Trace, Extended Events and Execution Plans
• Business as usual activities involved troubleshooting failed jobs, SSIS packages and provision of resolutions
• Configure ASE mon, expertise in point in time recovery
• Knowledge of configuring Linux and Windows operating systems for optimal database performance.
• Good amount of knowledge in networking, storage, server, and virtualization layers.
• Excellent knowledge of logical and physical database design.
• Excellent knowledge of database installation and configuration.
• Excellent knowledge of backup and recovery strategies.
• Excellent knowledge of database performance and tuning.
• Excellent knowledge of database migrations and upgrades.
• Excellent knowledge of clustering and high availability.
• Excellent knowledge of replication and disaster recovery.
• Excellent knowledge of database security and auditing.
• Excellent knowledge of data security governance and regulations such as GDPR and SOX.
• High-level working knowledge on MySQL, PostgreSQL, and MongoDB is added advantage

• Good working knowledge of MSSQL (including Always-On and Analysis Services).
• Working knowledge of Oracle 11g / 12c / 18c / 19c (including RAC, ASM, DataGuard and ODA appliances).
• Working knowledge of SAP (Sybase) ASE 12.5 / 15.7 / 16.0.
• Working knowledge of MongoDB 3.4 / 3.6 / 4.0 / 4.2.
• Good working knowledge of Snowflake.
• Working knowledge of SQL, T-SQL and PL-SQL.
• Working knowledge of Python, Perl, Bash, PowerShell, C#, Java, Ruby.
• Working knowledge of Red Hat Enterprise Linux and Oracle Solaris.
• Working knowledge of Windows Server.
• Working knowledge of BMC Control-M.
• Working knowledge of ESX VMWare.
• Working knowledge of Nutanix HCI.
• Good working knowledge of Active Directory, LDAP, and Kerberos.
• Good working knowledge of GitHub, Subversion and TeamCity.
• Good working knowledge of CyberArk.
• Good working knowledge of SharePoint, JIRA, and Confluence.
• Good working knowledge of ServiceNow and Serena Business Manager.
• Good working knowledge of cloud computing – IaaS, PaaS, and SaaS offerings across Azure, AWS, GCP and Oracle