Senior MSSQL DBA Professional

Vishay Intertechnology

Location

Pune | India

Job description

Vishay INDIA is currently seeking applicants for Senior MSSQL DBA
Responsible for creating and managing databases, ensuring data integrity and security, monitoring and troubleshooting systems, conducting proactive housekeeping, and managing various database environments
Additionally, youll be expected to create detailed documentation and collaborate effectively with internal technical teams

What you will be doing:

Create and manage multiple databases and assist in capacity planning.
Monitor, maintain database systems and troubleshoot problems that may arise.
Maintain data integrity and security (manage roles and permissions of database users).
Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
Monitor, maintain back-ups, restoration and replication.
Support software developers to transport SQL Objects to production.
Proactive housekeeping/archiving and shrinking of databases.
Manage production, QA and development database environments.
Create detailed documentation including diagrams of database infrastructure.
Effectively coordinate and communicate with all the stakeholders (internal technical teams).

What you will bring along:

10+ years experience in administering Microsoft SQL server databases (SQL Server 2012 and above)
Bachelor s or master s degree in computer science or equivalent education and experience.
Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster and various replication technologies would be an advantage.
Ability to develop procedure documents and maintain detailed database related documents

Job tags

Salary