Senior Database Analyst/Administrator

Posted 16 hours ago

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

📋 Description

• Engage in an Agile solution development environment characterized by daily scrums, biweekly sprint planning, and quarterly Program Increment planning.

• Establish operating standards and best practices focusing on performance, security, scalability, and maintainability.

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

• Facilitate efficient relationships between data, systems integration, and physical structures.

• Take part in the creation and implementation of database management policies and standards.

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

• Work alongside agency leaders, stakeholders, consultants, and program/agency staff to explore innovative data analysis techniques.

• Document intricate workflow designs for project teams and stakeholders.

• Analyze complex issues and contribute to business strategy, ideas, and methodologies within the Agile framework.

• Collect, analyze, and interpret extensive data sets to inform business decisions.

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

• Integrate data from various sources and create visual representations for KPIs and program metrics.

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

• Execute data validation to ensure data accuracy and integrity.

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

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

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

• Employ configuration management systems for version control purposes.

• Utilize the Atlassian Suite of software development management tools.

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


⛳️ Requirements

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

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

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

• Experience with Snowflake and familiarity with cloud platforms, specifically the Azure cloud platform.

• Background in database environment installation, configuration, and ongoing administrative support.

• Solid understanding of standard Data Warehouse concepts.

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

• Previous 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.

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

• Excellent organizational and time management skills.

• Outstanding written and verbal communication skills.

• Database or cloud certification preferred, such as Microsoft Certified Azure Database Administrator Associate or Microsoft Azure Solutions Architect Expert.

• 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 some with Health Savings Accounts.

• Various dental plan options.

• Vision plan available.

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

• Flexible work weeks when feasible.

• Vacation, sick, and personal time off.

• Paid holidays.

• Paid parental leave.

• Military leave available.

• Bereavement leave offered.

• Jury duty leave provided.

• 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.

People also viewed

Scholastic11 hours ago

Distribution/Fleet Planning Administrator

US flagFlorida OnlyFull-timeAdministration$20/hour
ApplyView job
Marsh McLennan12 hours ago

Senior Team Leader, Pension Administration

US flagUnited States OnlyFull-timeAdministration$57k – $114.5k/year
ApplyView job
Marsh McLennan12 hours ago

Senior Team Leader, Pension Administration

US flagUnited States OnlyFull-timeAdministration$57k – $114.5k/year
ApplyView job
Resolve Tech Solutions13 hours ago

Senior BASIS Administrator

US flagUnited States OnlyFull-timeAdministration
ApplyView job
Hunt St14 hours ago

Insurance Accounts Administrator

PH flagPhilippines OnlyFreelanceAdministrationA$1,700/month
ApplyView job
UVA Health15 hours ago

Senior Grants Administrator, Pre-Award – Office of Sponsored Programs

US flagVirginia OnlyFreelanceAdministration
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers