SQL Server Dba - Remote, India - Ambc Technologies

Ambc Technologies

Verified Company

Remote, India

2 weeks ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

Position:
SQL DBA

Exp: 7 to 10 years

Work Location:
Remote
In this case we need someone with 7-10 years of experience as a DBA to perform the following.

Understanding of lowlevel SQL permissions based on SQL Roles (for example: schema level permission assigned to roles)
T-SQL skills (writing stored procedures, querying system tables, code review for other members)
Azure Data Factory or Azure Synapse Analytics experience in designing pipelines (knowledge of Copy Data activity)
PowerShell scripting skills (general, Azure modules, error handling)
Capacity Planning: The DBA performs capacity planning to estimate future resource requirements based on data growth and user demands. They monitor resource utilization, analyse trends, and scale the Synapse environment by adding or removing resources as needed.
IAM in SQL Pool (Synapse) extended to Security and

Access Control:

The DBA ensures the security of the Synapse Data Warehouse by implementing appropriate access controls, user roles, and permissions.

They manage authentication mechanisms, encryption, and data privacy to protect sensitive information stored in the data warehouse.
- performance improvements extended to

Database Design:

The DBA collaborates with data architects and developers to design the database schema and data models for optimal performance and scalability.

They ensure that the data warehouse structure aligns with the organization's requirements and industry best practices.

Experience with GitHub & GitHub actions/workflows.
Compliance: Enable and manage database auditing capabilities
Data Integrity: Ensure entity integrity and referential integrity and manage constraints.
SQL Package (dacpac) typical for SQL Developers but many DBAs know that
SQL permissions and troubleshooting them typical DBA work.

Salary:
₹1,500, ₹1,600,000.00 per year

Schedule: