Banner Image

All Services

Engineering & Architecture

Sql dba, AWS RDS, sql azure, SSIS, SSRS

$15/hr Starting at $25

DBA & Cloud(AWS & Azure) Management and Migrations : • 5.4 years of experience in SQL SERVERDBA as Product Support and Application Database Administrator. • Experience on planning, Installing, Configuring and Administering SQL server 2000/2005/2008/2008R2/2012/2014/2016/2017 applying Service Packs accordingly and Windows Server 2000/2003/2003R2/2008/2008R2/2012/2012R2/2016. • Administering, maintaining, developing and recommending policies and procedures for ensuring the security and integrity of the company's databases and systems. • Creating and maintaining databases, data files and log files. • Ensuring successful and periodical Backups, Restoration and configuring maintenance plans. • Performed Database Refreshes. • Upgrade the environment from SQL 2000 to SQL 2005 and from SQL 2008 to SQL 2012. • Migration of servers and databases between the data centers. • Installed SQL Server service packs based on the errors and flaws that are found in the application. • Set up the ODBC configuration and upgradation of the different database in different sql server versions. • Creation and maintenance of databases, creating roles that assign to the particular users and managing user permissions based on requirements by client. • Hands on experience on Configuring and troubleshoot Replication. • Implementing and Configuration of High Availability solutions like DB Mirroring and Log-shipping. • Monitoring the servers and processes at different levels and tuning the Poor performance. • Experience on Clustering. • Knowledge on AlwaysOn Availability Groups Sql server 2012. • Configuring, Scheduling and administering routine Jobs, Alerts and Maintenance Plans as per client requirements. • Monthly Rebooting the server after the DCM(Data Center Maintenance) activity completes, check the all the services of SQL server and policies. • Downloading and deployments the SSIS packages from web services and doing Data Transformation Services and Export / Import operations. • Configure the appropriate VMs, storage and network in Azure to support the customer workloads moving to Azure. • Configure and implement monitoring, backup and archival solutions in Azure to support customer requirements. • Implement highly available and disaster recovery solutions in Azure to meet the customer SLA requirements. • Troubleshoot and identify performance, connectivity and other issues for the applications hosted in Azure platform. • Implement solutions using Azure PaaS features like web jobs, cloud services, Azure SQL Server, service bus, notification hubs etc. • Configure large database solutions in Azure using SQL Server or Oracle database solutions. • Configure windows and non-windows(Linux) workloads in Azure. Administer Microsoft SQL Server 2016 and 2017 systems (OnPrem and within AWS) • Configure the appropriate VMs, storage and network in AWS to support the customer workloads migrations moving onprem to AWS.

About

$15/hr Ongoing

Download Resume

DBA & Cloud(AWS & Azure) Management and Migrations : • 5.4 years of experience in SQL SERVERDBA as Product Support and Application Database Administrator. • Experience on planning, Installing, Configuring and Administering SQL server 2000/2005/2008/2008R2/2012/2014/2016/2017 applying Service Packs accordingly and Windows Server 2000/2003/2003R2/2008/2008R2/2012/2012R2/2016. • Administering, maintaining, developing and recommending policies and procedures for ensuring the security and integrity of the company's databases and systems. • Creating and maintaining databases, data files and log files. • Ensuring successful and periodical Backups, Restoration and configuring maintenance plans. • Performed Database Refreshes. • Upgrade the environment from SQL 2000 to SQL 2005 and from SQL 2008 to SQL 2012. • Migration of servers and databases between the data centers. • Installed SQL Server service packs based on the errors and flaws that are found in the application. • Set up the ODBC configuration and upgradation of the different database in different sql server versions. • Creation and maintenance of databases, creating roles that assign to the particular users and managing user permissions based on requirements by client. • Hands on experience on Configuring and troubleshoot Replication. • Implementing and Configuration of High Availability solutions like DB Mirroring and Log-shipping. • Monitoring the servers and processes at different levels and tuning the Poor performance. • Experience on Clustering. • Knowledge on AlwaysOn Availability Groups Sql server 2012. • Configuring, Scheduling and administering routine Jobs, Alerts and Maintenance Plans as per client requirements. • Monthly Rebooting the server after the DCM(Data Center Maintenance) activity completes, check the all the services of SQL server and policies. • Downloading and deployments the SSIS packages from web services and doing Data Transformation Services and Export / Import operations. • Configure the appropriate VMs, storage and network in Azure to support the customer workloads moving to Azure. • Configure and implement monitoring, backup and archival solutions in Azure to support customer requirements. • Implement highly available and disaster recovery solutions in Azure to meet the customer SLA requirements. • Troubleshoot and identify performance, connectivity and other issues for the applications hosted in Azure platform. • Implement solutions using Azure PaaS features like web jobs, cloud services, Azure SQL Server, service bus, notification hubs etc. • Configure large database solutions in Azure using SQL Server or Oracle database solutions. • Configure windows and non-windows(Linux) workloads in Azure. Administer Microsoft SQL Server 2016 and 2017 systems (OnPrem and within AWS) • Configure the appropriate VMs, storage and network in AWS to support the customer workloads migrations moving onprem to AWS.

Skills & Expertise

Amazon AWSApp DevelopmentAzureCreativeData ManagementDatabase DevelopmentEnvironmental IndustryFeature WritingImport/Export OperationsManagementNetworkingODBCPlanningProcess DesignRequirements AnalysisSchedulingSecurity ConsultingServer AdministrationSoftware DevelopmentSQLSQL AzureSsisSSRSStorage EngineeringWeb Development

0 Reviews

This Freelancer has not received any feedback.