Banner Image

All Services

Programming & Development

Database administrator (DBA) Consultant

$30/hr Starting at $50

I have 10+ years experience in Microsoft SQL Server database administration and consultancy, working with SQL Server 2000, 2005, 2008, 2014, 2016 and 2017. Work includes: - Manage SQL environments with more than 100 SQL Servers respecting tuning recommendations, performance monitoring results, capacity planning, space management and continuous quality assurance - Install, configure and manage SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008&2008R2, SQL Server 2005, SQL Server 2000. Set up SQL Server in cluster. - Perform SQL optimization and maintenance tasks for performance problems. - Resolve locking conflicts and resource utilization problems, optimizing queries and stored procedures. - Configure and manage SQL security. - Supervise SQL Backups and execute disaster recovery tasks using the SQL Backup Tool or a third-party software such as Quest LiteSpeed. - Migrate previous versions of SQL Server to SQL Server 2016 and SQL Server 2017. - Provide data extracts. - Design SSIS packages for automate backup/restore jobs of SSAS database cubes. - Keep updated documentation of database environments and configuration of servers. - Set up maintenance jobs (index defragmentation, database integrity checks, update statistics, etc) for performance and effective space management.

About

$30/hr Ongoing

Download Resume

I have 10+ years experience in Microsoft SQL Server database administration and consultancy, working with SQL Server 2000, 2005, 2008, 2014, 2016 and 2017. Work includes: - Manage SQL environments with more than 100 SQL Servers respecting tuning recommendations, performance monitoring results, capacity planning, space management and continuous quality assurance - Install, configure and manage SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008&2008R2, SQL Server 2005, SQL Server 2000. Set up SQL Server in cluster. - Perform SQL optimization and maintenance tasks for performance problems. - Resolve locking conflicts and resource utilization problems, optimizing queries and stored procedures. - Configure and manage SQL security. - Supervise SQL Backups and execute disaster recovery tasks using the SQL Backup Tool or a third-party software such as Quest LiteSpeed. - Migrate previous versions of SQL Server to SQL Server 2016 and SQL Server 2017. - Provide data extracts. - Design SSIS packages for automate backup/restore jobs of SSAS database cubes. - Keep updated documentation of database environments and configuration of servers. - Set up maintenance jobs (index defragmentation, database integrity checks, update statistics, etc) for performance and effective space management.

Skills & Expertise

AzureBackupConsultantData ManagementData ManipulationDatabase AdministrationDatabase DevelopmentDatabase EngineDatabase ServersDatabase SystemsDesignMicrosoftMicrosoft AzureMicrosoft SQL ServerMicrosoft SQL SsasMicrosoft SQL SSRSMonitoringPerformance TuningServer AdministrationSpace PlanningSQLSQL AzureSQL ClrSsisWindows Azure

0 Reviews

This Freelancer has not received any feedback.