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

#J-18808-Ljbffr