Database Analyst

TEKsystems, Inc.; Falls Church (VA); Remote; Full time

Job summary

A leading technology services company is seeking a Database Analyst and Advisor to enhance system performance and support stakeholders. The role emphasizes database administration, optimization, and collaboration across teams. Required qualifications include a Bachelor's degree and extensive experience in the IT sector, particularly with Snowflake and SQL. This fully remote position offers a competitive pay range and additional benefits.

Benefits

Medical, dental & vision

401(k) Retirement Plan

Life Insurance

Short and long-term disability

Health Spending Account (HSA)

Transportation benefits

Employee Assistance Program

Time Off/Leave (PTO)

Qualifications

• 10+ years of related experience in IT operations & development.
• Snowflake certification is required and must be active.
• Hands-on experience creating SQLs that will work on an existing Snowflake schema.

Responsibilities

• Improve system performance by conducting tests and troubleshooting.
• Assist with the design and maintenance of database components.
• Design conceptual and logical data models and flowcharts.

Skills

postgresql

data migration

database system

Database administrator

Database development

snowflake

SQL

Data

Education

Bachelor’s degree in computer science or related technical discipline

Job description

Description

How a Database Analyst and Advisor will Make an Impact:-Improving system performance by conducting tests, troubleshooting, query tuning, and integrating new elements and features-Assist various support teams and stakeholders with the design, maintenance, problem resolution and operational troubleshooting of all database components with a user or service experience mindset.-Cross functionally works with stakeholders including the Executive, Product, platform, Data and Design teams to assist with data-related technical issues operating in a matrix structure.-Support stakeholders with data infrastructure needs including performing unit tests and code reviews to ensure all code is rigorously designed, elegantly coded, and effectively tuned for performance to provide the highest level of service and user experience. Regularly review database estate for improvements and optimizations including right-sizing for new or current database systems including coordinating with the project team to identify future needs and requirements-Design conceptual and logical data models and flowcharts supporting comprehensive compliance and documentation standards-May coach and review the work of less experienced professionals-Ensure deliverables are completed on time and of high-qualityWhat You’ll Need to Succeed:Education:Bachelor’s degree in computer science or related technical discipline, or the equivalent combination of education, technical training, or work/military experienceRequired Experience:-10+ years of related experience in IT operations & developmentRequired Technical Skills:-Provide Database Admin functions (installing, managing, configuring, upgrading, optimizing, etc.) for cloud-based MSPSC databases which include SQL Server, Oracle, Aurora-Postgres, and MySQL.-Manage data in a Snowflake environment-Design and implement ETL (Extract, Transform, Load) solutions for transferring data between various sources and platforms-Optimize the performance of data repositories such as Snowflake and AWS RDS-Deploy and configure tools to monitor and report on the performance of the Snowflake system-Create & manage Snowflake objects, databases, schemas, tables, views, pipes, streams, tasks-User management, Implementation of RBAC best practices-Execute day-to-day Snowflake Administration in accordance with industry best-practices.-Maintain an automate first approach reducing toil and overhead by collaborating with data engineers/architects to transform data and integrate algorithms and models into automated processes-Maintains current knowledge of relevant technology and a curiosity for opportunities for improvement, innovation, and cost-reductionRequired Skills and Abilities:-In-depth understanding of database structure principles-Experience gathering and analyzing system requirements-Hands-on experience creating SQLs that will work on an existing Snowflake schema-Hands-on experience with Snowflake Administration, Snowflake development, Snowflake Utilities, Snow SQL, Snow Pipe-Snowflake certification is required and must be active-Expertise in SQL-Problem-solving mindset-High level of drive, self-motivation and initiative-Experience with source control and automation tools, platforms such as Git/GitHub, and languages such as Python is highly desirable-Experience supporting Federal, civilian and health agencies including experience with claims data is a plusPreferred Skills:-Experience supporting Federal, civilian and health agencies including experience with claims data is a plus.

Skills

postgresql, data migration, database system, Database administrator, Database development, snowflake, Sql, Data

Top Skills Details

postgresql,data migration,database system,Database administrator,Database development,snowflake

Additional Skills & Qualifications

Preferred Skills:Experience supporting Federal, civilian and health agencies including experience with claims data is a plus.Location:RemoteCitizenship Required:Candidate must have 3 of the last 5 years of work history in the US and will be required to go through a public trust background investigationWork visa sponsorship will not be provided for this position

Experience Level

Expert Level

Pay and Benefits

The pay range for this position is $60.00 - $66.00/hr.

Eligibility requirements apply to some benefits and may depend on your job
classification and length of employment. Benefits are subject to change and may be
subject to specific elections, plan, or program terms. If eligible, the benefits
available for this temporary role may include the following:

• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

Workplace Type

This is a fully remote position.

Application Deadline

This position is anticipated to close on Jun 25, 2025.

h4>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.

About TEKsystems and TEKsystems Global Services

We’re a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We’re a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We’re strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We’re building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

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