Banner Image

All Services

Administrative & Secretarial

MS SQL DBA and developer

$12/hr Starting at $25

• Over 7+ years of experience that includes analysis, programming, support, installation, migration and database administration. • Experience in planning new server Installation, configuration and maintenance SQL Server. • Migration and upgradation of various versions of SQL Server • Managing around 300 servers and supporting max size of 3 TB database • SQL Server Migration (SQL 2008R2 to SQL 2016 Private cloud) • SQL Server Build using JSON and Blueprint. • Applying SQL Server patches and hot fixes to stand alone and cluster servers. • Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options. • Verifying and resolving the SQL Server Performance issues and Finding and fixing the root cause • Experience in configuring and managing HADR concept like always on ,mirroring ,log shipping and replication . • Expertise in Database backup, Recovery, Restoration and Disaster Recovery Plans. • Experience in User Management activities like adding the user and managing the permissions and fixing the orphan users. • Experience in Creating and scheduling the jobs and troubleshooting the failed jobs. • Good Experience in Performance tuning activities like verifying the slow running queries. Fragmentation and re-indexing the fragmented indexes. • Experience in tools like Performance Monitor, Profiler, Import and Export wizard and Copy database wizard. • Configuring and monitoring Always ON • Configuring, monitoring and troubleshooting the REPLICATION and DR activities. • Performing the Failover and Failback operations in the cluster environment • Configuring and Maintaining and troubleshooting the Database mirroring and also experience in Mirroring DR activities. • Good Experience of implementing KANBAN agile. • Closing the tickets with in the SLA time and Monitoring the SLA(ITIL).

About

$12/hr Ongoing

Download Resume

• Over 7+ years of experience that includes analysis, programming, support, installation, migration and database administration. • Experience in planning new server Installation, configuration and maintenance SQL Server. • Migration and upgradation of various versions of SQL Server • Managing around 300 servers and supporting max size of 3 TB database • SQL Server Migration (SQL 2008R2 to SQL 2016 Private cloud) • SQL Server Build using JSON and Blueprint. • Applying SQL Server patches and hot fixes to stand alone and cluster servers. • Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options. • Verifying and resolving the SQL Server Performance issues and Finding and fixing the root cause • Experience in configuring and managing HADR concept like always on ,mirroring ,log shipping and replication . • Expertise in Database backup, Recovery, Restoration and Disaster Recovery Plans. • Experience in User Management activities like adding the user and managing the permissions and fixing the orphan users. • Experience in Creating and scheduling the jobs and troubleshooting the failed jobs. • Good Experience in Performance tuning activities like verifying the slow running queries. Fragmentation and re-indexing the fragmented indexes. • Experience in tools like Performance Monitor, Profiler, Import and Export wizard and Copy database wizard. • Configuring and monitoring Always ON • Configuring, monitoring and troubleshooting the REPLICATION and DR activities. • Performing the Failover and Failback operations in the cluster environment • Configuring and Maintaining and troubleshooting the Database mirroring and also experience in Mirroring DR activities. • Good Experience of implementing KANBAN agile. • Closing the tickets with in the SLA time and Monitoring the SLA(ITIL).

Skills & Expertise

Database AdministrationDatabase ConsultingSchedulingSQLSQL 2008SQL AzureTroubleshooting

0 Reviews

This Freelancer has not received any feedback.