SQL DBA Admin (Hiring For Pan India)

• Candidate should be strong and hands on with MS SQL Server database administration• Candidate should be well versed with performance tuning, not only DB level but should be able to performance tune the SQL queries, storied procs etc.• Installs and configures SQL Server including clustering, default collation, file locations, number of instances, and service accounts.• Utilizes database tuning and optimization programs or utilities (SQL Profiler, Index Tuning Wizard, etc.) to enhance database performance and application response times.• Sets database options to properly size and place transaction logs.• Creates and manages objects including constraints, indexes, stored procedures, triggers, and views.• Troubleshoots failed installations or upgrades.• Installs and configures SQL Server based on standard operating procedures.• Installs, optimizes, and configures databases.• Ensures that proper security is used.• Evaluates tests and performs Service Pack updates and SQL Server upgrades.• Recommends Microsoft "Best Practices" and follows the standards set by the team.• Reviews existing processes and proactively recommends changes to reduce time and complexity of such processes.• Configures database options for performance; considerations include capacity planning, network connectivity, physical drive configurations, and storage locations.• Provides ideas on how to enhance the backup process and continuously looks for ways to improve this process.• Provides assistance when needed troubleshooting and resolving issues with backups.• Responds to alerts based on criticality and escalates when necessary.• Creates basic alerts based on preconfigured performance counters.• Recommends advanced alerts and ensures that existing alerts have the correct thresholds. PRB