Deerwalk Services

Software Companies

Software Engineer (Database)

Views: 1303|Published on: Jun 07, 2021

IT & Telecommunication

Mid Level

Full Time

Vacancy: 2

Kathmandu|

Experience: More than or equal to 2 years|

Not Disclosed

Job Description

Roles and responsibilities of this job

Writing and debugging complex SQL and understanding the best ways to incorporate database requests into application programs
Configure and maintain database servers, including monitoring of system health and performance and database processes, to ensure high levels of performance, availability, and security
Create data migration/conversion techniques for system conversions or upgrades
Manage Production, QA and development database environments
Learn relevant business processes and understand the data flow, criticality, and dependencies
Allocate system storage and plan storage requirements for database systems
Perform periodic health checks and reports on database systems
Develop innovation, strategies, processes, and best practices
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, and security issues
Create T-SQL packages, procedures, functions, triggers, alerts, scripts for automation, and DTS packages for ETL
Employ SSAS and SSRS to automate data and reporting requirements by customers, vendors, and state and federal regulatory agencies

Job Specification

Required qualifications for this job

Required Education Level:Under Graduate (Bachelor)

Required Experience:More than or equal to 2 years

Other Specification

Bachelor’s degree or equivalent in Computer Science, Information Technology or a related field
2+ years MSSQL Server Developer/Administration experience required
Strong knowledge of database design, administration, and architecture
Must have strong knowledge on stored procedure and query optimization
Understanding of MSSQL's underlying physical and logical files
Experience with backups, restores and recovery models
Knowledge and understanding of all aspects of database tuning: software configuration, memory usage, data access, data manipulation, SQL, and physical storage
Should have knowledge on database architecture and design
Knowledge of structure query language (SQL) e.g., SQL/PSM or Transact- SQL
Ability to develop procedure documents and maintain detailed database related documents.
Concept of Database-as-a-service
Experience with .NET programming as well
Good analytical, time management, troubleshooting, and decision-making skills
Excellent written and verbal communication skills

Skills Required

Required skills for this job

Analytical

Decision Making

Database Administration

MS SQL Server

Salary

Offered financial and non-financial compensation for this job

Offered Salary:Not Disclosed

Applying Procedure

Click on Login to Apply to get the email address / external link to apply.

Note: You need to be a registered jobseeker to view the applying email address / external link.

Apply Before: Jun 22, 2021

About the organization

Deerwalk Services

Software Companies

Sifal, Kathmandu, Central Development Region, Nepal

Deerwalk Services Pvt Ltd (Soon to be Cedar Gate Services Pvt Ltd) is a leading software company in Kathmandu, Nepal, providing various services such as software development & testing, data analytics & management, IT infrastructure development, and business process support services to its parent company, Cedar Gate Technologies, USA. We employ 500+ professionals in our Kathmandu office and continue to grow. For more information, visit: https://cedargate.com/ & https://www.deerwalk.com/