Cloud Analyst - AzureSQL DBA
Location
Noida | India
Job description
Description
Noventiq is hiring! Noventiq's story is one of change. We grew, expanded, and adapted, learning more at each step. Now effecting change is at the heart of everything we do. And that doesn't just apply to our customers, it's how we feel about everyone who works with us.
Noventiq (the brand name of Cyprus-registered Softline Holding plc) is a leading global solutions and services provider in digital transformation and cybersecurity, headquartered and listed in London. The company enables, facilitates and accelerates digital transformation for its customers' businesses, connecting 75,000+ organizations from all sectors with hundreds of best-in-class IT vendors, alongside its own services and solutions.
With a turnover of US$ 1.1 billion in the fiscal year of 2021, Noventiq is currently one of the fastest growing companies in the sector. Noventiq's growth is underpinned by its three-dimensional strategy to expand its geography, portfolio and sales channels. The strategy is supported by Noventiq's active approach to M&As, enabling the company to take advantage of the ongoing consolidation in the industry. Noventiq's 3900 employees work in almost 60 countries throughout Asia, Latin America, Eastern Europe and Africa—markets with significant growth potential.
What You'll Do - Collaborate with stakeholders to understand business requirements and translate them into effective solutions, utilizing theoretical knowledge of both SQL Server and Azure SQL technologies.
- Aware about migration approach of on-premises SQL Server databases to Azure SQL with minimal
downtime.
- Understand backup and restore procedures tailored for both SQL Server and Azure SQL environments, considering Azure Backup services and native SQL Server backup capabilities.
- Administer SQL Server databases, including provisioning, configuration, and performance tuning to
meet performance and scalability requirements.
- Manage and optimize SQL Server instances, implementing approach and functionality of high
availability solutions such as SQL Server Always On configurations and failover clustering.
- Configure and manage Azure SQL Database instances, ensuring proper provisioning, configuration, and performance tuning for optimal resource utilization.
- Configure and manage Azure SQL Managed Instances, applying expertise in features like crossdatabase querying and support for SQL Agent jobs.
- Utilize Azure SQL Elastic Pools to optimize resource utilization and cost-effectiveness for managing multiple databases with varying workloads.
- Understanding about disaster recovery strategies specific to both SQL Server and Azure SQL, including failover planning and geo-replication options, to ensure high availability and data protection.
- Collaborate closely with infrastructure and networking teams to ensure secure and reliable connectivity for both SQL Server and Azure SQL services.
- Monitor and optimize both SQL Server and Azure SQL Database performance, utilizing tools like SQL Server Management Studio, Azure Monitor, and Query Performance Insights to identify and address performance bottlenecks.
- Implement robust security measures for both SQL Server and Azure SQL databases, including
authentication methods, RBAC, and encryption techniques to safeguard sensitive data.
- Develop comprehensive documentation outlining backup and restore procedures specific to both SQL Server and Azure SQL, considering factors such as storage redundancy and retention policies.
- Stay updated on the latest SQL Server and Azure SQL features and best practices, integrating them into existing infrastructure to enhance efficiency and reliability.
About You - Bachelor's degree in Computer Science, Information Technology, or a related field, providing a solid foundation in database management and cloud computing concepts.
- Theoretical understanding of SQL Server and Azure SQL internals, gained through coursework, training programs, or self-study, demonstrating knowledge of database architecture, indexing, query
optimization, and transaction management.
- Completed training or coursework focused on SQL Server database administration, including backupand restore operations, high availability configurations, disaster recovery strategies, Alwayson, SSIS, log shipping, and tools like Data Migration Assistant (DMA) and Database Migration Service (DMS).
- Familiarity with Azure cloud services and basic networking concepts, acquired through coursework or practical exercises, understanding the principles of cloud computing, Azure resource management, and virtual networking.
What We Offer - Insurance – Group Medical Coverage, Group Personal Accident, Group Term Life Insurance
- Rewards and Recognition Program, Employee Referral Program, Wellness Program and CSR Initiatives
- Maternity and Paternity Leaves
- Company Sponsored Certification Program
- Learning/Development Courses, Cross Skill, Mentorship and Leadership Programs
- Quarterly Performance Feedback Sessions
- Savings, Investments and Retirement Benefits
- Flexible Work Hours, Work from Home, Remote Working, Hybrid Working
- Company Onsite / Fun Events
Don't forget to include your CV and cover letter. We receive a lot of applications, but we try to notice each of our potential candidates.
Job tags
Salary
