Jobs
>
Gurgaon

    Analyst Database Administrator - Gurugram, India - Sun Life

    Sun Life
    Sun Life Gurugram, India

    Found in: Talent IN C2 - 1 week ago

    Default job background
    Temps plein
    Description

    Vous êtes unique, comme le sont votre parcours, votre expérience et votre façon de voir les choses. Ici, on vous encourage et on vous motive à donner le meilleur de vous-même, et on vous donne les moyens de le faire. Vous travaillerez avec des collègues dynamiques – experts dans leur domaine – qui sont impatients de partager leurs connaissances avec vous. Vous aurez des gestionnaires inspirants qui vous aideront à développer votre potentiel et à atteindre de nouveaux sommets. Chaque jour, vous aurez de nouvelles occasions de rendre la vie de nos Clients plus radieuse – ils sont au cœur de tout ce que nous faisons. Découvrez comment vous pouvez faire une différence dans la vie des gens, des familles, des collectivités – ici et partout dans le monde.

    Description de poste :

    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

    Catégorie d'emploi :

    Développement d'applications - TI

    Fin de l'affichage :

    29/04/2024
  • Bean HR Consulting

    Database Administrator

    Found in: Talent IN 2A C2 - 5 days ago

    Bean HR Consulting Noida/Gurgaon/Gurugram, India permanent

    Job Description: · We are seeking a skilled and experienced Azure SQL Database Administrator to join our dynamic IT team. As an Azure SQL Database Administrator, you will be responsible for managing, maintaining, and optimizing our Azure SQL database infrastructure. You will play ...

  • Nerd Geek Lab

    Database Administrator

    Found in: Talent IN 2A C2 - 6 days ago

    Nerd Geek Lab Gurgaon/Gurugram, India permanent

    Job Description and Responsibilities : · - Managing all the instances, Good Knowledge of SQL Server Licensing and versions. · - SQL Server Inventory and license management. · - Monitoring and backup of all the instances. · - Prior experience AWS SQL RDS and Microsoft SQL MI · - D ...

  • Mobifly

    Database Administrator

    Found in: Talent IN 2A C2 - 6 days ago

    Mobifly Gurgaon/Gurugram, India permanent

    If you are looking for an opportunity to solve deep technical problems and build innovative solutions in a fast paced environment working with smart, passionate software developers, this might be the role for you. You will work at the intersection of Business and Technology - own ...

  • MakeMyTrip

    MySQL Database Administrator

    Found in: Talent IN 2A C2 - 1 day ago

    MakeMyTrip Gurugram, India

    We are looking for an experienced MySQL Database Administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances ...

  • Guardian Life

    SQL Database Administrator

    Found in: Talent IN 2A C2 - 4 days ago

    Guardian Life Gurugram, India

    8-12 years of SQL Server DBA experience · Strong Experience with SQL Server Clustering, Mirroring, Log Shipping, AlwaysON · Experience with SQL coding and tuning · Must be hands-on, technically adept DBA, capable of performing required DB tasks. · Deep knowledge with SQL Server 2 ...

  • Make My Trip

    MakeMyTrip - MySQL Database Administrator

    Found in: Talent IN 2A C2 - 6 days ago

    Make My Trip Gurgaon/Gurugram, India permanent

    We are looking for an experienced MySQL Database Administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for orchestrating upgrades, backups, and provisioning of database instances ...

  • Mobifly

    SQL Server Database Administration

    Found in: Talent IN 2A C2 - 6 days ago

    Mobifly Gurgaon/Gurugram, India permanent

    If you are looking for an opportunity to solve deep technical problems and build innovative solutions in a fast paced environment working with smart, passionate software developers, this might be the role for you. You will work at the intersection of Business and Technology - own ...

  • Ally eXecutive HR Consulting

    Database Administrator

    Found in: Talent IN 2A C2 - 4 days ago

    Ally eXecutive HR Consulting Delhi, India

    Location: Delhi/ NCR (Hybrid) · Job Description : · We are seeking a skilled and experienced Azure SQL Database Lead to join our dynamic Database production support team. As an Azure SQL DB Lead, you will be responsible for managing and optimizing Azure SQL databases, leading a t ...

  • Credgenics

    Database Administrator

    Found in: Talent IN 2A C2 - 4 days ago

    Credgenics Noida, India

    About Credgenics: · Credgenics is India's first of its kind NPA resolution platform backed by credible · investors including Accel Partners and Titan Capital. We work with financial · institutions, Banks, NBFCs & Digital lending firms to improve the efficiency of · their collecti ...

  • DEME Group

    Database Administrator

    Found in: Talent IN 2A C2 - 1 day ago

    DEME Group New Delhi, India

    Summary · We are seeking a skilled Database Administrator with expertise in SQL Server, PostgreSQL, and proficiency in PowerShell scripting to join our team. As a DBA, you will be responsible for managing and optimizing our SQL Server and PostgreSQL database systems, ensuring the ...

  • Unnati

    Database Administrator

    Found in: Talent IN 2A C2 - 4 days ago

    Unnati Delhi, India permanent

    Leading Financial Services Company Our client is more than 2 decades old NBFC registered with the RBI. The company was set up with an aim to empower rural entrepreneurs, SMEs, and small institutions by micro-financing. The company has come a long way since its inception in 1992 a ...

  • Agreeya Solutions India Private Limited

    Database Administrator

    Found in: Talent IN 2A C2 - 6 days ago

    Agreeya Solutions India Private Limited Noida/Hyderabad, India permanent

    Essential Skills : Cassandra DBA (L2/L3), Secondary skills - Oracle DBA. · Roles and Responsibilities : · - Participate and assist in production data clusters and related processes · - Install, test, and configure the databases using Cassandra · - Create code as infrastructure p ...

  • Swonline

    Database Administrator

    Found in: Talent IN 2A C2 - 6 days ago

    Swonline Noida, India permanent

    Job Description: · 5+ years MS SQL Server Administration experience required · Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools · Experience with backups, restores and recovery models Knowledge of High Availability (H ...

  • Unnati

    Database Administrator

    Found in: Talent IN 2A C2 - 4 days ago

    Unnati Noida, India permanent

    Our client is a fast growing, PCI certified digital payments platform that leverages technology to offer a single-window alliance for acceptance of UPI and multiple wallets, as well as settlement and reconciliation. This enables service providers and fintech organisations to seam ...

  • Invia

    Database Administrator

    Found in: Talent IN 2A C2 - 4 days ago

    Invia Noida, India permanent

    Job Description : · - Looking for candidates with experience as DBA in MS SQL server. · - 5+ years of experience as a SQL DBA. · - Performing Health Checks and monitoring using Automated scripts and tools. · - Experience in User access management, Performance tuning and optimizat ...

  • Artek Enterprises Pvt Ltd.

    PostgreSQL database administrator

    Found in: Talent IN 2A C2 - 11 hours ago

    Artek Enterprises Pvt Ltd. Delhi, India

    **on-site - Delhi NCR** · • 3-4 years of Strong hands-on experience in PostgreSQL database administration including database installation and configuration. · • Must have experience with PostgreSQL PL/pgSQL functions to support database transactions. · • Responsible for creation ...

  • MarketScope

    Senior Database Administrator

    Found in: Talent IN 2A C2 - 6 days ago

    MarketScope Delhi, India permanent

    Purpose of Position : · We are seeking to hire a technically skilled database administrator that is capable of holding positions of great responsibility. In this role, you'll be assisting team and troubleshoot issues related to database problems that arise and carry out periodic ...

  • 3i Infotech Ltd.

    Oracle Database Administrator

    Found in: Talent IN 2A C2 - 4 days ago

    3i Infotech Ltd. Delhi, India

    JD for Oracle DBA · • Responsible for installations and configuration Oracle Database 11gR2/12C/19c on Linux/Unix platform in standalone and RAC environment. · • Excellent Knowledge and experience in Oracle Performance Tuning, DB upgrade, Migration, DB cloning, Data guard adminis ...

  • Careerfit

    Oracle Database Administrator

    Found in: Talent IN 2A C2 - 6 days ago

    Careerfit Delhi, India permanent

    Responsibilities : · Database Management : · Install, configure, and maintain Oracle database software and associated components. · Create and manage database objects such as tables, indexes, views, and stored procedures. · Automate routine database tasks using scripting language ...

  • ThoughtFocus

    SQL Database Administrator

    Found in: Talent IN 2A C2 - 1 day ago

    ThoughtFocus New Delhi, India

    About the job · Only Immediate joiners who can join within 0-30 Days. · Job Description · :We are seeking a highly skilled and experienced Senior DBA with extensive expertise in SQL DBA.RELEVANCE & IMPACTThe Database Administrator is directly responsible for integrity and securit ...