Database Administrator

• 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.