Sr Database Administrator

2 weeks ago

Bengaluru, India Consilio LLC Full time

Overview

About the company

Consilio stands as the global leader in eDiscovery, document review, flexible legal talent, and legal advisory & transformation consulting services. With its Consilio Complete suite of capabilities, the company empowers multinational law firms and corporations using innovative software, cost-effective managed services, and deep legal and regulatory industry expertise.

Job Summary:

We are seeking a highly skilled and experienced MSSQL Senior Database Administrator (DBA) to manage, maintain, and optimize our organization's Microsoft SQL Server databases. The ideal candidate will ensure the performance, availability, and security of critical database systems, supporting various applications and business operations 24/7/365. This role requires a proactive individual with an understanding of database architecture, best practices, and troubleshooting. This individual should have a deep understanding of MSSQL.

Responsibilities

Database Installation & Configuration: Install, configure, and upgrade SQL Server instances (all versions) across various environments (Dev, QA, UAT, Prod). Performance Tuning & Optimization: Monitor database performance, identify bottlenecks, and implement solutions for query optimization, indexing strategies, and database configuration to ensure optimal performance. Backup & Recovery: Design, implement, and maintain robust backup and recovery strategies to ensure data integrity and availability, including disaster recovery planning and execution. Security Management: Manage database security, including user permissions, roles, authentication, and encryption, adhering to security policies and compliance requirements. High Availability & Disaster Recovery: Implement and manage high availability solutions such as AlwaysOn Availability Groups. Troubleshooting & Support: Provide expert-level troubleshooting for database-related issues, including connectivity, performance, and data corruption, offering timely resolution. Monitoring & Alerting: Implement and maintain database monitoring tools and alerts to proactively identify and address potential issues. Capacity Planning: Monitor database growth and resource utilization, performing capacity planning to ensure scalability and future needs are met. Data Integrity & Corruption Checks: Implement and regularly perform data integrity checks to detect and resolve database corruption, ensuring data consistency and reliability. Standard Operating Procedures (SOPs): Develop, maintain, and regularly update Standard Operating Procedures (SOPs) for all database administration tasks and processes.

Additional Responsibilities

 Collaborate with development teams to optimize database designs and SQL queries for new applications and features.  Participate in on-call rotation for after-hours and holiday support of critical production systems.  Stay current with the latest SQL Server technologies, features, and industry best practices.  Assist in the evaluation and implementation of new database technologies and tools.  Provide mentorship and guidance to junior team members or developers on database best practices.  Develop, refine, and maintain SQL scripts for automation of routine DBA tasks.  Participate in auditing and compliance activities related to data management.  Support multiple concurrent projects, managing priorities and deadlines effectively.  Collaborate with other teams during incident calls to diagnose and resolve database-related issues.  Manage and prioritize database-related tickets through a formal ticketing system, ensuring timely resolution.

Bonus Skills:

Experience with SSAS, SSIS, and SSRS Experience with transactional replication Experience with Powershell Experience with version control (ie: Github)

Qualifications

Minimum Education Requirements:

Bachelor degree required or equivalent experience

Minimum Experience Requirements:

Working experience with MS Office tools (such as Outlook, MS Teams, Excel, PowerPoint, etc) 7+ years of experience as a SQL Server DBA or similar role 7+ years of experience with Performance Tuning and Optimization (PTO) 7+ years of TSQL experience

Other Requirements:

MCTS, MCITP, and/or MVP certifications a plus MS SQL Server certifications and/or experience writing advanced T-SQL queries Experience working with/supporting other eDiscovery applications Sense of ownership and pride in your performance and its impact on company’s success Critical thinker and problem-solving skills Team player Great time-management skills Great interpersonal and communication skills

Consilio’s True North Values

Excellence -  We strive to make every client our advocate

Passion -  We DO because we CARE.

Collaboration -  We win together through teamwork and communication.

Agility -  We flex, adapt and embrace change.

People -  We value, respect and invest in our teammates.

Vision -  We create clarity of purpose and a clear path forward.

 Consilio, LLC is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.

  • Sr Specialist Database Administration

    4 weeks ago

    Bengaluru, India AT&T Full time

    Job Description: Sr Specialist Database Administration - Snowflake This position is for Database administration of Snowflake databases and Apache Iceberg for Network service assurance applications. Major responsibilities include- Snowflake Administration: Database maintenance and optimization Snowflake resource tuning Snowflake custom script development...

  • Sr Specialist Database Administration

    2 days ago

    Bengaluru, Karnataka, India AT&T Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Description:Sr Specialist Database Administration - SnowflakeThis position is for Database administration of Snowflake databases and Apache Iceberg for Network service assurance applications.Major responsibilities include-Snowflake Administration:Database maintenance and optimizationSnowflake resource tuningSnowflake custom script developmentSnowflake...

  • Sr Specialist Database Administration

    7 days ago

    Bengaluru, Karnataka, India AT&T Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Description: Sr Specialist Database Administration - Snowflake This position is for Database administration of Snowflake databases and Apache Iceberg for Network service assurance applications. Major responsibilities include- Snowflake Administration:Database maintenance and optimizationSnowflake resource tuning Snowflake custom script...

  • Sr Specialist Database Administration

    4 weeks ago

    Bengaluru, India AT&T Full time

    Job Description Job Description: Sr Specialist Database Administration - Snowflake This position is for Database administration of Snowflake databases and Apache Iceberg for Network service assurance applications. Major responsibilities include- Snowflake Administration: - Database maintenance and optimization - Snowflake resource tuning - Snowflake...

  • Oracle Database Administrator

    1 week ago

    Bengaluru, India MNR Solutions Private Limited Full time

    Position: - Oracle Data Base Administration Experience: - 4yrs to 8yrs Location: - Bangalore - Architect HA and DR Solutions for PAAS services like Exadata, Autonomous Databases (ATP,ADW), RAC & Data guard) - Installation and upgrade of Oracle and RAC on 10g/11g/12c/18c/19c version under Linux/AIX platforms - Must have oracle ASM/ACFS implementation...

  • Senior Database Administrator

    2 weeks ago

    Bengaluru, India symplr Full time

    Overview Objective: The Senior Database Administrator will join our team and play a leading role in defining, developing, and documenting the structure and security of production services and databases for our healthcare solutions. Description: As a Sr. Database Administrator, you will be responsible for monitoring and alerting...

  • Senior Database Administrator

    2 weeks ago

    Bengaluru, India symplr Full time

    Overview Objective: The Senior Database Administrator will join our team and play a leading role in defining, developing, and documenting the structure and security of production services and databases for our healthcare solutions. Description: As a Sr. Database Administrator, you will be responsible for monitoring and alerting for...

  • Sr Database Administrator

    2 weeks ago

    Bengaluru, India Consilio LLC Full time

    Overview About the company Consilio stands as the global leader in eDiscovery, document review, flexible legal talent, and legal advisory & transformation consulting services. With its Consilio Complete suite of capabilities, the company empowers multinational law firms and corporations using innovative software, cost-effective managed services, and deep...

  • Sr Database Administrator

    7 days ago

    Bengaluru, Karnataka, India Consilio LLC Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    OverviewAbout the company Consilio stands as the global leader in eDiscovery, document review, flexible legal talent, and legal advisory & transformation consulting services. With its Consilio Complete suite of capabilities, the company empowers multinational law firms and corporations using innovative software, cost-effective managed services, and deep...

  • Database Administrator

    1 week ago

    Bengaluru, India EFI Full time

    EFI is looking for a Database Administrator to join our IT Team at our Bangalore office. ***Key Responsibilities** Provide database administration support for different types of databases such as MySQL and NoSQL DB. Providing 24/7 support for critical production databases Database Administration (Installing, administrating, implementing, and...