MarketBeat

Administration

• Administer and maintain SQL Server databases across production, staging, and development environments.
• Administer and maintain Windows servers, including updates, patching, and system monitoring.
• Monitor server performance, storage, and networking, resolving system-level issues proactively.
• Be available to resolve urgent database or server issues outside of business hours.
• Lead and support database migration projects, including the planned upgrade to SQL Server 2025.
• Implement and manage database backups, disaster recovery plans, and high-availability strategies.
• Monitor traffic, evaluate system health, and troubleshoot performance issues.
• Work with developers to design and optimize schemas, queries, and indexing strategies.
• Proactively identify and resolve database-related issues (e.g., blocking, deadlocks, long-running queries).
• Perform regular maintenance tasks such as index optimization, statistics updates, and capacity planning.
• Ensure database security, including user access controls and compliance with data privacy regulations.
• Document database architecture, processes, and procedures for internal reference.
• Other duties as assigned

Database and Server Administrator