Banner Image

All Services

Programming & Development

Database administrator

$10/hr Starting at $30

? Installing SQL server 2005, SQL Server 2008, SQL Server 2008 R2, SQL 2012 on Dev, QA and Production servers. ? Setting up SQL cluster A-A,A-P (two node or three node) ? Installing various service packs of SQL Server on Dev, QA and Production servers. ? Configuring SQL server reporting service on Dev, QA and Production servers. ? Implementing and troubleshooting SQL Server High availability options: Log Shipping, Database Mirroring. ? Working on Incident Management for Production and Non Production Servers. ? Preparing various reports about Releases and Database status for Management. ? Importing and Exporting SSIS Packages on Various Servers. ? Rebuilding and Reorganizing SQL Server Indexes for Performance Tuning. ? Disk space management ? Setup of various SQL server Agent Jobs and Maintenance Plans to automate the various Maintenance Tasks. ? TOOLS : Windows Performance Monitor, SQL Server Management Studio, SQL Server Configuration Manager, Reporting service Configuration Manager, SQL Server Profiler, Database Engine Tuning Advisor, Performance Dashboard , ? Third party tools: Quest ,Red-gate, Erwin ? User management ? Security and Managing SQL Server security and logins. ? Backup and recovery methods using Enterprise Manager and Query Analyser. ? SQL network configuration ( using Server / Client Network utilities) ? Database performance tuning. ? Troubleshooting database issues, Knowledge transfer/consultation to developers, monitoring SQL Server Jobs. ? Auditing (Logons), Capacity planning and monitoring database growth. ? 24X7 global On-call support, Analyze, recommend and execute patching and upgrade methodologies for SQL Server ? Coordinate processes and work

About

$10/hr Ongoing

Download Resume

? Installing SQL server 2005, SQL Server 2008, SQL Server 2008 R2, SQL 2012 on Dev, QA and Production servers. ? Setting up SQL cluster A-A,A-P (two node or three node) ? Installing various service packs of SQL Server on Dev, QA and Production servers. ? Configuring SQL server reporting service on Dev, QA and Production servers. ? Implementing and troubleshooting SQL Server High availability options: Log Shipping, Database Mirroring. ? Working on Incident Management for Production and Non Production Servers. ? Preparing various reports about Releases and Database status for Management. ? Importing and Exporting SSIS Packages on Various Servers. ? Rebuilding and Reorganizing SQL Server Indexes for Performance Tuning. ? Disk space management ? Setup of various SQL server Agent Jobs and Maintenance Plans to automate the various Maintenance Tasks. ? TOOLS : Windows Performance Monitor, SQL Server Management Studio, SQL Server Configuration Manager, Reporting service Configuration Manager, SQL Server Profiler, Database Engine Tuning Advisor, Performance Dashboard , ? Third party tools: Quest ,Red-gate, Erwin ? User management ? Security and Managing SQL Server security and logins. ? Backup and recovery methods using Enterprise Manager and Query Analyser. ? SQL network configuration ( using Server / Client Network utilities) ? Database performance tuning. ? Troubleshooting database issues, Knowledge transfer/consultation to developers, monitoring SQL Server Jobs. ? Auditing (Logons), Capacity planning and monitoring database growth. ? 24X7 global On-call support, Analyze, recommend and execute patching and upgrade methodologies for SQL Server ? Coordinate processes and work

0 Reviews

This Freelancer has not received any feedback.