Banner Image

All Services

Administrative & Secretarial

Sr SQL SERVER DBA

$10/hr Starting at $25

Over 5+ years of SQL Server DBA experience in Database Administration and Support of MS SQL Servers 2005, 2008, 2012 and 2014 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments. • Installation, Configuration and Maintenance of SQL Server 2005,2008, 2012 & 2014 • Up gradation of SQL Servers using IN place and Side by Side methods. • SQL Server security and object permissions, creation of users and assigning roles. • Maintenance plans for Rebuild Index and Update statistics. • Implementing DR and High Availability solutions by means of Always ON, Replication, Mirroring, Clustering and Log shipping. • Jobs and Alerts creation. • Performing integrity checks by Database Maintenance wizard and DBCC utilities • Applying Patches and Services packs • Troubleshooting SQL issues using SQL Tools, Execution plans, Trace, statistics and Index tuning wizard • Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks. • Familiar in writing distributed queries between SQL Servers and Linked Servers • Installation, Configuration, up gradation of instances of MSSQL SERVER 2014, 2012 on the production, Test and development servers. • Installation of service packs for SQL Server 2012 in all development and production environments. • Administration and creation of user logins and groups with appropriate roles, granting privileges to users and groups, monitoring user’s accounts. • Managing and checking Disk Space, Primary Files and Log Files of SQL server. • Taking Database Backups and Restoration. • Checking Jobs, Alerts, Operators and Maintenance Plans. • Designing, implementation and configuration of Replication and Database mirroring. • Query Optimization and performance tuning. • Familiar with DBCC commands, DR and Clustering. • Creating new Schemas, tables, Indexes, Views, stored procedure and altering tables. • Create Complex Queries for data analysis, extraction and Generate Custom reports using SQL Queries. • Migrating data from different data sources to Application Databases. • Installation and Maintenance of RS SQL O’Neil and in-house developed Applications. • Supported the server on which the applications run. • Respond to requests received by help desk in timely manner.

About

$10/hr Ongoing

Download Resume

Over 5+ years of SQL Server DBA experience in Database Administration and Support of MS SQL Servers 2005, 2008, 2012 and 2014 in Production, QA, Reporting Services, Development environments & Replication and Cluster Server Environments. • Installation, Configuration and Maintenance of SQL Server 2005,2008, 2012 & 2014 • Up gradation of SQL Servers using IN place and Side by Side methods. • SQL Server security and object permissions, creation of users and assigning roles. • Maintenance plans for Rebuild Index and Update statistics. • Implementing DR and High Availability solutions by means of Always ON, Replication, Mirroring, Clustering and Log shipping. • Jobs and Alerts creation. • Performing integrity checks by Database Maintenance wizard and DBCC utilities • Applying Patches and Services packs • Troubleshooting SQL issues using SQL Tools, Execution plans, Trace, statistics and Index tuning wizard • Performance Monitor, SQL Profiler and optimizing the queries, tracing long running queries and deadlocks. • Familiar in writing distributed queries between SQL Servers and Linked Servers • Installation, Configuration, up gradation of instances of MSSQL SERVER 2014, 2012 on the production, Test and development servers. • Installation of service packs for SQL Server 2012 in all development and production environments. • Administration and creation of user logins and groups with appropriate roles, granting privileges to users and groups, monitoring user’s accounts. • Managing and checking Disk Space, Primary Files and Log Files of SQL server. • Taking Database Backups and Restoration. • Checking Jobs, Alerts, Operators and Maintenance Plans. • Designing, implementation and configuration of Replication and Database mirroring. • Query Optimization and performance tuning. • Familiar with DBCC commands, DR and Clustering. • Creating new Schemas, tables, Indexes, Views, stored procedure and altering tables. • Create Complex Queries for data analysis, extraction and Generate Custom reports using SQL Queries. • Migrating data from different data sources to Application Databases. • Installation and Maintenance of RS SQL O’Neil and in-house developed Applications. • Supported the server on which the applications run. • Respond to requests received by help desk in timely manner.

Skills & Expertise

Admin SupportCluster AnalysisClusteringCreativeDistributed ComputingMicrosoftMicrosoft SQL ServerReport WritingSecurityServer AdministrationSoftware DevelopmentSQLStatistical AnalysisWriting

0 Reviews

This Freelancer has not received any feedback.