Database Administrator

UBA Solutions
Imadol, Lalitpur

Job Description

 What you’ll be doing: 

  • Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures. 
  • Effectively coordinate and communicate with all the stakeholders (internal teams and stakeholders). Advise developers on the most efficient database designs. Set up and maintain database infrastructure. 
  • Learn relevant business processes and understand the data flow, criticality and dependencies. 
  • Troubleshoot SQL Server service outages as they occur, define SLA and ensure support when required. 
  • Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them. 
  • Enhancements and Improvements to Existing Database Systems Infrastructure.
  • Determine the most effective way to increase performance including hardware recommendations, server configuration changes, performance tuning etc. 
  • Setup and test High-Availability as part Disaster Recovery Strategy for the Databases to ensure ability to meet the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). 
  • Execute data migrations to/from various platforms/engines and database upgrades.
  • Maintain data integrity and security (manage roles and permissions of database users).
  • Manage production, staging, and development database environments.
  • Proactive housekeeping of databases. 
  • Configure SQL Server monitoring utilities to minimize false alarms. 
  • Create detailed documentation including diagrams of database infrastructure. 

Key Responsibilities: 

Database Administration: 

  • Manage databases: MS SQL Server, MySQL, PostgreSQL, MongoDB, Oracle.
  • Administer AWS RDS for MySQL, PostgreSQL, SQL Server. 
  • Implement master-slave, active-active, and backup strategies. 
  • Optimize performance and conduct query analysis. 

Cloud and Tools: 

  • Use AWS services: Redshift, S3, RDS. 
  • Implement SQL Server clustering and high availability (HA) technologies. 
  • Utilize SQL Server management tools like Redgate. 

What we’re looking for: 

  • 5-7 years working experience in Advanced administration of database like MS SQL server, MySQL (incl. Amazon Aurora) 
  • Working knowledge in MySQL and In-Memory Databases (Redis, MongoDB, etc.) 
  • Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems. 
  • Experienced in SQL Server Integration Services (SSIS) 
  • Experienced in ETL (Extract-Transform-Load) development / data integration.
  • Experience in creating data hooks for analytics tools like – PowerBi, Tableau, Insights. 
  • Sound knowledge of RDBMS concepts, database design and SQL/T-SQL. 
  • Experience in SQL Server Clustering and HA technologies including mirroring, log 
  • shipping, failover cluster and various replication technologies would be an advantage.
  • Have knowledge of SQL Server management tools like Redgate etc. 
  • Knowledge of various database platforms (SaaS, PaaS, IaaS, etc. ) 
  • Good to have experience on Mulesoft. 
  • Postgresql and sound knowledge of oracle Has an innovative approach to work, constantly looking to upgrade the system to more efficient and effective new technologies. 
  • Monotype is expanding globally. Proficiency in one or more of the following languages is desirable (not mandatory) for this role: German, Japanese, French, Spanish. 
  • Strong business sense and sense of urgency to achieve business results.

Source Merojob


Job Detail Expired

  • Job Type :

    Full Time

  • Salary :

    Not Disclosed

  • Experience :

    5 - 6 (Years)

  • No. of Vacancy :

    1

  • Min. Education :

    Bachelor Degree

  • Last Date to Apply :

    February 18, 2025


Contact Detail

Email : info@uba-solutions.com
Website : https://uba-solutions.com/
Mobile : 01-5201774
Alternate Mobile :

Sign In