Database Administrator
%252520PTE.%252520LTD..jpg&w=3840&q=75)
IDC TECHNOLOGIES (SINGAPORE) PTE. LTD.
13 days ago
Posted date13 days ago
N/A
Minimum levelN/A
- 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.
JOB SUMMARY
Database Administrator
IDC TECHNOLOGIES (SINGAPORE) PTE. LTD.
Singapore
13 days ago
N/A
Contract / Freelance / Self-employed
Database Administrator