Want to join our team? please check below job opening
Good Experience in maintaining the production servers of multiple environments.
Creating new users on SQL server and Managing SQL Server Security.
Experience in Database backup and disaster recovery procedures.
Test backups to ensure we can meet the business Recovery Time Objectives (RTO).
Experience in Replication (Mandatory).
Having knowledge of Bulk Data Merging using SQL Server Import or Export.
Wizard or writing queries on SQL Server query window.
Creating and maintaining databases.
Monitoring, troubleshooting, and optimizing SQL Server performance.
Having knowledge of SQL Profiler to check the Execution Plan, Performance Monitor.
Monitored server performance, database, and transaction log growth and error logs.
Help the database query developers on technical issues, i.e. writing queries like join or sub-query, triggers, cursors, store procedures.
Have Experience of indexes.
Review and optimize SQL queries, store procedures, views, and triggers to help developers to achieve maximum efficiency and scalability.
Auditing of DML commands on SQL servers and individual databases.
Troubleshoot SQL Server service outages as they occur, including after- hours and weekends.
Configure SQL Server monitoring utilities to minimize false alarms.
Creating the configuration Document for the database environment.
Candidate should have good hands-on experience in SQL Data analysis using queries as well as using Microsoft Excel.
AWS RDS (database services).
All High availability concepts like log shipping, Replication, Mirroring, Always ON, Clustering.
Strong knowledge on Performance tuning.
Knowledge on .net application projects and connection strings.
Profiler and DTA usage and importance.
Carry out Defragmentation, Memory management, data migration, server upgrades.
Applying patches on existing or new SQL servers.
1. Strong experience in Database Administration in SQL Server ( 2008 r2,2012,2014,2016)
2. Knowledge of Oracle database would be an advantage
3. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
4. Ability to detect and troubleshoot SQL Server related CPU,memory, I/O, disk space and other resource contention.
5. Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Always On.
6. Experience of using Profiler traces and other tools to find the most frequently run queries.
7. Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
8. Knowledge of SQL Server tools ( Profiler, DTA, SSMS, PerfMon, DMVs, system sprocs)
9. SQL Development - ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
10. A self-starter who is committed to high quality work and can adapt to new challenges, either on their own or as part of a team
11. Ability to work in a deadline oriented environment
12. Good at MS office - Excel, Word, Outlook
13. Good interpersonal and communication skills - Written and Verbal.
14. Experience: 6 - 10 years
Please share your updated CV to hr@bsquare.in, directly for our quick response.