SQL Database Administrator
Establishes and maintains database performance standards; monitors systemusage; analyzes database performance and performs system optimization tasksto maintain data availability and ensure system responsiveness to user queries.• Devises and maintains data security and integrity standards; implements security access levels in accordance with management specifications.• Diagnoses and resolves database system performance problems.• Archive data; maintains archival and active records; performs data back-upand recovery.• Evaluates system and user needs and makes recommendations for increasedsystem capacity.• Plan and implement database conversion projects and the migration and upgrade of databases to new versions and servers.• Monitors network traffic and communications usage patterns; configures ormodifies network configuration to meet system demands and capacity planningneeds. Required Skills, Knowledge and Abilities• Knowledge of principles and practices of database development,management, warehousing and administration.• Knowledge of hierarchical and relational database management systemsoftware programming languages.• Knowledge of operating system software.• Knowledge of database security practices to monitor, control and evaluate useraccess, logons, permissions and related variables.• Knowledge of methods for ensuring, protecting and resolving problems involvingthe security of information systems.• Knowledge of archival, back-up and recovery methods.• Strong hands-on experience administering Microsoft SQL Server.• Experience with Azure SQL (Azure SQL Database or Managed Instance),including security administration, monitoring, and backup/recovery in Azure.• Familiarity with Azure data tools such as Azure Data Factory or Azure DatabaseMigration Service for moving data from legacy systems into SQL Server.• Skill in developing database queries and generating reports.• Ability to interview users and extract pertinent information for development ofdatabase query system and report generation, database model design andupgrades.• Ability to implement, control and evaluate database management systems.• Ability to prepare user documentation and train users in database capabilitiesand procedures for accessing data.• Ability to analyze, apply logic and solve technologyproblems.• Ability to establish and maintain effective working relationships with vendors,management, technical co-workers and support specialists, and system users. Minimum Education and Experience RequirementsA bachelor's degree from an accredited college or university in information systems,computer science or a related field and two years of experience in databasemanagement including performance optimization and troubleshooting, andimplementing, maintaining and controlling hierarchical or relational databasemanagement systems.