Requirements :-
● 4-6yearsworking experience in Advanced administration of database like MS SQL server, MySQL (incl. Amazon Aurora)
● Workingknowledge 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.
● SoundknowledgeofRDBMSconcepts, 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.
● HaveknowledgeofSQLServer management tools like Redgate etc.
● Knowledgeofvarious database platforms (SaaS, PaaS, IaaS, etc. )
● Goodtohaveexperience on Mulesoft.
● Postgresql and sound knowledge of oracle
● Hasaninnovative approach to work, constantly looking to upgrade the system to more efficient and effective new technologies.
● Monotypeisexpanding globally. Proficiency in one or more of the following languages is desirable (not mandatory) for this role: German, Japanese, French, Spanish.
● Strongbusiness sense and sense of urgency to achieve business results.
Job Responsibility :-
● Supportsoftware developers with database operations including the development of complex
● SQL,tuning of DMLandthecreation 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.
● Learnrelevant 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.
● Generatetraces, execution plans, identify performance issues, deadlocks/contention and resolve them.
● EnhancementsandImprovements to Existing Database Systems Infrastructure.
● Determinethemosteffective way to increase performance including hardware recommendations, server configuration changes, performance tuning etc
● Setupandtest 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).
● Executedata migrations to/from various platforms/engines and database upgrades.
● Maintaindata integrity and security (manage roles and permissions of database users).
● Manageproduction, staging, and development database environments.
● Proactive housekeeping of databases.
● Configure SQL Server monitoring utilities to minimize false alarms.
● Createdetailed documentation including diagrams of database infrastructure.
● Managedatabases: MSSQLServer, MySQL, PostgreSQL, MongoDB, Oracle.
● Administer AWSRDSfor MySQL, PostgreSQL, SQL Server.
● Implementmaster-slave, active-active, and backup strategies.
● Optimizeperformance and conduct query analysis.
● UseAWSservices: Redshift, S3, RDS.
● ImplementSQLServer clustering and high availability (HA) technologies.
● Utilize SQL Server management tools like Redgate.
UBA Solution
UBA Solutions is now collaborated with Monotype. Initially it was formed to meet the needs of globalization and to establish themselves as leader in the software market. Over the past 11 years, UBA Solutions have gained an excellent reputation by fulfilling the project requirement and meeting the strict deadlines of a worldwide clientele.
https://www.uba-solutions.com/Similar Jobs
Upload Your CV