Skip to main content

Careers Home > Job Search Results > Senior Database Administrator

Senior Database Administrator

Location: Kathmandu Nepal
Job ID: R0036156
Date Posted: Dec 2, 2023
Profession (Job Category): Data Analytics/Business Intelligence
Job Type (Experience Level): Experienced
Job Schedule: Full time
Remote: No

Share: mail
Save Job Saved


Your responsibilities:

  • 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

Your background:

  • 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. 

  • 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.

Share: mail