Hands-on experience with Continuous Integration/Continuous Deployment pipelines and Database/Schema as Code tools and approaches. 8+ years
PostgreSQL 11 and 12 pgAdmin 4.8 - 3+ years
Strong SQL for database query and data updates in Production
Analyze database changes requested by the Agile development teams for impacts to database designs, naming standards, design standards, data conversions, and documentation.
Experience analyzing and tuning queries to improve query performance.
Hands-on experience with scripting to automate database changes/baselines including bash, pgplsql, or groovy (Jenkins).
Knowledge of installation, maintenance and administration of PosgtreSQL and configuration within AWS RDS.
Strong interpersonal and communication skills necessary to collaborate effectively with customers and other team members.
Desired Skills
Experience with large enterprise solutions including but not limited to high availability, disaster recovery, and data management.
Hands-on experience and in depth knowledge of AWS database offerings (e.g. RDS, Aurora, and Dynamo).
Experience with transforming data from Legacy databases into archival data stores.
Experience developing databases with an Agile development process and ceremonies including scrums, planning events, backlog grooming, retrospectives and demos.
Experience with Jenkins CI/CD tools and scripting.
Experience with Liquibase and LiquiGen plug-in.
Experience with Replication and Change Data Capture (CDC) techniques and tools.
Experience with data conversion and management strategies
Experience with database partitioning and micro-services
Operating System and Infrastructure experience with RedHat Linux and Windows 10.
Experience with source code versioning with Git, Bitbucket, or other source control tools.
Ability to meet deadlines, concentrate, and to pay attention to detail.