Responsible for managing Microsoft SQL database platforms to include performance tuning, monitoring, and troubleshooting.
Proactive monitoring for performance issues.
Lead solution definition for determining the most effective resolutions to performance issues.
Define and adjust indexing strategies as part of performance management for the environment.
Maintains SQL databases in development, Quality Assurance, and production environments.
Install and configure new SQL Servers.
Designs, recommends, and promotes implementation of required database structures. Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations .
Assist developers with complex query tuning and schema refinement.
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
Performs security related functions based on NIST compliance, including automated scan reviews and remediation of vulnerabilities.
Acts as a technical resource for application and data users, data administrators and others.
Serves as point of contact with technical peers for the resolution of infrastructure-related issues.
Ensures compliance with company HIPAA, privacy, and government security policies.
Provides technical support and guidance for applications programming in support of all aspects of database systems.
Monitors and enforces standards for all database platforms.
Creates databases, table spaces, tables, indexes, triggers, procedures, SQL Reports, and all other objects.
Support integration of SQL Server Integration Service packages.
Administer both internal and external facing SQL Reporting Services implementation in development, testing and production.
Defines the content and structure of the database (schema) and advises users on efficient techniques for extracting data.
Consults with development groups concerning the impact new applications will have on the database.
Maintains accurate and up-to-date database system documentation.
Support all phases of testing. Correct errors and make necessary database modifications.