Database Administrator - Capitol Tech Solutions

 Administrator

Capitol Tech Solutions is looking for a driven Database Administrator who is not only strong technically but is innovative, motivated, and diligent database administrator for a fast-growing digital consulting company. Applicants with the ability to demonstrate exceptional problem-solving skills are desired, along with the ability to interact with clients technically. You will be a member of our development team in a highly fast pace and cutting-edge environment.

About CTS:

CTS specializes in providing complete custom build software, application modernization, and data driven solutions for public and private sector clients. Our team has years of experience building well-structured software applications that meet and exceed client expectations for agencies and organizations throughout Northern California. To find out more, visit our website at www.capitoltechsolutions.com

Primary Responsibilities:

As a Database Administrator you’ll focus on analytics for new and existing multiyear Data Warehouse program as the technical specialist for our government clients. Working on a modern technical platform (Azure, Snowflake) to help our client create cloud-based data warehouses and gain insights from meaningful data visualizations (Power BI). With strong attention to detail in project management you’ll provide leadership, solutions, and support others with your expertise.

  • Creates and maintains databases for development, test, training, stage, and production environments.
  • Implements and enforces database security
  • Evaluates and implements new releases of software and security updates.
  • Provides technical support to application development teams.
  • Optimize SQL queries to improve performance and reduces cloud infrastructure costs.
  • Administers all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.
  • Monitors database performance and tunes application queries as required.
  • Assists with impact analysis of any changes made to the database objects.
  • Participate in the ETL process to ensure data meets all validation requirements on import.
  • Troubleshoots any problems regarding the databases, applications, and development tools.
  • Work open cases to support and resolve databases issues.
  • Supports and maintains backup and recovery plans of the databases.
  • Provide proactive and reactive data management support and training to users
  • Support implementation of cloud data platform and cloud related architectures (Snowflake, Azure)
  • Design advanced data visualizations (Power BI)
  • Participate in Agile development cycles
  • Provides instruction and guidance to junior database administrators.

Qualifications:

  • Bachelor’s degree in Computer Science or relational database management administration with 3+ years’ experience as an Engineer
  • 3+ years of experience in data warehousing/BI/analytics.
  • Minimum 3+ years of experience working in Cloud platforms
  • Experience with design, build and operationalization of large-scale enterprise data solutions using one or more of Azure data and analytics services in combination with 3rd party tools
  • Experience with design and implementation of data engineering, ingestion, and curation functions on Azure, using Azure native or custom programming
  • Experience with data cleansing, profiling, and domain-specific data quality assessment
  • Experience integrating cloud data (OCI, AWS, Azure) solutions with existing/third party IT systems
  • Knowledge of migration, dev/ops, ETL/ELT, and BI required
  • Hands on experience on Agile practices and Scrum process.
  • Strong communication skills, both verbal and written

Salary Range:

$75,000-$100,000 per year depending on experience

Benefits:

  • Bonuses available based on performance
  • 10 days of PTO
  • Paid Holidays
  • 99% Medical/Dental paid
  • 401K + Employer Match

Requirement:

Able to work in Sacramento, CA. Hybrid Workplace – 3 days in the office and 2 days remote

Job Type: Full-time

Send Resumes to: Justino Santana, Director of People at jsantana@capitoltechsolutions.com

  • Listing ID: 6135
Contact details

Sacramento