Senior Sql Database Administrator

6 days ago


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

Job Title: Sr. 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 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).

Please refer to our Privacy Policy at UnitedLex for information, “



  • gurgaon, India UnitedLex Full time

    About UsUnitedlex (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...


  • gurgaon, India UnitedLex Full time

    About UsUnitedLex (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, India Varuna Integrated Logistics Pvt Ltd Full time

    **Job description** **Position description**: - Optimize and fine tune database systems to maximize their performance and operation. - Skilled at optimizing large, complicated SQL statements - Server Monitoring (Disk, CPU and Memory usage) and Resource Management. - Knowledge on any SQL server, Database Management & IT performance tool. - SQL Server Error...


  • Gurgaon, India Zorang Technologies Full time

    **Responsibilities**: - Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering. - Review, analyze, and evaluate business systems and user needs by facilitating brainstorming sessions with Federal Govt stakeholders. - Highly skilled at database design, installations, conversions Responsible...


  • gurgaon, India Incedo Inc. Full time

    LEAD MY SQL4B_Database Administration - MySQL(40133)Gurgaon5DAYS 24/78-10 yrsImmidiate joinersRole Description:As a Senior Technical Lead - Database Administration at Incedo, you will be responsible for managing and optimizing database management systems (DBMS) such as Oracle or SQL Server. You will work with database architects and developers to ensure that...

  • Database Administrator

    3 months ago


    Gurgaon, India Zorang Technologies Full time

    We are looking for a DBA professional who is passionate about their work and is aligned with the company's mission. Motivated to take ownership and have the zeal to continuously improve through learning and growth. Driven towards ways that maximize operational efficiency leading to customer satisfaction. **ROLES AND RESPONSIBILITIES**: - An expert-level...

  • Database Administrator

    3 months ago


    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, India ShipEase Technologies Private Limited Full time

    Currently we're hiring for Database Administration, who have experience in AWS Redshift or related technologies. The role will be responsible for maintaining / supporting our instance which deals thousands of records on a daily basis. **Roles and responsibilities: - ** Debugging skills and experience is a must. Experience with hot fixing breaks by log...


  • Gurgaon, India APEX Analytix, LLC - India Full time

    Supporting, maintaining, and communicating standards and procedures surrounding all SQL Server usage - Proficiency in writing TSQL queries, developing cursors, Stored Procedures, triggers. - Installing, upgrading, and maintaining development and production databases and servers - Directly support conversion activities and SQL Server issues affecting client...


  • Gurgaon, India Zorang Full time

    **Who are we?** Zorang technologies is a customer experience consulting firm that gives digital solutions through strategy, implementation and support so that data is seamlessly transferred to customer’s systems. You can read more about us at: **Please Note **:We’re trying to close this position urgently, Immediate joiners preferred. We can consider 30...


  • Gurgaon District, Haryana, India Neolytix Full time

    **Job Title: Database Administrator (DBA)** **Job Summary**: As a Database Administrator (DBA), you will be responsible for the setup of SQL Server on Azure, performance, integrity, and security of the organization's databases. You will work closely with the IT team, developers, and other stakeholders to ensure optimal database functionality. This role...


  • Gurgaon, India Azalio Technologies Full time

    **Position Title: Database Administrator** **Work Location: Gurgaon (Hybrid Mode)** We are **AZALIO **are on the path of providing a world-class workforce for telecom and cloud technologies. We help organizations bridge the gap between the market demand for cloud experts and the availability of cloud and telecom computing workforces. We at Azalio, work in...


  • Gurgaon, India Country Delight Full time

    Company DescriptionWe are a company dedicated to bringing back the essence of natural, fresh, and unadulterated milk to consumers. Our team of Engineers and IIM Graduates leverages technology to ensure superior milk sourced directly from farmers reaches our consumers hassle-free.Role DescriptionThis is a full-time on-site role based in Gurugram for a...


  • Gurgaon, Gurugram, Haryana, India Expedia Group Full time

    **Oracle Database Administrator** Are you prepared to build strong, scalable, global financial systems that support Expedia's current and future growth? Are you seeking an environment where you can drive innovation within database engines? If the prospect of working with top engineering talent gets you charged up, then Expedia Group's Platform Engineering...


  • Gurgaon, Gurugram, Haryana, India BlackRock Full time

    Description About this role Your team The Database Hosting Team is an integral part of Hosting Services which sits under the broader Aladdin Engineering. Hosting Service is responsible for operating and engineering the reliability, stability and performance of the firm's financial systems including Aladdin and ensuring its availability to our business...

  • Database Administrator

    3 months ago


    Gurgaon, India Saxo Bank Full time

    About the job: Responsibility: - Manage SQL Server databases- Configure and maintain database servers and processes- Monitor system's health and performance- Ensure high levels of performance, availability, sustainability and security- Analyze, solve, and correct issues in real time- Provide suggestions for solutions- Refine and automate regular processes,...

  • Database Administrator

    3 months ago


    Gurgaon/Gurugram/Bangalore, India CIEL HR Full time

    Job Description (Job Summary/Roles & Responsibilities) :- 24/7 Support handling L1 & L2 tickets- Installed and configured multi-nodes fully distributed Cassandra cluster.- Involved in Cassandra Cluster environment administration that includes adding and removing cluster nodes, cluster capacity planning, performance tuning, cluster Monitoring,...

  • SQL Dba

    3 months ago


    Gurgaon, India Infinity Labs Full time

    5+ years in SQL Server database administration - Install, configure, upgrade, and administer SQL Server database engine, SQL Server Service Broker, SQL Server Integration Services, SQL Server Analysis Services, and/or SQL Server Reporting Services. - Manage and Upgrade/Install database-related clustered and stand-alone servers in both physical and virtual...


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