Data Architect - 1601818 with Security Clearance
Computer Technologies Consultants (CTC) is seeking a Data Architect to support the US Department of State in Arlington, VAThis position is telework eligibleWith offices in Washington DC and San Diego, CA, CTC is a leading technology company providing lifecycle IT, data analytics, cloud managed hosting services, agile software development, DevOps, Test Automation, Cyber Security, and infrastructure solutionsAdditionally, we provide Professional Talent Acquisition Services as we proudly support the unique needs of U.
SDefense, Intelligence, and Federal Civilian agencies as well as Fortune 1000 companiesGot the Government Contractor Blues? Looking for a company that cares and goes beyond just filling another contract billet? Well look no further! Experience this family-oriented company who takes pride in you and will help you grow where your passions lieHolding many Defense & Federal government contracts around the globe, with our client you have the opportunity to take on new and evolving challenges, aim beyond what you think you are capable of and work in collaborative, dynamic, and high-tempo environmentsOur clients' employees are their most valued asset and they invest in their people because they are in it for the long termThey are committed to your success and well-being and offer competitive benefits packages, salaries, bonus/award programs, and a high potential for professional growth and job opportunities world-wideWhy Should You Be Interested ? oDirect hire full-time position oTelework eligible oCompetitive base salary and comprehensive benefits oMid-size company with room for growth Position Title :
Data Architect Position Location :
Candidate must reside in DC/MD/VA, this position is telework eligible Daily Responsibilities :
oResponsible for designing, creating, deploying and managing how the data will be stored, consumed, integrated and managed by different data entities and IT systems, as well as anyapplications using or processing that data in some wayoDesign new architectures and re-designing existing architectures; including data structures and database codeDesign and build relational databasesoPerform data access analysis design, and archive/recovery design and implementation, especially in a Microsoft SQL Server environmentAble to define, design, and build dimensional databasesoDesign and implement all database objects including schemas, tables, clusters, indexes, views, sequences, packages and procedures based on system requirements oDevelop data warehousing blueprints, evaluating hardware and software platforms, and integrating systemsDevelop strategies for data acquisitions, archive recovery, and implementation of a databaseTranslates business needs into long-term architecture solutions oManaging input of various data sources, definition of database architecture, development of database code, construction and maintenance of ETL based processes, design of database reporting, construction of data flow diagrams and creation of documentation manualsoCreating code for database modification, constructing and accessing databases using stored procedures, triggers and functions; developing ETL processesoImplement and optimize queries and stored proceduresExpert knowledge with data profiling and migration tasksData migration expertiseoDesigning new architectures and re-designing existing architectures (including data structures and database code) oReview and develop object and data models and the metadata repository to structure the data for better management and quicker accessoProvide guidance and support to all technical positions including system architects, developers and database administratorsoThe requirements as stated above reflect industry standardsRequired Years of Experience (min) :
o10 years of professional experience in database architecture o12 years related in the software development fieldoAt least 3 years of experience managing data integration between SaaS solutions and between SaaS and.
NET applicationsRequired Degree/Certifications :
oBS/BA degree in Computer Science, Information Sciences, or related IT discipline OR Allowable Substitution:
Additional ten (10) years of related professional experience can be substituted for a BS/BA degreeRequired Experience :
oA minimum of 10 (ten) years of professional experience in database architectureoA minimum of 12 (twelve) years related in the software development fieldoAt least 3 years of experience managing data integration between SaaS solutions and between SaaS and.
NET applicationsoExpert in backup integrity and disaster recovery situationsExpert in a data warehouse environment, which includes data design, database architecture, and metadata repository creationoExpert with data definition language to implement database objectsExperience with coding stored procedures, functions, and triggers to implement data access controls oExpert reviewing, testing, and troubleshooting database structures and codeExperience masking and replicating large data sets (for privacy and testing purposes) using enterprise tools oEnforce change management processes in each environment oExpert-level knowledge of Microsoft SQL ServeroThe minimum experience and education requirements for this position are due to the complexity, at the program level, of the tasks at handThis senior level position will be instrumental in designing, updating and maintaining mission critical systemsRequired Clearance :
oSecret or ability to obtain Secret clearance Recommended Skills Relational Databases Data Architecture Extract Transform Load (Etl) Metadata Teradata Sql Data Migration Estimated Salary: $20 to $28 per hour based on qualifications.
SDefense, Intelligence, and Federal Civilian agencies as well as Fortune 1000 companiesGot the Government Contractor Blues? Looking for a company that cares and goes beyond just filling another contract billet? Well look no further! Experience this family-oriented company who takes pride in you and will help you grow where your passions lieHolding many Defense & Federal government contracts around the globe, with our client you have the opportunity to take on new and evolving challenges, aim beyond what you think you are capable of and work in collaborative, dynamic, and high-tempo environmentsOur clients' employees are their most valued asset and they invest in their people because they are in it for the long termThey are committed to your success and well-being and offer competitive benefits packages, salaries, bonus/award programs, and a high potential for professional growth and job opportunities world-wideWhy Should You Be Interested ? oDirect hire full-time position oTelework eligible oCompetitive base salary and comprehensive benefits oMid-size company with room for growth Position Title :
Data Architect Position Location :
Candidate must reside in DC/MD/VA, this position is telework eligible Daily Responsibilities :
oResponsible for designing, creating, deploying and managing how the data will be stored, consumed, integrated and managed by different data entities and IT systems, as well as anyapplications using or processing that data in some wayoDesign new architectures and re-designing existing architectures; including data structures and database codeDesign and build relational databasesoPerform data access analysis design, and archive/recovery design and implementation, especially in a Microsoft SQL Server environmentAble to define, design, and build dimensional databasesoDesign and implement all database objects including schemas, tables, clusters, indexes, views, sequences, packages and procedures based on system requirements oDevelop data warehousing blueprints, evaluating hardware and software platforms, and integrating systemsDevelop strategies for data acquisitions, archive recovery, and implementation of a databaseTranslates business needs into long-term architecture solutions oManaging input of various data sources, definition of database architecture, development of database code, construction and maintenance of ETL based processes, design of database reporting, construction of data flow diagrams and creation of documentation manualsoCreating code for database modification, constructing and accessing databases using stored procedures, triggers and functions; developing ETL processesoImplement and optimize queries and stored proceduresExpert knowledge with data profiling and migration tasksData migration expertiseoDesigning new architectures and re-designing existing architectures (including data structures and database code) oReview and develop object and data models and the metadata repository to structure the data for better management and quicker accessoProvide guidance and support to all technical positions including system architects, developers and database administratorsoThe requirements as stated above reflect industry standardsRequired Years of Experience (min) :
o10 years of professional experience in database architecture o12 years related in the software development fieldoAt least 3 years of experience managing data integration between SaaS solutions and between SaaS and.
NET applicationsRequired Degree/Certifications :
oBS/BA degree in Computer Science, Information Sciences, or related IT discipline OR Allowable Substitution:
Additional ten (10) years of related professional experience can be substituted for a BS/BA degreeRequired Experience :
oA minimum of 10 (ten) years of professional experience in database architectureoA minimum of 12 (twelve) years related in the software development fieldoAt least 3 years of experience managing data integration between SaaS solutions and between SaaS and.
NET applicationsoExpert in backup integrity and disaster recovery situationsExpert in a data warehouse environment, which includes data design, database architecture, and metadata repository creationoExpert with data definition language to implement database objectsExperience with coding stored procedures, functions, and triggers to implement data access controls oExpert reviewing, testing, and troubleshooting database structures and codeExperience masking and replicating large data sets (for privacy and testing purposes) using enterprise tools oEnforce change management processes in each environment oExpert-level knowledge of Microsoft SQL ServeroThe minimum experience and education requirements for this position are due to the complexity, at the program level, of the tasks at handThis senior level position will be instrumental in designing, updating and maintaining mission critical systemsRequired Clearance :
oSecret or ability to obtain Secret clearance Recommended Skills Relational Databases Data Architecture Extract Transform Load (Etl) Metadata Teradata Sql Data Migration Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
