SQL Database Administration

Overview

About MOURI Tech :

MOURI Tech is a professional global enterprise solution provider helping its customers transform into intelligent enterprises. It offers comprehensive solutions and world-leading consulting and delivery experience to many fortune 500 companies across the globe. As a lead innovator of NextGen AI solutions, it enables its customers to achieve new business performance thresholds. MOURI Tech helps its clients to be resilient and successful in the long run through digital transformation.

Operating across five continents, MOURI Tech continually engages with employees, clients, partners, and community organizations worldwide. At MOURI Tech, we have transitioned into AI-based digital mode of learning to ensure our associates are steadfast learners and can sustain themselves as resilient professionals. We shape our employees into certified professionals and upskill their career journeys throughout their associations with us. MOURI Tech provides a transparent, healthy, and favorable work environment with teams and business units seamlessly connected across the organization.

Job role :   SQL Database Administration

Experience level : 6-8 years

SQL DBA duties and responsibilities

• Must have experience with SQL 2017.PTO (Performance Tuning & Optimization) expert level, including T-SQL refactoring.
• Experience of PTO with batch, stored procedure, and ah-hoc workloads.
• Experience DWFT architectures. Experience with DMVs, Profiler Trace and Extended Events.
• Experience solving concurrency issues.
• Backup / Restore of Production data to lower environments, including data scrubbing.
• SQL Security : managing SQL Logins and AD groups across the AG.
• Knowledge of managing column-level encryption across PROD, STAG and QA environments.
• Knowledge of gMSA and TLS. Using Database Triggers to manage custom security groups / database roles.
• Familiarity with Ola Hallengren scripting.
• Familiarity with SSIS Integration Services Catalog deployments / Jobs on an Availability Group.
• SQL Patching and job failures fix and script execution DML statements in prod
• Documentation changes, ticket management, daily task reporting

Primary Skills Required :

Secondary Skills Required