Senior Database Administrator (SQL Server, Snowflake & Data Lake) (812598)

Smart Cloud Solution; Kentucky; On-site; USD 90,000 - 120,000; Full time

Job summary

Smart Cloud Solution is seeking a Senior Database Administrator to provide critical production support for key applications and manage SQL Server and Snowflake environments. You will collaborate with development teams on database requests, participate in disaster recovery, apply security patches, and tune performance across on-prem and cloud data stores.

The role emphasizes supporting the Snowflake data lake, ensuring data integrity, and maintaining compliance with security standards while

Qualifications

• Bachelor's degree or equivalent in IT, CS or related field.
• Extensive SQL Server DBA experience including backup, restore and recovery.
• Experience with Snowflake and data lake environments.
• Strong knowledge of access security and database integrity.

Responsibilities

• Provide production support for critical applications and SQL Server databases.
• Collaborate with development teams on database requests and upgrades.
• Participate in disaster recovery and security patching activities.
• Monitor performance, tune queries, and address compliance issues related to access and configuration.
• Support Snowflake data lake environments and set up system threshold alerts.

Skills

SQL Server DBA

Snowflake

Data Lake

Disaster Recovery planning

Security & Compliance

Performance tuning

Backup & Restore

Education

Bachelor's degree or equivalent

Tools

Snowflake tooling

Job description

Job Title: Senior Database Administrator (SQL Server, Snowflake & Data Lake)
Location: Columbus, Ohio

Role Overview

This role involves providing critical production support for key applications, assisting with SQL Server database administration, and collaborating with the application development team on database requests. The Administrator will participate in disaster recovery processes, assist with database upgrades, security patches, and performance tuning, and address compliance issues related to database access, security, and configuration. Additionally, the role includes supporting day-to-day production operations, troubleshooting performance issues and software bugs, setting up system threshold alerts, creating performance metrics, and providing DBA support for the Snowflake data lake environment.

Key Responsibilities

• Provide critical production support for applications including DTE, Finder, and Fairfax.
• Assist with SQL Server database administration tasks.
• Collaborate with the application development team on database-related requests.
• Participate in the Disaster Recovery process.
• Support database upgrades, security patches, and performance issue resolution.
• Address compliance issues, particularly those related to database access, security, and configuration.
• Support day-to-day production operations, including troubleshooting performance issues and software bugs.
• Set up alerts for database system thresholds.
• Create metrics for system performance.
• Assist with DBA support for the Snowflake data lake environment.

Required Skills

• Bachelor’s degree or equivalent work experience in Information Technology, Computer Science or a related field
• Highly skilled in SQL Server database design, installations, and conversions.
• Professional experience being responsible for database backup and recovery procedures.
• Professional experience with access security and database integrity.
• Professional experience with physical data storage design and data storage management.
• Experience with Snowflake.
• Experience with Data Lake.