Knowledge of Failover clustering, SQL server AlwaysOn Groups, SQL server mirroring, SAN replication, and other high availability technologies
Ensure all database servers are backed up in a way that meets the businesss Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business Recovery Time Objectives (RTO)
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
Configure SQL Server monitoring utilities to minimize false alarms.
As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies.
Install and configure new SQL Servers
Deploy database change scripts provided by third party vendors.
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index / query changes.
Document the companys database environment.
Monitoring of database performance and stability
Establish the baseline for system performance, recognize deviation, and suggest and implement improvements to slow running queries
Develop and document technical processes and procedures as needed.
Interact, meet, discuss, and troubleshoot issues with the engineering team.
Report project status as required for all recurring and non-recurring efforts.
Work under minimal direction and independently determine and develop approach to solutions.
Administering SQL Server, the backup, integration, restore, reporting and maintenance processes.
Diagnose and analyze using third-party diagnostic tools.
SQL Server security configuration and management
Work with the team on migrating older versions of SQL Server to new, if required.
Administer and maintain Azure SQL managed instance.
Development on Power BI, if required.
Create Business Requirement document, KPI dimensions matrix, source to target mapping documents.
MSSQL DBA Job Requirements :
Experience on Microsoft SQL Server 2008,2012, 2014,2016,2017,2019,2022.
Production Support Activities (Installation, Upgradation and Troubleshooting).
T-SQL Scripts for Administration and Monitoring tasks.
Microsoft Clustering services (MSCS) knowledge- Install / Configure / support.
Relevant knowledge of the operating system (2008, 2012,2016,2019) as far as MS-SQL databases is concerned.
High Availability (Log shipping, Replication and Mirroring) Always ON
User creation & maintenance, database log space monitoring and maintenance.
Good knowledge on Always on and high availability
Strong fundamentals of SQL.
Strong in SQL Architecture, Backup & Restore process.
Configuring CDC replication.
Configuring TDE in always on servers.
Knowledge on ITIL process.
Good communication, should be able to clarify issues with customer
(ref : hirist.tech)
Create a job alert for this search
Database Administrator • Bhubaneshwar
Related jobs
Promoted
System Administrator (Windows, AWS, SQL)
stackwaybhubaneswar, orissa, in
System Administrator | 3+ Years Experience | Windows Server, AWS, SQL.At stackway, we believe software development is best done in small, highly functional teams with good collaboration, cooperatio...Show moreLast updated: 12 days ago
Promoted
snowflake Cloud Database Administrator
Leading automobile GCCbhubaneswar, orissa, in
Cloud Platform Expertise : Familiarity with leading cloud platforms such as Amazon Web Services (AWS), Microsoft Azure, and Snowflake is essential.
Understanding their database offerings, such as AWS...Show moreLast updated: 30+ days ago
Promoted
MONGO DB Administrator
IGT Solutionsbhubaneswar, orissa, in
MongoDB Administrator with Java Exposure.Immediate to 30 days preferred.MongoDB databases in a distributed environment.The ideal candidate should possess strong database administration expertise, s...Show moreLast updated: 11 days ago
Promoted
PostgreSQL Database Administrator
DigitalRecruiter APPbhubaneswar, India
PostgreSQL Database Administrators (DBAs).The role involves providing BAU support, performance tuning, and maintenance for PostgreSQL environments while ensuring database availability, security, an...Show moreLast updated: 5 days ago
Promoted
OBIEE Administrator
KPI Partnersbhubaneswar, orissa, in
The ideal candidate will be responsible for the management and maintenance of the Oracle Analytics Server, ensuring optimal performance and availability.
This role will involve working closely with ...Show moreLast updated: 12 days ago
Promoted
OAS Administrator
KPI Partnersbhubaneswar, orissa, in
The ideal candidate will be responsible for the management and maintenance of the Oracle Analytics Server, ensuring optimal performance and availability.
This role will involve working closely with ...Show moreLast updated: 12 days ago
Promoted
Hadoop Administrator - Big Data
Tehno RightBhubaneshwar
Job Role : Hadoop Administrator (Role open for multiple locations) - WFH and WFO Job description : What is your Role ? - You will mana...Show moreLast updated: 30+ days ago
Promoted
Database Administrator
BizTech Staffingbhubaneswar, orissa, in
We are seeking an experienced Database Administrator (DBA) with expertise in managing and migrating data across multiple database platforms, including Amazon Redshift, MongoDB, SQL Server, and Orac...Show moreLast updated: 12 days ago
Promoted
Database Administrator
Amicon Hub Servicesbhubaneswar, orissa, in
Role : Databricks Administrator (Client : Patch).Strong hands-on experience in Databricks workspace setup & cluster management.
User & group administration via Azure AD / IAM / SCIM.Cluster configurat...Show moreLast updated: 10 days ago
Promoted
iSeries Administrator
COX-LITTLE & COMPANYbhubaneswar, orissa, in
Position : iSeries Administrator.The iSeries Administrator is responsible for bridging the gap between the US team and offshore team to provide round-the-clock support and administration of the worl...Show moreLast updated: 10 days ago
Promoted
Oracle Database Administrator
Core Minds Tech SOlutionsCuttack
Oracle Database Administrator : Responsibilities : Direct Responsibilities : 1.Responsible for installation, configuration and managin...Show moreLast updated: 30+ days ago
Promoted
Database Administrator - SQL Server / Oracle DB
Core Minds Tech SOlutionsBhubaneshwar
Roles & Responsibilities : - Manage and optimize Microsoft SQL Server and Oracle databases across on-premises data centers and cloud environments.Perform advanced database ...Show moreLast updated: 30+ days ago
Promoted
Database Reliability Engineer (DRE)
Nebula Tech SolutionsBhubaneswar, Odisha, India
We’re looking for a Database Reliability Engineer (DRE) to join our growing engineering team.In this role, you’ll work on building and operating scalable, cloud-native data platforms that power...Show moreLast updated: 22 days ago
Promoted
Senior Database Administrator
CitNOW Groupbhubaneswar, orissa, in
Founded in 2008, CitNOW is an innovative, enterprise-level software product suite that allows automotive dealerships globally to sell more vehicles and parts more profitably.CitNOW’s app-based plat...Show moreLast updated: 30+ days ago
Promoted
Database Developer
NIRMALYABhubaneswar, Odisha, India
Nirmalya is a leading provider of advanced cloud-based systems including Enterprise Resource Planning, Supply Chain Management, Smart Warehouse Management, and more.
Headquartered in Bhubaneswar, In...Show moreLast updated: 27 days ago
Promoted
Database Expert TimescaleDB
Block Liquiditybhubaneswar, orissa, in
We are a fast-growing company building advanced analytics platforms and dashboards for traders, builders, analysts, quants and researchers.
Our mission is to make complex data accessible through cle...Show moreLast updated: 7 days ago
Promoted
NonStop Database Admin
Coffeee.iobhubaneswar, orissa, in
Job Title : -NonStop Database Admin.Perform NonStop Database Admin tasks that may include, but not limited to support activities such.
Database Product Installation, Maintenance, Planning, Monitoring,...Show moreLast updated: 9 days ago
Promoted
Senior AWS Administrator
CYAN360bhubaneswar, India
Job title : AWS Infrastructure Engineer.ETL / ELT processes using AWS services such as AWS Glue, AWS Lambda and AWS Step Functions.
Ensure data quality, security, and compliance with industry best prac...Show moreLast updated: 3 days ago