UnitedLex - Senior Database Administrator - SQL Server

4 weeks ago


GurgaonGurugram, IN IRUNWAY INDIA PRIVATE LIMITED UnitedLex Full time

About Us :

UnitedLex (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.

Job Title : Sr. Database Administrator

Job Location : Gurgaon

Reporting Structure : Director, Database Management and Administration.

Job Description :

The Database Administrator is responsible for supporting operational management of 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.

Technology Skills & Experience :

- Strong knowledge and experience with Microsoft SQL Server 2016 or higher version.

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

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

Education : Bachelor's degree or higher in Computer Science, Information Systems or related field.

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 requests 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 reports 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).

(ref:hirist.tech)
  • Database Administrator

    2 months ago


    Gurgaon/Gurugram, IN United Lex Full time

    About Us : Unitedlex (Erstwhile iRunway) 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,...

  • Database Administrator

    2 months ago


    Pune/Chandigarh/Chennai/Mumbai/Gurgaon/Gurugram/Bengaluru,Panchkula, IN Mobile Programming LLC Full time

    Job Description :We are looking for a junior database administrator (DBA) to join our IT team and help us manage and maintain our databases. You will be responsible for ensuring the security, availability, performance, and integrity of our data. You will also assist in database design, development, backup, recovery, and troubleshooting. You will work as an...


  • Gurgaon/Gurugram, IN IRUNWAY INDIA PRIVATE LIMITED UnitedLex Full time

    Unitedlex India Pvt. Ltd : (Formerly known as iRunway) 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,...

  • Database Administrator

    2 months ago


    Gurgaon/Gurugram/Haryana, IN MINDTEL GLOBAL PRIVATE LIMITED Full time

    We are looking for a highly skilled and motivated Database Administrator (DBA) to join our IT team. The ideal candidate will have extensive experience in managing, optimizing, and securing database systems. This role is crucial for ensuring the availability, performance, and reliability of our databases, as well as supporting development and operational...


  • Gurgaon/Gurugram, IN hiringgo Full time

    Job Title : Senior SQL Server Developer. Location : Gurugram. Experience : Minimum 5 Years. Job Type : Full-Time. Job Overview :- We are seeking an experienced SQL Server Developer with a minimum of 5 years of experience in designing, developing, and optimizing database solutions.- The ideal candidate will focus on creating, optimizing, and maintaining...


  • Gurgaon/Gurugram/Haryana, IN AIS Info Full time

    Join AIS Info and leverage your expertise to design, develop, and optimize mission-critical database solutions!About AIS Info : AIS Info is a leading technology and professional services company headquartered in Gurgaon, India. We help clients across various industries, including banking, finance, insurance, and telecommunications, streamline operations,...


  • Gurgaon/Gurugram, IN IRUNWAY INDIA PRIVATE LIMITED UnitedLex Full time

    OVERALL PURPOSE OF JOB : - We are looking for a highly skilled DevOps Engineer with expertise in Terraform and Ansible to join our dynamic team.- The Infrastructure Automation Engineer is charged with the design and development of scripts and code needed to automate and integrate IT systems and related infrastructure.- This role would act as the subject...


  • Gurgaon/Gurugram, IN AIS Info Full time

    Company Description :AIS Info is a leading professional services and technology company headquartered in Gurgaon, India. We are dedicated to transforming business operations by reducing operating costs, enhancing compliance, and mitigating risks through advanced automation and a highly skilled workforce. Our mission is to partner strategically with our...

  • Senior Associate

    3 weeks ago


    Gurgaon/Gurugram, IN Ankura Consulting Group, LLC Full time

    Job Description Summary : Are you a self-starter? Do you enjoy supporting globally based teams? Would your friends generally describe you as a night owl? If so, Ankura is looking for a Database Administrator that fits these criteria with the desire to be a critical member of our team. Under minimal supervision, you will work as a member of the Data &...


  • Noida/Delhi NCR/Gurgaon/Gurugram, IN Lancetech solutions Full time

    Location : REMOTE/Gurugram. Shift timing : 1:30PM to 10:30PM. Mandatory Skills : 7-14 years in database SQL, MySQL, DBA. Notice period : Immediate to 30 days of notice. The ideal candidate will ensure the performance, integrity, and security of our databases and develop and maintain database applications. Key Responsibilities :Database Administration :-...


  • Gurgaon/Gurugram, IN Mobifly Full time

    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 - owning end to end development of features that help fortune 500 to solve their...

  • Database Administrator

    6 months ago


    Gurgaon/Gurugram, IN Mobifly Full time

    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 - owning end to end development of features that help fortune 500 to solve their...

  • SQL Developer

    2 months ago


    Gurgaon/Gurugram, IN PeopleStrong Full time

    Job Description :- Develop high-quality database solutions.- Use SQL/MYSQL to develop and implement procedures and functions.- Review and interpret ongoing business report requirements.- Research required data.- Build appropriate and useful reporting deliverables.- Analyze existing SQL queries for performance improvements.- Suggest new queries.- Develop...


  • Gurgaon/Gurugram/Remote, IN Lancetech solutions Full time

    Job Title : DBA Administrator. Location : REMOTE/Gurugram. Shift timing : 1:30PM to 10:30PM. Mandatory Skills : 7-14 years in database SQL, MySQL, DBA. The ideal candidate will ensure the performance, integrity, and security of our databases and develop and maintain database applications. Key Responsibilities : Database Administration :- Design, install, and...


  • Gurgaon/Gurugram, IN oasis TechnoSoft Pvt. Ltd. Full time

    Job Summary :We are seeking an experienced Oracle Database Administrator (DBA) to join our dynamic team. The ideal candidate will have a strong background in Oracle database management and will be responsible for maintaining the performance, integrity, and security of our Oracle databases.Key Responsibilities :- Install, configure, and upgrade Oracle...

  • SQL Developer

    2 months ago


    Gurgaon/Gurugram, IN PeopleStrong Full time

    Job Description :- Develop high-quality database solutions.- Use SQL to develop and implement procedures and functions.- Review and interpret ongoing business report requirements.- Research required data.- Build appropriate and useful reporting deliverables.- Analyze existing SQL queries for performance improvements.- Suggest new queries. ETL tool knowledge...


  • Gurgaon/Gurugram, IN ValueFirst Digital Media Pvt. Ltd Full time

    As Database Administrator you would require to understand MySQL Architecture, Installing and upgradation, replication Clustering and security of MySQL. Key Responsibilities : - Using INFORMATION_SCHEMA database for accessing metadata. - Performing start and end operations of MySQL. - Evaluating character sets and data types for performance-related concerns....


  • Gurgaon/Gurugram, IN Questhiring Full time

    Job Description :- Do you have the zeal for building and implementing databases ?- If you are a creative blend of entrepreneurial spirit and expertise, willing to learn and adapt new technologies, believe in setting high technical standards, We would love to talk to you!Educational Qualification : - Bachelor/Master's degree in CS/ME/IT/ Related...

  • Database Architect

    1 month ago


    Gurgaon/Gurugram, IN Aviation Indeed Private Limited Full time

    Position : Data ArchitectRole Overview :The Data Architect will play a pivotal role in designing and implementing the company's data infrastructure. This position requires a strong understanding of data modeling, architecture, and best practices to ensure data quality, consistency, and accessibility across the organization.Key Responsibilities :-...


  • Gurgaon/Gurugram, IN AzimuthGRC Technologies India Private Limited Full time

    Job Description :- Conduct the Azure SQL/Azure SQL MI/SQL on Azure VM, On Prem SQL Server, SSRS, SSIS, Azure Synapse and other related products as applicable and necessary- Install/Configure/Setup/Administer and Maintain production and non-production environmentsSetup High-Availability and Disaster Recovery- Plan and test high availability and disaster...