jobs in IDC TECHNOLOGIES (SINGAPORE) PTE. LTD.

IDC TECHNOLOGIES (SINGAPORE) PTE. LTD. Hiring! Part Time Database Administrator in , Earn up to SGD 9,000 - Ricebowl

Database Administrator

IDC TECHNOLOGIES (SINGAPORE) PTE. LTD.

SGD6,000 - SGD9,000 Per Month

Central

Share
Save

Working Location

  • Central Singapore

Job Description

Responsibilities

  • 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 (*************) 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.

Important Information

Never provide your bank or credit card details when applying for jobs. Do not transfer any money or complete unrelated online surveys. If you see something suspicious, Report this Job ad.

Learn More