MSSQL Database Administrator

2 days ago

Mumbai, India Wipro Full time

Job Description

Position Title - MSSQL Database Administrator L2

Location - Mumbai

Role Summary

As a L2 resource of his /her team, he /she :

  • Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s.
  • Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
  • Proposes service improvements for all Oracle/EBS services supported throughout the organization.
  • Provides technical knowledge, supports services both proactively and reactively to maintain the availability and reliability of database system infrastructure in accordance to the SLA.
  • Works in line with policies based on LEAN-CA-CIB best practices.
  • Actively engages during any high severity issue and drives for issue resolution.
  • Reviews technology changes to identify potential risks.
  • Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.
  • Is aware of the global IT structure so that he/she anticipates interrelationships within the organization.
  • Engages with technical peer, Development team, Service managers, Architect and project teams on technology roadmap and projects.
  • Facilitates transformation projects and suggest future directions for new areas of improvement and enhancements.
  • Guarantees the production readiness.
  • Is available and able to drive technically, any complex or high severity incidents that occur within the scope of their role.
  • Actively engages to understand new technologies and technology trends and reviews them with a view to incorporate them into Bank operations.
  • 24x7 Production support including scheduled and emergency night and weekend work.
  • Follow the IT service management guideline while working with tools like Service Now.
  • Preparedness to work in Shifts in rotation.

Key Responsibilities

Technical Expertise

MUST HAVE

  • Must have strong technical knowledge in MSSQL 2014 & above Administration.
  • Execution of backup/recovery procedures and DB refreshes.
  • Should have handled database installations as MSSQL DBA.
  • Creation and Maintenance of Database Instances
  • Event, database performance and availability monitoring.
  • Exposure to Logical and Physical database design and Implementation.
  • Install, configuring, applying patches to MSSQL servers.
  • Knowledge and experience in Replication, Log Shipping, Clustering, Always On in SQL 2005 above– configure and basic troubleshooting.
  • Backup monitoring, verification.
  • Applying Database patches, upgrade and migration
  • OS level activities related to database tasks.
  • Log, scheduled Job Management through Control-M or similar products.
  • Schema Object, Partition Management.
  • Expertise in handling Database Maintenance related to Index and DBCC.
  • Hands on expertise in Performance tuning.
  • Development support/ debugging performance issues.
  • Windows administration experience desired.
  • Well averse with DB Scripting, SQL Profiler, Extended Events, Query Analyzer and Query Store and Intelligent query processing.
  • Experience on ITIL/operations and production support

GOOD TO HAVE

  • Good knowledge in MSBI
  • Should have handled database installations as MSBI DBA.
  • Experience in MSBI and its related components like SSAS/SSIS/SSRS and Power BI.
  • Exposure to SSIS Packages, SSAS, SSRS and Power BI.
  • Application DBA Exposure.
  • PowerShell scripting

Shift/Oncall & Weekend Support

Flexible to work in shifts/ weekends/On-Call support as follows:

Shift

Timings

Morning Shift

4.30AM to 1.30PM

Afternoon Shift

11.30AM to 8.30PM

Afternoon Shift 1

12.30PM to 9.30PM **

Evening Shift

2.30PM to 11.30PM

Evening Shift 1

3.30PM to 12:30AM **

** Day light savings Period- Nov to Mar ( 1hour ahead) **

On-Call Support- To provide On-Call support services on rotational basis

  • 11.30 PM Night to 4.30 am on weekdays after end of the evening shift work (Apr to Oct).
  • 12.30 Midnight to 4.30 am on weekdays after end of the evening shift 1 shift work (Nov to Mar).
  • 00:00 AM to 11:59PM on both Saturday and Sunday.

  • Weekend Support - Mandatory to work on every 3rd Saturday of given month. ( Timings From time to end time to be mentioned )

Public Holiday Support – Paris Holidays (Client Holiday) will be followed as public holidays and not India holidays.

Process & Tools

  • ITSM tool- HP Service Now – Ticketing tool for INC/SR/Change/Problem tickets.
  • In-house tools.
  • HP OMI for monitoring.
  • Strong knowledge on ITIL Process & Practices.

Educational Qualifications

Bachelor’s degree or Master’s degree in Information/Computer technology preferred.

Key Competencies:

  • 5yrs (Min) to 8yrs (Max) of relevant experience in MSSQL/MSBI database administration.
  • The candidate should have worked in a SLA driven environment.
  • Ability to work in a flexible, team-oriented and constantly changing environment.
  • Good Oral and Written communication skills
  • Good knowledge on PowerShell/Python and T-SQL Scripting.
  • Having MSSQL/MSBI certification will be added advantage.
  • Having previous banking BAU support will be added advantage.

  • Mssql database administrator

    2 days ago

    Mumbai, India Wipro Full time

    Job Description Position Title - MSSQL Database Administrator L2 Location - Mumbai Role Summary As a L2 resource of his /her team, he /she : Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s. Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise. Proposes service improvements...

  • MSSQL Database Administrator

    3 days ago

    Mumbai, India Wipro Full time

    Job DescriptionPosition Title - MSSQL Database Administrator L2Location - MumbaiRole SummaryAs a L2 resource of his /her team, he /she:Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s.Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.Proposes service improvements for all Oracle/EBS...

  • MSSQL Database Administrator

    3 days ago

    Mumbai, India Wipro Full time

    Job DescriptionPosition Title - MSSQL Database Administrator L2Location - MumbaiRole SummaryAs a L2 resource of his /her team, he /she:Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s.Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.Proposes service improvements for all Oracle/EBS...

  • MSSQL Database Administrator

    1 day ago

    Mumbai, India Wipro Full time

    Job Description Position Title - MSSQL Database Administrator L2 Location - Mumbai Role Summary As a L2 resource of his /her team, he /she : Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s. Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise. Proposes service improvements for all...

  • Wipro | MSSQL Database Administrator

    3 days ago

    mumbai, India Wipro Full time

    Job DescriptionPosition Title - MSSQL Database Administrator L2Location - MumbaiRole SummaryAs a L2 resource of his /her team, he /she:Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s.Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise.Proposes service improvements for all Oracle/EBS...

  • Wipro | MSSQL Database Administrator

    3 days ago

    mumbai, India Wipro Full time

    Job Description Position Title - MSSQL Database Administrator L2 Location - Mumbai Role Summary As a L2 resource of his /her team, he /she : Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s. Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise. Proposes service improvements for all...

  • L2 Database Administrator-msSQL

    1 day ago

    Mumbai, Maharashtra, India Kyndryl Full time

    Who We Are At Kyndryl, we design, build, manage and modernize the mission-critical technology systems that the world depends on every day. So why work at Kyndryl? We are always moving forward - always pushing ourselves to go further in our efforts to build a more equitable, inclusive world for our employees, our customers and our communities. The...

  • Database Administrator

    2 days ago

    Mumbai, India Groxily Technologies Full time

    DBA (MSSQL DBA ) Exp - 6+ Location - Mumbai 3 Months / Extendable MSSQL DBA. SQL and PL/SQL programming languages & Oracle's database administration Oracle PLSQL and Data understanding **Job Type**: Temporary Contract length: 3 months **Benefits**: - Health insurance - Provident Fund Schedule: - Day shift Ability to commute/relocate: - Mumbai,...

  • MySQL Database Administrator

    6 days ago

    Navi Mumbai, India Innovative Tech Hub Full time

    Job Profile Name - MySQL Database Administrator - Experience Required - 8 - 12 years - Skills Required - MySQL, MSSQL, Postgre SQL - Work Location - Navi Mumbai - Position Required - 2 - Detail Job Description - Should be able to install & maintain the performance of database servers. - Should be able to write & deploy SQL patches. - Should be familiar with...

  • MsSQL Database Administrator

    3 days ago

    Mumbai, Maharashtra, India RARR Technologies Pvt Ltd Full time

    6+ years of experience in database administration, operations, and production support. - Experience writing sql/pl-sql storedprocs or complex queries for reporting. - Experience in Monitoring backup and recovery Management with native and tools like Commvault, Cohesity, etc. - Experience in scheduling db maintenance jobs, Db provisioning/de-provisioning, db...

  • Database Administrator

    3 days ago

    Vikhroli, Mumbai, Maharashtra, India Netmagic Solutions Full time

    Hi All **Greetings from NTT!!!** We are looking for Database administrator-MSSQL L2 for Vikhroli Mumbai. Job Details: Mandatory Key skills: Logshipping, Replication, Mirroring and Cluster Experience: 4.5 to 8 years relevant experience required Qualification: Relevant/Any graduate Location: Vikhroli-Mumbai Notice Period: Immediate/15 days CTC: 6 LPA...

  • MySQL Database Administrator

    2 days ago

    Navi Mumbai, India Tata Consultancy Services Full time

    Skill Set: MySQL Database / Postgres Database administration, replication, performance and monitoringMust Have:1. Hands on – Setup , administer and support MySQL databases servers for Production , QA and Development.2. Hands on – Perform appropriate backup , restoration and upgrades of MySQL/Postgres instances.3. Monitor databases for performance,...

  • MySQL Database Administrator

    2 days ago

    navi mumbai, India Tata Consultancy Services Full time

    Skill Set: MySQL Database / Postgres Database administration, replication, performance and monitoringMust Have:1. Hands on – Setup , administer and support MySQL databases servers for Production , QA and Development.2. Hands on – Perform appropriate backup , restoration and upgrades of MySQL/Postgres instances.3. Monitor databases for performance,...

  • MySQL Database Administrator

    2 days ago

    Navi Mumbai, India Tata Consultancy Services Full time

    Skill Set: MySQL Database / Postgres Database administration, replication, performance and monitoringMust Have:1. Hands on – Setup , administer and support MySQL databases servers for Production , QA and Development.2. Hands on – Perform appropriate backup , restoration and upgrades of MySQL/Postgres instances.3. Monitor databases for performance,...

  • MySQL Database Administrator

    19 hours ago

    Navi Mumbai, India Tata Consultancy Services Full time

    Skill Set: MySQL Database / Postgres Database administration, replication, performance and monitoring Must Have: 1. Hands on – Setup , administer and support MySQL databases servers for Production , QA and Development. 2. Hands on – Perform appropriate backup , restoration and upgrades of MySQL/Postgres instances. 3. Monitor databases for...

  • MySQL Database Administrator

    9 hours ago

    Navi Mumbai, India Tata Consultancy Services Full time

    Skill Set: MySQL Database / Postgres Database administration, replication, performance and monitoring Must Have:1. Hands on – Setup , administer and support MySQL databases servers for Production , QA and Development. 2. Hands on – Perform appropriate backup , restoration and upgrades of MySQL/Postgres instances. 3. Monitor databases for performance,...

  • Database Administrator

    3 days ago

    Mumbai, Maharashtra, India Ria Full time

    Database Administrator position for the Global DBA team India Office at Ria Money Transfer, a dynamic and international company, global leader in money transfer and currency exchange, with employees from every corner of the globe. Ria Money Transfer is the Largest Money Services Business (MSB) Company in India Database Administrator position for the Global...

  • Senior SQL Database Administrator

    10 hours ago

    Mumbai, Maharashtra, India Cambridge Technology (CT) Full time

    At Cambridge Technology (CT), we are seeking a highly skilled Senior SQL Database Administrator to join our team. This individual will be responsible for managing Microsoft SQL Server environments, including Azure and Always-On configurations.Key Responsibilities:We are looking for a professional with strong experience in database administration, migration,...

  • Associate Database Administrator

    1 week ago

    Lower Parel, Mumbai, Maharashtra, India CeX Full time

    **Location**:Lower Parel, Mumbai **Experience**:0 - 1 years **CTC**:3.5 - 5.5 lac pa **Responsibilities**: - Work on both Mysql and MSSQL database Administration. - Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, connectivity issues, security issues etc. - Should be able to work on Performance...

  • Database Administrator

    2 days ago

    Mumbai, India NTT Ltd. Full time

    NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future. In today’s ‘iNTTerconnected’ world, connections matter more now than ever. By bringing together talented people, world-class technology partners and emerging innovators, we help our clients solve...