Senior Database Administrator

Brief Job Description

1. 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).

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

Requirement

• Min. 5 years of relevant experiences as a DBA
• Mandatory Skills - Microsoft SQL Server
• Preferred Skills - Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services(SSRS), Azure SQL Database, MongoDB

Other Details

• Work location: West area
• Type: Renewable contract based role
• Working Hours: Monday to Friday, 830am to 6pm