Jobs
>
Gurgaon

    Manager Database Administration - Gurgaon, India - UnitedLex

    UnitedLex
    Default job background
    Legal
    Description

    ABOUT THE COMPANY :


    UnitedLex India Pvt Ltd (Erstwhile iRunway India Pvt Ltd) is a data and professional services company delivering outcomes that create value and competitive advantage for legal and the business.

    Our business is anchored by a passion for innovation brought to life by a global community of diverse individuals determined to deliver on the promise of data mastery, legal acumen, and human ingenuity


    OVERALL PURPOSE OF JOB:


    The Manager of Database Administration is responsible for supporting and leading the Database Administration team and operational management of SQL Server Infrastructure.

    This role is also responsible for overseeing databases services which includes maintaining and managing our entire database environment including production, test and development database servers across the organization located in the different geography.

    This includes supporting databases for third-party applications, and our in-house applications for routine maintenance, server administration and management, and addressing ad hoc requests.

    This person will also be responsible to support database/data store services as defined by SOPs meeting defined SLAs while maintaining practices that are consistent with company's goals as well as industry best practices and regulatory requirements.


    REQUIREMENTS & COMPETENCIES:
    Work Experience
    10+ years of hands-on experience in providing DBA support for large 24X7 production database environment.
    3-5+ years of hands-on experience leading a team, meeting deadlines, and driving results.
    Technology Skills & Experience
    Strong knowledge and experience with Microsoft SQL Server 2016 or higher version.
    Very good understanding of SQL Server Architecture, backups, indexes, jobs, Transaction Logs etc.
    Hands-on experience in managing database backups, performing recovery/restore etc.
    Hands-on experience with SQL Server installation, security configuration, applying service packs and patches.
    Very good understanding and hands-on experience of building Microsoft failover clustering services and AlwaysOn infrastructure.
    Microsoft Azure SQL and other components of Azure
    Database Encryption
    Database growth vs disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use)
    Strong ability to write/develop SQL scripts for various database management activities and ad-hoc projects
    Hands-on experience with developing PowerShell scripts for various database administration activities
    Good understanding of SQL Server security architecture.
    Having exposure to large databases and comfortable in managing 24X7 OLTP database services.
    Experience of providing DBA support for 24X7 production support for Microsoft SQL Server-based database services.
    Experience with DBCC commands for routine maintenance activities and writing scripts for database administration.
    Good understanding of database monitoring tools, responding alerts as well as follow-up actions on alerts
    Experience with other RDBMS product like Oracle and MySQL is a plus
    Experience with DevOps is a plus
    Experience with any NoSQL product is preferred.
    Project Delivery Competence
    Ability to accurately gauge and estimate effort required to complete tasks assigned
    Ability to apply technical, programmatic solutions to complex business requirements
    Strong ability to build design database according to requirements specifications
    Experience in an environment of rapid development and delivery
    Should be opened to being on call over the weekend and after-hour on rotational basis
    General/Soft Skills
    Ability to communicate ideas effectively- both technical and conceptual; verbally and written
    Ability to multi-task with superior decision-making, analytical and problem-solving abilities
    Ability to work with senior leaders to communicate with confidence, clarity, and authority on subject matter expertise
    Ability to lead and manage a team
    Ability to mentor, develop a team

    Education
    Bachelor's degree in computer science, Information Systems, or related field preferred
    Azure SQL Server Certification preferred


    RESPONSIBILITIES:


    Build, maintain and support all the Production databases servers that are running or may run on AlwaysOn, clustered or non-clustered environments.

    Responsible for maintaining database backups (full, differentials and transaction logs), verify and retain them for a specific period to meet retention policy as per our SLA.

    Create and maintain all documentation including SOPs and SLAs that relates to Database Management and Administration.

    Analyze database activities and performance, using various tools like SQL Server inbuilt tools as well as third-party tools, troubleshoot and track the nature and resolution of problems.

    Provide reports based on ad hoc request by business (or client) from various applications.
    Perform install, apply patches, build SQL cluster under the supervision of Database Manager/Architect.
    Perform routine database administration activities like index management, transaction log management, update statistics, check database integrity etc.

    Write and modify database code (T-SQL, stored procedure, views, triggers, user-defined functions) for our in-house applications as and when required.

    Develop report and/or write complex T-SQL queries for reports as and when required.
    Assist in coordinating and supporting special projects related to the database environment, High Availability (HA) and Disaster Recovery (DR).


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


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


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


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


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


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


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


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


  • 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 · * ...


  • JRK Infotech Gurugram, Haryana, India

    **Required Skill Set: · - ** · - Minimum Experience of minimum 3+ years in oracle DBA. Experience in the banking domain is preferable. · - Oracle Production database administration with knowledge of Oracle 10g, 11g databases, sql loader, RMAN, Physical Standby Databases, Dataguar ...


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


  • Azalio Technologies Gurgaon, India

    **Position Title: Database Administrator** · **Work Location: Gurgaon (Hybrid Mode)** · We are **AZALIO **are on the path of providing a world-class workforce for telecom and cloud technologies. · We help organizations bridge the gap between the market demand for cloud experts an ...


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


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


  • Stem, Inc. Gurugram, Haryana, India

    . · Stem's culture embodies diversity & inclusion beyond the traditional facets of gender, ethnicity, age, disabilities, and sexual orientation to include experience, personality, communication, workstyles, and more. At our core, Stem is at the momentous intersection of clean ene ...


  • Zorang Gurgaon, India

    **Who are we?** · Zorang technologies is a customer experience consulting firm that gives digital solutions through strategy, implementation and support so that data is seamlessly transferred to customer's systems. · You can read more about us at: · **Please Note **:We're trying ...