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-quality What 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 experience Required Experience: -10+ years of related experience in IT operations & development Required 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-reduction Required 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 plus Preferred 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: Remote Citizenship 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 investigation Work 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.