What are the responsibilities and job description for the Sql Database Administrator position at TEKsystems?
*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 are performing at optimum levels 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 remaining compliant 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 that it is 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 storage management across databases; creates volumes, monitors the space and provides capacity planning based on the growth of the databases.
Administers Denodo Data Virtualization tool including designing databases, and creating base views to deploy across environments. Troubleshoot issues and support to Business for accessing the views.
Develops T-SQL scripts, stored procedures, views, triggers and indices.
Creates and maintains MS SQL Agent jobs, alerts, and security 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 Apr 15, 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.
*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 are performing at optimum levels 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 remaining compliant 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 that it is 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 storage management across databases; creates volumes, monitors the space and provides capacity planning based on the growth of the databases.
Administers Denodo Data Virtualization tool including designing databases, and creating base views to deploy across environments. Troubleshoot issues and support to Business for accessing the views.
Develops T-SQL scripts, stored procedures, views, triggers and indices.
Creates and maintains MS SQL Agent jobs, alerts, and security 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 Apr 15, 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.
Salary : $100,000 - $150,000
