What are the responsibilities and job description for the Sr. Database Engineer position at BCMC?
BCMC is seeking a Sr. Database Engineer with Amazon Redshift expertise to work collaboratively with agile development teams in the design, development, and deployment of advanced cybersecurity capabilities. Hybrid work is allowed.
Responsibilities:
• Work with large structured and unstructured data sets - Implement data management systems from conception, through all stages of design, development, and deployment in a CI/CD agile environment
• Design, setup and administration of Amazon Redshift data warehouse in the AWS cloud
• Migrate data from legacy RDBMSs and other data sources to AWS cloud databases using AWS tools, programming languages, and complex ETL processes
• Design and implement the technical architecture necessary to support analytic and statistical processing requirements based on tradeoff between performance and quality
• Perform 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
• 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
• Develop a strong understanding of customer baseline capabilities, design and objectives, and applying improvements to systems
• Maintain current industry knowledge of relevant concepts, practices and procedures.
Required Skills:
• Must be a US Citizen. Active Secret clearance. Must be able to obtain a TS/SCI clearance. Must be able to obtain DHS Suitability
• This is a Hybrid position, but remote work will be considered
• Must have a minimum of 10 years of relevant professional experience
• Experience in the design, setup, management, data migration, and tuning of Redshift in the AWS cloud using AWS tools, and custom code
• Understanding and relevant experience with big data and data analytics
• Development experience building ETL pipelines at scale
• Experience with data transformation techniques such as aggregations, joins, and data cleaning
• Experience working with large structured and unstructured data sets
• Good understanding of Red Hat Enterprise Linux operating system, storage configurations, network architecture, VMware, management tools, and the trade-offs of various configurations on performance and data quality
• 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
• Possess 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; focus on customer service.
Desired Certifications:
• AWS Cloud certification such as AWS Certified Cloud Practitioner or AWS Certified Big Data Specialist
Required Education:
• Bachelor’s degree in information assurance, cyber or software engineering or a related discipline is required. [Twelve (12) years of experience (for a total of twenty-two (22) or more years) may be substituted for a degree.]
Our Company Overview:
Business Computers Management Consulting Group, LLC (BCMC) is a small business specializing in Information Technology (IT), Cybersecurity, Information Assurance (IA), SOA, 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. We are ISO 9001:2015, ISO 27001:2013, 20000:2018, and CMMI L3 certified and registered promising highest quality and services o all of our clients.
Benefits
Extremely competitive salary
95% employer paid for employee medical, dental, & vison 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
11 standard holidays & 3 weeks of annual leave
