Database Administrator

2 months ago


GurgaonGurugram, 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, and human ingenuity.

Job Title : Senior Database Administrator.

Job Location : Gurgaon.

Reporting Structure : Director, 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.

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

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

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


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


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


  • 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 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 MathLogic Full time

    Role Description :This is a full-time on-site role as a part of team supporting large data platform transformation exercise. Opportunity to move to Data Science team. Technical requirements :- DBA knowledge and experience, doesn't need to be an expert DBA, but should know and have some exposure and experience.- Understanding existing stored procedures...

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

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


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


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


  • Gurgaon/Gurugram, IN Awiros Full time

    About Awiros :Incorporated in 2015, Awiros is making it possible for everyone to build as well as utilize the most advanced applications of Computer Vision and AI in their everyday lives using its app-oriented open and unified Operating System model. With a stellar team of researchers and engineers, our constant endeavor is to push the boundaries of...


  • 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 PeopleXM Full time

    Description :- Support development, test and production environments, including application security and availability.- Create, configure, backup and restore a WebLogic Server domain, cluster, and authentication provider.- Ensures installations meet standards and technical specifications.- Plan, install, build, manage, support, configure, secure and test...


  • Bangalore/Gurgaon/Gurugram/Nagpur, IN Intuitive Apps Full time

    As a Big Data Admin, you will play a crucial role in ensuring the smooth operation and optimization of our Hadoop and Spark infrastructure. Your responsibilities will include :Hadoop Installation and Deployment :- Install Hadoop in Linux environments.- Deploy and maintain Hadoop clusters.- Monitor cluster health to ensure continuous uptime.- Analyze storage...

  • Data Engineer

    2 months ago


    Gurgaon/Gurugram, IN curatAId Full time

    Job Description :Expertise in Azure cloud tools for our client, a global business and technology services firm. In this role, you will be integral to designing, developing, and maintaining the data infrastructure. The ideal candidate will have extensive experience with cloud-based data technologies, particularly in Azure, and a proven track record of...


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


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