Senior Sql Database Administrator

2 months ago


gurgaon, 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, 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, Haryana, India Spectral Consultants Full time

    Job Title: SQL Database AdministratorJob Summary:Spectral Consultants is seeking an experienced SQL Database Administrator to join our team. As a key member of our database administration team, you will be responsible for ensuring the high availability, performance, and security of our SQL Server databases.Responsibilities:• Design, implement, and maintain...


  • Gurgaon, Haryana, India Spectral Consultants Full time

    Job Title: SQL Database AdministratorWe are seeking an experienced SQL Database Administrator to join our team at Spectral Consultants. As a key member of our database team, you will be responsible for ensuring the smooth operation of our SQL Server infrastructure.Responsibilities:Design, implement, and maintain high-availability database solutions using SQL...


  • Gurgaon, Haryana, India Sun Life Full time

    {"h1": "Database Administrator Job Description", "p": "At Sun Life, we're looking for a skilled Database Administrator to join our team. As a key member of our IT department, you'll be responsible for ensuring the smooth operation of our databases, ensuring data integrity, and optimizing database performance. Responsibilities: * Resolve reported service...


  • Gurgaon, Haryana, India AHEAD Full time

    Job Title: SQL Database AdministratorAHEAD is seeking a skilled SQL Database Administrator to join our technical service delivery team. As a key member of our team, you will be responsible for managing and supporting Microsoft SQL database systems for our clients.Key Responsibilities:Provide technical support for client issues through our managed service...


  • Gurgaon, Haryana, India AHEAD Full time

    Job Title: SQL Database AdministratorAHEAD is seeking a skilled SQL Database Administrator to join our technical service delivery team. As a key member of our team, you will be responsible for managing and supporting Microsoft SQL database systems for our clients.Key Responsibilities:Provide technical support for client issues related to Microsoft SQL...


  • Gurgaon, Haryana, India AHEAD Full time

    Job Title: SQL Database AdministratorAHEAD is seeking a highly skilled SQL Database Administrator to join our technical service delivery team. As a key member of our team, you will be responsible for managing and supporting Microsoft SQL database systems for our clients.Key Responsibilities:Provide technical support for client issues through our managed...


  • Gurgaon, Haryana, India Mobifly Full time

    About the Role:We're seeking a highly skilled Senior SQL Server Database Administrator to join our team at Mobifly. As a key member of our database team, you will be responsible for designing, implementing, and maintaining high-performance database systems that support our business-critical applications.Key Responsibilities:Perform ongoing tuning of database...


  • Gurgaon, Haryana, India Sun Life Full time

    Job Title: SQL Server Database AdministratorJob Summary:As a SQL Server Database Administrator at Sun Life, you will be a key member of our Data Management Services team, responsible for the design, implementation, and maintenance of our SQL Server infrastructure. You will be working with a team of experienced professionals to ensure the reliability,...


  • Gurgaon, Haryana, India AHEAD Full time

    AHEAD is seeking a skilled SQL Database Administrator to join our technical service delivery team. As a key member of our team, you will be responsible for managing and supporting Microsoft SQL database systems for our clients.Key ResponsibilitiesProvide technical support for client issues through our managed service deskInstall and configure database...


  • Gurgaon, Haryana, India Spectral Consultants Full time

    Job Title: SQL Database AdministratorAt Spectral Consultants, we are seeking an experienced SQL Database Administrator to join our team. The successful candidate will be responsible for ensuring the smooth operation of our SQL Server infrastructure, including production, development, and staging environments.Key Responsibilities:Provide 24/7 on-call support...


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


  • Gurgaon, Haryana, India AHEAD Full time

    Job SummaryAHEAD is seeking a skilled SQL Server DBA to join our technical service delivery team. As a key member of our team, you will be responsible for managing and supporting Microsoft SQL database systems for our clients. This is a fantastic opportunity to work with a leading provider of digital business platforms and contribute to the success of our...


  • Gurgaon, Haryana, India i2k2 Network Pvt Ltd Full time

    Job Title: MS SQL Database AdministratorJob Summary:We are seeking an experienced MS SQL Database Administrator to join our team at i2k2 Networks Pvt Ltd. As a key member of our IT team, you will be responsible for maintaining database servers, optimizing database performance, and ensuring high availability and scalability.Key Responsibilities:Maintain...


  • Gurgaon, Haryana, India United Lex Full time

    Job Title: Senior Database AdministratorAbout Us: United Lex is a data and professional services company delivering outcomes that create value and competitive advantage for legal and business.Overview: We are seeking an experienced Senior Database Administrator to support our operational management of databases services. The successful candidate will be...


  • Gurgaon, Haryana, India AHEAD Full time

    Job SummaryAHEAD is seeking a skilled SQL Server DBA to join our technical service delivery team. As a key member of our team, you will be responsible for managing and supporting Microsoft SQL database systems for our clients.Key ResponsibilitiesProvide technical support for client issues through our managed service deskInstall and configure database...


  • Gurgaon, Haryana, India Mobifly Full time

    Unlock Your Potential as a SQL Server Database AdministratorAre you a skilled database professional looking for a challenging role that will push your technical expertise to the next level? We're seeking a talented SQL Server Database Administrator to join our team at Mobifly.About the Role:As a SQL Server Database Administrator, you will be responsible for...


  • Gurgaon, Haryana, India i2k2 Network Pvt Ltd Full time

    Job Title: MS SQL Database AdministratorJob Summary:We are seeking an experienced MS SQL Database Administrator to join our team at i2k2 Networks Pvt Ltd. As a key member of our IT team, you will be responsible for maintaining database servers, optimizing database performance, and ensuring high availability and scalability.Key Responsibilities:Maintain...


  • Gurgaon, Haryana, India Guardian Life Full time

    Job Title: SQL Server Database AdministratorJob Summary:We are seeking a highly skilled SQL Server Database Administrator to join our team at Guardian Life. The successful candidate will be responsible for designing, implementing, and maintaining large and complex database environments.Key Responsibilities:Design and implement database solutions that meet...


  • Gurgaon, Haryana, India AHEAD Full time

    AHEAD is a leading provider of digital transformation solutions. We are seeking a highly skilled SQL Database Administrator to join our technical service delivery team. As a key member of our team, you will be responsible for managing and supporting Microsoft SQL database systems for our clients.Key Responsibilities:Provide technical support for client...


  • Gurgaon, Haryana, India Sun Life Full time

    Job Summary We are seeking an experienced Database Administrator to join our team at Sun Life. The successful candidate will be responsible for the administration and maintenance of our SQL Server databases, ensuring high availability and performance. Key Responsibilities: Administer and maintain SQL Server databases Ensure high availability and...