PostgreSQL Database Administrator

Role name:

PostgreSQL Database Administrator

Role Description:

? Sitting for extended periods of time? Dexterity of hands and fingers to operate a computer keyboard and mouse? Physically able to participate and lead training sessions, presentations and/or meetings.? Reasoning and analyzing complex information? Regularly required to talk and hear? Overtime may be required to meet deadlines

Competencies:

PostgreSQL, Digital: Terraform, Database Administration (DBMS)

Essential Skills:

? 10-12 years of experience in managing Postgres databases. 5 years of experience should be on the cloud version preferably AWS experience in managing databases as RDS services in AWS, security policy, user authentication, IAM, and database administration in AWS. ? Install, configure, patch, Migrate, Maintain, and upgrade Open-source Database platforms Databases like PostgreSQL, and AWS RDS? Working Knowledge of EDB, Oracle, SQL Server and AWS Day to Day operation on S3 EC2 etc ? Should be able to implement effective and maintainable database coding practices that form an architectural foundation? Experience in Postgres SQL performance improvement, indexing/other approachesGood experience on partitioning database? Experience with message queuing, full-text indexing, and other high-performance data concepts? Experience in AWS environment management and knowledge of different tools for the same? Experience in Postgres SQL migration approach, estimating it, and technically managing it? Advanced understanding of

Desirable Skills:

? AWS RDS hands-on experience? Capacity planning, performance assessment of AWS RDSs? Strong Postgres/SQL Server DB administration experience in production environments? Configuration and support of complex RDS Databases in AWS environment, Configuring and managing high availability, resiliency solutions leveraging Aurora Read replicas & Global Database? Experience in managing multiple RDS, database versions on large systems? Practical experience in monitoring? Knowledge of reporting and query tools and practices

Country:

United States

Branch | City | Location:

TCS – Los Angeles
LAS VEGAS
Las Vegas, NV

Keywords:

Postgress DBA