Create a Job Alert.

Enter your email below to save this search and receive job recommendations for similar positions.
Thank you. We'll send jobs matching these to
You already suscribed to this job alert.
GB
0 suggestions are available, use up and down arrow to navigate them
CR

Business Intelligence Developer (DBA) job in San José at Emerson

Create Job Alert.

Get similar jobs sent to your email

List of Jobs

Apply to this job.
Think you're the perfect candidate?
Apply on company site
Business Intelligence Developer (DBA) at Emerson

Business Intelligence Developer (DBA)

Emerson San Jose de Costa Rica/San Jose, San José Province Full Time
Apply on company site
Description

The main activity of the job is to provide business users the entire Emerson Process Managements operational data in an informative format viewable in reports. Business users use the data in the reports to make strategic business decisions. In order to make this large volume of data accessible in usable reports in very fast response times, the data has to be transformed into a particular format called dimensional data which is stored in data marts or data warehouses. This project involves designing and maintaining ETL (Extract-Transform-Load) mechanisms to download data from Emerson transactional database systems, then transform and load the data into Data Marts data warehouses to aid the creation of business reports that can enable users to make better decisions. The project uses Microsoft SQL Server as an Operational Database and Microsoft SQL Server Integration Services as its primary ETL tool to download data from Oracle, flat files systems, IBM source systems, SQL Server upstream databases. The project also uses various other tools for day-to-day project activities like Red Gate SQL Toolbelt, Microsoft Excel, SQL Server Reporting Services and Microsoft PowerShell.

Responsibilities

Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.

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.

Writing ETL jobs to download different types of data from Oracle to SQL Server Data Marts to support newer or existing reports

Implemented SSIS package configurations (Environment Variable and SQL Server)

Deployed, monitored, scheduled jobs and maintained SSIS packages.

Support a set of 150-odd ETL jobs which run in each ETL shift - 3 shifts running per day.

Designed and Developed reports based on requirements using SQL Server Reporting Services (SSRS) and deployed them. Extensively worked on cross-tabbed and Matrix reports using SSRS.

Requirements Gathering and Analysis for changes in ETL, support and performance improvements

Onsite Coordination and Status Reporting to the client.

Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members



Requirements

3-4 years MS SQL Server Administration experience required

Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools

Experience with backups, restores and recovery models

Experience with SSIS, SSRS and SSAS

Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server

Experience working with Windows servers, including Active Directory

Excellent written and verbal communication

Ability to multi-task and context-switch effectively between different activities and teams

At least a bachelor's degree in computer science, computer engineering, or related field.

[ Link removed ]  
Our Commitment to Our People
We invest in our employees to ensure they have the marketplace knowledge, skills and competencies to compete and lead in a global economy. Our training programs focus on end-to-end development from onboarding through senior leadership.
Flexible and competitive benefits plans offer you the right options to meet your individual/family needs
Our success is measured by the positive impact we make on people, our communities and the world in which we live. [ Link removed ] .
Our Commitment to Diversity & Inclusion
At Emerson, we are committed to fostering a culture where every employee is valued and respected for their experiences and perspectives. We believe a diverse and inclusive work environment contributes to the rich exchange of ideas that inspires innovation and brings the best solutions to our customers. This philosophy is fundamental to living our company’s values and our responsibility to leave the world in a better place.
Diversity and Inclusion at Emerson is about welcoming, respecting, and valuing the differences each employee possesses. Inclusion is creating a real sense of engagement, belonging and connection for all employees. Learn more about our [ Link removed ]  and about [ Link removed ] .

If you have a disability and are having difficulty accessing or using this website to apply for a position, you can request help by sending an email to [ Link removed ] .  

 



20191014-1001 

Emerson, a Fortune 500 company with $18.4 billion in sales, more than 20 Innovation, Solutions & Engineering Centers, and 200 manufacturing locations worldwide, is committed to helping employees grow and thrive throughout their careers. We are innovators, question-askers and problem-solvers. We don’t settle for good enough or “This is the way it’s always been done.” Instead, we push ourselves and strive for the “never been done before.” 

Our Automation Solutions business enables the greatest use of the world's most valuable resources, ensuring the performance and safety of industries that are the backbone of daily life.

Our Commercial & Residential Solutions business helps ensure human comfort and health, protect food quality and safety, advance energy efficiency and create sustainable infrastructure.

No calls or agencies please. 



 

Recommended Skills

  • Sql Server Integration Services
  • Sql Server Reporting Services
  • Sql Server Analysis Services
  • Extract Transform Load (Etl)
  • Information Security
  • Performance Tuning
Apply to this job.
Think you're the perfect candidate?
Apply on company site

Job ID: 21013183