SQL Database Administration|

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-8yrs

Skills required : Must have experience with SQL 2017.PTO (Performance Tuning & Optimization)

Job Description

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.

Experince 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.

Primary Skills Required

6-8yrs of experience.
• Must have experience with SQL 2017 Always-On Availability Groups.
• Experience on AWS where SQL Database are hosted on AWS.
• PTO (Performance Tuning & Optimization) expert level, including T-SQL refactoring.
• Experience of PTO with batch, stored procedure and ah-hoc workloads.
• Experience with DMVs, Profiler Trace and Extended Events. Experience solving concurrency issues. . Experienc DWFT architectures
• Backup / Restore of Production data to lower environments, including data scrubbing.
• 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.
• Installation and patching of SQL Server, Windows and Security CUs. Familiarity with Windows Events and Registry editing.
• Working familiarity with legacy business continuity solutions : e.g. database mirroring. . Review of DDL, T-SQL for operational, performance and security best practices