Avatar for SANROSE
Provides professional IT consulting and custom software development services

Sr. Database Administrator (DBA)

  • Tallahassee
  • |10 years of exp
  • |Full Time
Posted: 7 days ago
Job Location
Tallahassee
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
T-SQL
ETL
Microsoft SQL Server
Data Validation
Windows Services
Stored procedures
indexing
Scheduling
QUERY OPTIMIZATION
Data Mapping
Elt
Azure SQL Database
Power BI
Schema Design
Azure SQL
Error Handling
Views
Functions
Azure SQL Managed Instance
Execution Plans
Physical Database Design
Scheduled Processes
SQL Server Hosted in Microsoft Azure

About the job

This is an onsite work position based in Tallahassee,FL. Apply only if you are willing to relocate.Education: Bachelor’s or master’s degree in Computer Science, Information Systems, or related field; or equivalent work experienceCertifications: Current Microsoft certifications relevant to Azure Database Administrator, Azure Data Engineer, Azure Solutions Architect, or related database technologiesRequired Experience 10+ years of experience administering enterprise Microsoft SQL Server environments, including production and non-production systems of medium to high complexity Experience administering Azure SQL Database, Azure SQL Managed Instance, or SQL Server hosted in Microsoft Azure. Experience with database installation, configuration, patching, upgrades, security administration, monitoring, performance tuning, capacity planning, backup, recovery, and high availability. Strong experience with T-SQL, schema and physical database design, indexing, stored procedures, views, functions, execution plans, and query optimization. Experience designing and supporting data transformation and integration processes, including ETL/ELT, data mapping, validation, scheduling, and error handling. Experience supporting or troubleshooting Windows Services and scheduled processes that interact with Microsoft SQL Server, Azure SQL, Power BI, or enterprise applications.Preferred Experience Experience with Azure services that support database, integration, monitoring, security, storage, automation, or data processing workloads. Experience eliciting, analyzing, documenting, and validating business and technical requirements with stakeholders. Experience supporting regulated or government environments and implementing role-based access, auditing, encryption, least privilege, and data protection practices. Experience with Azure DevOps, source control, deployment pipelines, Infrastructure as Code, PowerShell, or other database automation and release-management practices.Responsibilities Administer, maintain, monitor, and support enterprise Microsoft SQL Server and Azure SQL databases across development, test, staging, and production environments. Configure and maintain instances, databases, storage, access controls, service accounts, encryption, auditing, database mail, jobs, alerts, and monitoring. Plan, implement, test, and document backup, restore, high availability, disaster recovery, database integrity, and continuity procedures. Monitor and tune database performance through query analysis, execution plans, indexing, statistics, configuration, capacity planning, and resource optimization. Design and maintain logical and physical data models, schemas, data dictionaries, tables, views, stored procedures, functions, and related database objects. Design, build, maintain, and troubleshoot data transformation and integration processes, including ETL/ELT workflows, data mapping, validation, scheduling, and error handling. Support and troubleshoot Windows Services, scheduled tasks, and application components that depend on database connectivity, data processing, or integration services. Support approved Azure services and hybrid connectivity used by Azure SQL, SQL Server, data integration, monitoring, security, storage, and automation solutions. Elicit, analyze, document, validate, and translate business requirements into secure, supportable database and data solutions. Perform incident response, root-cause analysis, remediation, change implementation, and knowledge transfer for database-related issues. Create and maintain technical documentation, operational procedures, architecture diagrams, runbooks, and Standard Operating Procedures (SOPs). Attend project and operational meetings, provide regular status updates, and submit weekly project reports and time sheets. Coach, mentor, training, and provide knowledge transfer to OATS staff and project teams

About the company

SANROSE company logo
Provides professional IT consulting and custom software development services1-10 Employees
Learn more about SANROSE image