Hiring Location- Pune /n Exp Range - 8-12 /n Job Purpose and primary objectives: /n /n

- Responsible for managing, maintaining, enhancing and strategic development of all database related technologies in EMEA as well as internationally for the Securities Business.

/n

- The Database Operations team are responsible for providing 24x7 RDBMS and MSSQL database support in EMEA and internationally for the Securities Business.

/n /n Key responsibilities (please specify if the position is an individual one or part of a team): /n /n

- Responsible for ensuring daily health and compliance checks are performed for all Production systems.

/n

- Responsible for ensuring database systems are backed up successfully and any issues are promptly resolved.

/n

- Responsible for ensuring database jobs are running successfully and any issues are promptly resolved.

/n

- Responsible for ensuring database monitoring alerts are detected promptly and satisfactorily resolved.

/n

- Responsible for ensuring sufficient capacity is available to accommodate projected BAU growth.

/n

- Responsible for ensuring all emails sent to the team distribution list are responded to in a timely manner.

/n

- Responsible for ensuring problem tickets and service requests are handled with efficiency and the customer in mind.

/n

- Responsible for ensuring database platforms are highly available, reliable, secure and performant.

/n

- Responsible for database installation, configuration, tuning, upgrades, and general maintenance activities.

/n

- Responsible for providing technical support to application support and development teams.

/n

- Responsible for providing consultancy to application support and development teams on database and systems design.

/n

- Responsible for executing disaster recovery procedures when necessary.

/n

- Responsible for applying database security updates as per defined policies.

/n

- Responsible for reviewing and subsequently remediating items detected by Qualys vulnerability and compliance scans.

/n





- Responsible for ensuring that all project/investment related workloads are delivered according to plans and budget defined.

/n

- Responsible for ensuring all operational procedures are kept current and accurate.

/n

- Responsible for participating in On-Call rotation, triaging, and addressing production issues as they arise.

/n

- Responsible for identifying cost saving and optimisation.

/n

- 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.

/n

- Supervisory / Managerial responsibilities (please specify if the position will have persons reporting to it):

/n /n No /n /n

- Other responsibilities – Budgets, targets, equipment etc (please specify):

/n /n None /n Key Skills/Knowledge: /n Essential: /n /n

- Strong SQL DB Administration skills on SQL Server 2012 and above.

/n

- Strong skill set on Database disaster recovery, backup restore.

/n

- Install, patch and upgrade existing SQL Server, Sybase infrastructure.

/n

- 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.

/n

- Should have expertise on CIS Hardening, security vulnerability fixes.

/n

- Should have strong experience/background in Windows PowerShell.

/n

- Performance monitoring and tuning using Dynamic Views, SQL Trace, Extended Events and Execution Plans

/n

- Business as usual activities involved troubleshooting failed jobs, SSIS packages and provision of resolutions

/n

- Configure ASE mon, expertise in point in time recovery

/n





- Knowledge of configuring Linux and Windows operating systems for optimal database performance.

/n

- Good amount of knowledge in networking, storage, server, and virtualization layers.

/n

- Excellent knowledge of logical and physical database design.

/n

- Excellent knowledge of database installation and configuration.

/n

- Excellent knowledge of backup and recovery strategies.

/n

- Excellent knowledge of database performance and tuning.

/n

- Excellent knowledge of database migrations and upgrades.

/n

- Excellent knowledge of clustering and high availability.

/n

- Excellent knowledge of replication and disaster recovery.

/n

- Excellent knowledge of database security and auditing.

/n

- Excellent knowledge of data security governance and regulations such as GDPR and SOX.

/n

- High-level working knowledge on MySQL, PostgreSQL, and MongoDB is added advantage

/n /n Desirable: /n /n

- Good working knowledge of MSSQL (including Always-On and Analysis Services).

/n

- Working knowledge of Oracle 11g / 12c / 18c / 19c (including RAC, ASM, DataGuard and ODA appliances).

/n

- Working knowledge of SAP (Sybase) ASE 12.5 / 15.7 / 16.0.

/n

- Working knowledge of MongoDB 3.4 / 3.6 / 4.0 / 4.2.

/n

- Good working knowledge of Snowflake.

/n

- Working knowledge of SQL, T-SQL and PL-SQL.

/n

- Working knowledge of Python, Perl, Bash, PowerShell, C#, Java, Ruby.

/n

- Working knowledge of Red Hat Enterprise Linux and Oracle Solaris.

/n

- Working knowledge of Windows Server.

/n

- Working knowledge of BMC Control-M.

/n

- Working knowledge of ESX VMWare.

/n

- Working knowledge of Nutanix HCI.

/n

- Good working knowledge of Active Directory, LDAP, and Kerberos.

/n

- Good working knowledge of GitHub, Subversion and TeamCity.

/n

- Positive working knowledge of CyberArk.

/n

- Good working knowledge of SharePoint, JIRA, and Confluence.

/n

- Good working knowledge of ServiceNow and Serena Business Manager.

/n

- Good working knowledge of cloud computing – IaaS, PaaS, and SaaS offerings across Azure, AWS, GCP and Oracle

/n

📌 Senior Sql Database Administrator (Pune)
🏢 Tata Consultancy Services
📍 Pune