Senior Database Analyst – Administrator

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

📋 Description

• Operate within an Agile solution development framework, participating in daily scrums, biweekly sprint planning, and quarterly Program Increment planning.

• Establish operating standards and best practices that address performance, security, scalability, and maintainability.

• Define, manage, and coordinate data elements and standards.

• Ensure efficient data relationships, systems integration, and physical structure.

• Collaborate with Product Owners and users to collect business requirements and translate them into technical specifications.

• Engage with agency leaders and stakeholders on innovative data analysis methodologies.

• Document intricate workflow designs for project teams and stakeholders.

• Analyze complex issues and contribute to new business strategies, ideas, and methods within the Agile framework.

• Collect, analyze, and interpret substantial amounts of data to inform business decisions.

• Utilize advanced statistical analysis, data mining, and predictive modeling techniques.

• Integrate disparate information and identify patterns and relationships across datasets.

• Create data visualizations to track key performance indicators and other significant program metrics.

• Host and conduct peer reviews of code produced by other developers.

• Conduct data validation to ensure accuracy and integrity of data.

• Develop stored procedures, jobs, views, tables, and other database objects within SQL Server Management Studio.

• Design and develop dimensional data models, encompassing star and snowflake schemas, fact and dimension tables, and enterprise data marts.

• Create and deploy ETL packages utilizing a CI/CD pipeline.

• Implement configuration management systems for version control.

• Work with the Atlassian Suite of software development management tools.

• Index system and application logs in Splunk, creating dashboards, alerts, and reports from those logs.

• Provide support for a mission-critical application utilized by the federal courts community.

⛳️ Requirements

• A minimum of seven (7+) years in server database maintenance and database analysis or a comparable role.

• Bachelor's degree in Computer Science, Computer Programming, Computer Engineering, or other relevant computer-based discipline; experience may substitute for a degree.

• Proficient experience with Microsoft SQL Server, Informix, and Oracle.

• Familiarity with Snowflake and exposure to cloud platforms such as Azure.

• Solid understanding of standard data warehouse principles.

• Skilled in data modeling, data mapping, data flow diagrams, and data marts.

• Prior experience in architecting and implementing cloud-based database solutions across various platforms.

• Experience in migrating data from legacy on-premises databases to multi-cloud/hybrid cloud environments.

• Proven ability to lead initiatives independently, prioritize effectively, and achieve results.

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

• Excellent organizational and time management capabilities.

• Ability to identify priorities and manage a diverse range of tasks within deadlines.

• Exceptional written and verbal communication skills.

• Capacity to collaborate with individuals at all levels.

• Comfortable drafting ideas, implementation plans, and status reports.

• Database or cloud certification is preferred, such as Microsoft Certified Azure Database Administrator Associate, Microsoft Azure Solutions Architect Expert, or other equivalent industry-recognized database certifications.

• Experience in creating and managing database reports, visualizations, and dashboards is preferred.

• Familiarity with court operations and law enforcement business data is preferred.

🏝️ Benefits

• Options for medical plans, including those with Health Savings Accounts.

• Options for dental plans.

• Vision plan availability.

• 401(k) plan featuring pre-tax and post-tax contributions with company matching.

• Flexible work weeks where feasible.

• Paid vacation, sick, and personal time off.

• Paid holidays.

• Paid leave for parental, military, bereavement, and jury duty.

• Short- and long-term disability benefits.

• Life insurance coverage.

• Accidental death and dismemberment insurance.

• Personal accident insurance.

• Critical illness insurance.

• Business travel and accident insurance.