Add office photos
All Filters
9 UBA Solutions Jobs
Database Administrator 2
UBA Solutions
posted 2hr ago
Job Role Insights
Key skills for the job
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.
- 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-6 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.
- Postgres sql and sound knowledge of oracle
- Has an innovative approach to work, constantly looking to upgrade the system to more efficient and effective new technologies.
- UBA Solutions Pvt Ltd., Imadol Road, Lalitpur 44600
Employment Type: Full Time, Permanent
Read full job descriptionCompare UBA Solutions with
TCS
Compare
Accenture
Compare
Wipro
Compare
Cognizant
Compare
Capgemini
Compare
Infosys
Compare
HCLTech
Compare
Tech Mahindra
Compare
Genpact
Compare
IBM
Compare
LTIMindtree
Compare
DXC Technology
Compare
Mphasis
Compare
NTT Data Information Processing Services
Compare
Sutherland Global Services
Compare
Hexaware Technologies
Compare
HCL Group
Compare
eClerx
Compare
Coforge
Compare
Virtusa Consulting Services
Compare
Similar Jobs for you
Share an Interview