Analyst Database Administrator

1 week ago

Gurgaon, Haryana, India Sun Life Full time

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

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India Antal International Full time

    Role Details :Key Responsibilities and Accountabilities:Database Management : Design data solution on Azure/On-Prem and sometime in collaboration with business/technical partners. Managing Database solution on Azure/onprem for SQL Server, Azure SQL Server (Managed/unmanaged), MySQL and PostgreSQL Manage Datawarehouse solution on Azure like Databricks, Data...

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India Insight Enterprises, Inc. Full time

    Requisition Number:92481DATABASE ADMINISTRATORWorking hours: US shift (Night)Location: Delhi NCR (Non-Remote)Position OverviewThe Database Administrator is responsible for all aspects of Insight's database administration and production support. This responsibility include database configuration, maintenance, production support, troubleshooting, and capacity...

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India Nerd Geek Lab Full time

    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 DR planning and execution. Experience on SQL Clustering Develop and implement best practices,...

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India Mobifly Full time

    If you're eager to tackle challenging technical issues and develop creative solutions in a dynamic setting alongside talented and passionate software engineers, then this role could be a great fit for you.Here at our company, you'll be at the forefront of blending Business and Technology - taking charge of end-to-end feature development that assists Fortune...

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India United Airlines Full time

    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 innovation and is the foundation of all that we doOur Shared Purpose:"Connecting people....

  • Database Administrator

    4 weeks ago

    Gurgaon, Haryana, India United Airlines Full time

    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 innovation and is the foundation of all that we do. Our Shared Purpose: "Connecting people. Uniting the...

  • Database Administrator

    1 month ago

    Gurgaon, Haryana, India United Airlines Full time

    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 innovation and is the foundation of all that we do. Our Shared Purpose: "Connecting people. Uniting the...

  • Database Administrator, Oracle

    1 week ago

    Gurgaon, Haryana, India Softenger Full time

    Job Profile: Database Administrator, OracleJob Location: GurugramExperience Required: 35 yrs Database Installation, Configuration, Upgradation, Migration, Monitoring, and Administration of production databases supporting activities. Allocate system storage and plan future storage requirements for the database system. Demonstrate proficiency in RMAN, Data...

  • Principal Database Administrator

    1 week ago

    Gurgaon, Haryana, India Hudson RPO Full time

    Role : Principal Database Administrator Role Purpose :The principal responsibility of this role is to provide operational expertise around database management within the Site Reliability Engineering (SRE) team and work with the software engineering teams for new and existing databases.This encompasses : Working in partnership with the business and the...

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India Comviva Full time

    ABOUT COMVIVA :Comviva is changing the world through digital experiences. Our innovative portfolio of digital solutions and platforms bring greater choice, faster time to market and flexibility, to better meet the evolving needs of our customers as they drive growth, transform and bring efficiency. From maximizing customer lifetime value to enabling large...

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India Skyleaf Full time

    We are hiring for someone who has extensive experience as a SQL DBA with little bit of hands-on experience on working with SQL server.Experience : 6 to 8 years (max)Location : Gurugram (Work from office)Notice Period : Immediate to 30 Days Responsibilities : Primary responsibility of this role is going to be supporting highly transactional database...

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India Comviva Full time

    ABOUT COMVIVA :Comviva is changing the world through digital experiences. Our innovative portfolio of digital solutions and platforms bring greater choice, faster time to market and flexibility, to better meet the evolving needs of our customers as they drive growth, transform and bring efficiency. From maximizing customer lifetime value to enabling large...

  • Oracle Database Administrator

    1 week ago

    Gurgaon, Haryana, India Insight Enterprises, Inc. Full time

    Requisition Number: 96141 Job Title: Oracle Database AdministratorAbout Insight:Founded in 1998, Insight is headquartered in Chandler, Arizona, USA and has more and has more than 13000+ Teammates worldwide with global presence in Canada, United Kingdom, Germany, Australia, India, Singapore and many more. With offices in the prime location -Gurgaon and...

  • Oracle Database Administrator

    1 week ago

    Gurgaon, Haryana, India Insight Enterprises, Inc. Full time

    Requisition Number: 96141 Job Title: Oracle Database Administrator About Insight: Founded in 1998, Insight is headquartered in Chandler, Arizona, USA and has more and has more than 13000+ Teammates worldwide with global presence in Canada, United Kingdom, Germany, Australia, India, Singapore and many more. With offices in the prime location...

  • Database Administration

    1 week ago

    Gurgaon, Haryana, India Tivix Full time

    Experience 3+ YearsSkills and QualificationsExperience in database automation tasks.Experience in MySql or MongoDB database administration.Experience designing logical and physical databases for OLTP.Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.Proficient...

  • Oracle Database Administrator

    1 week ago

    Gurgaon, Haryana, India Insight Enterprises Full time

    Requisition Number:96141**Job Title: Oracle Database AdministratorAbout Insight:Founded in 1998, Insight is headquartered in Chandler, Arizona, USA and has more and has more than 13000+ Teammates worldwide with global presence in Canada, United Kingdom, Germany, Australia, India, Singapore and many more. With offices in the prime location -Gurgaon and...

  • Database Administrator

    1 week ago

    Gurgaon, Haryana, India Comviva Full time

    ABOUT COMVIVA :Comviva is changing the world through digital experiences. Our innovative portfolio of digital solutions and platforms bring greater choice, faster time to market and flexibility, to better meet the evolving needs of our customers as they drive growth, transform and bring efficiency. From maximizing customer lifetime value to enabling large...

  • SQL Database Administrator

    1 week ago

    Gurgaon, Haryana, India Expedia Group Full time

    SQL Database AdministratorWhat you'll do:Administer, maintain, and optimize our SQL database environmentExperience in a 24x7, high traffic OLTP environmentEnsure high availability and disaster recovery capabilities for all databasesDevelop and implement backup and recovery strategiesMonitor database performance and proactively identify and resolve...

  • Oracle Database Administrator

    1 week ago

    Gurgaon, Haryana, India Medanta Full time

    Job Location - GurgaonWork Days - 6 days weekJob Objective -To administer multipleOracle (MUST), Sqlserver databases spread across locations in a distributed environmentJob Responsibility -1.Support and TrainingProviding User support (24x7) HRS – On callProblem escalation to corporate team and third parties as appropriate.Identifying and resolving database...

  • MySQL Database Administrator

    1 week ago

    Gurgaon, Haryana, India MakeMyTrip Full time

    We are seeking for an experienced MySQL database administrator who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. This role requires a deep understanding of database architecture, data modelling, and database security. The ideal candidate will have a proven track record of managing large-scale...