Database Administrator

idc technologies (singapore) pte. ltd.

Singapore, Cecil Street

6-9 Years

SGD 6,000 - 9,000 per month

Save

Posted 6 days ago
Be among the first 10 applicants

Early Applicant

Job Description

Use tools like SQL Profiler, Performance Monitor, and Extended Events to diagnose and fix slow queries.
Install and configure SQL Server instances, including clustering and high availability setups.
Design efficient database schemas, indexes, and stored procedures.
Optimize queries and performance tuning.
Develop scripts using PowerShell and T-SQL for automated maintenance tasks.
Implement automated backup strategies (full, differential, log backups).
Ensure disaster recovery and high availability (HA) using replication, mirroring, Always On Availability Groups.
Manage user roles, permissions, and authentication mechanisms.
Implement encryption and data masking techniques.
Set up failover clustering, log shipping, replication, and Always On features.
Optimize MongoDB queries using indexes and aggregation pipelines.
Address database corruption, deadlocks, and performance bottlenecks.
Manage migrations between different SQL Server versions and cloud environments (Azure SQL).
Install and configure MongoDB instances (standalone, replica sets, sharded clusters).
Design efficient NoSQL schemas using collections, documents, and indexing strategies.
Configure backup strategies (mongodump, snapshots) and recovery plans.
Manage user roles, authentication (LDAP, x.509), and encryption.
Use tools like mongostat, mongotop, and Atlas monitoring for performance optimization.
Set up and maintain replica sets for high availability.
Configure sharding for handling large datasets.
Automate administrative tasks using scripts in Python, Bash, or JavaScript.
Analyze logs (mongod.log) and resolve issues like slow queries, connection failures.
Manage MongoDB instances on cloud platforms (AWS, Azure, MongoDB Atlas).
Implement CI/CD pipelines with MongoDB integrations.