Banner Image

All Services

Other

SQL Server DBA

$8/hr Starting at $25

• 6+ years of experience in education and IT Industry and 4+ years in SQL DBA. • Expertise in installation & configuration of MS SQL Server 2008/2012/2014/2016 and PostgreSQL (pgAdmin 9.3/ 9.4/ 9.5). • Knowledge and experience in High Availability solutions, Database Backup & Maintenance Plan, performace and tuning, security management and more. • Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on). • Proficiency in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables • Strong knowledge of backups, restores, recovery models, database shrink operations and DBCC commands and tracing using SQL Profiler. • Strong knowledge of index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. • Knowledge in SSRS and SSIS like creating report using SSRS Importing Data using SSIS.

About

$8/hr Ongoing

Download Resume

• 6+ years of experience in education and IT Industry and 4+ years in SQL DBA. • Expertise in installation & configuration of MS SQL Server 2008/2012/2014/2016 and PostgreSQL (pgAdmin 9.3/ 9.4/ 9.5). • Knowledge and experience in High Availability solutions, Database Backup & Maintenance Plan, performace and tuning, security management and more. • Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on). • Proficiency in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables • Strong knowledge of backups, restores, recovery models, database shrink operations and DBCC commands and tracing using SQL Profiler. • Strong knowledge of index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively. • Knowledge in SSRS and SSIS like creating report using SSRS Importing Data using SSIS.

Skills & Expertise

Data AdministrationData BackupDatabase AdministrationEducationHigh Availability SystemIndexingMicrosoft SQL ServerMirroringOperationsPerformance TuningSecurity ConsultingSQLSQL Server Reporting Services (SSRS)

0 Reviews

This Freelancer has not received any feedback.