Database Developer with Scripting expertise

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.

Required Skills

• 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.

Desired Skills

• 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

Position Details: 

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

Tagged as: Database Developer with Scripting expertise