SQL Database Administrator

Tata Consultancy Services; Pune District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Tata Consultancy Services seeks a seasoned Database Operations professional to manage and enhance SQL Server and related database ecosystems across global production. You will ensure health checks, backups, disaster recovery, and high availability while collaborating with application teams and security stakeholders.

The role requires strong SQL, disaster recovery, security hardening, and experience with Windows/Linux environments, virtualization, and enterprise monitoring tools.

Qualifications

• 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

Responsibilities

• Responsible for daily health and compliance checks for all Production systems.
• Responsible for backups and prompt resolution of issues.
• Ensure database jobs run successfully and resolve issues promptly.
• Monitor alerts and ensure issues are satisfactorily resolved.
• Manage capacity to accommodate growth.
• Respond to team emails in a timely manner.
• Handle problem tickets and service requests with efficiency and customer focus.
• Ensure platforms are highly available, reliable, secure and performant.
• Install, configure, tune, upgrade and maintain databases.
• Provide technical support to application teams.
• Consultancy to development teams on database and system design.
• Execute disaster recovery procedures when necessary.
• Apply security updates as per policies.
• Remediate items from vulnerability scans.
• Deliver workloads per plans and budget.
• Keep operational procedures current and accurate.
• Participate in On-Call rotation and address production issues.
• Identify cost savings and optimization.
• Build relationships across Bank and Securities teams.

Skills

SQL Server Admin

Disaster Recovery

PowerShell

High Availability

Performance Tuning

Database Migrations

Linux/Windows OS

Security & GDPR

Networking & Storage

Always-On

MySQL/PostgreSQL/MongoDB

Tools

MSSQL

Oracle

MongoDB

MySQL

PostgreSQL

Snowflake

Python

PowerShell

VMware ESX

Nutanix HCI

Active Directory

GitHub

SharePoint

ServiceNow

Job description

• Responsible for managing, maintaining, enhancing and strategic development of all database related technologies in EMEA as well as internationally for the Securities Business.
• The Database Operations team are responsible for providing 24x7 RDBMS and MSSQL database support in EMEA and internationally for the Securities Business.

Key responsibilities

• Responsible for ensuring daily health and compliance checks are performed for all Production systems.
• Responsible for ensuring database systems are backed up successfully and any issues are promptly resolved.
• Responsible for ensuring database jobs are running successfully and any issues are promptly resolved.
• Responsible for ensuring database monitoring alerts are detected promptly and satisfactorily resolved.
• Responsible for ensuring sufficient capacity is available to accommodate projected BAU growth.
• Responsible for ensuring all emails sent to the team distribution list are responded to in a timely manner.
• Responsible for ensuring problem tickets and service requests are handled with efficiency and the customer in mind.
• Responsible for ensuring database platforms are highly available, reliable, secure and performant.
• Responsible for database installation, configuration, tuning, upgrades, and general maintenance activities.
• Responsible for providing technical support to application support and development teams.
• Responsible for providing consultancy to application support and development teams on database and systems design.
• Responsible for executing disaster recovery procedures when necessary.
• Responsible for applying database security updates as per defined policies.
• Responsible for reviewing and subsequently remediating items detected by Qualys vulnerability and compliance scans.
• Responsible for ensuring that all project/investment related workloads are delivered according to plans and budget defined.
• Responsible for ensuring all operational procedures are kept current and accurate.
• Responsible for participating in On-Call rotation, triaging, and addressing production issues as they arise.
• Responsible for identifying cost saving and optimisation.
• Responsible for building strong relationships across the Bank and Securities with other Bank and Securities functions and business areas, underpinned by trust and the core values of the bank

Key Skills/Knowledge: 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

Desirable

• 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