Database Architect

Assent Advisory Group Full Time Norfolk, VA Posted 1 day ago Locations: Norfolk, VirginiaGovernment and client locations as required Job Description Assent Advisory Group is seeking a Database Architect to support the design, development, integration, and optimization of enterprise database environments supporting federal government programs. The successful candidate will help design strategies for enterprise database systems, establish standards for database operations, programming, and security, and support the design and construction of large relational databases. The position will also support integration of new systems into existing data warehouse structures and improvement of database performance and functionality. This is a journeyman-level position requiring 3–10 years of relevant experience in database architecture, database engineering, data warehousing, or related technical disciplines. Role And Responsibilities Design and support strategies for enterprise database systems.Design, develop, and maintain relational database structures.Support development and implementation of database architecture standards.Establish and maintain standards for database operations, programming, security, and data management.Design and construct large relational databases.Integrate new systems and data sources into existing database and data warehouse environments.Analyze database performance and recommend improvements to performance, scalability, and functionality.Develop and maintain logical and physical data models.Support database schema design, normalization, indexing, and query optimization.Assist with data migration, data integration, and system modernization initiatives. Support database security, access controls, data integrity, and governance requirements.Troubleshoot database and data-integration issues.Coordinate with software developers, data scientists, business intelligence analysts, systems engineers, cybersecurity personnel, and program leadership.Develop technical documentation, architecture diagrams, data dictionaries, and system design documentation.Support testing, validation, configuration management, and implementation of database changes.Assist in the development of data warehouse and enterprise analytics environments. Experience 3–10 years of relevant professional experience in database architecture, database engineering, database administration, data warehousing, data integration, or a related field.Demonstrated experience designing and supporting relational databases.Experience integrating new systems with existing database or data warehouse environments.Experience analyzing and improving database performance and functionality.Working knowledge of database security and access-control principles.Experience developing or maintaining data models and database schemas.Strong troubleshooting and analytical skills.Ability to work independently and within multidisciplinary technical teams.Strong written and verbal communication skills.Federal government or Department of Defense experience preferredCitizenship: Must be a U.S. Citizen. Education Bachelor’s degree in Computer Science, Information Systems, Information Technology, Data Engineering, Software Engineering, Computer Engineering, or a related technical discipline preferred.Relevant professional experience may be considered in lieu of degree requirements where permitted by the contract. Licenses/Certifications Microsoft Certified: Azure Database AdministratorMicrosoft Certified: Azure Data EngineerOracle Database certificationAWS Database certificationMicrosoft Fabric certificationCompTIA Data+Other database, cloud, or data engineering certificationsCurrent federal security clearance preferred but not required for all positions.Ability to obtain and maintain a Public Trust, Secret, or higher clearance if required by the contract. Preferred Technical Skills SQLMicrosoft SQL ServerPostgreSQLOracleAzure SQLRelational database designData warehouse architectureETL / ELT processesData modelingDatabase performance tuningIndexing and query optimizationData integrationMicrosoft AzurePower BI data architectureMicrosoft FabricData governance and securityAPIs and system interfaces Job Features Job Category Data Scientist Salary Range $90,000 - $145,000 Apply For This Job Name* Email* Phone* United States+1United Kingdom+44Afghanistan (‫افغانستان‬‎)+93Albania (Shqipëri)+355Algeria (‫الجزائر‬‎)+213American Samoa+1Andorra+376Angola+244Anguilla+1Antigua and Barbuda+1Argentina+54Armenia (Հայաստան)+374Aruba+297Australia+61Austria (Österreich)+43Azerbaijan (Azərbaycan)+994Bahamas+1Bahrain (‫البحرين‬‎)+973Bangladesh (বাংলাদেশ)+880Barbados+1Belarus (Беларусь)+375Belgium (België)+32Belize+501Benin (Bénin)+229Bermuda+1Bhutan (འབྲུག)+975Bolivia+591Bosnia and Herzegovina (Босна и Херцеговина)+387Botswana+267Brazil (Brasil)+55British Indian Ocean Territory+246British Virgin Islands+1Brunei+673Bulgaria (България)+359Burkina Faso+226Burundi (Uburundi)+257Cambodia (កម្ពុជា)+855Cameroon (Cameroun)+237Canada+1Cape Verde (Kabu Verdi)+238Caribbean Netherlands+599Cayman Islands+1Central African Republic (République centrafricaine)+236Chad (Tchad)+235Chile+56China (中国)+86Christmas Island+61Cocos (Keeling) Islands+61Colombia+57Comoros (‫جزر القمر‬‎)+269Congo (DRC) (Jamhuri ya Kidemokrasia ya Kongo)+243Congo (Republic) (Congo-Brazzaville)+242Cook Islands+682Costa Rica+506Côte d’Ivoire+225Croatia (Hrvatska)+385Cuba+53Curaçao+599Cyprus (Κύπρος)+357Czech Republic (Česká republika)+420Denmark (Danmark)+45Djibouti+253Dominica+1Dominican Republic (República Dominicana)+1Ecuador+593Egypt (‫مصر‬‎)+20El Salvador+503Equatorial Guinea (Guinea Ecuatorial)+240Eritrea+291Estonia (Eesti)+372Ethiopia+251Falkland Islands (Islas Malvinas)+500Faroe Islands (Føroyar)+298Fiji+679Finland (Suomi)+358France+33French Guiana (Guyane française)+594French Polynesia (Polynésie française)+689Gabon+241Gambia+220Georgia (საქართველო)+995Germany (Deutschland)+49Ghana (Gaana)+233Gibraltar+350Greece (Ελλάδα)+30Greenland (Kalaallit Nunaat)+299Grenada+1Guadeloupe+590Guam+1Guatemala+502Guernsey+44Guinea (Guinée)+224Guinea-Bissau (Guiné Bissau)+245Guyana+592Haiti+509Honduras+504Hong Kong (香港)+852Hungary (Magyarország)+36Iceland (Ísland)+354India (भारत)+91Indonesia+62Iran (‫ایران‬‎)+98Iraq (‫العراق‬‎)+964Ireland+353Isle of Man+44Israel (‫ישראל‬‎)+972Italy (Italia)+39Jamaica+1Japan (日本)+81Jersey+44Jordan (‫الأردن‬‎)+962Kazakhstan (Казахстан)+7Kenya+254Kiribati+686Kosovo+383Kuwait (‫الكويت‬‎)+965Kyrgyzstan (Кыргызстан)+996Laos (ລາວ)+856Latvia (Latvija)+371Lebanon (‫لبنان‬‎)+961Lesotho+266Liberia+231Libya (‫ليبيا‬‎)+218Liechtenstein+423Lithuania (Lietuva)+370Luxembourg+352Macau (澳門)+853Macedonia (FYROM) (Македонија)+389Madagascar (Madagasikara)+261Malawi+265Malaysia+60Maldives+960Mali+223Malta+356Marshall Islands+692Martinique+596Mauritania (‫موريتانيا‬‎)+222Mauritius (Moris)+230Mayotte+262Mexico (México)+52Micronesia+691Moldova (Republica Moldova)+373Monaco+377Mongolia (Монгол)+976Montenegro (Crna Gora)+382Montserrat+1Morocco (‫المغرب‬‎)+212Mozambique (Moçambique)+258Myanmar (Burma) (မြန်မာ)+95Namibia (Namibië)+264Nauru+674Nepal (नेपाल)+977Netherlands (Nederland)+31New Caledonia (Nouvelle-Calédonie)+687New Zealand+64Nicaragua+505Niger (Nijar)+227Nigeria+234Niue+683Norfolk Island+672North Korea (조선 민주주의 인민 공화국)+850Northern Mariana Islands+1Norway (Norge)+47Oman (‫عُمان‬‎)+968Pakistan (‫پاکستان‬‎)+92Palau+680Palestine (‫فلسطين‬‎)+970Panama (Panamá)+507Papua New Guinea+675Paraguay+595Peru (Perú)+51Philippines+63Poland (Polska)+48Portugal+351Puerto Rico+1Qatar (‫قطر‬‎)+974Réunion (La Réunion)+262Romania (România)+40Russia (Россия)+7Rwanda+250Saint Barthélemy+590Saint Helena+290Saint Kitts and Nevis+1Saint Lucia+1Saint Martin (Saint-Martin (partie française))+590Saint Pierre and Miquelon (Saint-Pierre-et-Miquelon)+508Saint Vincent and the Grenadines+1Samoa+685San Marino+378São Tomé and Príncipe (São Tomé e Príncipe)+239Saudi Arabia (‫المملكة العربية السعودية‬‎)+966Senegal (Sénégal)+221Serbia (Србија)+381Seychelles+248Sierra Leone+232Singapore+65Sint Maarten+1Slovakia (Slovensko)+421Slovenia (Slovenija)+386Solomon Islands+677Somalia (Soomaaliya)+252South Africa+27South Korea (대한민국)+82South Sudan (‫جنوب السودان‬‎)+211Spain (España)+34Sri Lanka (ශ්‍රී ලංකාව)+94Sudan (‫السودان‬‎)+249Suriname+597Svalbard and Jan Mayen+47Swaziland+268Sweden (Sverige)+46Switzerland (Schweiz)+41Syria (‫سوريا‬‎)+963Taiwan (台灣)+886Tajikistan+992Tanzania+255Thailand (ไทย)+66Timor-Leste+670Togo+228Tokelau+690Tonga+676Trinidad and Tobago+1Tunisia (‫تونس‬‎)+216Turkey (Türkiye)+90Turkmenistan+993Turks and Caicos Islands+1Tuvalu+688U.S. Virgin Islands+1Uganda+256Ukraine (Україна)+380United Arab Emirates (‫الإمارات العربية المتحدة‬‎)+971United Kingdom+44United States+1Uruguay+598Uzbekistan (Oʻzbekiston)+998Vanuatu+678Vatican City (Città del Vaticano)+39Venezuela+58Vietnam (Việt Nam)+84Wallis and Futuna (Wallis-et-Futuna)+681Western Sahara (‫الصحراء الغربية‬‎)+212Yemen (‫اليمن‬‎)+967Zambia+260Zimbabwe+263Åland Islands+358 A valid phone number is required. Cover Letter Attach Resume* No file chosen Browse