Database Administrator

Database Administrator
Remote (Eventually onsite)

Description:
Diversified Systems is searching for a Database Administrator to provide advanced database administration, performance optimization, high availability, disaster recovery, security, and Azure database support for enterprise database environments. This position is responsible for implementing, configuring, maintaining, monitoring, and securing Microsoft SQL Server platforms across on-premises and Azure environments while ensuring database performance, availability, scalability, and compliance.

The successful candidate will collaborate with development teams, IT architects, security personnel, and business stakeholders to support database infrastructure, application lifecycle activities, cloud modernization efforts, and enterprise data management initiatives.

Responsibilities:

Database Maintenance & Configuration
Install, configure, patch, and upgrade SQL Server instances across production, staging, and development environments.
Manage server storage, system databases, and data file structures.
Develop and orchestrate Azure and on-premises DBMS architectures to ensure scalable and resilient solutions.
Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
Implement and configure DBMS platforms aligned with organizational requirements.
Performance Monitoring & Tuning
Proactively monitor system health, resource allocation, and database performance metrics.
Optimize database performance through index tuning, query optimization, and resolution of blocking and deadlock issues.
Monitor and fine-tune DBMS performance to improve efficiency and reliability.
Perform performance tuning and system configuration across multiple database platforms.
Provide Tier III support for complex database issues and performance challenges.
Backup & Disaster Recovery
Design, test, and execute database backup and recovery strategies.
Implement and support High Availability (HA) and Disaster Recovery (DR) solutions including Always On Availability Groups, Log Shipping, Failover Cluster Instances, and replication technologies.
Design and plan comprehensive HA/DR strategies.
Configure and deploy HA/DR environments and manage database replication processes.
Configure and support Azure database backup, recovery, security, monitoring, and migration solutions.
Participate in Disaster Recovery and Business Resumption activities as assigned.
Security & Compliance
Implement strict role-based access controls (RBAC).
Manage database user accounts, logins, and permissions.
Configure encryption for data at rest and in transit.
Work closely with the State Chief Information Security Officer to implement and enforce security standards.
Support database security, compliance, integrity, and access management initiatives.
Utilize Azure Key Vault to securely manage credentials and sensitive information.
Developer Support & Database Design
Assist development teams with schema design, table structures, data type selection, and database architecture decisions.
Review stored procedures, triggers, functions, and complex T-SQL code for performance and maintainability.
Collaborate with development teams throughout the application lifecycle, including planning, design, development, implementation, data migration, quality assurance, and data administration.
Support data exchange standards and secure data architecture practices.
Automation & Scripting
Develop T-SQL, PowerShell, and command-line scripts to automate maintenance activities including backups, monitoring, integrity checks, statistics updates, reporting, and index management.
Azure & Enterprise Data Services
Configure and support Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Backup, Azure RBAC, and Azure database services.
Support migration and integration efforts between on-premises SQL Server and Azure database platforms.
Design database strategies supporting business objectives and enterprise modernization initiatives.
Contribute to business case development and solution architecture planning.
Documentation & Leadership
Create and maintain documentation covering installations, configurations, monitoring, security standards, migrations, backup procedures, and operational best practices.
Provide mentorship and technical guidance to peers and junior team members.
Collaborate with IT Architecture, Infrastructure, Security, and Development teams to deliver database solutions.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, a related technical field, or equivalent work experience required.
  5 years of hands-on experience managing enterprise Microsoft SQL Server database environments required.
  5 years of performance monitoring and tuning experience required.
  5 years of experience implementing security controls including role-based access control (RBAC) required.
  5 years of experience supporting developers through schema reviews, database design, and code reviews required.
  5 years of experience supporting enterprise-level SQL Server environments, including both on-premises and Azure platforms required.
  Deep expertise in SQL Server Management Studio (SSMS) and SQL Server internals required.
  Advanced proficiency with Transact-SQL (T-SQL) required.
  Experience implementing SQL Server Integration Services (SSIS) packages and ETL workflows required.
  Experience supporting Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines required.
  Knowledge of Azure Monitor, Log Analytics, Microsoft Entra ID, Azure Key Vault, Azure Backup, and Azure role-based access control required.
  Experience migrating and integrating databases between on-premises SQL Server and Azure environments required.
  Understanding of Azure database security, networking, scalability, cost optimization, and HA/DR capabilities required.
  Strong analytical, troubleshooting, documentation, and communication skills required.

• Hands-on experience with third-party monitoring and backup tools such as Redgate highly desired.
• Experience serving on Disaster Recovery, Incident Response, or Business Continuity teams highly desired.

About Diversified Systems
Founded in 1990, Diversified Systems is an award-winning Technology Services corporation providing all levels of IT project consulting services nationwide. DSI is headquartered in Columbus, Ohio with regional offices in the American Midwest and East Coast. We offer our consultants a number of flexible and competitive compensation benefit packages.

Diversified Systems is committed to the principles of equal employment. We are committed to complying with all federal, state, and local laws providing equal employment opportunities, and all other employment laws and regulations.

Diversity, Equity and Inclusion
DSI values authenticity and is committed to making sure our employees and partners are valued and respected. At DSI, we believe building a diverse culture is important because we know when people work together, we can achieve better results as a team. DSI realizes that everyone comes from various backgrounds. We celebrate these differences because our employees are our greatest asset as we strive to best meet the needs of those we serve. As part of our ongoing efforts, DSI is focused on advancing equality, diversity, and inclusion by setting high standards to continually evolve our culture. This includes but is not limited to recruiting, community involvement, client delivery, and career development.