Wipro | MSSQL Database Administrator

2 weeks ago

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.

  • Wipro | MSSQL Database Administrator

    2 weeks ago

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

  • MsSQL Database Sme

    1 month ago

    India Luxoft Full time

    Remote India, India Database Administration BCM Industry 28/11/2024 Req. VR-109781 **Project description**: About the client: Our client is a UK subsidiary of a global financial house working in multiple markets and asset classes. **Responsibilities**: OVERVIEW OF THE DEPARTMENT/SECTION: Responsible for managing, maintaining, enhancing and strategic...

  • Wipro | Administrator | india

    2 months ago

    india Wipro Full time

    WALK-IN DRIVE DATE : 12TH NOV TIMINGS : 10:30 AM TO 12 PM VENUE : WIPRO TECHNOLOGIES LTD. Phase 2, Rajiv Gandhi Infotech Park, Hinjewadi, 411057 LOCATIONS(hiring for) : Pune and HYDERABAD Service Desk Analyst (Fresher and experienced) Responsibilities: 1. As a Support Analyst, you will be responsible for assisting end users on applications problems,...

  • Database Administrator

    7 months ago

    India myCloudDoor Full time

    **Description**: Do you have experience as Database Administrator? Are you looking for your next professional challenge? Would you like to participate in innovative projects? At myCloudDoor are looking for you! **Who we are?** myCloudDoor is a company of IT consultancy and adoption services, migration and implementation of Cloud Solutions. Specialized on...

  • Database Administrator

    6 months ago

    India Dayforce Full time

    Dayforce is a global human capital management (HCM) company headquartered in Toronto, Ontario, and Minneapolis, Minnesota, with operations across North America, Europe, Middle East, Africa (EMEA), and the Asia Pacific Japan (APJ) region. Our award-winning Cloud HCM platform offers a unified solution database and continuous calculation engine, driving...

  • Wipro | OCI Administrator | india

    1 month ago

    india Wipro Full time

    Job Title: PAAS Admin/OCI Admin Location: Pune, Hyderabad, Bangalore, Noida, Gurugram, Mumbai, Chennai Type: Full-time Experience: 8+ years Job Description: We are looking for an experienced Oracle PAAS Administrator to manage and maintain Oracle PAAS environment. The ideal candidate will possess a deep understanding of Oracle Cloud Infrastructure...

  • Teamware Solutions | Cloud Database Administrator

    4 weeks ago

    india Teamware Solutions Full time

    Greetings from Teamware Solutions a division of Quantum Leap Consulting Pvt. LtdWe are hiring a Cloud Database AdministratorWork Mode: HybridLocations: Bengaluru, Pune Experience: 7 -12 YearsNotice Period: Immediate to 15 daysJob description: Strong technical understanding of Database Administration in Cloud platforms with focus on RDBMS and NoSQL flavors of...

  • Teamware Solutions | Cloud Database Administrator | india

    4 weeks ago

    india Teamware Solutions Full time

    Greetings from Teamware Solutions a division of Quantum Leap Consulting Pvt. Ltd We are hiring a Cloud Database Administrator Work Mode: Hybrid Locations: Bengaluru, Pune Experience: 7 -12 Years Notice Period: Immediate to 15 days Job description: Strong technical understanding of Database Administration in Cloud platforms with focus on RDBMS and...

  • Teamware Solutions | Cloud Database Administrator | india

    4 weeks ago

    india Teamware Solutions Full time

    Greetings from Teamware Solutions a division of Quantum Leap Consulting Pvt. Ltd We are hiring a Cloud Database Administrator Work Mode: Hybrid Locations: Bengaluru, Pune Experience: 7 -12 Years Notice Period: Immediate to 15 days Job description: Strong technical understanding of Database Administration in Cloud platforms with focus on RDBMS and...

  • Minfy | PostgreSql Database Admin

    3 weeks ago

    india Minfy Full time

    We are seeking an experienced PostgreSQL Database Administrator (DBA) with secondary expertise in SQL Server (MSSQL) to join our team. The ideal candidate will have hands-on experience managing databases in AWS RDS/Aurora environments and a strong understanding of high availability, disaster recovery, performance optimization, and automation. Key...

  • Minfy | PostgreSql Database Admin

    3 weeks ago

    india Minfy Full time

    We are seeking an experienced PostgreSQL Database Administrator (DBA) with secondary expertise in SQL Server (MSSQL) to join our team. The ideal candidate will have hands-on experience managing databases in AWS RDS/Aurora environments and a strong understanding of high availability, disaster recovery, performance optimization, and automation.Key...

  • PayTabs Global | Database Administrator

    2 weeks ago

    india PayTabs Global Full time

    Summary/ Objective We are looking for an experienced Database Administrator (DBA) to oversee the management, optimization, and security of our database systems, including SQL Server and MySQL. The role involves designing high-availability solutions, ensuring compliance, and implementing cost-effective database strategies. The ideal candidate should possess...

  • PayTabs Global | Database Administrator

    2 weeks ago

    india PayTabs Global Full time

    Summary/ ObjectiveWe are looking for an experienced Database Administrator (DBA) to oversee the management, optimization, and security of our database systems, including SQL Server and MySQL. The role involves designing high-availability solutions, ensuring compliance, and implementing cost-effective database strategies. The ideal candidate should possess...

  • PostgreSQL and MsSQL

    6 days ago

    India CIEL HR Full time

    Job Summary Looking for Immediate Joiners to 20 days NP **Years of Experience**: 5+Years Primary skill - PostgreSQL and secondary skill - MSSQL YOU MUST HAVE - Bachelor’s in Computer Science or equivalent work experience preferred - 6+ year’s hands-on experience as a DBA with Knowledge of PostgreSQL, MongoDB/MySQL. - Must have a minimum of 4+...

  • Mindsprint | MSSQL DBA | india

    1 month ago

    india Mindsprint Full time

    Mindsprint is hiring for SQL DBA:Job Description: Minimum 9+ years’ work experience as Database Administrator in MSSQL DBA support and worked in any other RDBMS platform such as Azure, Mysql, Sybase, Postgres (Secondary Skill)Sound knowledge of SQL server architecture and conceptsShould have hands-on experience in troubleshooting DB performance...

  • Wipro | Java Selenium API-testing

    4 weeks ago

    india Wipro Full time

    Location : Bangalore/Chennai/Hyderabad/PuneMode : F2F (Walk in)Date : 14-Dec-2024Experience : 5 – 10 YearsNotice Period: Immediate to 45 daysInterested candidates can share update CV (with all payroll company names) and recent photo(passport) to boopathyraja.r90@wipro.comSDETJD:Should be between 5 to 10 years of experience on software test automation using...

  • Wipro | Python Developer | india

    1 month ago

    india Wipro Full time

    Hi Linkies, We are hiring for Python+Devops role Work Location: Bangalore/Hyderabad/Pune Experience: 4.6 Years to 6 Years Notice Period: 30 days to 60 days Highest Qualification:15 years full time education mandatory Mandatory Skills: Python Developer+Go+Devops Detailed JD – Python+ Devops •Senior level (5 to 8 years) experience in designing and...

  • Wipro | Java Selenium API-testing | india

    4 weeks ago

    india Wipro Full time

    Location : Bangalore/Chennai/Hyderabad/Pune Mode : F2F (Walk in) Date : 14-Dec-2024 Experience : 5 – 10 Years Notice Period: Immediate to 45 days Interested candidates can share update CV (with all payroll company names) and recent photo(passport) to SDET JD: Should be between 5 to 10 years of experience on software test automation using Java/J2EE ...

  • Wipro | Java Selenium API-testing | india

    4 weeks ago

    india Wipro Full time

    Location : Bangalore/Chennai/Hyderabad/Pune Mode : F2F (Walk in) Date : 14-Dec-2024 Experience : 5 – 10 Years Notice Period: Immediate to 45 days Interested candidates can share update CV (with all payroll company names) and recent photo(passport) to SDET JD: Should be between 5 to 10 years of experience on software test automation using Java/J2EE ...

  • Database Administrator

    7 months ago

    India Ciklum Full time

    Description **Ciklum** is looking for a **Database Administrator** to join our team full-time in **India**. We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and...