Sr Administrator

4 weeks ago

Gurgaon, India UnitedLex Full time

About Us

iRunway (Erstwhile UnitedLex) 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 Location : Gurgaon

Please click on the link to visit our website :

JOB DESCRIPTION Job Title: Sr.  Database Administrator Level: Full Time

Business Unit: Technology Solutions

Shift: 9PM to 6 AM (Remote)

Reporting Structure:  Manager, Database Management and Administration

OVERALL PURPOSE OF JOB:

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

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

  • Sr Administrator

    1 week ago

    Gurgaon, Haryana, India UnitedLex Full time

    About UsiRunway (Erstwhile UnitedLex) 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...

  • Executive Personal Assistant

    3 weeks ago

    gurgaon, India SR WEALTH ELITE Full time

    Company DescriptionSR Wealth Elite is a trusted wealth management firm located in Gurugram, with over 15 years of experience in empowering clients to achieve their wealth creation goals. Led by top SEBI-registered research analysts and experienced market professionals, we deliver customized services that are tailored to each client's financial goals,...

  • Executive Personal Assistant

    4 weeks ago

    gurgaon, India SR WEALTH ELITE Full time

    Company DescriptionSR Wealth Elite is a trusted wealth management firm located in Gurugram, with over 15 years of experience in empowering clients to achieve their wealth creation goals. Led by top SEBI-registered research analysts and experienced market professionals, we deliver customized services that are tailored to each client's financial goals,...

  • Executive Personal Assistant

    1 week ago

    Gurgaon, Haryana, India SR WEALTH ELITE Full time

    Company DescriptionSR Wealth Elite is a trusted wealth management firm located in Gurugram, with over 15 years of experience in empowering clients to achieve their wealth creation goals. Led by top SEBI-registered research analysts and experienced market professionals, we deliver customized services that are tailored to each client's financial goals,...

  • Sr Administrator

    1 week ago

    Gurgaon, Haryana, India UnitedLex Full time

    About Us iRunway (Erstwhile UnitedLex) 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...

  • Sr Administrator

    3 weeks ago

    gurgaon, India UnitedLex Full time

    About Us iRunway (Erstwhile UnitedLex) 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...

  • Sr Administrator

    1 month ago

    gurgaon, India UnitedLex Full time

    About Us iRunway (Erstwhile UnitedLex) 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...

  • Aws Cloud Administrator

    3 weeks ago

    Gurgaon, India SITS Full time

    We Need AWS Cloud Administrator Urgently Job Title: Specialist Cloud Admin/ Sr. Specialist Cloud Admin Location: Gurugram, Haryana #job#aws#cloud#jobhiring#urgentlyhiring#urgentrequirement#urgent#job#gurugram The Cloud Computing Administrator + Security Engineer will be responsible for maintaining infrastructure of company Cloud Servers as well as ensuring...

  • Sr Analyst

    1 week ago

    Gurgaon, Haryana, India UnitedLex Full time

    About Us: UnitedLex (erstwhile iRunway India Pvt Ltd) is a data and professional services company delivering outcomes for high-performing law firms and corporate legal departments in the areas of digital litigation, intellectual property, contracts, compliance, and legal operations. Founded in 2006 with a mission to push the boundaries of legal...

  • Sr. Oracle DBA

    6 days ago

    gurgaon, India Dhani Full time

    Sr. Oracle DBA JD:Experience: 10+ yrs. ExpDesired Competencies (Technical/Behavioral Competency)Must-Have:Experience in working on Oracle 11g, 12c and 19c databases on various platforms (Unix, Windows) & MySQL/PostgreSQL administration.Good Knowledge in Oracle database Administration skills.Oracle RAC, ASM & Knowledge on Scripting(Shell Script) for...

  • Finance Systems Administrator

    1 week ago

    Gurgaon, Haryana, India GLG Full time

    Finance Systems Administrator Reporting to the Sr Director of Finance Systems, the Great Plains Administrator will be a key member of the Finance Systems team. You will be responsible for the implementation, maintenance, and optimization of Microsoft Dynamics Great Plains (GP) and OneStream within GLG. Your primary focus will be to ensure the smooth and...

  • Sr. Network Administrator

    1 week ago

    Gurgaon, Haryana, India Giesecke+Devrient Full time

    Objective Of This Role: As a Senior Network administrator, You will provide high-level technical expertise in the area of Network administration. This individual would be responsible for ensuring that the established processes to meet the regulatory and G&D corporate security requirements are respected and optimized, in a fast-paced and critical...

  • Sr Engineer

    1 month ago

    Gurgaon, India UnitedLex Full time

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

  • Sr Engineer

    3 weeks ago

    gurgaon, India UnitedLex Full time

    About Us iRunway (Erstwhile UnitedLex) 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...

  • Sr Engineer

    4 weeks ago

    Gurgaon, India UnitedLex Full time

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

  • Sr Engineer

    1 month ago

    gurgaon, India UnitedLex Full time

    About Us iRunway (Erstwhile UnitedLex) 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...

  • Sr Engineer

    1 week ago

    Gurgaon, Haryana, India UnitedLex Full time

    About Us iRunway (Erstwhile UnitedLex) 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...

  • Sr. Brand Services Associate

    3 weeks ago

    gurgaon, India Publicis Groupe Full time

    Position : Sr. Brand Services AssociateExp Required : 2 - 4 yearsMain Task & Responsibilities :Manage day to day operations (inter dept coordination, intra dept coordination, finalizing work – taking feedback, understanding how to decode client feedback, artworks, attention to detail, competitive knowledge, market visits, minutes of the meeting.Knowledge...

  • Sr. Brand Services Associate

    1 week ago

    Gurgaon, Haryana, India Publicis Groupe Full time

    Position : Sr. Brand Services AssociateExp Required : - 4 yearsMain Task & Responsibilities :Manage day to day operations (inter dept coordination, intra dept coordination, finalizing work – taking feedback, understanding how to decode client feedback, artworks, attention to detail, competitive knowledge, market visits, minutes of the meeting.Knowledge of...

  • Sr Executive Human Resources

    6 days ago

    gurgaon, India SGT UNIVERSITY Full time

    Position Name: Sr Executive Human ResourcesSGT University is in search of a seasoned professional to work as a Sr executive HR for its campus near Delhi. The University (a Health Science University), in its campus spread over 70 acres near Gurgaon, offers courses in Health Sciences, such as Medicine, Dental Sciences, Pharmacy, Nursing, and also in...