Banner Image

All Services

Programming & Development Database Design & Administration

SQL Server Administration and Powershell

$30/hr Starting at $30

• Over 16 years of Software Development & Administration experience in various computing environments. • 10+ years of experience in Database Administration, Architect and Developer for very large and complex databases in SQL Server 2016/2017, 2014, 2012, SQL Server 2008 R2, 2008 and 2005. • Installed SQL Server 2017 in Linux box. Configured, Always On Availability Groups on Linux • 4+ years of experience in Database Administration and Developer for very large and complex databases in Sybase ASE 15.0.1, 15.0.2, 15.5 and 15.7 on UNIX. • 2+ years’ experience as a Unix administrator (Shell Scripting) . • Experience documenting business requirements and technical architecture/design while translating complex requirements and designs for development, testing and implementation. • Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting. • Hadoop Multi Node Clusters, HDFS Installation and Shell Commands. • Successfully Migrated 10TB database from Sybase to SQL Server 2014, Using SSMA and other migration techniques. • Prepared new established standards for SQL installations, maintenance, tuning and improving Tempdb performance. • Prepared custom based reports for customers using Powershell scripts. • Automated System center orchestrator /Powershell scripts for Silent SQL Installation, Health Check Report, AlwaysOn and Cluster Configuration. • Experience at writing SQL. Familiarity with some of the more powerful SQL constructs and an appreciation of performance issues - how to write performance queries and also how to investigate and tune existing performance problems. • Working well within a small team of highly talented people and enjoy engaging with customers directly to resolve and understand issues. • Administering SQL Server High Availability and Disaster Recovery strategies. • Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations. • Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG. • Experience in using DMV and dynamic management functions for finding out long running queries. • Knowledge of Windows high availability technologies (NLB, Clustering, DR, virtualisation etc) • Experience in Disaster Recovery Planning and Security Management operations. • Proficiency and expertise in SQL Server Replication, backup/recovery, configuration, hardware, Disaster recovery and planning. • Hands on experience in DR processes including Log shipping and Database Mirroring. • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. • Planning and Migrating the SQL Server from lower version to higher versions. • Capacity planning and monitoring database growth. • Experience on Data center servers and handling 2.4 TB databases. • Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012. • Proficiency in using Third Party backup

About

$30/hr Ongoing

Download Resume

• Over 16 years of Software Development & Administration experience in various computing environments. • 10+ years of experience in Database Administration, Architect and Developer for very large and complex databases in SQL Server 2016/2017, 2014, 2012, SQL Server 2008 R2, 2008 and 2005. • Installed SQL Server 2017 in Linux box. Configured, Always On Availability Groups on Linux • 4+ years of experience in Database Administration and Developer for very large and complex databases in Sybase ASE 15.0.1, 15.0.2, 15.5 and 15.7 on UNIX. • 2+ years’ experience as a Unix administrator (Shell Scripting) . • Experience documenting business requirements and technical architecture/design while translating complex requirements and designs for development, testing and implementation. • Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting. • Hadoop Multi Node Clusters, HDFS Installation and Shell Commands. • Successfully Migrated 10TB database from Sybase to SQL Server 2014, Using SSMA and other migration techniques. • Prepared new established standards for SQL installations, maintenance, tuning and improving Tempdb performance. • Prepared custom based reports for customers using Powershell scripts. • Automated System center orchestrator /Powershell scripts for Silent SQL Installation, Health Check Report, AlwaysOn and Cluster Configuration. • Experience at writing SQL. Familiarity with some of the more powerful SQL constructs and an appreciation of performance issues - how to write performance queries and also how to investigate and tune existing performance problems. • Working well within a small team of highly talented people and enjoy engaging with customers directly to resolve and understand issues. • Administering SQL Server High Availability and Disaster Recovery strategies. • Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations. • Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG. • Experience in using DMV and dynamic management functions for finding out long running queries. • Knowledge of Windows high availability technologies (NLB, Clustering, DR, virtualisation etc) • Experience in Disaster Recovery Planning and Security Management operations. • Proficiency and expertise in SQL Server Replication, backup/recovery, configuration, hardware, Disaster recovery and planning. • Hands on experience in DR processes including Log shipping and Database Mirroring. • Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels. • Planning and Migrating the SQL Server from lower version to higher versions. • Capacity planning and monitoring database growth. • Experience on Data center servers and handling 2.4 TB databases. • Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012. • Proficiency in using Third Party backup

Skills & Expertise

Administrative AssistantData ManagementDatabase DevelopmentLanguage TranslationMicrosoft SQL ServerPowerShellProcess DesignServer AdministrationSQLSystems EngineeringUnixWriting

0 Reviews

This Freelancer has not received any feedback.