UBA Solutions

Database Administrator

UBA Solutions

Database Administrator

UBA Solutions incorporated on February 12, 2006, is one of the pioneer IT companies of Nepal. UBA Solutions is a Monotype Partner Company working in collaboration with Monotype Inc. , a US-based multinational company since 2009. Headquartered in the Boston area of the United States and offices across 4 continents, Monotype is the world’s #1 company in fonts. It’s a trusted partner to the world’s top brands and was named “One of the Most Innovative Companies in Design for 2018” by Fast Company. Monotype’s fonts and technologies help bring brands to life! 

At UBA Solutions, we offer an entrepreneurial environment where technology professionals thrive and where individual contributions really count. Our employees create and help shape some of the most cutting edge technologies every day. 

As a partner of Monotype, our engineering teams use best in class advanced techniques and tools in Continuous Integration, LAMP, Node.JS, AWS, Reactjs and automated test solutions in the entire spectrum of solutions in areas like cloud services, e-commerce, embedded systems, digital advertising and brand engagement.

UBA Solutions incorporated on February 12, 2006, is one of the pioneer IT companies of Nepal. UBA Solutions is a Monotype Partner Company working in collaboration with Monotype Inc. , a US-based multinational company since 2009. Headquartered in the Boston area of the United States and offices across 4 continents, Monotype is the world’s #1 company in fonts. It’s a trusted partner to the …

Database Administrator

Views: 389 | Apply Before: 1 week, 2 days from now

Basic Job Information

Job Category : IT & Telecommunication
Job Level : Mid Level
No. of Vacancy/s : [ 1 ]
Employment Type : Full Time
Job Location : Imadole, Lalitpur
Offered Salary : Not Disclosed
Apply Before(Deadline) : Feb. 18, 2025 23:55 (1 week, 2 days from now)

Job Specification

Education Level : Under Graduate (Bachelor)
Experience Required : More than 5 years
Professional Skill Required : AWS Troubleshooting MySQL Communication Time Management Database Management

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.


Similar Jobs
Powered by Merojob AI

Job Action

More Jobs By this Company

Similar Jobs
Powered by Merojob AI
job_detail_page
Search, Apply & Get Job: FREE