UBA Solutions incorporated on February 12, 2006, is one of the pioneer IT companies in 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 with 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 “O ... ne of the Most Innovative Companies in Design for 2018” by Fast Company. Monotype brings brands to life through type and technology that consumers engage with every day. The company's rich legacy includes a library that can be traced back hundreds of years, featuring famed typefaces like Helvetica, Futura, Times New Roman and more. Monotype also provides a first-of-its-kind service that makes fonts more accessible for creative professionals to discover, license, and use in our increasingly digital world. We work with the biggest global brands, and with individual creatives, offering a wide set of solutions that make it easier for them to do what they do best: design beautiful brand experiences. Want to learn more about who we are and how you can become part of our team? Visit us at www.monotype.com 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.
View Company ProfileDatabase Administrator
Job summary
-
No. of Vacancy
: 1 -
Job Type
: Full Time -
Offered Salary
: Negotiable -
Gender
: Both -
Career Level
: Mid Level -
Experience
: 4-6 Years -
Apply Before
: 2024-12-22 (10 Days Left) -
Skills
:ETLMySQLSQLTableau
Job Description:
- 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.
- Genera tetraces, and 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 the 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.
Required Knowledge, Skills, and Abilities:
Database Administration:
- Manage databases: MSSQLServer, MySQL, PostgreSQL, MongoDB, Oracle.
- Administer AWSRDS for MySQL, PostgreSQL, and 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 SQLServer clustering and high availability (HA) technologies.
- Utilize SQL Server management tools like Redgate.
What we’re looking for:
- Working knowledge in MySQL andIn-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, logshipping, 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.
- Mono type 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.
Education + Experience:
- 4-6 years of working experience in Advanced administration of databases like MS SQL server, MySQL (incl. Amazon Aurora).
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.
Job Action
Company others jobs
-
Senior Software Dev... UBA Solutions Pvt. L... 10 Days Left Quick ViewLead Software Engine... UBA Solutions Pvt. L... 10 Days Left Quick ViewENGINEERING MANAGER UBA Solutions Pvt. L... 10 Days Left Quick ViewDirector of Engineer... UBA Solutions Pvt. L... 10 Days Left Quick ViewDevops Engineer II UBA Solutions Pvt. L... 23 Days Left Quick View
Related Jobs
-
Principal Software E... Infinite Computer So... 8 Days Left Quick View