SQL Server Dba
2 months ago
**Date Opened**:Aug 1, 2023
**Location**: IN
**Company**:Allstate Insurance Company
IT Database Administration work includes designing, configuring, and managing databases to ensure the integrity, security and accessibility of the organization's data including: Defining standards for physical data storage, maintenance, access and security administration. Performing backup and recovery using Database Management Systems. Configuring database parameters and defining data repository requirements, data dictionaries, and warehousing requirements. Designing and implementing approaches to improve database performance, capacity, and scalability.
**Responsibilities**:
1. Database Design and Configuration - 35%Designs, configures, and manages databases of broad scope and complexity to ensure the integrity, security, and accessibility of the organization's data. Maintains and updates complex data schemas consisting of shared tables, indexes, database-resident program units, and other logical structures.
Configures and defines data repository requirements, data dictionaries, and warehousing requirements.
2. Performance and Troubleshooting - 45%
Minimizes database downtime and managing parameters to provide fast query responses; audits and monitors attempted transactions and tracks transaction logs to prevent errors and disruptions.
Analyzes, resolves, and corrects complex or persistent issues with database connectivity and functionality.
Performs tests and evaluations regularly to ensure data security, privacy, and integrity.
Monitors the user authentication process and administers security parameters (e.g. user names, passwords, local and external authentication, etc.); identifies data authenticity and security improvements.
Conducts regular checks, data updates, and tunes database instances to optimize performance and enhance capacity and scalability.
Conducts backup and recovery to ensure vital information can be retrieved in case of accidental loss or security breach.
Provides proactive and reactive data management support and training to users.
3. Practice Maturation - 20%
Defines standards for physical data storage, maintenance, access, and security administration.
Documents and enforces database administration policies, procedures, and standards.
Coaches, reviews, and delegates work to less experienced team members.
Requires 8+ years of related experience as a database administrator.
Experience with relational database development and management and related software.
Programming and scripting languages (e.g. SQL, Oracle, SQL Server).
Data backup, recovery, security, and integrity principles and best practices.
Application programming interfaces (APIs) and their functions.
Systems Development Life Cycle (SDLC) and Agile methodology and best practices.
Incident management best practices to respond to issues and incidents.
End-to-end project coordination and collaboration.
Database administration case tools (frontend/backend) and third party tools.
Tools used to generate reports.
Trouble ticketing tools.
Interpersonal, oral, and written communication skills.
Analytical, critical thinking, and problem-solving skills.
Project coordination, organizational, prioritization, and time management skills with attention to detail.
**Primary Skills**:
SQL Database Adminsitrator
LI-DP1
**Experience**:
8-10 Yrs
**Shift Timing**:
1PM to 9.30 PM IST
Weekend Support on business need
-
SQL Server Dba
3 weeks ago
India Bloom Consulting Services Full time**SQL Server DBA ( Job ID : 000001013 )**: NA Experience **6 - 6 years** Offered Salary Notice Period **Not Disclosed** **SQL Server DBA**Responsibilities** - Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. - Configure and maintain database servers and processes,...
-
SQL Server Dba
3 weeks ago
India Bloom Consulting Services Full timeNA Experience **6 - 6 years** Offered Salary Notice Period **Not Disclosed** **SQL Server DBA** **Responsibilities** - Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. - Configure and maintain database servers and processes, including monitoring of system health and...
-
SQL Server Dba
6 days ago
India Bloom Consulting Services Full timeNAExperience- 6 yearsOffered SalaryNotice PeriodNot DisclosedSQL Server DBAResponsibilities Manage SQL Server databases through multiple product lifecycle environments, from development to missioncritical production systems. Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of...
-
Expert Infrastructure
6 days ago
india IT Advanced Consulting SA Full timeJob Description En tant qu'Expert en Infrastructure spécialisé Administrateur DBA Oracle et SQL Server , vous interviendrez en renfort de l'équipe DBA sur les pôles Oracle et SQL Server (Administration et Sécurité).- DBA Oracle : Expert en Administration de bases Oracle (contribution à l'administration, au bon fonctionnement et à la disponibilité du...
-
SQL Dba
3 weeks ago
India Bloom Consulting Services Full time**SQL DBA ( Job ID : 000000538 )**: NA Experience **7 - 10 years** Offered Salary Notice Period **Not Disclosed** - Position Purpose- Essential Functions- Configure and maintain database servers and processes, including monitoring of system health and performance to ensure high level of performance of critical Microsoft SQL Server RDBMS systems and...
-
sql dba
6 days ago
India Novalink Solutions LLC Full timeJob Title: SQL Server Database AdministratorCompany: This established company is seeking a skilled SQL Server Database Administrator to join their dynamic team.Sample Tasks:- Support SQL server applications- Supporting SQL Server components, including SSIS and SSRS- Maintaining and troubleshooting ETL processes- Performing SQL backups and Disaster Recovery-...
-
Microsoft SQL Server Operations DBA
2 months ago
india Rockstar India Full timeAt Rockstar Games, we create world-class entertainment experiences.A career at Rockstar Games is about being part of a team working on some of the most creatively rewarding and ambitious projects to be found in any entertainment medium. You would be welcomed to a dedicated and inclusive environment where you can learn and collaborate with some of the most...
-
SQL DBA Developer
4 days ago
india Softtek Full timeAbout Softtek Requirements ·Knowledge of installing, configuring, and upgrading SQL Server databases. ·Familiar with the SQL Server editions and their specific features. ·Knowledge with Transact-SQL for writing queries and scripts. ·Ability to analyze and optimize SQL queries, indexes, and stored procedures. ·Experience with...
-
Senior SQL DBA
7 days ago
india Link Group Full timeOverview The SQL DBA will provide full lifecycle production assistance to development, infrastructure, testing and ultimately production. The SQL DBA will be managing and maintaining the SQL Server database environments across IaaS and PaaS platforms, ensure development and testing database environments are kept up to date, work on performance tuning and...
-
SQL Server Dba
4 weeks ago
India NCR Full timeAbout NCR NCR Corporation (NYSE: NCR) is a leader in transforming, connecting and running technology platforms for self-directed banking, stores and restaurants. NCR is headquartered in Atlanta, Ga., with 38,000 employees globally. NCR is a trademark of NCR Corporation in the United States and other countries. Essential **Responsibilities**: - Perform...
-
Database Analyst
2 weeks ago
india Hitya Global Full timeJob Description and Responsibilities : - Manage SQL Server or Mysql Server - 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...
-
SQL Dba
6 days ago
India Bloom Consulting Services Full timeNAExperience- 10 yearsOffered SalaryNotice PeriodNot DisclosedPosition PurposeEssential Functions Configure and maintain database servers and processes, including monitoring of system health and performance to ensure high level of performance of critical Microsoft SQL Server RDBMS systems and ensure the high availability of our products. Experience of...
-
Ms SQL Dba
2 months ago
India CIEL HR Full timeJob Summary Role - MS SQL DBA Exp - 5- 8 years NP - immediate **JD**: Hands on experience on Log Shipping/Mirroring/Replication 2. Experience with backups, restores and recovery models & performance tuning 3. Hands on experience on configuring Always on and troubleshooting issues related to same 4. Hands on experience on Installation/configuration on...
-
MSSQL DBA with Azure
2 months ago
india Coforge Full timeRole: MSSQL DataBase Administrator with Azure Location: Greater Noida Work Type: WFO (5 Days a Week) Notice Period: 0-15 Days Only Primary: Microsoft SQL Server - Experience in Administrating MSSQL Database (On-premise & Azure Cloud), Troubleshooting, installation, and configuration of high availability and disaster recovery Secondary - MySQL (On-premises &...
-
Senior DBA
1 month ago
india Marlabs LLC Full timeDescription: Organization Marlabs is a digital innovation company helping enterprises innovate & capture digital opportunities to enable swifter solutions. Our focus is to help each of our clients find and capture their unique opportunities and empower them with digital technologies so that they can run a purposeful business. Visit and know more...
-
Senior DBA
6 days ago
India Marlabs LLC Full timeDescription: Organization Marlabs is a digital innovation company helping enterprises innovate & capture digital opportunities to enable swifter solutions. Our focus is to help each of our clients find and capture their unique opportunities and empower them with digital technologies so that they can run a purposeful business. Visit and know more about us...
-
MS SQL DBA
3 weeks ago
india Navisite Full timeAt Navisite, celebrating our employees and investing in their well-being and development is not just a priority or an initiative - it's woven directly into our company fabric. Our mantra and unofficial corporate hashtag #SoMuchGood is all about recognizing our team's commitment and achievements, both inside and outside the office. It's that theme that has...
-
MS SQL DBA
2 months ago
india Navisite Full timeAt Navisite, celebrating our employees and investing in their well-being and development is not just a priority or an initiative - it's woven directly into our company fabric. Our mantra and unofficial corporate hashtag #SoMuchGood is all about recognizing our team's commitment and achievements, both inside and outside the office. It's that theme that has...
-
SQL Dba
2 weeks ago
India Espire Infolabs Full time**Experience**: - 5-8 years **Location**: - India **Posted On**: - 18-Apr-2024 **Job Code**: - ESP/2024/04021 **Academic Qualifications**: BE/ B. Tech/ MCA **Relevant Experience**: SQL DBA, Replication, Cluster Always on - Perform production support administration tasks including proactive monitoring, troubleshooting, tracing, backup, recovery, and...
-
SQL Server Dba
6 days ago
India Allstate Insurance Company Full timeDate Opened:Aug 1, 2023Location:INCompany:Allstate Insurance CompanyIT Database Administration work includes designing, configuring, and managing databases to ensure the integrity, security and accessibility of the organization's data including: Defining standards for physical data storage, maintenance, access and security administration. Performing backup...
