Microsoft SQL Server 2019

Teamware Solutions

3 - 5 years

2 - 5 Lacs

Bengaluru Karnataka India

Posted:1 day ago| Platform: Foundit logo

Apply

Skills Required

T-SQL queries cloud-based SQL

Work Mode

On-site

Job Type

Full Time

Job Description

Key Responsibilities:
Database Management:
Administer, configure, and manage
Microsoft SQL Server 2019
environments.
Ensure
high availability
and
disaster recovery
planning, using technologies such as
Always On Availability Groups
,
SQL Server Clustering
, and
Database Mirroring
.
Perform regular database
backups
,
restores
, and
replications
to ensure data integrity and availability.
Manage
SQL Server security
, including
permissions
,
roles
, and
encryption
.
Database Development:
Design, develop, and maintain
SQL Server 2019 databases
and
SQL queries
to support business applications.
Optimize
SQL queries
for performance, ensuring minimal query execution time and optimal resource utilization.
Create and maintain
stored procedures
,
views
,
functions
, and
triggers
for business logic implementation.
Assist in data migration tasks and ensure smooth integration of
SQL Server 2019
with other business systems and applications.
Performance Tuning and Optimization:
Monitor
SQL Server performance
using built-in tools such as
SQL Server Management Studio (SSMS)
,
SQL Profiler
, and
Dynamic Management Views (DMVs)
.
Identify and resolve performance bottlenecks, including
index optimization
,
query tuning
, and
server configurations
.
Implement and manage
indexes
,
statistics
, and
partitioning
to ensure optimal query performance.
Backup and Recovery:
Implement and manage
backup
and
restore
strategies to ensure
data integrity
and
availability
in case of system failures.
Configure and test
disaster recovery
plans, ensuring minimal downtime and data loss.
Ensure
automated backup processes
are in place and validated regularly.
Security and Compliance:
Implement
SQL Server security
best practices, including
role-based access control
,
encryption
, and
auditing
.
Ensure compliance with industry standards and regulatory requirements related to data management and privacy.
Maintain database
audit trails
, ensuring all changes and accesses are properly logged and monitored.
Troubleshooting and Support:
Provide
technical support
and troubleshooting for
SQL Server 2019
issues, ensuring the stability and performance of the databases.
Investigate and resolve database-related issues, including
performance issues
,
corruption
, and
data inconsistencies
.
Collaborate with development and IT teams to resolve application issues related to the database.
Documentation and Reporting:
Maintain accurate and up-to-date documentation on database configurations, maintenance procedures, and recovery plans.
Generate reports on database performance, resource utilization, and potential risks.
Assist in
capacity planning
and forecasting resource needs for the databases based on growth projections.
Collaboration and Stakeholder Engagement:
Collaborate with cross-functional teams, including
development
,
operations
, and
business analysts
, to gather requirements and deliver database solutions.
Provide support for
data migration
,
ETL processes
, and integrations with other systems.
Train and mentor junior database administrators and developers on best practices for database management and development.
Required Qualifications:
Bachelor's degree
in
Computer Science
,
Information Technology
,
Software Engineering
, or a related field.
3-5 years
of experience in
Microsoft SQL Server
, with strong experience in
SQL Server 2019
.
Solid understanding of
database administration
, including
backup/recovery
,
performance tuning
,
high availability
, and
disaster recovery
.
Proficiency in
SQL development
, including writing
T-SQL queries
,
stored procedures
,
functions
,
triggers
, and
views
.
Experience with
SQL Server Management Studio (SSMS)
,
SQL Profiler
, and other SQL Server administration tools.
Strong understanding of
security
,
permissions
, and
encryption
practices within
SQL Server
.
Knowledge of
indexing
strategies,
query optimization
, and
database partitioning
.
Experience with
PowerShell scripting
for database automation and management is a plus.
Familiarity with
cloud-based SQL environments
(e.g.,
Azure SQL Database
) is a plus.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.