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. It is crucial that we take on the challenge of accelerating the pace of change and this will need our unwavering energy. Developing and deploying our technology and solutions, combined with our expertise, co ... ntributes to long-term customer value creation and a real and positive human impact. Electricity will be the backbone of the entire energy system. Together with customers and partners, we are shaping collective action to provide the needed technologies, new ways of thinking and new ways of working. By combining advanced digital solutions and services, such as Hitachi Lumada, with our energy platform, that is built on unique domain expertise and experience, we are helping to make the energy system more resilient and secure.
View Company ProfileSenior Database Administrator
Job summary
-
No. of Vacancy
: 1 -
Job Type
: Full Time -
Offered Salary
: Negotiable -
Gender
: Both -
Career Level
: Senior Level -
Experience
: 5 Years -
Apply Before
: 2024-04-24 Closed -
Skills
:DatabasesSQL
Job Description:
- Define and model data requirements.
- Create and manage multiple databases and assist in capacity planning.
- Monitor, maintain database systems and troubleshoot problems that may arise
- Maintain data integrity and security (manage roles and permissions of database users
- Use tools like SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them.
- Assist in developing strategies and implementing solutions for managing back-ups, restoration and replication.
- 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.
- Identify database framework gaps and design solution to fix the gaps and enhance the framework.
- Support software developers with database operations including the development of complex SQL, tuning of DML, the creation of stored procedures and adopt new features provided by newer database versions.
- Effectively coordinate and communicate with all the stakeholders (internal teams and clients).
- Mentor and monitor juniors on database related tasks to improve team efficiency.
- Conduct regular code review of team members.
- Research and learn relevant business processes and understand the data flow, criticality and dependencies.
- Create detailed documentation including diagrams of database infrastructure.
- 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.
Required Knowledge, Skills, and Abilities:
- Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
- Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
- Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
- 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).
- Ability to develop procedure documents and maintain detailed database related documents.
- Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies
- Knowledge on Azure SQL Server Managed Instance, Azure SQL Database
- A multitasker, and team player who has patience and ability to handle job pressure.
Education + Experience:
- Minimum of bachelor's degree in computer engineering or equivalent.
- 5+ years of experience in Database Administration and managing multiple MS SQL 2016 (or higher) RDBMS on large systems.
Apply Instruction:
Interested candidates fulfilling the mentioned criteria are encouraged to Apply using the Easy Apply Button below. Registered candidates may also apply using the Apply Now Button.
