The Senior Database Architect is responsible for the analysis, design, development, and implementation of the data architecture in support of the agency mission.
The Senior Database Architect will architect the analytical data systems including data warehouse(s), data lake(s), and data mart(s) as best meet the agency requirements.
The Senior Database Architect is familiar with a variety of the database technologies, concepts, methodologies, practices, and procedures and rely on experience and judgment to plan and accomplish goals.
Database Architects perform a variety of complicated tasks with minimal or no direct supervision. They assist in defining system and application architecture and provide vision, problem anticipation, and problem-solving ability to the agency. They consult with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions, utilizing knowledge of theory, principles, or technology of specific discipline or field of specialization.
Role Description: | •
Possesses extensive knowledge of one or more database systems and is capable of hands-on work in all phases of database design and management. •
Three (3) years of experience working with Microsoft SQL Server. • Four (4) years of experience in designing data model and architecture to support high performance, high availability data analytic functions for relational (structured), unstructured, and spatial data sets. • Determines data structural requirements by analyzing client operations, applications, programming, reporting, analytics and informatics; reviewing objectives with clients; and evaluating systems. •
Develops reliable and scalable database solutions through designing and implementing proposed system • Defines database physical structure, functional capabilities, security, back-up, and recovery specifications. •
Produces data flow diagrams and flowcharts; applies optimum access techniques; coordinating installation actions; and documents actions. •
Participates in the identification, prioritization, and development of technical initiatives and strategies. •
Works with database analysts to develop methodologies, report views, queries, analytical cubes, and table replications • Performs systems analysis on database, and resolves performance, capacity, and replication issues as necessary. •
Ensures that all data is in the proper format. •
Develops and maintains database standards and naming conventions. •
Keeps up to date on emerging database architectures, technologies, and methodologies, and attends training classes as necessary. •
Understands and knows best practices regarding application of different analytical data solutions such as data warehouse, data lakes, or data marts from the ground up in support of an organization initiative. |
SkillRequired / DesiredAmount of Experience
#cb #dice
What We Do
vTech solution Inc. is a Managed IT Services firm based out of Washington DC with a primary focus on Cloud Computing and Professional Services.
vTech was incorporated in January 2006 under the Commonwealth of Virginia as an IT Professional firm. vTech has experienced constant growth over the years and has developed various IT service capabilities by diversifying its service portfolio to IT Consulting, Enterprise Software Solutions, and Cloud Computing Services to provide complete IT Managed Service offerings.
Currently, we are one of the nation’s fastest-growing private companies and have been consecutively named in INC. 5000 list for the past five years.
Our focus is to enhance the level of success for our clients by efficiently offering the highest quality services. We use the most advanced IT technologies and practices to add value to our client services.
We specialized in core competencies which include Cloud solutions, Network Services, Security Solutions, Customized Application Services, System Integration, AI Tools, and Professional IT Services such as Project Management, Staff Augmentation, and IT Infrastructure Services.
vTech Solution's unwavering dedication to results defines our brand. Our time-tested management processes, quality control methods, and state-of-the-art work environment ensure that our clients' most complex projects are delivered on time, on budget, and message.
"vTech encourages and supports a healthy work-life balance for its employees. It offers a workplace where you can work with dignity and independence. vTech offers a competitive salary and comprehensive benefits package. We offer tuition and training expense reimbursement and a flexible work schedule."