Cloud Architect at ICSA in Gaithersburg, MD
ICSA, Inc.Gaithersburg, MD
Cloud Database Developer Architect Location Gaithersburg, MD
DescriptionClient is seeking a highly motivated Cloud Database Developer and Architect to contribute to the development and administration support of a large federal IT project. The candidate should have a solid understanding of database design, development and management, using Microsoft Azure services, and should be able to perform quality control, transform data via ETL processes, debug and analyze code, and work with team members to ensure a high quality end product. The ideal candidate for this position is someone who bull Has excellent analytical, problem solving, and debugging skills bull Works both independently and as a part of a team bull Is able to effectively collaborate with a development team, business analysts, and projects managers Core Responsibilities bull Provide development and administration support for numerous MS SQL databases in an Azure Cloud based development environment including TSQL development (stored procedures and triggers), SQL and index performance tuning, and database design bull Develop and maintain Extract
- Load (ETL) scripts, SQ
L scripts, and ETL schedules, using MS SQL Server Integration Services or Azure Data Factor bull Develop and implement all database indexing, maintenance, backup, transformations, and stored procedures, utilizing SQL Management Studio and Azure Management Portal bull Ability to evaluate and recommend other cloud-based data storage mechanisms, such as Blob, Table, Cosmos DB, Graph, etc. to optimize the design and architecture of the platform based on requirements bull Strong understanding of Azure platform capabilities for the design and development of modern applications, SaaS and PaaS solutions bull Lead the development of engineering artifacts documenting the systemrsquos design and architecture or the cloud-based databases, including Technical Design Document preparation and delivery bull Work with business analysts to fully understand business requirements and convert into appropriate technical solutions bull Provide accurate estimates of effort required to complete assignments bull Conduct reviews to ensure all code passes organizationally-mandated code reviews and audits bull Complete assignments according to the established deadlines Requirements bull B.S. or M.S. in Computer Science or equivalent work experience bull Minimum of 5 years of experience in database design, development and management bull Microsoft Azure, or other Cloud relevant experience in Database Architecture and Design bull Demonstrated knowledge of transactional database and data warehouse architecture, design, and development (star schema, high dimensional model, fact tables, etc.) bull Deep knowledge of relational databasersquos objects and their functions bull Demonstrated experience with MS SQL Server Integration Services and SQL Scripts bull Familiarity with backup recovery, performance tuning and optimization. bull Extensive data migration skills and working experience with ETL concepts and tools Preferred Qualifications bull Developinginstantiating conceptual, logical, and physical data models bull Extensive knowledge in ER Diagram and design of logical and physical data modelling bull Experience working with Microsoft Azure. bull Experience working in an iterative software development life-cycle bull Experience in government health care programs Laxman 703-445-6985
More ICYMI Jobs
Uh oh! Something went wrong. Please try again.