Jobs
>
Gurgaon

    Analyst Database Administrator - gurugram, India - Sun Life

    Sun Life
    Sun Life gurugram, India

    1 day ago

    Default job background
    Description

    Job Description

    :

    POSITION DESCRIPTION (JOB SUMMARY)

    The candidate will be a member of a team within Data Management Services (DMS). The primary role on the team will be as a SQL Server Database Administrator supporting various Canadian and US client applications, but the individual may be asked to take on additional duties including: infrastructure support and cross-training on other DBMS platforms.

    PRIMARY OBJECTIVES

  • Resolution of reported service requests, pro-active and reactive performance analysis related to databases
  • Carry out Database migrations, upgrades, patching and evaluation/roll out of new database related tools
  • Troubleshooting, monitoring and diagnose issues with SQL Server Database engine, SSIS, SSRS, SQL codes and highly customized jobs.
  • Adherence to documented standards and procedures while doing database related activities like change management.

    • RELATIONSHIPS

    REPORTS TO : Delivery Manager,DMS

    SUPERVISES:

    EXTERNAL RELATIONSHIPS: Servicing customers, partners

    INTERNAL RELATIONSHIPS: Working with other team members, technical/team leads, management, specialized IT areas and application support teams to ensure consistent delivery and quality of database services.

    TASKS, DUTIES & RESPONSIBILITIES

  • Support Areas Database Administrative support of SQL Server versions 2014 – 2022 : Monitoring, maintenance and housekeeping of SQL Server and Databases, SQL Jobs, User Access management and regular client requests. Writing and tuning SQL codes and highly customized jobs. Infrastructure support of SQL Server versions 2014 – 2022 : server/instance installs (stand-alone and clustered), service-pack upgrades, hot fixes, client tool installs, readiness programs, new feature exploitation, research and development. BI support of SSIS and SSRS: Deployment, Security, performance tuning, Creating and enforcing Standards & best practices, automate repetitive tasks, designing, troubleshoot and diagnose issues with SSIS, SSRS.
  • Support of application and upgrade database (Database Migration/ upgrade) from existing SQL versions to latest SQL Server versions.
  • Incident Management: Knowledge of Incident management process and participation in a rotational on-call schedule to support off hours production incidents
  • Occasional participation in after-hours and weekend support of production implementations, infrastructure activities, and various disaster recovery exercises
  • Maintaining up-to-date documentation and procedures for all supported applications and environments.
  • Maintaining 99.99% availability for all production environments.
  • Evaluation of functionality and features with newer versions of the SQL Server DBMS/ database related tools
  • Pro-active and reactive performance analysis, monitoring, troubleshooting and resolution of issues.
  • Monitoring and support of nightly production batch cycles (SQL Jobs and SSIS Packages).
  • Regular review of database maintenance/ support tasks and performance improvement procedures
  • Work Planning/Escalation: Organizing and monitoring personal workload and escalating to manager when issues arise
  • Continuous Improvement: Sharing ideas for process improvement and innovative solutions to known problems

    • KNOWLEDGE, SKILLS & ATTITUDES

  • Intermediate Knowledge SQL Server Concepts like SQL Architecture, Indexes, T-SQL skills & DMV. Database Maintenance/ Support tasks and lower-level monitoring using tools like Extended Events, DMV, PerfmonSQL Server Replication , Always-on , AWS , Clustering .Troubleshooting & diagnose issues with both SSIS & SSRS (Deploy, design, Security, Tuning, Creating and enforcing Standards & best practices, automate)Understanding of system tables, stored procedures, functions, triggers & SQL tuning General troubleshooting like assisting clients with various issues related to connectivity, permissions, access , distributed queries issues, suggesting solutions, best practices etc. SQL Server Security , adept in creating and maintain complex User and permission management environment using AD groups, DB roles, SQL ids and Proxy accounts. Desirable to have Knowledge of Performance Tuning by analyzing, optimizing and rewriting/re-designing SQL codes.Hands-on experience with SQL Server installations and patching. PowerShell scripting to automate DBA related tasks. Ability to understand existing automated tasks and tweak/troubleshoot them.Some knowledge of data-mapping and logical and physical data modeling.Knowledge of AWS, Specifically, migration to AWS from in premise data centerBasic Database DevOps knowledge

    • CORE COMPETENCIES

  • Strong analytical abilities and willingness to handle medium to complex scenarios.
  • Excellent communication skills (both verbal and written)
  • Very high commitment levels and willing to work in any shift timings.
  • Strong organizational skills with the ability to do multi-tasking
  • Detailed oriented, focused approach on handling issues
  • Taking accountability and ownership
  • Sharing information and best practices with team members
  • Drive Knowledge management sessions in expertise skill with team

    • MINIMUM QUALIFICATIONS & EXPERIENCE REQUIRED

    DEGREE/ DEPLOMA IN : BE/ B. Tech /MCA / M. Tech / in Computer Science or related technology.

    PRIOR EXPERIENCE: Minimum 4 to 6 years of SQL Server database administration experience handling medium to large databases.

  • In SQL Server running on the Win Server 2016, 2022 operating system

    • GOOD TO HAVE: Basic knowledge of SSAS, CMD Shell Scripting/ FTP shares, Powershell, VB script and .net/C# would be preferred.

    Experience on SQL tools like power designer, DB artisan, Redgate.

    CERTIFICATIONS : Microsoft Database certification or AWS certification

    Job Category:

    IT - Application Development

    Posting End Date:

    29/04/2024
  • Insight Enterprises, Inc.

    Database Administrator

    1 week ago

    Insight Enterprises, Inc. Gurgaon, India

    **Requisition Number**:92482** · **DATABASE ADMINISTRATOR** · **Working hours: UK shift** · **Location: Delhi NCR (Non-Remote)** · **Position Overview** · The Database Administrator is responsible for all aspects of Insight's database administration and production support. This r ...

  • Zorang Technologies

    Database Administrator

    1 week ago

    Zorang Technologies Gurgaon District, Haryana, India

    We are looking for a DBA professional who is passionate about their work and is aligned with the companys mission. Motivated to take ownership and have the zeal to continuously improve through learning and growth. Driven towards ways that maximize operational efficiency leading t ...

  • Ericsson

    Database Administrator

    6 days ago

    Ericsson Gurgaon, India

    **About this opportunity**: · **At Ericsson, you can be a game changer Because working here isn't just a deal. It's a big deal. This means that you get to demonstrate our 140+ years of experience and the expertise of more than 95,000 varied colleagues worldwide. At MFS under Busi ...

  • Rosmerta Technologies Ltd

    Database Administrator

    3 days ago

    Rosmerta Technologies Ltd Gurgaon, India

    A professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information throughout the company, considering both backend data structure and frontend accessibility for end-users. · **Responsibilities** ...

  • S&P Global

    Database Administrator

    3 days ago

    S&P Global Gurgaon District, Haryana, India

    The Shared Services team is responsible for managing and supporting our Managed Services clients. The role involves being a member of the database team within Shared Services which is responsible for maintaining managed services databases on the cloud including: · - Administratio ...

  • Orange

    Database Administrator

    6 days ago

    Orange Gurugram, Haryana, India

    **key result / decision areas (outcomes) · Install and maintain the performance of database servers. · Develop processes for optimizing database security. · Set and maintain database standards. · Manage database access. · Performance tuning of database systems. · Diagnose and tro ...

  • United Airlines

    Database Administrator

    1 week ago

    United Airlines Gurugram, Haryana, India

    **Description**: · United's Digital Technology team designs, develops and maintains massively scaling technology solutions brought to life with innovative architectures, data analytics, and digital solutions. · **Our Values**: At United Airlines, we believe that inclusion propels ...

  • Zorang Technologies

    Database Administrator

    1 week ago

    Zorang Technologies Gurgaon, India

    **ROLES AND RESPONSIBILITIES**: · - An expert-level Database Administrator, with a strong primary skill set in Microsoft SQL Server and hands-on experience in Oracle as a DBA or developer, is a must. · - Hands-on experience with SSIS and SSRS is a must. · - Excellent knowledge of ...

  • Junglee Games

    Database Administrator

    1 week ago

    Junglee Games Gurgaon, India

    As our **DBA - RDBMS** you willbring together a set of overlapping disciplines (Database Administration, Systems Engineer, Data Architecture, Data Engineer, Infrastructure Engineer) but is primarily focused on Live Site Engineering skills, which includes deployment, capacity plan ...

  • S&P Global

    Database Administrator

    3 days ago

    S&P Global Gurgaon, India

    Shift - 2PM to 11PM · Excellent knowledge of Relational Database - Oracle · - Knowledge of AWS environment and good to have Terraform and Ansible skills · - Designing the database structures for new projects, good understanding of data modeling. · - Strong knowledge of Materializ ...

  • Bravura Solutions

    Database Administrator

    1 week ago

    Bravura Solutions Gurgaon, India

    Close date: · Tuesday, 31 January 2023 · Working pattern: · Full time · Contract Type: · Permanent · **Location**: · Gurgaon · Department: · Cloud · Description & Requirements: · Position · **Oracle DBA Consultant** · Job Status · Full Time, Permanent · Location · Open, India · * ...

  • EQUABLI India

    Database Administrator

    6 days ago

    EQUABLI India Gurgaon, India

    Database Engineer · **Job Category**:ITSoftware Application Development · **Job Type**:Full Time · **Job Location**:REMOTE · **General Summary** · This position is for experienced Database Engineer with focus on database development. · Database engineer will be part of scrum team ...

  • Siemens Mobility

    Database Administrator

    1 week ago

    Siemens Mobility Gurgaon, India

    **Job ID**: · **Company**: · - Siemens Limited**Organization**: · - Siemens Energy**Job Family**: · - Research & Development**Experience Level**: · - Experienced Professional**Full Time / Part Time**: · - Full-time**Remote vs Office**: · - Office/Site only**Contract Type**: · - P ...

  • Neolytix

    Associate Database Administrator

    5 days ago

    Neolytix Gurgaon District, Haryana, India

    **Job Title: Database Administrator (DBA)** · **Job Summary**: As a Database Administrator (DBA), you will be responsible for the setup of SQL Server on Azure, performance, integrity, and security of the organization's databases. You will work closely with the IT team, developers ...

  • Softenger

    Database Administrator, Oracle

    3 days ago

    Softenger Gurgaon, India

    **Job Profile**: · - Database Administrator, Oracle**Job Location**: · - Gurugram**Experience Required**: · - 4-5 yrs- Work with a team that supports large number of Oracle databases. · - Participate in management, prioritization, minor enhancements/fix activities, problem manage ...

  • Amanzi Technologies

    SQL Database Administrator

    1 week ago

    Amanzi Technologies Gurgaon, India

    **Amanzi Technologies Pvt. Ltd.****: · - Permanent- Gurgaon, Noida- Posted 4 hours agoOut of Box Solution · **Job Brief**: · A professional Database Administrator (DBA) will keep the database up and running smoothly 24/7. The goal is to provide a seamless flow of information thro ...

  • Arting Digital

    Oracle Database Administrator

    3 days ago

    Arting Digital Gurgaon, India

    ROLES & RESPONSIBILITIES: · - Experience installing, configuring, and managing Oracle databases in different operating · - systemsExperience in performance monitoring analysis and tuning · - Experience in troubleshooting the issues, Health checks, · - Good Understanding in AI - s ...

  • Expedia Group

    Oracle Database Administrator

    2 days ago

    Expedia Group Gurgaon, Gurugram, Haryana, India

    **Oracle Database Administrator** · Are you prepared to build strong, scalable, global financial systems that support Expedia's current and future growth? Are you seeking an environment where you can drive innovation within database engines? If the prospect of working with top en ...

  • VARITE INDIA PRIVATE LIMITED

    Database Administrator Iii

    1 week ago

    VARITE INDIA PRIVATE LIMITED Gurgaon, India

    : · - Manage and maintain thousands of production database Servers · - Automate and innovate new ways to manage large database clusters and improve existing db performance for our multitude of existing customer bases. · - Push the limits of Elasticsearch, Cassandra, MongoDB, and ...

  • Fixity Technologies Pvt Ltd

    SQL Database Administrator

    5 days ago

    Fixity Technologies Pvt Ltd Gurugram, Haryana, India

    Please find attached JD · Location: Gurgaon · Experience: 4 to 8 years · Notice period: Immediate to 30 days only · - 4 to 8 yrs Experience as Microsoft SQL database administration · - Sound knowledge in SQL server 2012, 2016 + · - Performance tuning and query optimization · - Kn ...