Job Details

Join to apply for the Database Administrator - Hybrid, OH role at Ocean Blue Solutions Inc

2 months ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Face to Face Interviews Only

Hybrid, will be required to be onsite at 1980 West Broad St, Columbus, 5 days a week

The candidate will support The Ohio Department of Transportation's Database Administration team working on tasks for the Transportation Systems Management and Operations (TSMO) team.

This role is crucial for ensuring the performance, availability, security, and integrity of our SQL Server database environments, both on-premises and within Azure Synapse. The ideal candidate will have extensive experience with complex SQL Server infrastructures, including AlwaysOn availability groups, and designing, implementing, and maintaining ETL processes using SQL Server Integration Services (SSIS). They will troubleshoot database issues, optimize query performance, and ensure smooth operation of data platforms.

Responsibilities

• Administer and monitor Azure Synapse Analytics environment, including data warehousing and data integration components.
• Design, develop, implement, and maintain ETL packages using SQL Server Integration Services (SSIS).
• Provide recommendations to the business unit on database architecture for new use cases.
• Lead the implementation of a new Data Lake in Azure Synapse.
• Perform regular database maintenance tasks.
• Monitor database performance, identify bottlenecks, and implement performance tuning strategies.
• Troubleshoot database issues, including connectivity, query performance, and data corruption.
• Maintain database security policies and ensure data integrity and compliance.
• Collaborate with application teams to optimize database design and queries.
• Document configurations, processes, and procedures.
• Stay updated with the latest SQL Server and Azure data platform technologies.

Experience

• Manage SQL Server databases across development to production environments.
• Configure and maintain database servers, ensuring high performance, availability, and security.
• Apply data modeling techniques for development and implementation.
• Analyze, troubleshoot, and resolve issues in real time.
• Perform scheduled maintenance and support deployment activities.
• Mentor team members and share technical expertise.
• Experience with decommissioning and migrating older systems.

Required Skills

• 4-year college degree or equivalent; advanced study preferred.
• 10+ years MS SQL Server Administration experience.
• 5+ years MS Azure SQL Server Administration experience.
• 2+ years administering Azure Synapse Analytics.
• Experience with Performance Tuning and Optimization.
• Experience with backups, restores, and recovery models.
• Experience with Azure Data Lake architecture.
• Knowledge of High Availability and Disaster Recovery options.
• Experience with Windows Server and Active Directory.
• Excellent communication skills.
• Flexible, team-oriented, proactive personality.
• Ability to organize, plan, and adapt in a fast-changing environment.
• Ability to multi-task effectively.

Additional Details

• Seniority Level: Mid-Senior Level
• Employment Type: Full-time
• Job Function: Information Technology
• Industries: IT Services and Consulting

J-18808-Ljbffr