Database Engineer Lead: Principal (TS)

Sterling, VA
Jun 18, 2019
Jun 21, 2019
Full Time
Database Engineer Lead **Top Secret Required** BCMC is looking for motivated individuals to support a long-term engineering program for one of the country's highest priority cyber initiatives. On this program you will have the opportunity to work with technical leaders in cyber, networking, computer science, and data analytics to develop the next generation of automated cyber defense platforms. Individuals in this role are responsible for implementing, deploying, and maintaining database systems. These capabilities are used to analyze, detect, and prevent sophisticated threats and vulnerabilities on enterprise networks. Responsibilities: Using database expertise to lead teams with diverse skill sets (eg data architects, data scientists, software developers) in support of a large, agile-based, cybersecurity system Working with large structured and unstructured data sets Implementing data management systems from conception, through all stages of design, development, and deployment in a CI/CD agile environment Design, setup, administer, and tune NoSQL databases in the AWS cloud Design and implement the technical architecture necessary to support analytic and statistical processing requirements based on tradeoff between performance and quality Performing data transformations such as aggregations, joins, and data cleaning to support analytic applications and visualizations Write and refine code to ensure quality and reliability of data extraction and processing Analyze and resolve data performance and quality issues Make data available to data scientists, programmers, and other users using programming and scripting languages such as R, Python, Java, JavaScript, etc. Perform data analysis and design, data modeling, business intelligence management, master data management, metadata management, data quality management, data security, auditing and other functions of data management and governance Generate data estimates of work to be performed, compare estimates to actuals, and continue to refine estimates Work collaboratively with agile development teams, attending daily scrums and providing data related solutions to development team Develop and maintain database code libraries, data models, SOPs, and other documentation in the team collaboration environment Migrate data from legacy RDBMSs and other data sources to NoSQL database in the AWS cloud using complex ETL processes, tools, and programming languages Maintain current industry knowledge of relevant concepts, practices and procedures Required Skills: Must have an active Top Secret (TS) clearance. Must be able to obtain a TS/SCI clearance Must be able to obtain DHS Suitability 10+ years of relevant database experience Demonstrated ability to lead teams with diverse skill sets (eg data architects, data scientists, software developers) Demonstrated experience mentoring junior to mid-level data professionals Able to effectively work as a leader, in a group, or as an individual contributor Excellent understanding of big data and data analytics Experience working with large structured and unstructured data sets Development experience building ETL pipelines at scale Solid SQL development skills Experience with Linux/Unix tools and shell scripts Expertise in data analysis and design, data modeling, master data management, metadata management, data warehousing, performance tuning, data quality improvement, data security, auditing and encryption Good communication skills, both oral and written Must work well in a team environment as well as independently Must exhibit good time management skills, independent decision making capability, and a focus on customer service. Desired Skills: Experience providing database engineering support to Intelligence, DoD, or DHS Customers Understanding of Certification and Accreditation (ICD 503/DCID 6/3) processes as they apply to database technologies Ability to support both SQL and NoSQL data management systems Expertise in other RDBMS platforms such as Oracle RAC and SQL Server Familiarity with AWS data migration tools such as AWS DMS, Amazon EMR, and AWS Data Pipeline Experience with data transformation techniques such as aggregations, joins, and data cleaning Experience with Red Hat Enterprise Linux (RHEL) operating system, storage configurations, network architecture, VMware, and/or related management tools Database management experience of SQL databases such as MySQL and PostgreSQL in AWS cloud Experience creating and managing NoSQL databases such as DynamoDB in the AWS cloud Object mapping and migration of data from legacy structured and unstructured data sources to Amazon DynamoDB using AWS tools, custom code, or ETL scripts Programming experience with languages such as R, Python, Java, JavaScript, JSON, etc. Knowledge of Hadoop ecosystem, Map/Reduce, and data management products including Hbase, Hive, and Pig DevSecOps and Continuous Integration / Continuous Delivery (CI/CD) knowledge Experience or training in Six Sigma Methodology ITIL knowledge and certification Familiarity with SAFe (Scaled Agile Framework). Required Education: BS Computer Science, Computer Engineering, Computer Information Systems, OR Computer Systems Engineering. Two years of related work experience may be substituted for each year of degree level education Desired Certifications: IBM Certified Data Engineer - Big Data Google Cloud Certified Professional - Data Engineer Cloudera Certified Professional - Data Engineer CCDH: Cloudera Certified Developer for Apache Hadoop CCAH: Cloudera Certified Administrator for Apache Hadoop CCSHB: Cloudera Certified Specialist in Apache HBase CSSLP Certified Secure Software Lifecycle Professional Certifications related to Scaled Agile Framework (SAFe) such as SAFe Practitioner (SP) or SAFe Program Consultant (SPC) DoD 8570.1 IAT Level I Company Overview: BCMC is an Information Technology (IT), Cybersecurity, Information Assurance (IA), Big Data Management, Program Management, and more for Federal, State, and Local agencies. We possess highly skilled engineers, providing innovative solutions backed by strong past performances. Benefits Extremely competitive salary 95% employer paid for employee medical, dental, & vision coverages 100% employer paid for employee life, STD & LTD disability coverages 401k with company match and profit sharing Flexible Spending Account (FSA) for dependent & health care 10 standard holidays & competitive Paid Time Off (PTO)