KARYA CONSULTANTS PRIVATE LIMITED
This listing was posted on hirist.
Principal Consultant - Production Support (8-10 yrs) Bangalore/Any Location
Location:
Bangalore/Any Location
Description:
Job Description :- Experience in SQL Server Database is must.- Experience in Production DBA is must.- Experience T-SQL Development is must.Skills :- Installation (Standalone, Always On, Distributed AGs)- SQL Server Security Management : Windows & SQL Authentication, Creating Logins, Database Users, Server roles, Database roles, - Permissions : Server level, DB level, Object level, working with Managed Service Accounts (SMA), Server Principal Names (SPNs)- Implementing and managing the Database backup and restore strategies, including third party Backup tools, example: Rubrik, TSM- Skills in Performance Tuning, troubleshootingRoot Cause Analysis (Perf.Monitor/SQL Server Profiler/Database tuning advisor/Extended events)- Good Knowledge on Indexes, Statistics, analysing the execution plan, deadlocks, blockings, Parameter sniffing, lock escalation, MAX DOP, Cost threshold Parallelism.- Good knowledge on memory concepts , buffer pool, procedure cache, PLE, memory grants pending.etc.- Good knowledge on Observability tools Diagnostic tools (ex : New Relic ), monitoring Database health components ( Eyes on Glass)- Good knowledge on Always On, Distributed availability Groups configuration and troubleshooting sync issues.- Good understanding on TempDB behavior- SQL Server Agent, working with Agent Jobs, MSX- Good to have : Change Data Capture (CDC), Query store- Good to have : T-SQL development & Query optimization, PowerShell scripting- Good to have : Cloud exposure and multi Database technologies(OracleMongoDBPostgres. etc)Minimum Qualifications :- Bachelor's/ master's in computer science or related disciplines.- 8+ years of relevant experience for Principal Consultant- Excellent oral and written communication is a must.- Ability to understand business requirements and translate them into technical requirements. (ref:hirist.tech)
Visit Our Partner Website
This listing was posted on another website. Click here to open: Go to hirist
Important Safety Tips
- Always meet the employer in person.
- Avoid sharing sensitive personal and financial information.
- Avoid employment offers that require a deposit or investment.
To learn more, visit the Safety Center or click here to report this listing.
More About this Listing: Principal Consultant - Production Support (8-10 yrs) Bangalore/Any Location
Principal Consultant - Production Support (8-10 yrs) Bangalore/Any Location is a Consulting Jobs Consultant Job at Karya Consultants located in India. Find other listings like Principal Consultant - Production Support (8-10 yrs) Bangalore/Any Location by searching Oodle for Consulting Jobs Consultant Jobs.
Principal Consultant - Production Support (8-10 yrs) Bangalore/Any Location is a Consulting Jobs Consultant Job at Karya Consultants located in India. Find other listings like Principal Consultant - Production Support (8-10 yrs) Bangalore/Any Location by searching Oodle for Consulting Jobs Consultant Jobs.