#ssrs to azure migration | Explore Tumblr posts and blogs

thedbahub · 1 year ago

Text

A Brief Overview of Migrating Your On-Prem SSRS to Azure Power BI

Ever thought about moving your SQL Server Reporting Services (SSRS) from the comfort of its on-premise setup to the cloud? With Azure and Power BI waving from the horizon, it’s a journey worth considering. This leap not only catapults your business intelligence (BI) tools into the future but also taps into Azure’s scalability and Power BI’s slick analytics. But let’s not sugarcoat it; this…

View On WordPress

#Azure SQL Database #Cloud BI transformation #Power BI integration #Power BI report optimization #SSRS to Azure migration

0 notes

marklovesdata · 3 years ago

Link

#ssis to adf migration #ssrs to azure migration #sql on prem to azure

2 notes · View notes

linkhello1 · 5 years ago

Text

Windows/SQL Server Admin

local candidates strongly preferred interviews to be conducted by Skype or Google Hangout some after-hours and weekend hours required based on workload candidates must participate in on-call rotation candidate hired will work ONSITE 50% of the time NOW, NO exceptions, and work ONSITE 100% of the time after restrictions are lifted General Job Description: This resource will work as part of the Virginia Department of Health, Office of Information Management (OIM-DBA) team. The team member will assist in maintenance and administration of SQL Server databases that support critical multi-tier applications implemented mostly in Windows environment using MS suite of tools. The resource will also support administration and maintenance of the agency website that uses Wordpress/MySQL set-up. The OIM-DBA team is currently tasked with developing a migration plan to transition from traditional data center environment to the Cloud infrastructure (private/AWS/Azure); the resource will help in coordinating this effort, provide technical assistance in configuring the new set-up with emphasis on security, compile test plans, implement and adopt new features, set-up monitoring and automate processes; document time and effort. The contractor should be able to work and communicate with vendors if required and share timely updates with the team. Sql server administration starting from 2008/2012/2016 versions with Alway-On SQL Server in Azure, AZure SQL T-SQL, Stored Procedure, SSIS, SSRS IIS with Security experience s - Experiences in Azure - VM, App Service Experiences in Azure - VM, App Service, Azure AD, Azure Storage Wordpress Administration MySQL and Amazon RDS for MySQL Windows Server 2008+/Linux Redhat v7+ .NET Development: ASP.NET, ASP.NET MVC, WPF, WCF Tomcat, NGINX Tableau administration Sql server backup/recovery/performance tuning Quest Spotlight for SQL Server Enterprise ArcGIS setup/administration -- Reference : Windows/SQL Server Admin jobs from Latest listings added - LinkHello http://linkhello.com/jobs/technology/windowssql-server-admin_i11245

0 notes

linkhellojobs · 5 years ago

Text

Windows/SQL Server Admin

local candidates strongly preferred interviews to be conducted by Skype or Google Hangout some after-hours and weekend hours required based on workload candidates must participate in on-call rotation candidate hired will work ONSITE 50% of the time NOW, NO exceptions, and work ONSITE 100% of the time after restrictions are lifted General Job Description: This resource will work as part of the Virginia Department of Health, Office of Information Management (OIM-DBA) team. The team member will assist in maintenance and administration of SQL Server databases that support critical multi-tier applications implemented mostly in Windows environment using MS suite of tools. The resource will also support administration and maintenance of the agency website that uses Wordpress/MySQL set-up. The OIM-DBA team is currently tasked with developing a migration plan to transition from traditional data center environment to the Cloud infrastructure (private/AWS/Azure); the resource will help in coordinating this effort, provide technical assistance in configuring the new set-up with emphasis on security, compile test plans, implement and adopt new features, set-up monitoring and automate processes; document time and effort. The contractor should be able to work and communicate with vendors if required and share timely updates with the team. Sql server administration starting from 2008/2012/2016 versions with Alway-On SQL Server in Azure, AZure SQL T-SQL, Stored Procedure, SSIS, SSRS IIS with Security experience s - Experiences in Azure - VM, App Service Experiences in Azure - VM, App Service, Azure AD, Azure Storage Wordpress Administration MySQL and Amazon RDS for MySQL Windows Server 2008+/Linux Redhat v7+ .NET Development: ASP.NET, ASP.NET MVC, WPF, WCF Tomcat, NGINX Tableau administration Sql server backup/recovery/performance tuning Quest Spotlight for SQL Server Enterprise ArcGIS setup/administration -- Reference : Windows/SQL Server Admin jobs from Latest listings added - LinkHello http://linkhello.com/jobs/technology/windowssql-server-admin_i11245

0 notes

cvwing1 · 5 years ago

Text

Windows/SQL Server Admin

local candidates strongly preferred interviews to be conducted by Skype or Google Hangout some after-hours and weekend hours required based on workload candidates must participate in on-call rotation candidate hired will work ONSITE 50% of the time NOW, NO exceptions, and work ONSITE 100% of the time after restrictions are lifted General Job Description: This resource will work as part of the Virginia Department of Health, Office of Information Management (OIM-DBA) team. The team member will assist in maintenance and administration of SQL Server databases that support critical multi-tier applications implemented mostly in Windows environment using MS suite of tools. The resource will also support administration and maintenance of the agency website that uses Wordpress/MySQL set-up. The OIM-DBA team is currently tasked with developing a migration plan to transition from traditional data center environment to the Cloud infrastructure (private/AWS/Azure); the resource will help in coordinating this effort, provide technical assistance in configuring the new set-up with emphasis on security, compile test plans, implement and adopt new features, set-up monitoring and automate processes; document time and effort. The contractor should be able to work and communicate with vendors if required and share timely updates with the team. Sql server administration starting from 2008/2012/2016 versions with Alway-On SQL Server in Azure, AZure SQL T-SQL, Stored Procedure, SSIS, SSRS IIS with Security experience s - Experiences in Azure - VM, App Service Experiences in Azure - VM, App Service, Azure AD, Azure Storage Wordpress Administration MySQL and Amazon RDS for MySQL Windows Server 2008+/Linux Redhat v7+ .NET Development: ASP.NET, ASP.NET MVC, WPF, WCF Tomcat, NGINX Tableau administration Sql server backup/recovery/performance tuning Quest Spotlight for SQL Server Enterprise ArcGIS setup/administration -- Reference : Windows/SQL Server Admin jobs from Latest listings added - cvwing http://cvwing.com/jobs/technology/windowssql-server-admin_i14167

0 notes

marcosplavsczyk · 5 years ago

Link

SQL Server Management Studio (SSMS) is an integrated environment for managing SQL Server instances. By using SSMS, one could access, configure, manage, administer, and develop all components of SQL Server.

As official and the most recognizable “all in one” client user interface, its design is quite user friendly and comprehensive. Furthermore, the software combines and brings together a range of both graphical and visual design tools and rich script editors to ensure simplified interaction with SQL Server.

On top of all, it’s worth mentioning that with every major release, the application is better in terms of security and performance.

And to any database administrator (DBA) productivity and versatility may prove to be very important. Productivity will allow the job to be done easily and swiftly, and versatility ensures different ways of accomplishing one single task.

However, with all the mentioned perks, there are some downsides to its functionality, that are time-consuming and sometimes very tedious.

One of which, that SSMS clearly lacks the possibility of adding multiple SQL Server instances at once.

Understanding the problem

Don’t think that this is an overblown statement. Just imagine large corporations with a huge amount of SQL Servers, we’re talking hundreds here, both local and scattered around the network waiting to be discovered and used.

And now, here is a person that needs to do a simple task like pulling the build numbers for all SQL instances that are currently managed. First and foremost, the connection between every single one of those instances needs to be established in order to use and manage them. To connect them via the SSMS, every SQL Server instance needs to be manually added. Just imagine hundreds of instances that need to be added one-by-one. It is clearly an exhausting task, without any exaggeration.

In this case, the performance and productiveness of a database administrator could take a massive hit, and to some, this may end up being a dealbreaker, to others the necessary hassle.

Another thing that needs to be mentioned here is that once the SSMS is closed or restarted, on the new application launch, the connection to previously managed instances is lost, and those needs to be added again, manually.

In this article, we will take a look into the process of adding SQL Server instance via SSMS and then provide an insight into the different ways of accomplishing the same by using the 3rd party alternative, ApexSQL Manage.

With all being said, let’s dive into the process of connecting a SQL instance in the SQL Server Management Studio.

Connect SQL instance in SSMS

To connect a SQL instance in SSMS, one should do the following:

Launch the SQL Server Management Studio

Once the software is initialized, by default, the Connect to Server window will pop-up:

Here, configure the following:

From the Server type drop-down list bellow can be selected:

Database Engine – the core component of SQL Server instance used for storing, processing and securing

Analysis Services – SSAS is a multidimensional analysis tool that features Online Analytical Processing (OLAP), powerful data mining abilities and reporting used in Business Intelligence to ease your managing data tasks

Reporting Services – SSRS is a reporting and visualization tool for SQL Server, and by using it, one can create, manage and publish reports and dashboards

Integration Services – SSIS is a fast and flexible data warehousing tool that can be used for data extraction and for executing a wide range of data migration tasks

Azure-SSIS Integration Runtime – the Integration Runtime (IR) is the compute infrastructure used by Azure Data Factory to provide the data integration capabilities across different network environments

This is where the Database Engine option should be chosen.

In the Server name drop-down list, choose the preferred SQL Server instance to make a connection with. Here, the previously used SQL instances are listed:

If the desired SQL instance is not listed, choose the Browse for more… option at the bottom of the drop-down list:

Under the Local Servers tab of the Browse for Servers window, displayed are all SQL instances installed on the local machine. In addition to this, under the same tab, all configured SQL Server Services are listed as well:

In the Network Servers tab, SQL instances discovered across the network are shown:

Once the SQL Server instance is selected, proceed to choose the Authentication mode. In its drop-down list the following options are displayed, and the majority of those with their own set of configurable settings:

Windows Authentication – this mode allows a user to connect through a Windows user account

SQL Server Authentication – anytime this mode is used, proper login and password credentials are required

Azure Active Directory – Universal with MFA – this mode delivers strong authentication with a range of different verification options the user can choose from: phone call, text message, smart cards with a pin or mobile app notifications

Azure Active Directory – Password – use this mode for connecting to SQL Server instance database and when logged in to Windows using Azure AD credentials from a domain not combined with Azure

Azure Active Directory – Integrated – this mode is used when connecting to SQL Database and logged in to Windows using Azure Active Directory credentials from a federated domain

After the proper authentication is chosen, click the Connect button to establish the connection between the SQL Server Management Studio and the selected SQL Server instance:

Now, the SQL instance is shown in the Object Explorer on the left with all its properties and objects:

To view the build number for this newly connected instance, right-click on its name and choose Properties:

Build number details are now listed in the General tab of the Server Properties window:

To add another SQL instance and view its build number, click the Connect drop-down menu and choose the Database Engine option:

In the Connect to Server window, configure the same settings based on the previously described steps:

Once a new instance is added, repeat the same steps to see its build number.

And this set of actions will have to be repeated numerous times in order to complete one simple task.

Using 3rd party software

ApexSQL Manage is a powerful application used for managing SQL instances. Some of its core features and capabilities ensure the user can easily discover instances across the network, execute high-level analysis in the search for SQL Server health issues, capture real-time state and condition of SQL Server instance by creating its snapshot, to make a comparison between instances and snapshots as well as to document them in various file formats.

In this section, the focus will be on the versatility mentioned in the introduction part of this article.

In that regard, the SQL manage instance tool offers a few more options when it comes to adding SQL Servers and making connections to the preferred SQL instance and the application itself. Also, it offers the “welcomed” capability of easily adding multiple SQL instances at the same time.

Following are the mentioned options:

Add SQL Instances manually – like in SSMS, SQL Server instances could be added manually and only one at a time

Add SQL instances discovered on a network – configure a search setting that will ensure scan will be executed on the specific area of network

Add SQL instances from the last scan – no new scan is required since the SQL manage instance tool remembers the results from the last scan being performed

Add SQL instances automatically – a scan can be automated and set to be executed in the desired time and frequency

Add SQL instances with quick action option – execute quick scan based on the previously configured settings

Note: For more information on this topic, please visit the Different ways of adding SQL Server instances in a SQL manage instance software article.

Completion of the example task will now look quite different, i.e., it can be done in just a couple of steps. The first step is to choose the preferred method for adding SQL instances, and with the connection between them and SQL manage instance software is established, they will be listed in the main grid of the Inventory tab. Their build versions will be displayed in the Build number column.

The second and final action would be to just read out build versions from the column. It is quite convenient that all build versions of connected instances can be seen at once:

Conclusion

When in need to manage multiple SQL instances at the same time, one doesn’t have to add them one-by-one to perform certain management tasks since there is a solution to achieve this feat instantly and quickly. This will save some valuable hours from daily work chores, helping up in reducing some pressure and, to an extent, increasing one’s productivity.

#SQL Solution Center

0 notes

employmentusanet · 6 years ago

Text

[Full-time] Sr. cloud Engineer at CILLIUM

Location: New York Description: Sr. Software Engineer (.Net & Azure) Under the supervision of the Cloud Software and Services Functional Manager, the incumbent will have overall responsibility for the technical designs on which functional and non-functional requirements (which reflect the medical device and healthcare business needs of the R&D) can be met. Additionally, the incumbent will provide end to end cloud solutions for data capture and data integration with medical devices and healthcare applications, define the application components, interfaces, architectures based on multiple mobile platforms and cloud platforms. The incumbent will also work closely with the cloud and data service team to ensure that solutions are adhering to our long-term strategy and following best practices which must be documented and updated regularly. Responsibilities: o Provide technical strength to development teams and collaborating with architects, development teams, and business teams to ensure solutions are developed with best practices. o Work with Cloud teams in developing a DevOps strategy for the builds and deployment of software solutions including assisting in picking the right tools. o Develop PowerShell scripts and ARM templates to automate the provisioning and deployment process o Design the appropriate Azure solutions (Azure IaaS, PaaS, SaaS, FaaS, etc) based on R&D technology strategies and requirements o Troubleshoot and identify performance, connectivity, security and other issues for the applications hosted in Azure platform o Develop custom features in Visual Studio based on specifications and technical designs in a timely manner o Design and implement MSMQ (Microsoft Messaging Queue) and AppFabric Cache. o Design and develop client-server software modules and protocols/APIs to integrate devices and application systems, including Bluetooth enabled devices, mobile device applications and cloud enabled applications. o Participate in the conceptual phases of identifying and solving business problems and initiatives, conducting design and development of feasibility prototypes of system features and technology, formulating an architectural vision to drive delivery o Responsibility for mentoring and advising development teams, and other roles that interface with development, participate in the Production deployment process as needed o Advise leadership about industry best practices, trends, and technology, analyze the current Cloud environment to detect critical deficiencies and recommend solutions for improvement o Ensure functional requirement specifications and technical protocol API specifications are well documented and followed o Work with business to coordinate Azure deployments, cutover, and go live per SILC and needs o Audit access on a regular basis to ensure security has not been compromised Skills & Experience o Bachelor of Science in Computer Engineering, Computer Science or Electrical Engineering, with 10 plus years of experience, or MS with 6 plus years of experience o Design and implementation Experience using the OAuth 2.0 authorization framework for Authorization/Authentication services o 4+ years of hands-on development experience using .NET technologies (.Net, C#, WCF services and cloud design patterns). o Strong programming experience including Object-Oriented Programming, Design Patterns, Web Services o Demonstrated experience in Microsoft technologies including IIS, SSIS, SSRS, Entity Framework, WCF Framework, WPF (Windows Presentation Foundation) o Deployed application with RESTful/SOAP services interfaces o 3+ years of working experience using SQL Server 2016 or higher, Azure SQL DB and/or NoSQL Databases. o Advanced knowledge of SQL queries, stored procedures, triggers, indexes, data types, table structures, and database design principles. o Create automation tasks and runbooks on all functions for future use o 3+ years of Azure Cloud working experience and cloud solution expertise ( Azure IaaS, PaaS, SaaS, FaaS) o Expertise in hybrid cloud solutions with implementation experience of integrating public cloud into tradition/private hosting/cloud models o Solid experience in Azure cloud migration (on premise to Cloud platforms), implementation and security management in all different levels o Strong understanding of API-First application approach, experience in developing and deploying application solutions on Azure o Experience with client-server transaction-level synchronization and back-end synchronization/replication. o Proven record in full life cycle software development and delivery o Experience with system performance problem analysis, triage, and solution activities. Able to untangle web of issues, prototype, and deliver recommendations to resolve tough system problems. o Excellent oral/written communication skills (passionate, persuasive, and assertive) o Self-motivated, self-starter, confident in working in multinational environments with onsite/offshore model. cilliumjobsatcilliumdotcomPreferred o BS in Computer Engineering or Electrical Engineering with 12 plus years of experience or MS in Computer Engineering or Electrical Engineering with 8 plus years of experience o Medical devices/regulated industry product development background preferred o Design and implementation of security around Web Services and Relational database preferred. o Experience with healthcare standards such as FHIR, HL7 o Microsoft Azure certifications a plus o Agile/SCRUM certifications a plus o Working with software development / requirements analysis tools preferred Reference : Sr. cloud Engineer jobs Apply to this job from employment-usa.net http://www.employment-usa.net/job/28366/sr-cloud-engineer-at-cillium/

0 notes

americajobsnet · 6 years ago

Text

[Full-time] SQL DBA at neena

Location: California URL: https://www.jobisite.com Description: Position Title SQL DBA Primary Skill SQL Server DBA experience with 2012 or newer,SSIS,SSRS,,SQL Server Stored Procedure Design and implementation,SQL Server database troubleshooting and query optimization,Performance monitoring,Database The client is looking for someone who has a strong understanding of SQL Server database administration, with experience developing in SSIS and XML..This position will be an addition to our database support team of three SQL Server DBAs. This person will help shape the department's future SQL Server vision from database standards and policies to automation efforts for deployment. The ideal candidate will have experience implementing databases in the cloud and will have experience with continuous integration and automation concepts. RESPONSIBILITIES: â€¢ Perform day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.). â€¢ Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. â€¢ Refine and automate regular processes, track issues, and document changes. â€¢ Effectively prioritize and manage concurrent projects, demonstrate initiative, and work independently with minimal supervision. â€¢ Drive results and leverage past experiences to improve the environment and related processes. â€¢ Coordinate with other agency departments to update and integrate processes as necessary. â€¢ Demonstrate leadership skills (foster a spirit of teamwork, mentor peers, and take ownership of assigned project work). â€¢ Install and configure SQL Server, applying service packs and feature packs. â€¢ Apply data modeling techniques to ensure integration and performance expectations are met as well as allow for future flexibility to meet changing business needs. â€¢ Assist developers with complex query tuning and schema refinement. â€¢ Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps. SKILLS REQUIRED FOR THIS POSITION â€¢ SQL Server DBA experience with 2012 or newer. [REQUIRED] 8 years â€¢ SQL Server Integration Services (SSIS) [REQUIRED] 8 years â€¢ SQL Server Reporting Services (SSRS) [REQUIRED] 8 years â€¢ SQL Server Stored Procedure Design and implementation [REQUIRED] 8 years â€¢ SQL Server database troubleshooting and query optimization [REQUIRED] 8 years â€¢ SQL Server Database Performance monitoring [REQUIRED] 8 years â€¢ SQL Server Database Design [REQUIRED] 8 years â€¢ Expert understanding of Database best practices [REQUIRED] 8 years â€¢ Experience upgrading databases from lower to latest versions [REQUIRED] 6 years â€¢ Strong technical and project management skills, as well as the willingness to engage in a hands-on way, to provide specific technical guidance and leadership - [REQUIRED] 6 years â€¢ Strong written and verbal communication skills [REQUIRED] 6 years â€¢ Data Warehousing concepts [REQUIRED] 3 years â€¢ Operational automation using scripts (knowledge of Octopus Deploy and DbUp preferred). [REQUIRED] 2 years â€¢ Familiarity with Agile (Scrum and/or Kanban) methodology [REQUIRED] 2 years â€¢ Databases migration using Azure &/or AWS [Highly desired] â€¢ Experience in performing DR techniques - Always On, Clustering, Replication, Database mirroring, etc. [Highly desired]. Reference : SQL DBA jobs Apply to this job from America Jobs http://www.america-jobs.net/job/48889/sql-dba-at-neena/

0 notes

jobsaggregation2 · 5 years ago

Text

Windows/SQL Server Admin

local candidates strongly preferred interviews to be conducted by Skype or Google Hangout some after-hours and weekend hours required based on workload candidates must participate in on-call rotation candidate hired will work ONSITE 50% of the time NOW, NO exceptions, and work ONSITE 100% of the time after restrictions are lifted General Job Description: This resource will work as part of the Virginia Department of Health, Office of Information Management (OIM-DBA) team. The team member will assist in maintenance and administration of SQL Server databases that support critical multi-tier applications implemented mostly in Windows environment using MS suite of tools. The resource will also support administration and maintenance of the agency website that uses Wordpress/MySQL set-up. The OIM-DBA team is currently tasked with developing a migration plan to transition from traditional data center environment to the Cloud infrastructure (private/AWS/Azure); the resource will help in coordinating this effort, provide technical assistance in configuring the new set-up with emphasis on security, compile test plans, implement and adopt new features, set-up monitoring and automate processes; document time and effort. The contractor should be able to work and communicate with vendors if required and share timely updates with the team. Sql server administration starting from 2008/2012/2016 versions with Alway-On SQL Server in Azure, AZure SQL T-SQL, Stored Procedure, SSIS, SSRS IIS with Security experience s - Experiences in Azure - VM, App Service Experiences in Azure - VM, App Service, Azure AD, Azure Storage Wordpress Administration MySQL and Amazon RDS for MySQL Windows Server 2008+/Linux Redhat v7+ .NET Development: ASP.NET, ASP.NET MVC, WPF, WCF Tomcat, NGINX Tableau administration Sql server backup/recovery/performance tuning Quest Spotlight for SQL Server Enterprise ArcGIS setup/administration -- Reference : Windows/SQL Server Admin jobs from Latest listings added - JobsAggregation http://jobsaggregation.com/jobs/technology/windowssql-server-admin_i10427

0 notes

nox-lathiaen · 5 years ago

Text

Windows/SQL Server Admin

local candidates strongly preferred interviews to be conducted by Skype or Google Hangout some after-hours and weekend hours required based on workload candidates must participate in on-call rotation candidate hired will work ONSITE 50% of the time NOW, NO exceptions, and work ONSITE 100% of the time after restrictions are lifted General Job Description: This resource will work as part of the Virginia Department of Health, Office of Information Management (OIM-DBA) team. The team member will assist in maintenance and administration of SQL Server databases that support critical multi-tier applications implemented mostly in Windows environment using MS suite of tools. The resource will also support administration and maintenance of the agency website that uses Wordpress/MySQL set-up. The OIM-DBA team is currently tasked with developing a migration plan to transition from traditional data center environment to the Cloud infrastructure (private/AWS/Azure); the resource will help in coordinating this effort, provide technical assistance in configuring the new set-up with emphasis on security, compile test plans, implement and adopt new features, set-up monitoring and automate processes; document time and effort. The contractor should be able to work and communicate with vendors if required and share timely updates with the team. Sql server administration starting from 2008/2012/2016 versions with Alway-On SQL Server in Azure, AZure SQL T-SQL, Stored Procedure, SSIS, SSRS IIS with Security experience s - Experiences in Azure - VM, App Service Experiences in Azure - VM, App Service, Azure AD, Azure Storage Wordpress Administration MySQL and Amazon RDS for MySQL Windows Server 2008+/Linux Redhat v7+ .NET Development: ASP.NET, ASP.NET MVC, WPF, WCF Tomcat, NGINX Tableau administration Sql server backup/recovery/performance tuning Quest Spotlight for SQL Server Enterprise ArcGIS setup/administration -- Reference : Windows/SQL Server Admin jobs Source: http://jobrealtime.com/jobs/technology/windowssql-server-admin_i11141

0 notes

salesforcetrainingstuff-blog · 6 years ago

Text

We have an urgent requirement for “Analyst Programmer – POWER BI” in Melbourne.

Australian PR/Citizen is Must

Permanent/ Contract

Start Date: Immediate

Job Description:

1. 3-5 years of relevant IT experience

2. 2+ years’ experience in Power BI, SSIS, SSRS, SSAS, and SQL Server

3. Knowledge and experience in other tools such as Tableau

4. Migration of reports to POWER BI from other reporting tools like QlikView or Business Objects

5. Basic Knowledge in Azure ML, R, Python, TensorFlow

6. Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)

7. Familiarity with Data modeling, Data Integration, and testing

For more details please email your profile to: [email protected]

For More: https://www.linkedin.com/feed/update/urn:li:activity:6552033960233402368

For more details about this role, Please visit our website careers page: https://www.bmptechnologies.com.au

#bmptechnologies #jobsearch #jobseeking #jobscheduling #jobscanning #melbournejobs #jobsinau #jobsinaustralia #jobshunting #lookingforjobchange #jobchange #jobsinAustralia #jobsearchAustralia #careeropport #careerplanning #careerdevelopment #careersAustralia #JobOpportunities #careeropportunities #jobs #career #Hiring #Australia #Melbourne #Jobs4U #citizen #businessobjects #queries #powerbi #sqlserver #ssas #ssis #azureml #dataintegration #qlikview #ssrs #tableau #sql #urgentrequirement #datamodeling #python #tensorflow #migration #programmer

0 notes

jobisitejobs · 6 years ago

Text

SQL Developer

PLEASE NOTE*** The client is ONLY scheduling IN-PERSON INTERVIEWS for this position. They WILL NOT schedule webcam or phone interviews. Please ONLY SUBMIT CANDIDATES who can EASILY ATTEND an IN-PERSON INTERVIEW if selected to interview***

While working on system enhancements, the successful candidate is expected to propose, design, and develop solutions in concert with the front-end developer(s) to fulfill the business requirements ? individual needs to work well in a team and independently as needed.

The successful candidate will be required to follow standard practices for migrating changes to the test and production environments and provide post-production support. When not working on enhancement requests or problem reports, the candidate would concentrate on performance tuning.

Responsibilities:

Assist in designing, developing, and enhancing large transaction and reporting databases.

Assist in converting existing Legacy applications to newer technologies

Assist in integrating in-house applications with third-party enterprise solutions.

Design, create and implement database systems based on the end user's requirements.

Develop database schemas, tables and dictionaries using SQL server 2008 R2, 2012, and 2016.

Translate business requirements into software applications and models.

Develop and maintain efficient, well-documented custom SQL scripts; stored procedures triggers using Microsoft T-SQL by defined business rules and requirements to support application development

Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans. Recommend query and index improvements in application to increase performance.

Thoroughly test all approved application and database code additions and changes before implementing to staging. Request approval from users before implementing any additions or changes to the production environment.

Research, understand and apply best practices, cost-effective solution, policies and procedures towards all assigned tasks, roles and responsibilities.

Use the Microsoft Team Foundation Server (TFS) to manage changes to the code.

Participate in requirement analysis discussions and come up with an efficient technical solution

Develop new and maintain existing reports using SQL Server Reporting Services (SSRS)

Build and Deploy ETL processes using SQL Server Integration Services (SSIS).

Required Experience

Demonstrated experience with relational database design and implementation using MS SQL Server

Experience optimizing SQL queries for improving performance and maintaining data integrity

Experience in creating database migration scripts by using schema and data compare tools

Experience in creating batch packages using SSIS

Experience in creating reports using SSRS

Experience in architecting, writing and maintaining RESTful APIs/Services

Write efficient, consistent and testable code

Proficiency with using Visual Studio 2012,2015 & 2017

Ability to understand and analyze the business requirements and come up with a practical technical solution

Demonstrated experience in SOA and web service development

Experience in using LINQ

Demonstrated experience with C#, .NET framework, and object-oriented design/development.

Demonstrated experience with Microsoft Azure cloud services

Being able to work with minimal requirements and improve the functionality as requirements are refined

Technical understanding of infrastructure components, their dependencies, and interactions between servers, virtual systems, networks, databases, web applications, etc.

Required Skill

Experience with working with different versions of SQL server (2008 R2, 2012 and 2016) 5+ years

Expert knowledge of TSQL ? 5+ years

Database modeling & Design ? 5+years

Experience in creating batch packages using SSIS ? 3+ years

Experience in creating reports using SSRS ? 3+years

Experience optimizing SQL queries for improving performance and maintaining data integrity ? 5+ years

Experience with C#, .NET framework, and object-oriented design/development ? 5+ years

Experience in architecting, writing and maintaining RESTful APIs/Services ? 5+years

Experience in using LINQ ? 5+ years

Experience with Microsoft Azure cloud services ? 1-year minimum

Proficiency with different versions of Visual Studio (2012,2015 & 2017) ? 5 + years

SQLDeveloper from Job Portal https://www.jobisite.com/extrJobView.htm?id=155898

0 notes

usajobsite · 6 years ago