Mandatory Skills

Microsoft SQL Server

Preferred Skills

Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services(SSRS), Azure SQL Database, MongoDB

Brief Job Description

Microsoft SQL Server (MSSQL) Administrator and MongoDB Administrator

Microsoft SQL Server (MSSQL) Administrator Responsibilities:
• 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.
• 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.
• Use tools like SQL Profiler, Performance Monitor, and Extended Events to diagnose and fix slow queries.
• Set up failover clustering, log shipping, replication, and Always On features.
• Address database corruption, deadlocks, and performance bottlenecks.
• Develop scripts using PowerShell and T-SQL for automated maintenance tasks.
• Manage migrations between different SQL Server versions and cloud environments (Azure SQL).

MongoDB Administrator Responsibilities:
• 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.
• Optimize MongoDB queries using indexes and aggregation pipelines.
• 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.