ALOHA!!

SQL Database Administrator in Honolulu, Hawaii.

FTE work employment.

Monday-Friday, 8:00 am- 5:00 pm.

5 days Onsite in Downtown Honolulu

Description

Responsible for the overall performance, reliability, and security of data, databases, and related systems. Ensures that databases and processes perform optimally and that all data, databases, and related systems are recoverable.

Performs preventative maintenance measures. Regularly monitors database and ETL operations to ensure successful completion. Provides after-hour support and troubleshooting activities for all databases and ETL processes, as needed to ensure 24/7 system availability. After-hours monitoring of systems and processes as needed to resolve production issues.

Performs system and server administrative duties, including software installations, upgrades, configuration, and migrations.

Implements data strategy to secure, restore, and archive databases while complying with the Bank’s information security policies.

Leads and manages technical projects of moderate complexity.

Develops, administers, and maintains the EDW, data marts, application interfaces, data virtualization layers, reports, dashboards, data extracts, and ETL platforms.

Ensures appropriate controls over the EDW to ensure a highly controlled and auditable environment.

Executes appropriate testing and validation activities for all platforms. Documents test results and ensures that all open issues are resolved.

Creates and maintains design documents, application overview documents, data flow diagrams, procedures, standards, and other technical documents.

Installs and configures MS SQL servers for standalone and failover cluster environments.

Dell Compellant's storage management across databases creates volumes, monitors space, and provides capacity planning based on the databases' growth.

Administers Denodo Data Virtualization tool, including designing databases and creating base views to deploy across environments. Troubleshoot issues and provide support to businesses in accessing the views.

Develops T-SQL scripts, stored procedures, views, triggers, and indices.

Creates and maintains MS SQL Agent jobs, alerts, and security of all SQL server instances.

Designs and implements SSIS packages and SSRS reports.

Assists with production incidents and resolutions, including root cause analysis and recommendations.

Develops PowerShell scripts.

Support Developers with tuning SQL queries, debugging, and troubleshooting.

Fosters a positive, learning, and collaborative team environment. Proactively documents and cross-trains teammates to promote knowledge transfer and to ensure adequate coverage.

Skills

Sql, Database administrator, Performance tuning, batch processing, Sql database, snowflake

Additional Skills & Qualifications

Great communication skills, Ability to come on-site and be on rotation for 2 week sprints

Pay and Benefits

The pay range for this position is $100000.00 - $150000.00/yr.

Weekly Paydays - Enjoy the ease and security of a weekly paycheck.Casual Dress Code - Looking good and feeling good has never been so easy.Birthday Holidays - We celebrate you! Enjoy time off every year on this very important day.Free On-Site Fitness Classes (at certain locations)

Workplace Type

This is a fully onsite position in Honolulu,HI.

Application Deadline

This position is anticipated to close on Mar 31, 2025.

About TEKsystems:

We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.