DBA Consultant

Job Description:
Essential Skills:

• Experience as an application DBA in an Oracle and/or PostgreSQL environment.
• Experience writing database procedural code. PL/SQL, T/SQL
• Experience in database schema design and implementation in one or more AWS data storage and access technologies such as AWS RDS (Oracle and PostgreSQL, Aurora, Redshift, S3, Glue Meta Store
• Experience working w/ design teams on large scale data movement projects.
• Application and database performance tuning.
• Experience with UNIX/Python scripting and Dev/Ops tools.
• Experience in relational and dimensional data modeling.
• Experience using data modeling tools like ER Studio or ERWin.
• Experience working with file formats like JSON, Parquet, XML, Avro
• Development and coding experience in PL/SQL, Python, JAVA.

Responsibilities:

• Support team with managing data and perform development or maintenance work on data models to support enterprise projects.
• Provide analysis and feedback on data model discrepancies and integration challenge.
• Coordinate with business units and technical staff to understand data usage, lineage, and attributes.
• Align data architecture workstreams with business objectives.
• Gather information for new data models and/or reuse of data models in new environment.

Mandatory Skills:

• PL/SQL , PostgreSQL, Oracle, SQL, Python, SQL , Data modeling knowledge, SQL Tunning.