Senior Data Warehouse DevOps Specialist at NTT Ltd.

Senior Data Warehouse DevOps Specialist

We are looking to employ engineers/developers who will be responsible for designing, developing, and supporting database structures and scripts and ensuring their stability, reliability, and performance. Candidates will be working in a very dynamic DevOps team on a global information platform, and will be expected to work with global and regional BI teams to assist with developing BI and Data Management solutions and establishing best practices. A large part of the role will also focus on developing data acquisition solutions across a wide range of source systems.

Responsibilities:

• Develop and optimise SQL tables, views, procedures, and query statements
• Develop acquisition solutions, which will include SQL/SSIS/DS, Log Reader Replications, ESB technologies, and bespoke API solutions
• Develop and maintain optimal SQL Indexing strategies
• Ensure performance, security, and availability of databases and associated services
• Handle common database procedures like upgrades, backups, recovery, migration, etc.
• Profile server resource usage, and optimise and tweak as necessary
• Create, manage and optimise SQL server jobs
• Evaluate new technologies and be able to build Proofs of Concepts
• Prepare design specifications, and detailed solution documentation
• Collaborate with other team members and business stakeholders
• Participate in Agile ceremonies like feature/story development, backlog grooming, and daily scrums

Skills & Qualifications:

• IT Degree/Diplomas/Certifications – must demonstrate in-depth knowledge of working with servers, networks, computer resources, etc.
• Certified on SQL Server 2014 or later (2016 preferred)
• Certified on SAP Hana 2.0 or later (SP02+ preferred)
• Minimum 5-7 years’ experience on Microsoft SQL Server technology stack (SQL, MDS, SSIS, Analysis Services, On-premise gateways, Power BI, Azure) - especially in large scale data environments
• At least 1-2 years’ experience on SAP Hana technology stack (SQL, XSC/XSA, SDA, SDI, DP Agents, SAP Data Services)
• Skilled at optimising large complicated SQL statements
• In depth understanding of SQL Server Indexing and profiling capabilities
• Comprehensive understanding of data modelling best practices
• Deep knowledge of SQL Server and/or Hana security architecture
• Knowledge of best practices when dealing with relational and column store database technologies
• Capable of configuring and maintaining SQL Server and/or Hana in a clustered server environment on Windows Server and/or SUSE Linux (for SAP Hana)
• Ability to plan resource requirements from high level specifications
• Capable of troubleshooting common database issues
• Capable of using and troubleshooting Analysis Services multidimensional and tabular cubes for MS SQL and/or Analytical Views for SAP Hana
• Proficient understanding of Visual Studio, SQL Management Studio, SAP Hana Studio & Web IDE, and versioning solutions like Team Foundation Services, GitHub, etc.
• Experience with developing ETL solutions
• Experience with ESB/Queueing technologies like RabbitMQ
• Experience with Web Service integration components like SOAP, JSON, XML, etc.
• Experience with Log Reader replications like SQL Server Transactional Replication or SAP Smart Data Integration
• Experience with programming languages like C# .Net, VB .Net, ASP.Net, Python