Database Track Engineer Job in Bangalore at Hexaware Technologies

Hexaware Technologies is hiring for the role of Database Track Engineer!

Responsibilities of the Candidate:

• SQL Server Administration: A strong understanding of SQL Server administration, including database design, performance tuning, and troubleshooting.
• Windows Functions: Experience in SQL Server functions, common table expressions, and advanced stored procedure writing.
• Query Plans and Index Tuning: Reading query plans, tuning indexes, and troubleshooting performance bottlenecks, blocking, deadlocking, and other issues.
• SQL Profiler and Extended Events: Experience with SQL Profiler and Extended Events for performance monitoring and troubleshooting.
• Technical Documentation: Maintaining detailed technical documentation.
• Database Strategy: Leading efforts to define database strategy, architecture, standards, and procedures to preserve the integrity and security of company data resources.
• Troubleshooting: Troubleshooting database problems and implementing corrective measures as required.

Requirements:

• SQL Server Administration: A strong understanding of SQL Server administration, including database design, performance tuning, and troubleshooting.
• Azure Knowledge: Familiarity with Azure services, particularly Azure SQL Database, including its features, limitations, and best practices.
• Database Migration Techniques: Knowledge of various migration methods, such as backup and restore, database copy, Azure Database Migration Service, and Data Migration Assistant.
• Data Security: Understanding of data security principles and experience in implementing security measures in Azure SQL Database, such as firewall rules, encryption, and access controls.
• Networking: Understanding of networking concepts, including virtual networks, subnets, and connectivity options to ensure smooth migration and ongoing operation.
• Scripting and Automation: Proficiency in scripting languages like PowerShell or Azure CLI to automate migration tasks and streamline the process.
• Backup and Recovery: Experience in implementing backup and recovery strategies in Azure SQL Database to ensure data integrity and availability during and after migration.
• Performance Tuning: Ability to optimize database performance in Azure SQL Database, including indexing, query optimization, and resource utilization monitoring.
• Troubleshooting Skills: Strong problem-solving skills to identify and resolve issues that may arise during the migration process or after the database is migrated to Azure SQL Database.
• Documentation: Capability to document migration plans, procedures, and post-migration configurations to ensure smooth handover and future reference.