Responsibilities:

  • Installation of MS SQL Server and related software.
  • Setting up RDS Instances on AWS Cloud and management
  • Configuration of server hardware and software settings to optimize performance.
  • Initial setup of databases including configuring settings such as collation, file locations, and size parameters.
  • Setting up database security measures including authentication and authorization schemes.
  • Regular updates and patches to the MS SQL Server software as released by Microsoft.
  • Monitoring disk space and planning for database storage requirements.
  • Implementing and testing backup and recovery procedures.
  • Performing routine database maintenance tasks such as indexing and defragmentation.
  • Monitoring system and MS SQL Server performance metrics.
  • Analyzing and resolving performance issues.
  • Tuning MS SQL queries and server settings for optimal performance.
  • Implementing and maintaining database caching and other optimization techniques.
  • Managing database access controls and permissions for users and groups.
  • Implementing and monitoring security protocols to protect data integrity and access.
  • Regularly auditing database access and usage.
  • Ensuring compliance with relevant data security regulations and standards.
  • Data import and export operations.
  • Structuring, partitioning, and archiving data as necessary.
  • Managing data replication, data distribution, and data synchronization tasks.
  • Overseeing data integrity checks and corrections.
  • Designing and implementing a comprehensive backup strategy.
  • Regular testing of backup files to ensure recoverability.
  • Planning and implementing disaster recovery procedures.
  • Documenting disaster recovery plans and maintaining recovery point objectives (RPO) and recovery time objectives (RTO).
  • Developing and maintaining documentation related to database environments.
    Generating performance, audit, and other reports as required by the business.
  • Providing insights and recommendations based on data and performance trends.