The #1 Site for IT and Engineering Jobs - search all IT and Engineering  jobs.

database administrator

Job Description

Position Summary

The Database Administrator is responsible for performing database software releases and system upgrades, evaluating and installing patches, maintaining and monitoring database system configurations/alerts, ensuring data integrity across systems/schemas, and day-to-day maintenance to ensure operability, performance, and availability of critical data. This role will assist in defining a supportable database backup strategy, coordinating/defining recovery tasks associated with BCP and DR exercises, and performing design and unification of large data sets and sources for a company-wide Business Intelligence Platform.

Core Duties and Responsibilities

Maintains production and test database performance/availability internally developed applications by leveraging SQL management tools and methods; including execution plan management, index tuning, recommending and implementing stored procedure performance enhancements, evaluating and recommending hardware resources, and identifying root causes and solutions for system performance and system capacity issues.
Implements and supports routine database maintenance processes including security patching, and database backup and retention policies.
Supports the change management process by implementing new releases and keeping all test environments in sync.
Supports customer requests for database reporting consulting and issue troubleshooting.
Identifies database requirements for new solutions by interviewing customers and collaborating with internal team members and program management staff.
Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
Supports efforts to design and execute Business Continuity Planning and Disaster Recovery exercises.
Participates in product roadmap discussions and identifies key areas for database improvements in the product and incorporates these improvements into ongoing & future development initiatives.
Works on complex big data projects under the direction and coordination of senior team members.
Education and Experience

Bachelor's degree in Computer Science, Information Systems, or other related discipline
Knowledge of RDBMS systems and SQL language (ex: ANSI SQL, T-SQL, PL/SQL)
5-7 years of overall database administration experience
5+ years SQL Server
Production SQL Server administration/support experience
Experience/exposure working with big data and analytic platforms and familiarity with concepts including data lakes/warehouses, unstructured data, visualization, AI, and machine learning
Strong technical, analytical, and problem-solving skills to troubleshoot root cause of database related issues
Experience with AWS cloud hosting environments
Experience with object-oriented programming languages
Experience implementing and supporting transactional table replication/synchronization




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.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems .com for other accommodation options.

Job Requirements

 

Job Snapshot

Location US-NY-Albany
Employment Type Full-Time
Pay Type Year
Pay Rate N/A
Store Type IT & Technical
Apply

Company Overview

TEKsystems, Inc

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. Learn More

Contact Information

US-NY-Albany
Megan Gallacchi
Snapshot
TEKsystems, Inc
Company:
US-NY-Albany
Location:
Full-Time
Employment Type:
Year
Pay Type:
N/A
Pay Rate:
IT & Technical
Store Type:

Job Description

Position Summary

The Database Administrator is responsible for performing database software releases and system upgrades, evaluating and installing patches, maintaining and monitoring database system configurations/alerts, ensuring data integrity across systems/schemas, and day-to-day maintenance to ensure operability, performance, and availability of critical data. This role will assist in defining a supportable database backup strategy, coordinating/defining recovery tasks associated with BCP and DR exercises, and performing design and unification of large data sets and sources for a company-wide Business Intelligence Platform.

Core Duties and Responsibilities

Maintains production and test database performance/availability internally developed applications by leveraging SQL management tools and methods; including execution plan management, index tuning, recommending and implementing stored procedure performance enhancements, evaluating and recommending hardware resources, and identifying root causes and solutions for system performance and system capacity issues.
Implements and supports routine database maintenance processes including security patching, and database backup and retention policies.
Supports the change management process by implementing new releases and keeping all test environments in sync.
Supports customer requests for database reporting consulting and issue troubleshooting.
Identifies database requirements for new solutions by interviewing customers and collaborating with internal team members and program management staff.
Recommends solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
Supports efforts to design and execute Business Continuity Planning and Disaster Recovery exercises.
Participates in product roadmap discussions and identifies key areas for database improvements in the product and incorporates these improvements into ongoing & future development initiatives.
Works on complex big data projects under the direction and coordination of senior team members.
Education and Experience

Bachelor's degree in Computer Science, Information Systems, or other related discipline
Knowledge of RDBMS systems and SQL language (ex: ANSI SQL, T-SQL, PL/SQL)
5-7 years of overall database administration experience
5+ years SQL Server
Production SQL Server administration/support experience
Experience/exposure working with big data and analytic platforms and familiarity with concepts including data lakes/warehouses, unstructured data, visualization, AI, and machine learning
Strong technical, analytical, and problem-solving skills to troubleshoot root cause of database related issues
Experience with AWS cloud hosting environments
Experience with object-oriented programming languages
Experience implementing and supporting transactional table replication/synchronization




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.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 888 472-3411 or email accommodation@teksystems .com for other accommodation options.

Job Requirements

 
Sologig Advice

For your privacy and protection, when applying to a job online: Never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction.Learn More

By applying to a job using sologig.com you are agreeing to comply with and be subject to the workinretail.com Terms and Conditions for use of our website. To use our website, you must agree with theTerms & Conditionsand both meet and comply with their provisions.
database administrator Apply now