-
Establish and maintain database performance standards, monitor system usage, analyze database performance, and perform system optimization to ensure data availability and responsiveness to user queries.
-
Develop and maintain database security and integrity standards, implementing appropriate security access levels in accordance with management specifications.
-
Diagnose, troubleshoot, and resolve database performance and system-related issues.
-
Manage data archiving, maintain archival and active records, and perform database backup and recovery operations.
-
Evaluate system and user requirements and recommend database capacity enhancements and infrastructure improvements.
-
Plan and implement database conversion projects, including database migration and upgrades to new versions and servers.
-
Monitor network traffic and communication usage patterns, and configure or modify network settings to meet system demands and capacity planning requirements.
-
Knowledge of database development, management, data warehousing, and administration principles and practices.
-
Knowledge of hierarchical and relational database management systems and associated programming languages.
-
Knowledge of operating system software and database infrastructure.
-
Strong understanding of database security practices, including monitoring and managing user access, logins, permissions, and access controls.
-
Knowledge of information systems security practices, including methods for protecting information and resolving security-related issues.
-
Knowledge of database archiving, backup, and recovery methodologies.
-
Strong hands-on experience administering Microsoft SQL Server.
-
Experience with Azure SQL (Azure SQL Database or Azure SQL Managed Instance), including security administration, monitoring, backup, and recovery in Azure environments.
-
Familiarity with Azure data tools such as Azure Data Factory (ADF) or Azure Database Migration Service for migrating data from legacy systems into SQL Server.
-
Proficiency in developing database queries and generating reports.
-
Ability to gather and analyze user requirements for database queries, reporting solutions, database modeling, and system upgrades.
-
Ability to implement, manage, control, and evaluate database management systems.
-
Ability to prepare user documentation and train users on database capabilities and data access procedures.
-
Strong analytical, logical thinking, and problem-solving abilities.
-
Ability to establish and maintain effective working relationships with vendors, management, technical teams, support specialists, and system users.
An equivalent combination of education and relevant professional experience may be considered in place of the stated minimum education and experience requirements.
