Database Analyst / Administrator
New
K
KMRG, LLCDatabase operations
Remote work from within the United StatesFull-TimeSenior
Salary140,000 - 175,000 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- Seven (7) or more years of database maintenance, database analysis, or related experience
- Required Skills
- AWSSQLETLCI/CDDatabricks
Requirements
- Have seven or more years of database maintenance, database analysis, or related experience.
- Hold a bachelor’s degree in Computer Science, Computer Programming, Computer Engineering, or a related field; equivalent experience may be considered.
- Have experience supporting production databases, including shift-based and on-call support.
- Be proficient with AWS database technologies, such as Amazon Aurora PostgreSQL and other AWS-managed data services.
- Have experience working with Databricks.
- Have experience installing, configuring, and administering database environments.
- Know data warehousing, dimensional modeling, data mapping, data flow diagrams, and data marts.
- Have experience architecting and implementing cloud-based database solutions and migrating on-premises data to multi-cloud or hybrid-cloud environments.
- Be able to provide on-call support and/or follow a flexible work schedule as needed.
- Preferred: AWS Certified Data Engineer – Associate, AWS Certified Solutions Architect – Associate/Professional, or an equivalent cloud/database certification.
- Preferred: Experience developing and managing database reports, dashboards, and visualizations.
- Preferred: Knowledge of court operations and law enforcement business data.
Responsibilities
- Install, configure, administer, and maintain production database environments.
- Monitor database performance, troubleshoot incidents, and restore services with development and operations teams.
- Perform root-cause analysis and improve database reliability, performance, security, and scalability.
- Administer AWS-managed databases, including Amazon Aurora PostgreSQL, and support Databricks environments.
- Develop stored procedures, jobs, views, tables, and other database objects using SQL Server Management Studio (SSMS).
- Design dimensional data models, including star and snowflake schemas, fact and dimension tables, and data marts.
- Support migration of legacy on-premises databases to cloud and hybrid platforms.
- Build and deploy ETL packages through CI/CD pipelines and version-control workflows.
- Analyze data from multiple sources and develop KPI visualizations; index logs in Splunk and create dashboards, alerts, and reports.
- Translate business needs into technical requirements, document workflows, and participate in Agile planning, scrums, and peer code reviews.
View Full Description & ApplyYou'll be redirected to the employer's site