Database Architect

Job Number: ? 652846 Job Category: ? Information Technology - Other Location: ? VIENNA, VA US Schedule: ? Full-time Travel: ? None Shift: ? Day Job Potential for Teleworking: ? Yes Clearance Level Must Currently Possess: ? None Clearance Level Must Be Able to Obtain: ? Public Trust Description: ?Leidos Veterans Health is seeking a Database Architect. Requires US Citizen or US Person (Green Card Holder) with the ability to obtain a site clearance; pass a minimal background investigation. Basic Qualifications: ? The Database Architect will design, maintain and build conceptual, logical and physical database models. The Database Architect will be responsible for database architecture, design, and creation, optimization, deriving conversion and migration methods for existing data, and developing automated conversion and migration methods. The Database Architect will be responsible for the planning, installation, configuration, maintenance and production monitoring of database instances. Must possess technical expertise in the creation and maintenance of database structures, complex queries, stored procedures, functions, and user security in a multi-server environment. Must be proficient in the use of SSRS, SSIS and applying general ETL principles and practices. Knowledge of data warehousing and data analytics would be highly beneficial. Maintains database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions. Determines database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems; Develops database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications. Installs database systems by developing flowcharts; applying optimum access techniques; coordinating installation actions; documents actions. Proficiency in the creation of Tableau reports using Tableau Desktop would be highly beneficial. Required Experience: ? Prior experience with installation, configuring and migrating versions of SQL server to include data migration tasks and activities and consistency checks Experience in Informatica ETL tools; SSIS, DTS, Bulk Insert including the ability to handle server mappings and object creation tasks in the preparation of routine ETLs and evaluating database performance impacts and remediation Experience in Business Process Modeling (BPM) Technical acumen of replication models such as Snapshot, Merge, and Transactional Experience in data processing tasks such as Data compressions, Data partitioning, CDC and updating statistics Adept in reporting applications such as SSRS, SSAS. Tableau experience is a plus. Technical knowledge of SQL Server functions such as Assemblies and interactions, XML data types, Data columns, Scalar valued functions Familiarity with performance tuning of databases using Windows performance monitor and SQL profiler Ability to handle server mapping and objects creation tasks and prepare routine ETLs and evaluate database performance Create routine queries with stored procedures and views and participate in tuning and optimization of stored procedures and database queries. Prepare users and user groups and managed access permissions. Formulate and execute schema objects including indexes and views. Desired Skills: ? Technologies: SQL Server, PostgreSQL database, TSQL, SSRS, Informatica ETL, SSIS ETL, MS Visio 2013/2010/2007, Navicat (database modeling), ER/Win, REST and SOAP Operating Systems: Windows 2016/2012/2008 R2, Linux Cloud Technologies: Amazon Web Services (AWS) - Elastic Cloud (EC2) Programming Languages: Java (JS, jQuery, AJAX), Java Script, C#, PHP, .NET Databases: MS SQL Server Management Studio (2016/2012/2008), MS SQL Server, PostgreSQL 9.x (including use of pgAdmin III & IV, Linux shell), Active Directory, MS Access, MS SQL Reporting Services, Data Reports, Informatica (ETL) Reporting/BI Tools: Microsoft SQL Reporting Services, Tableau Server, Tableau Desktop 9.3, Microsoft Power BI Desktop Modeling Tools: MS Visio 2013/2010/2007, Navicat (database modeling)= Web Servers: IIS 10.0/8.0/7.0/6.0, Tomcat Quality Tools: Load Runner, HP Quality Center, AutomatedTest QA, WebLoad, Selenium Qualifications: ? EDUCATION & EXPERIENCE: ? Requires BS and 4 - 8 years of prior relevant experience or Masters with 2 - 6 years of prior relevant experience. Leidos Overview: ? Leidos is a global science and technology solutions leader working to solve the world's toughest challenges in the defense, intelligence, homeland security, civil, and health markets. The company's 33,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Virginia, Leidos reported pro forma annual revenues of approximately $10 billion for the fiscal year ended January 1, 2016 after giving effect to the recently completed combination of Leidos with Lockheed Martin's Information Systems & Global Solutions business (IS&GS). For more information, visit www.Leidos.com. The company's diverse employees support vital missions for government and commercial customers. Qualified women, minorities, individuals with disabilities and protected veterans are encouraged to apply. Leidos will consider qualified applicants with criminal histories for employment in accordance with relevant Laws. Leidos is an Equal Opportunity Employer. Other Locations: ? - provided by Dice
Ajax, Architecture, Automated, BI Tools, Civil, Database, Development, IIS, Informatica, Java, jQuery, Linux, Management, Modeling, PHP, PostgreSQL, Programming, QA, Quality Center, Security, SOAP, SQL, SQL Server, Web Servers, Windows, XML

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Senior Development Database Architect (Minimum...
Dahlgren, VA InfoReliance Corporation
Principal Technical Program Manager, Database ...
McLean, VA MicroStrategy
Database Architect
Chantilly, VA Cgi
Federal - AWS Database Architect
Arlington, VA Accenture
Database Architect
Newport News, VA Cgi
Senior Database Architect
Dunn Loring, VA Leidos