Job ID: R0040841
Date Posted: Feb 22, 2024
Company Name: PIONEER SOLUTIONS NEPAL PVT. LTD.
Profession (Job Category): Data Analytics/Business Intelligence
Job Type (Experience Level): Experienced
Job Schedule: Full time
At Hitachi Energy our purpose is advancing a sustainable energy future for all. We bring power to our homes, schools, hospitals, and factories. Join us and work with fantastic people, while learning and developing yourself on projects that have a real impact to our communities and society. Bring your passion, bring your energy, and be part of a global team that appreciates a simple truth: Diversity + Collaboration = Great Innovation
Hitachi Energy is co-creating global and local solutions to solve the global challenge of an inclusive and equitable carbon-neutral future. We achieve this across industries, geographies and for every step on each customer’s unique journey.
Define and model data requirements.
Create new and update existing databases as per the requirement.
Monitor the database performance and verify that it’s running properly at all levels.
Troubleshoot if any kind of performance issue arises.
Coordinate with the IT team to create backup and recovery plans and procedures.
Identify the potential risk of database software and work towards minimizing those risks.
Provide first level of support for any database related issues raised by team members.
Help team members to adopt new features provided by newer database versions.
Identify database framework gaps and design solution to fix the gaps and enhance the framework.
Mentor and monitor juniors on database related tasks to improve team efficiency.
Conduct regular code review of team members.
Take ownership of projects for its timely delivery including (but not limited to) planning, estimation, development approach, assignment, reporting etc.
Involve in performance evaluation of team members.
Living Hitachi Energy’s core values of safety and integrity, which means taking responsibility for your own actions while caring for your colleagues and the business.
Minimum of bachelor’s degree in computer engineering or equivalent preferred
2+ years of experience in Database Administration and managing multiple MS SQL 2016 (or higher) RDBMS on large systems.
Experience in Performance Tuning and Query Optimization.
Knowledge of index management, integrity checks, statistics, configuration.
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Partitioning.
Knowledge of SQL Server tools (Profiler, SSMS, PerfMon, DMVs, and system sprocs).
SQL Development – ability to write and troubleshoot SQL Code and design.
Excellent verbal /written communication skills, Documentation skills for processes and procedures.
A multitasker, and team player who has patience and ability to handle job pressure.