SME Database Architect

  • General Dynamics
  • 1175 Colony Square Suite 1700, Atlanta, GA 30361, USA
  • Nov 09, 2020
[Information Technology]

Job Description

Responsibilities for this PositionLocation: USA GA AtlantaFull Part/Time: Full timeJob Req: RQ70055Type of Requisition:RegularClearance Level Must Currently Possess:NoneClearance Level Must Be Able to Obtain:NoneSuitability:No Suitability RequiredPublic Trust/Other Required:NoneJob Family:Database Analysis/DesignJob Description:GDIT is seeking a Database Architect to join our team in support of The Centers for Disease Control and Prevention's (CDC) Office of Financial Resources (OFR) to implement an Acquisition Management System (AMS). GDIT will acquire, configure, implement, and provide go-live support, providing a low-code commercial off-the-shelf (COTS) solution.To implement the AMS, the overall team will be engaged in all aspects of the deployment from requirements gathering, architectural design, software configuration and development, testing, implementation and deployment support, change management, training, data migration, data management, and post go-live support.This position is for full time employment with GDIT. Business hours are 8:00am - 5:00pm, Monday through Friday. All work is remote with travel as requested to Atlanta, GA locations at both GDIT (2 Corporate Blvd., Suite 100 Atlanta, GA 30329) and CDC (2939 Brandywine Road, Atlanta, GA 30341).Requirements:Design strategies for enterprise database systems and set standards for operations, programming, and security. Design and construct large relational databases. Integrate new systems with existing warehouse structure and refine system performance and functionality. --Provides technical/management leadership on major tasks or technology assignments. Establishes goals and plans that meet project objectives. Has domain and expert technical knowledge. Directs and controls activities for a client, having overall responsibility for financial management, methods, and staffing to ensure that technical requirements are met. Interactions involve client negotiations and interfacing with senior management.Decision making and domain knowledge may have a critical impact on overall project implementation. May supervise others.The Database Architect will conduct full lifecycle activities to include requirements analysis and design, develop analysis and reporting capabilities, and continuously monitor performance and quality control plans. This work involves designing and administering data collection tools, cleaning, merging, and managing new and existing data sets as well as establishing and maintaining data quality procedures to ensure accuracy and timeliness of data.* Monitor and report system resource consumptions to assure databases meet requirements* Identify, analyze, and interpret trends or patterns in complex data sets* Identify and define database processes improvement opportunities* Coordinate with the database developers and ensure implementation of standards and modular structures* Design & administer all schemas in SQL Server databases; includes management of all database objects & dependencies* Create and manage the Data Flow & Data Modeling for multiple systems* Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements* Responsible for monitoring, verifying & tracking all structure changes in SQL Server and other databases through source control* Work along with the development lead in approving database structure changes and updates prior to releases* Manage & update the entity relationship diagrams (ERDs) (logical & physical) for SQL Server and other databases* Review, update, & manage data dictionaries for all schemas in SQL ServerQUALIFICATIONS:Required skills and experience:* BA/BS and 10+ years' experience. (Degree in Computer Science, Information Systems or related area is preferred)* 5+ years of current experience as a database architect* Extensive experience in the development of databases objects including stored procedures, triggers, views and functions* Experience with trouble shooting database performance issues including optimization* Extensive experience with packaging and delivering database updates for production releases* Experience with creating database documentation including ERD's, data dictionaries and architecture diagrams.* Ability to obtain public trust clearanceDesired skills and experience:* Experience working in an Agile development team is preferred* In depth experience in data analysis* Superior technical documentation skillsSKILLS AND ATTRIBUTES:* Excellent listening and interpersonal skills* Strong written and verbal communication skills* Strong attention to detail and requirements with the ability to meet project deadlines* Ability to collect, organize, analyze, and disseminate significant amounts of informationScheduled Weekly Hours:40Travel Required:Less than 10%T elecommuting Options:Some Telecommuting AllowedWork Location:USA GA AtlantaAdditional Work Locations:We are GDIT. The people supporting some of the most complex government, defense, and intelligence projects across the country. We deliver. Bringing the expertise needed to understand and advance critical missions. We transform. Shifting the ways clients invest in, integrate, and innovate technology solutions. We ensure today is safe and tomorrow is smarter. We are there. On the ground, beside our clients, in the lab, and everywhere in between. Offering the technology transformations, strategy, and mission services needed to get the job done.
GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.