Opportunity Details

Full Time Snowflake Database Administrator

CA

Apply Now

Share This

Copy URL

Outcomes. Delivered.

Voyatek, formerly GCOM Software and OnCore Consulting, delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide.

For example, our technology:

• Facilitates access to nutritious food for children of mothers participating in the WIC program
• Supports first responders in reducing opioid overdoses within their communities.
• Empowers colleges and universities to identify and thwart financial aid fraud
• Equips teachers with valuable insights to identify students requiring additional support
• Enhances efficiency for state tax agencies, leading to 99% faster return processing and quicker refunds for taxpayers

With a focus on Tax & Revenue, Health & Human Services, and Justice & Public Safety, Voyatek combines the scale to support large complex projects with the agility and accessibility of a boutique solutions provider. Together, Voyatek and its customers work to improve population wellbeing, create safer communities, and foster a thriving economy.

We’re more than a technology company -- we’re an outcomes company.

We encourage our employees to think differently, ask tough questions, and relentlessly pursue what’s best for our customers and the residents they serve.

We believe that the value of technology is defined by its human impact. If you agree, you’ve come to the right place.

Voyatek is seeking applicants to occupy the position of Snowflake Database Administrator within our team. This role offers remote work opportunities.

Key Responsibilities:

• Actively work with database software support for raising support tickets and triaging outages.
• Implement/support automation for production deployment on database platform.
• Develop, build & maintain mission critical centralized database platform.
• Diagnose and troubleshoot database errors.
• Implement user /query log analysis and alerts.
• Will collaborate with heterogeneous user groups from data engineers to data scientists.
• Implement data encryption/decryption/masking policies to protect PII/PCI data.
• Demonstrated proficiency of index design, query plan optimization and analysis required.
• User security auditing.
• Create utilization and capacity plans.
• Tune the database to improve queries.
• Provide technical leadership, fosters a team environment, and provides mentorship and feedback to technical resources.
• Should be able to review project requests describing database user needs to estimate time and cost required to accomplish project.
• User management, Security management, performance management, High availability management, space management, and backup management of databases.
• Build and maintain secure, compliant data processing pipelines, tables, views, procedures, and datasets.
• Integrate, transform, and consolidate data from various structured and unstructured data systems into structures that are suitable for building analytics solutions and/or performing analysis.
• Use database management tools and other Azure services for availability and performance monitoring.
• Automate database administration tasks using SQL and shell scripts.
• Work with engineers in support of SSO authentication requirements.
• Managing sets of XML, JSON, and CSV from disparate sources.
• Interprets, identifies, and solves unique and meaningful problems.
• Leads technical contribution to requirements / story development conversations.
• Communicates complex findings in a structured and clear manner to a non-technical audience (written and verbal) including communication to leadership.
• Follows best practices and standards, identifies gaps, and suggests changes.
• Responsible for understanding environmental constraints and planning to mitigate.
• Works respectfully with all team members, both OneAmerica colleagues and vendor partner team members.

Mandatory Qualifications:

• Bachelor Degree in Computer Science or relevant field
• 8 + years of experience in system or application database administration, to include providing critical support for database operations
• 8 + years of experience supporting databases running on Azure or AWS cloud.
• 8 + years of experience working on a relational database as an application DBA.
• Ability to migrate from on-premises databases to cloud-based databases.
• Knowledge of Snowflake a plus.
• Understanding of data ingestion, data transformation, and making data consumable.
• Superb communication and coaching skills with the ability to connect with members of the development teams.
• Ability to apply and influence best practices and sound database design principles on a relational database platform.

Desired Qualifications:

• Snowpro Core Certification a plus
• Experience with database tools, such as: SSMS, Toad, and ER/Studio Data Modeler.

The wage range for this role considers the wide range of factors that are considered in making compensation decisions. This includes, but is not limited to, skill sets, experience and training, licensure and certifications, and geographic location. At Voyatek, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current annual range is $95,000 to $158,300.

If you think you are a good fit for us, we encourage you to apply. Check out our career website for all open positions!

Voyatek provides equal employment opportunities to all employees and applicants for employment without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status or domestic violence victim status, religion, age, disability, genetic information, service in the military, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Equal employment opportunity applies to all terms and conditions of employment, including recruitment and hiring, job assignment/placement, promotion, upgrading, demotion, termination, layoff, recall, transfer, leave of absence, rates of pay or other compensation, internship, and training.