
Senior Database Analyst/Administrator
Posted 16 hours ago

Posted 16 hours ago
This is a fully remote position, open to applicants in Virginia.
• 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.
• 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.
• 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.
Scholastic
Marsh McLennan
Marsh McLennan
Resolve Tech Solutions
Get handpicked remote jobs straight to your inbox weekly.