UnitedLex - Senior Database Administrator - SQL Server

2 months ago

Gurugram, India 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)

  • UnitedLex - Advanced Administrator - SQL Server

    1 month ago

    Gurugram, India IRUNWAY INDIA PRIVATE LIMITED UnitedLex Full time

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

  • Advanced Administrator

    2 months ago

    gurugram, India UnitedLex Full time

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

  • Advanced Administrator

    2 months ago

    Gurugram, India UnitedLex Full time

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

  • UnitedLex | Senior Engineer- Netapp Storage | gurugram

    3 weeks ago

    gurugram, India UnitedLex 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

    3 weeks ago

    Gurgaon/Gurugram, India 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,...

  • UnitedLex | Sr Analyst

    1 month ago

    gurugram, India 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,...

  • SQL Server Database Administrator

    7 months ago

    Gurugram, Haryana, India AHEAD Full time

    AHEAD is currently seeking a SQL Server DBA (Database Administrator) who will be counted on as part of the technical service delivery team to successfully manage and support Microsoft SQL database systems for clients. **Duties & Essential Job Functions**: - Resolve Client Technical Support Issues (Managed Service Desk) - Proactive database monitoring and...

  • Senior Database Administrator

    3 weeks ago

    Gurugram, India Flairdeck consulting Full time

    Company Description : At FlairDeck, we are a leading force in the recruitment and staffing industry, dedicated to redefining talent acquisition through unmatched dedication and expertise. Specializing in connecting top-notch talent with exceptional job opportunities, our team focuses on niche skills like IoT to drive business success. We are matchmakers for...

  • UnitedLex | Senior Network Engineer | gurugram

    4 weeks ago

    gurugram, India UnitedLex Full time

    REQUIREMENTS & COMPETENCIES: Bachelor’s Degree, Trade school certificate in Network Administration and / or Equivalent Experience 8+ years as Network Engineer in a Medium to Large Enterprise Environment Must have Cisco Switching, Routing, Cisco Meraki, and ASA knowledge. Must have Load balancer F5 . Must have Palo Alto Firewall Knowledge Good to have...

  • UnitedLex | Sr Analyst

    1 month ago

    gurugram, India UnitedLex Full time

    About Us UnitedLex India Private Limited (Erstwhile iRunway) is a data and professional services company delivering outcomes that create value for high-performing law firms and corporate legal departments in the areas of litigation and investigations, intellectual property, contracts, compliance, and legal operations. Location : Gurgaon Shift : 10:30 AM...

  • UnitedLex | Senior Associate

    1 month ago

    gurugram, India UnitedLex Full time

    Position: Senior Associate Location: Bangalore/Gurgaon About Us: Unitedlex India Pvt. Ltd. (Formerly known as 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...

  • UnitedLex | Associate

    1 week ago

    gurugram, India UnitedLex Full time

    Job Title: Associate – Patent Paralegal & IDS Management Overview: The Paralegal is responsible for individual contribution as part of the UnitedLex IP Managed Services. Primary day to day focus will be on various patent-related docketing and IDS activities. Candidates should have strengths in teamwork (internal and external stakeholders), quality...

  • SQL Database Administrator

    1 month ago

    Gurugram, India Publicis Groupe Full time

    SQL Server/Azure Database Administrator- KEY RESPONSIBILITIESInstallation, upgradation, Administration and Maintenance of SQL Server InstancesCreate Users and assign permissions based on the level of database access the user would needSetup High-Availability as part of Disaster Recovery Strategy for the DatabasesTroubleshoot various problems that arise in...

  • SQL Database Administrator

    1 month ago

    Gurugram, India Publicis Groupe Full time

    SQL Server/Azure Database Administrator- KEY RESPONSIBILITIESInstallation, upgradation, Administration and Maintenance of SQL Server InstancesCreate Users and assign permissions based on the level of database access the user would needSetup High-Availability as part of Disaster Recovery Strategy for the DatabasesTroubleshoot various problems that arise in...

  • SQL Database Administrator

    1 month ago

    Gurugram, India Publicis Groupe Full time

    SQL Server/Azure Database Administrator- KEY RESPONSIBILITIES Installation, upgradation, Administration and Maintenance of SQL Server Instances Create Users and assign permissions based on the level of database access the user would need Setup High-Availability as part of Disaster Recovery Strategy for the Databases Troubleshoot various problems that arise...

  • UnitedLex - Storage Architect - SAN/NAS

    2 months ago

    Gurugram, India 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,...

  • SQL Database Administrator

    1 month ago

    gurugram, India Publicis resources Full time

    Installation, upgradation, Administration and Maintenance of SQL Server Instances Create Users and assign permissions based on the level of database access the user would need Setup High-Availability as part of Disaster Recovery Strategy for the Databases Troubleshoot various problems that arise in the day-to-day operations and fix the issues Monitoring and...

  • SQL Database Administrator

    1 month ago

    Gurugram, India Publicis resources Full time

    Installation, upgradation, Administration and Maintenance of SQL Server InstancesCreate Users and assign permissions based on the level of database access the user would needSetup High-Availability as part of Disaster Recovery Strategy for the DatabasesTroubleshoot various problems that arise in the day-to-day operations and fix the issuesMonitoring and...

  • SQL Database Administrator

    1 month ago

    Gurugram, India Publicis resources Full time

    Installation, upgradation, Administration and Maintenance of SQL Server InstancesCreate Users and assign permissions based on the level of database access the user would needSetup High-Availability as part of Disaster Recovery Strategy for the DatabasesTroubleshoot various problems that arise in the day-to-day operations and fix the issuesMonitoring and...

  • SQL Database Administration

    6 months ago

    Gurugram, Haryana, India Ericsson Full time

    **About this opportunity!**: Our GFGO Global Business Services Global Shared Service Centre for Learning Operations fulfils a pivotal role towards all Ericsson employees, with global responsibility for the efficient operations of our total employee learning offering. As the SQL Database Administration, you will play a pivotal role in ensuring the efficient...