Consultant II
SteerLean Consulting
- Location
- Gurgaon, Haryana, India
- Job type
- Full-time
Required skills
- Agile
- Azure
- clustering
- communication skills
- cross-functional
- database
- IaaS
- PaaS
- SQL
- T-SQL
- PowerShell
About the role
SteerLean Consulting
Website:
steerlean.com
Job details:
Job Role
Cloud and SQL DBA
Job Description Overview
- Be eager to learn and stay up to date on new and emerging cloud technologies.
- Work as part of client teams, following Agile/Scrum approaches and ceremonies.
- Communicate effectively and professionally with teammates, client personnel, and client stakeholders.
- Knowledgeable about the latest industry trends, and highly innovative.
Requirements
Background and Experience
- Bachelor’s degree in information technology, Computer Science, or related field preferred, or equivalent practical experience.
- 4+ years of experience in a similar or related role is required.
- Any relevant cloud certification is a plus.
Technical Skills
- Microsoft SQL Server and Azure SQL Database / Managed Instance
- SQL Server installation, configuration, patching, upgrades, and migrations(PaaS to IaaS)
- Strong in query optimization, execution plans, indexing, and performance tuning
- Hands-on with DMVs, Query Store, and performance monitoring tools
- Backup and recovery strategies including full, differential, log backups, and point-in-time restore
- Experience with Azure backup features like geo-restore and long-term retention (LTR)
- High availability and disaster recovery: Always On Availability Groups, Failover Clustering, log shipping, geo-replication
- Database security: users, roles, permissions, TDE, Always Encrypted, auditing, data masking
- Monitoring and troubleshooting using SQL Profiler, Extended Events, Azure Monitor, Log Analytics
- Strong T-SQL scripting skills and automation using PowerShell.
- Experience with database migration tools like Azure DMS, BACPAC, and backup/restore
SQLSoft Skills
- High integrity, with a proactive, positive approach to work
- Strong communication and collaboration skills to work effectively in a team environment
- Strong problem-solving skills.
- Excellent communication skills and the ability to collaborate with cross-functional teams.
- A willingness to learn and take on new challenges in a fast-paced environment.
- Ability to manage multiple priorities and tasks effectively
Click on Apply to know more.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.