• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 22nd Jan 2024

?·        Design, architect, build, test, update, and document PostgreSQL databases.
·        Administer PostgreSQL databases throughout the development and production lifecycles in an AWS environment.
·        Design and develop logical and physical database designs.
·        Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience.
·        All other duties as assigned or directed.?

Skills Requirements:

Basic Qualifications:

?·        Bachelor's Degree in Computer Science, Mathematics, Engineering, or a related field
·        Master's or Doctorate degree may substitute for required experience
·        5+ years of experience with database infrastructure tasks on Linux/Unix operating systems.
·        5+ years of experience with relational database administration/management.

Required Skills:

·        Experience working in a cloud environment (e.g. AWS) and with deployment of AWS Cloud Infrastructure.
·        Knowledge of PostgreSQL architecture.
·        Experience setting up and managing PostgreSQL on AWS RDS and AWS EC2 Virtual Server.
·        Experience with data architecture, logical and physical design, reporting and analysis.
·        Experience developing and testing Linux or Bash scripts for startup, shutdown, backups, database scripts, and other                   scripting.
·        Experience with programming languages like PL/pgSQL and Groovy.
·        Experience with Replication and Change Data Capture (CDC) techniques and tools.
·        Experience with data conversion and management strategies.
·        Experience with database partitioning and microservices.
·        Expertise in writing complex SQL queries in PostgreSQL and optimize queries.
·        Strong communication and collaborative skills in providing technical direction and hands-on database administration to                include design, development, and testing. 

Desired Skills:

·        Comprehensive knowledge of Scrum and Kanban Agile development process and ceremonies including scrums, planning             events, backlog grooming, retrospectives, and demos.
·        Experience working as part of a large team and working with upstream and downstream dependencies.
·        Experience with various administration and development platforms for PostgreSQL (e.g., pgAdmin)
·        Experience with Liquibase and LiquiGen plug-in.
·        Experience with Jenkins CI/CD tools and scripting.
·        Experience with source code versioning and Pull Requests with Git and Stash.
·        Experience with performance tuning and increasing efficiency of a large enterprise system.?