Database Analyst / Administrator

This is a fully remote position, open to applicants in United States.

📋 Description

• Install, configure, administer, and maintain critical production database environments.

• Monitor database performance, troubleshoot incidents, and collaborate with development and operations teams to restore services.

• Conduct root-cause analysis to enhance database reliability, performance, security, and scalability.

• Manage AWS databases, such as Amazon Aurora PostgreSQL, and provide support for Databricks environments.

• Create stored procedures, jobs, views, tables, and additional database objects utilizing SQL Server Management Studio (SSMS).

• Design dimensional data models, including star and snowflake schemas, as well as fact and dimension tables and data marts.

• Assist in migrating legacy on-premises databases to cloud and hybrid platforms.

• Develop and deploy ETL packages via CI/CD pipelines and version-control workflows.

• Establish and enforce database policies and standards focusing on data integrity, quality, security, and administration.

• Validate data accuracy and perform analysis across multiple sources using statistical methods, data mining, and predictive modeling.

• Identify trends to inform decision-making and create KPI visualizations.

• Collaborate with product owners and users to translate business requirements into technical specifications and document workflows.

• Engage in Agile planning, daily scrums, peer code reviews, and technical collaboration.

• Utilize Atlassian development tools.

• Index system and application logs in Splunk, and develop dashboards, alerts, and reports.

⛳️ Requirements

• A minimum of seven (7) years of experience in database maintenance, database analysis, or a related field.

• Bachelor’s degree in Computer Science, Computer Programming, Computer Engineering, or a related discipline; equivalent experience may be accepted.

• Proven experience in supporting production databases, including shift-based and on-call responsibilities.

• Expertise in AWS database technologies, particularly Amazon Aurora PostgreSQL and other AWS-managed data services.

• Familiarity with Databricks.

• Experience in installing, configuring, and administering database environments.

• Understanding of data warehousing, dimensional modeling, data mapping, data flow diagrams, and data marts.

• Background in architecting and implementing cloud-based database solutions.

• Experience in migrating on-premises data to multi-cloud or hybrid-cloud settings.

• Strong analytical, technical, and problem-solving abilities.

• Capability to work independently, prioritize tasks, and adhere to deadlines.

• Excellent organizational, written, and verbal communication skills.

• Ability to document technical plans, operational status, and complex solutions for a variety of stakeholders.

• Must be available for on-call support and/or have the flexibility to work a varied schedule as required.

• Preferred: AWS Certified Data Engineer – Associate, AWS Certified Solutions Architect – Associate/Professional, or equivalent cloud/database certification.

• Preferred: Experience in developing and managing database reports, dashboards, and visualizations.

• Preferred: Knowledge of court operations and law enforcement business data.

• U.S. citizenship is required.

• Willingness to undergo a federal background check.

• Ability to comply with federal drug-free workplace regulations.

🏝️ Benefits

• Flexible work schedule.

• Shift-based and on-call coverage as necessary.

• Remote work opportunities available within the United States.

• No travel required.