Epicareer Might not Working Properly
Learn More

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