Banner Image

All Services

Programming & Development

Database administration

$15/hr Starting at $25

? Adequate in ITIL process and Incident Management. ? Working knowledge in MS SQL Server, IIS, and Cluster Management ? Designing Database Solutions for Microsoft SQL Server. ? Database designing and optimization of the SQL database and storage management. ? Extensive knowledge of Always on. ? Working knowledge On Microsoft Azure. ? Worked as SQL/ORACLE DBA for 1.5 years. ? Working Knowledge of using SSIS, SSRS. ? Working on system catalogs and system databases. ? A Microsoft Certified Professional with 7+ Years of experience in SQL Administration in 24*7 Production Support environments. ? Good experience with SQL server 2014, 2012 2008 R2, 2008, 2005 and 2000 Installations, Configurations, Migrations and maintenance. ? Hands on Experience in applying the Service packs and Cumulative packs for servers. ? Good experience on creating and applying db best practices for a db. ? Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users. ? Verifying and resolving the SQL Server Blocking issues and Finding and fixing the root cause ? Expertise in Maintenance of databases, Performance Tuning and Troubleshooting. ? Hand on experience of using SCOM and IDERA for monitoring. ? Extensive experience in Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options. ? Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups. ? Good experience with implementing and Troubleshooting High Availability of database servers using Replication, Log Shipping and Database Mirroring. ? Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run the databases efficiently. ? Performing the Cluster installation and adding the nodes in the respective servers in SQL Server 2000, 2005, 2008R2, 2012. ? Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities. ? Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks. ? Provided support on 24x7 shift rotation basis and monitor trouble ticket queues to attend user and customer calls. ? Working on Incident management, Incident trend analysis, Incident reduction, Configuration Management ? Documented the Standard Operating Procedures. ? Using ITIL best practices (HPQC, ITSM, and Service Now,HPSM) for Incident/Change/Problem Management. ? Responsible for Database support, troubleshooting, planning and migration. ? Resource planning and coordination for Application DB Migrations with project managers, application and web app teams. ? Monitoring of Database size and disk space (Capacity Planning) in Production, Staging & Development environme

About

$15/hr Ongoing

Download Resume

? Adequate in ITIL process and Incident Management. ? Working knowledge in MS SQL Server, IIS, and Cluster Management ? Designing Database Solutions for Microsoft SQL Server. ? Database designing and optimization of the SQL database and storage management. ? Extensive knowledge of Always on. ? Working knowledge On Microsoft Azure. ? Worked as SQL/ORACLE DBA for 1.5 years. ? Working Knowledge of using SSIS, SSRS. ? Working on system catalogs and system databases. ? A Microsoft Certified Professional with 7+ Years of experience in SQL Administration in 24*7 Production Support environments. ? Good experience with SQL server 2014, 2012 2008 R2, 2008, 2005 and 2000 Installations, Configurations, Migrations and maintenance. ? Hands on Experience in applying the Service packs and Cumulative packs for servers. ? Good experience on creating and applying db best practices for a db. ? Experience in implementing SQL Server security and Object permissions like maintaining creation of users, configuring permissions and assigning roles to users. ? Verifying and resolving the SQL Server Blocking issues and Finding and fixing the root cause ? Expertise in Maintenance of databases, Performance Tuning and Troubleshooting. ? Hand on experience of using SCOM and IDERA for monitoring. ? Extensive experience in Creating and Administering the SQL Server Databases like data and log file placements and managing the growth parameters and database options. ? Protecting the databases by taking different kinds of Backups such as Full, Differential, and Transactional log backups. ? Good experience with implementing and Troubleshooting High Availability of database servers using Replication, Log Shipping and Database Mirroring. ? Establishing weekly maintenance plans such as Integrity check, Rebuilding indexes, Update statistics and monthly maintenance plans such as clean up history etc. to run the databases efficiently. ? Performing the Cluster installation and adding the nodes in the respective servers in SQL Server 2000, 2005, 2008R2, 2012. ? Performing the Failover and Failback operations in the cluster environment and adding the new Disks and troubleshooting activities. ? Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks. ? Provided support on 24x7 shift rotation basis and monitor trouble ticket queues to attend user and customer calls. ? Working on Incident management, Incident trend analysis, Incident reduction, Configuration Management ? Documented the Standard Operating Procedures. ? Using ITIL best practices (HPQC, ITSM, and Service Now,HPSM) for Incident/Change/Problem Management. ? Responsible for Database support, troubleshooting, planning and migration. ? Resource planning and coordination for Application DB Migrations with project managers, application and web app teams. ? Monitoring of Database size and disk space (Capacity Planning) in Production, Staging & Development environme

Skills & Expertise

Administrative AssistantDatabase AdministrationDatabase Development

0 Reviews

This Freelancer has not received any feedback.

Browse Similar Freelance Experts