We are constantly looking for smart & talented developers to join the Deviget family. You should be eager to work with cutting-edge technologies, have the drive to learn new things and work in a fast- moving,dynamic environment.

Postgres DBA

Location: Multiple Cities, South America, United States
The Database Administrator (DBA)/Developer will be accountable for maintaining the rapidly growing relational database infrastructure for a suite of cloud-based applications.
Responsibilities
  • Design and develop database solutions using tables, stored procedures, functions, views and indexes
  • Proactively monitor database systems ensuring availability and performance
  • Troubleshoot and resolve database issues
  • Assist in fine-tuning SQL queries and designing tables, views, indexes
  • Oversee database backup and recovery
  • Capacity monitoring and planning
  • Develop, maintain and enforce data security policies
  • Maintain data infrastructure documentation
  • Work closely with Software Engineers to ensure data integrity and overall system quality
  • Participate in testing process through unit testing and bug fixes
  • All other duties as assigned
Should Have
  • 3+ years in a working environment utilizing Postgres and related technologies
  • 3+ years of working in an AWS environment and knowledge of RDS and DynamoDB
  • Managed database performance, security and integrity through proactive monitoring, tuning and maintenance
  • Experience in database design, development and data modeling
  • Ability to analyze, troubleshoot and performance tune SQL queries, stored procedures, packages and functions
  • Ability to identify problems, and effectively communicate solutions to peers and management
Other valuable skills
  • MySQ, RDS
  • Windows Services
  • OS: Linux, Windows Server
  • Data architecture
  • Database security
  • Database replication
  • NoSQL/Big Data: Cassandra, MongoDB
  • Hadoop: HDFS, MapReduce
  • Business Intelligence (BI)
  • Agile/Scrum methodologies

You must have a good understanding of English (spoken and written)
You must be based in South America
or
this job portal is powered by CATS