Software Database Engineer – PostgreSQL

Wisestep - Las Vegas, NV

Full-time - Mid Level

Las Vegas, NV

About the position

The Software Database Engineer - PostgreSQL role focuses on managing and optimizing PostgreSQL databases, particularly in cloud environments like AWS. The position requires extensive experience in database administration, performance tuning, and migration strategies, with a strong emphasis on security and best practices in database management. The engineer will be responsible for the installation, configuration, and maintenance of database systems, ensuring high availability and performance while adhering to coding standards and security policies.

Responsibilities

• Manage PostgreSQL databases within the EDB ecosystem and AWS RDS services.
• Install, configure, patch, migrate, maintain, and upgrade PostgreSQL and AWS RDS databases.
• Implement effective database coding practices and architectural foundations.
• Optimize PostgreSQL performance through indexing and other techniques.
• Partition databases and manage high-performance data concepts like message queuing and full-text indexing.
• Oversee AWS environment management and utilize various tools for database operations.
• Conduct database migration from on-premises to AWS and vice versa, including estimation and technical management.
• Utilize Linux OS and SSH for remote system connections.
• Write efficient database code while ensuring data quality, privacy, and security.
• Use tools like Jira, GitHub, Ansible, and Terraform for project management and automation.
• Understand CI/CD processes using GitLab and manage batch processes and job scheduling.

Requirements

• 10-12 years of experience in managing PostgreSQL databases.
• 5 years of experience with cloud databases, preferably AWS.
• Hands-on experience with AWS RDS services and security policies.
• Advanced understanding of Linux OS and SSH connections.
• Strong experience in PostgreSQL performance improvement and database partitioning.
• Knowledge of database design principles and query optimization.
• Experience with monitoring tools and performance insights for RDS.
• Proficient in Python and AWS Lambda.

Nice-to-haves

• Experience with PgBouncer, PgPool, and related binaries.
• Familiarity with capacity planning and performance assessment of AWS RDS.
• Knowledge of reporting and query tools.