Manager Database Administration

4 weeks ago


gurgaon, India UnitedLex Full time
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).

  • Gurgaon, India Insight Enterprises, Inc. Full time

    **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 responsibility include database configuration, maintenance, production support,...


  • Gurgaon, India Rosmerta Technologies Ltd Full time

    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** - Build database systems of high availability and quality depending on each end...


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


  • 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

    2 months ago


    Gurgaon, India MMC Corporate Full time

    **ob Summary** An excellent opportunity for a Change Management Coordinator looking for a long-term opportunity, growth and flexible work environment within Database Services team. In this capacity, the responsibilities will include: - Review, validate, approve and align DBA resources to Change Requests received by Database Services team - Provide...


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


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


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


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


  • Gurgaon, India Optim hire Full time

    **Key Responsibilities** - Responsibility for preparing for backup and disaster recovery of company databases. - Develop processes for optimising database security. - Diagnose and troubleshoot database errors. - Provide proactive and reactive data management support and training to users Required Experience - Hands-on experience with SQL and NoSQL databases...


  • 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

    2 months ago


    Gurgaon, India iQuanta Full time

    **Role: Database administrator** **Salary: 6 LPA** **Exp: 4 - 6 yrs** - 4-6 years of programming experience demonstrating advanced system knowledge in several domain areas, technologies, and tools to create high quality software - Build database systems of high availability and quality depending on each end user’s specialised role - Design and implement...


  • Gurgaon, India Softenger Full time

    **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 management, stability analysis, etc. - To be proactive in nature thus identifying problems...


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


  • Gurgaon, India Medanta Full time

    Job Location - Gurgaon Work Days - 6 days week Job Objective - To administer multiple Oracle (MUST) , Sqlserver databases spread across locations in a distributed environment Job Responsibility - 1.Support and Training Providing User support (24x7) HRS – On call Problem escalation to corporate team and third parties as appropriate. Identifying and...


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


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


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


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


  • Gurgaon, India Arting Digital Full time

    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 - scripts to create multiple DB instance, Good Data Archiving.Good understanding with DB...