SQL Server Production DBA

Overview

We are seeking an experienced

SQL Server Production DBA

with Postgres SQL knowledge who will be responsible for ensuring the

availability, security, and performance

of our databases. This role involves handling production DBA responsibilities, disaster recovery (DR), data migration, SSIS, SSRS, and import / export processes. This role will work with other team members to ensure 100% uptime, plan future capacity requirements, maintain security, and apply updates. As a DBA, you will solve exciting technical challenges by analyzing, troubleshooting, and designing vital services, platforms, and infrastructure while always thinking about reliability, scalability, resilience, security, and performance. Responsibilities

Manage

SQL Server production environments , ensuring high availability and security. Serve as SME (subject matter expert) for Microsoft SQL Server, PostgreSQL and other database technologies. Implement and maintain

backup and disaster recovery (DR)

strategies. Perform

database migrations, upgrades, and patching . Optimize

query performance, indexing, and database tuning . Develop and maintain

SSIS packages for ETL

operations and data import / export. Generate and maintain reports using

SSRS . Troubleshoot and resolve

database performance, connectivity, and security issues . Implement

replication, mirroring, and clustering

for high availability. Work with development teams to support application and database changes. Perform

capacity planning, monitoring, and proactive maintenance . Work closely with Application Developers to design, test, implement, perfect and maintain efficient transactional and analytical data models. Participates in SQL codereviews for the application teams to enforce SQL coding standards. Lead / engage in tuning, upgrade, and configuration projects to enhance performance and ensure stability. Supply Ad Hoc data reporting and data pulls for Analytics teams Perform various ad-hoc data loading and data manipulation tasks. Help

support architecture and process flow diagrams for data systems Participates in the evaluation, design, implementation, maintenance, support, and enhancement of sophisticated database systems and technologies. Setup Test, Dev, Staging and Production Environments. (Installing SQL Server) Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent) From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery) Requirements

7-9 years

of experience as a SQL Server DBA in a

production environment . Expertise in

SQL Server 2016 and above . Strong experience with

SSIS, SSRS, and data import / export processes . Knowledge of

database security, backup, and disaster recovery (DR) strategies . Experience with

high availability solutions (clustering, mirroring, log shipping, Always On Availability Groups) . Strong knowledge of

T-SQL, query optimization, and performance tuning . Experience with database migrations and upgrades. Familiarity with

Windows Server administration and PowerShell

scripting is a plus. Familiarity with

Data lake

is a plus. Excellent troubleshooting and problem-solving skills. Strong organizational and communication skills and coordination skills and able to work efficiently under pressure. Experience with MS Azure and MS Azure managed instance databases. Documented hands-on expertise managing high-volume instances of MS SQL setups featuring high availability. Experience with CI / CD in cloud environments and container technology, Docker and Kubernetes, Docker Swarm. Experience in telecommunication and networking environment is an asset, Postgres SQL management.

#J-18808-Ljbffr