axcess.io | Full time
About us
We offer Cloud Managed Services and DevOps Automation to improve the agility and velocity of businesses.
We are a cloud-native services company with clients in multiple geographies and industries. We specialize in cloud transformation, DevOps automation, managed services and cloud-native application development. With offices in USA and India, we empower organizations to transform and secure their IT infrastructure, scale up their operations, and manage customer workloads from ISO 27000-certified Global Network Operations Centers (GNOC).
Job Description
The SQL Server Data Engineer will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. The data warehouse supports an enterprise application suite of program management tools. Must be capable of working independently and collaboratively.
Responsibilities:
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
Troubleshoot issues related to memory-optimized tables in MS SQL Server 2019 - Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Assist developers with complex query tuning and schema refinement.
Requirements
The ideal candidates must have:
- Minimum 5 years of relevant experience in data modelling, database & datawarehouse management, performance tuning on Microsoft SQl server Databases
- 3+ years of experience with programming and database scripting; and
experience with clustered configurations, redundancy, backup and recovery - Good knowledge of SSIS development, T-SQL, Views, Stored Procedures, Functions and Triggers.
- Experience in AWS and Azure Cloud will be an added advantage
Benefits
As per market standards
Job Information
Job Title
SQL Server Data Engineers
Industry
IT Services
Work Experience
5+ years
City
Bengaluru
State/Province
Karnataka
Country
India
Zip/Postal Code
560102
