Database Administrator

About the role

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.

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at IDC TECHNOLOGIES (SINGAPORE) PTE. LTD.? Share your experience