
Senior Database Administrator
$ 7,000 - $ 10,000 / month
Checking job availability...
Original
Simplified
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
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