Send me more jobs like this

BI Operational Specialist

Keywords / Skills : BI Operational Specialist, SQL Database, Query, SQL DBA, T-SQL, ETL, SSIS , Azure SQL database, BI DevOps , Azure Analysis Services

3 - 6 years
Posted: 2019-07-26

Nationality
Philippines
Industry
IT/Computers - Software
Function
IT
Role
System Analyst/Tech Architect
Database Administrator (DBA)
Education
Bachelors
Degree
Posted On
26th Jul 2019
Job Description
Responsibilities: 
  • MS SQL Database and Query Optimization and Overall Performance responsible 
  • Monitoring of Data Warehouse ETL batch jobs, collaborating with BI DevOps team on implementing performance improvement changes 
  • Release and Deployment of new DW components in Production environment 
  • MS SQL Database Administration, including access management, backup/recovery and patching of production and management of lower environments (development, test, QA, UAT) 
  • MS SQL infrastructure and resource monitoring (capacity, memory and disk space) & troubleshooting 
  • Incident and Request ticket and Problem records management for BI 
  • Initial investigation of incidents and implementation of workarounds and/or quick fixes 
  • Execution of application-specific complex tasks 


Qualifications: 
  • Strong MS SQL DBA background, and experience from similar operational role 
  • Experience with full-scale and partial deployment methods and practices 
  • Exceptional T-SQL skills, also within execution planning and profiling 
  • ETL and SSIS Experience 
  • Experience with Azure SQL database and Azure Analysis Services 
  • Experience with Team Foundation Server 


About Company

ProV was founded in 2003 to reduce IT complexity by using services and technologies that don't get in the way - powerful enough to meet the complex demands facing today's enterprises. By streamlining processes, we help companies improve productivity and reduce errors while still saving money. We've assembled a great team to help streamline enterprise day-to-day processes and change how IT implementation, management and support work. Now, ProV is a team of over 600 peers across offices in the US, Germany, India and the Philippines.

Our Shared Mission and Values

Our mission is to help companies thrive by enabling all processes to work together effortlessly.
Our values are commitments to each other. They provide the backbone for our company processes and daily interactions. We believe that, in the long run, these commitments lead to a thriving culture and a more successful business, for ourselves and our customers.

Inclusion is part of our company culture and essential to ProV’s future. We continue to nurture and create opportunities for the next generation, relying on our talent pool’s diverse background to innovate and inspire. More importantly, we see hundreds of ProV employees speaking over 17 languages and working together. Our core values celebrate those differences and the rewarding experiences our customers enjoy
Similar Jobs
View All Similar Jobs


Walkin for you