Database Administrator

Database Administrator

Location: Toronto, ON (Hybrid/On-site)

Required Skills:

• 1.SQL DBA Administration
• 2.PostgreSQL DB Administration
• 3. Mongo DB Administration

Experience: 7 to 10 Years

• Experience in Database Administration in SQL Server (2012,2014, 2016, 2017)
• Experience in Database Deployment and Transformation in Public Cloud (Azure / AWS / Google)
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention • Good knowledge on PostgreSQL and Mongo DB
• Knowledge on DB architectures and P2G activities
• Good knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Always ON
• Strong knowledge of indexes, index management, integrity checks, Database Encryption, configuration, patching.
• Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SSCM, PerfMon, DMVs)
• Documentation skills for processes and procedures ( creating KBs, run books, topology etc )
• SQL Database Operational support to tech users

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.



•

Last updated on Sep 14, 2023