SQL Server/Azure SQL DBA
Core
Manage SQL Server and Azure SQL databases for a government revenue collection system, focusing on performance, security, and availability.
Role type
Senior SQL Database Administrator
Builds
Revenue collection systems and related database environments
Domain
Government / Financial Services
Required skills
SQL Server administration, Azure SQL administration, database security, backup and recovery, performance monitoring, capacity planning, database migrations, network traffic monitoring (via careerplan.io/jobs/g2f90b12-sql-serverazure-sql-dba-at-trigyn-technologies-inc)
Technologies
SQL Server, Azure SQL, Network Security
Responsibilities
Establish and maintain database performance standards, monitor system usage, analyze performance, and optimize systems to ensure data availability and responsive user queries; Develop and maintain data security and integrity standards, and implement access levels according to management specifications; Diagnose and resolve database performance issues; Archive data, maintain archival and active records, and perform database backups and recovery; Assess system and user needs and recommend capacity increases; Plan and implement database conversions, migrations, and upgrades to new database versions and servers; Monitor network traffic and communications usage, and adjust network configurations to meet system demands and capacity needs
