Centurion Consulting Group
Database Developer with Scripting expertise Windsor Mill, MD
We are hiring a Database Developer with Scripting expertise for a multi year federal program in Baltimore, MD.
Key Required Skills: Database developer, data loading, and expert in the SQL and scripting skills. Design, development, testing, and maintenance of UNIX shell scripting and Python
• Expert in the various data loading techniques to Greenplum MPP database and develop process to automate it, and troubleshoot any data load errors
• Experience with Greenplum or PostgreSQL database administration and application connection troubleshooting tasks
• Database development experience with strong skills in SQL, PL/SQL and PL/pgSQL.
• Expert in shell scripting, regular expression and automating tasks
• Perform source system data analysis to understand data relationships
• Investigate and resolve data quality, data loading failures and develop data cleansing routines
• Design and document logical and physical data models in data modeling tool
• Generate Data Definition Language (DDL) scripts from modeling tool
• Design and document source to target data mappings
• Design, develop and test custom data loading and data manipulation routines
• Automate the custom data loading process and continue to improve based on requirements.
• Provide ad hoc query support for ad hoc query requests
• Experience with AWS, EC2, S3
• Provide mentorship to group members and will be expected to help develop and support mid and junior level staff.
• May be scheduled for after hours on-call support and will be required to support production release during non-peak hours.
• Experience working with complex data warehouse projects
• Experience designing custom data loading and manipulation processes to populate the data warehouse
• Ability to analyze source data for potential data quality issues and address these issues
• Ability to effectively communicate information, both verbally and written to end users, team members and management
• High-level knowledge of various industry leading data ware house components (databases, BI/reporting tools)
• Experience in scripting (Shell scripting, python, Java) and automation
• Experience with DevOps
• Prepare technical documents and presentation
• Familiarity with Atlassian product suites, git, bitbucket, confluence, jira.
• Ansible scripting
• Experience with cloud environment, AWS
• Database Administration (DBA) skills
Education: Bachelors degree from an accredited college in a related discipline and 7+ years of experience
Clearance: Ability to Obtain a Public Trust
US Citizenship or Authorization to work in US required
Travel: < 10% (CONUS)
Centurion Consulting Group, LLC is an Equal Opportunity Employer EOE M/F/D/V
No third parties or subcontractors