MS Azure DB Adminstrator & Developer

Position ID: MZAD-TC-PR-2
Title:MS Azure DB Adminstrator & Developer
Reporting to:  Director Product & Research
Function: Technology
No of openings: 1

Role Context:

Ennoventure’s Product tech stack includes Azure/MS SQL. A database administrator & developer is someone
who will bring the industry best practices to the db design, development and maintenance to the product team.

Functional Context:

The team is responsible for the product development/ customer delivery, continuous improvement, and strategic development of operational requirements, processes, and technology, to deliver key service outcomes for customers

Role Expectations:

» Administer, maintain, develop, and implement policies and procedures for ensuring the security and integrity of the
company’s databases.
» MSSQL Azure Portal support
» Resolve database performance capacity issues, replication, and other distributed data issues.
» Assist in analysing proposed systems and recommending improvements to existing systems.
» Participate in releasing database changes, related to application deployments.
» Produce and maintain complete database systems documentation.
» Design, implement and maintain databases to support the goals and strategies of the division.
» Support database development and operations across divisions.
» Work with the clients and the applications manager to solve business problems with little or no direct supervision.
» Excellent knowledge of database backup, recovery, security, integrity, and SQL
» SQL Server Security: User security best practices; Database Encryption; Audit; Change management.
» Database Availability: Understand backup and Recovery; Replication; Always On; DB Maintenance; DB Tuning
Optimization; Troubleshooting.
» Should be flexible to support during Holidays/Weekends and Off workhours
» Need to be On-call support during any Prod emergency events – Deployments, Fixes and DB Availability
» SQL Server Management: Windows OS; Monitoring; Power shell; Storage; VM; Memory; Patching; Job Management;
Extended Events
» Other DBA Tasks: SSIS; SSRS data imports and extracts
» Report generation

Performance Indicators

» SLA Compliance of the product
» Turn Around Time

Minimum Entry Qualifications & Additional Certifications

Bachelor’s degree

Experience:

2-4 Years’ Experience in Azure platform, TSQL, SQL Server Security, Backup and Recovery, Replication, Stored Procedure, CDC, Memory Tuning, Triggers, DB Tuning, SQL Server Management

Knowledge Areas:
Essential

Good Knowledge In T Sql Scripting Able To Handle All Sql Database Dba Related Daily Maintenance Tasks Good Exposure In Database And Sql Performance Tuning Experience In Database Sql Performance Tuning

Troubleshooting And Resolving Database Issues Conforming To Client Compliances And Expectations

Skills:

DB Design, implantation and Trouble shooting skills.

Architecting new DB solutions.