Description
We are looking for self-motivated, great team-player and passionate Performance DBA to support production AWS PostgreSQL databases.
Responsibilities And Tasks
• Maintain database performance, stability and scalability, and data integrity.
• Performance-tune SQL queries.
• Configure, administer and patch Amazon Aurora/RDS PostgreSQL (primary), DynamoDB, and Redis.
• Implement database backup and recovery strategy.
• Proactively monitors the health of databases and make recommendations to optimize performance and efficiency.
• Diagnose and resolve database, network, and firewall issues.
• Collaborate with various teams in developing system hardware layouts, configuring firewall rules, tuning, and load testing of mission-critical database systems.
• Comply with database security standards.
• Document database administration and management related processes and procedures.
• Provide support to the application developers, including, but not limited to data refresh, SQL and PL/pgSQL performance tuning and best practice recommendations.
• Conduct code reviews with application developers.
• Automate database administration and maintenance activities.
• Assist with routine future database (can be other databases, such as Redis) administration tasks.
• Rently is an ISO, ISMS and PIMS certified and SOC2 certified company completely focuses on Security, so all individuals being a part of Rently should keep Security as the main priority.
Must-Have
• Over all 6+ years of experience
• 3-5 years of extensive experience as a Production PostgreSQL DBA. (Mandatory)
• 2+ years of experience with other databases, such as AWS DynamoDB and Redis.
• 3+ years of AWS RDS management experience.
Required Skills
• Proficient in relational database management systems and principles, network and database security.
• Advanced understanding of database backup and recovery strategies.
• Advanced understanding of high availability solutions and strategies.
• Proficient with SQL and performance tuning.
• Ability to pay meticulous attention to detail.
• Self-driven and ability to meet goals and deadlines.
• Must have strong analytical and problem-solving skills.
• Ability to multi-task, prioritize and work under pressure in a fast-paced work environment.
• Strong scripting language experience.
• Fluent in Linux command-line utilities and operations.
• Ability to work directly with cross-functional teams to resolve application issues.
• Possess strong verbal and written communication skills.
• 24x7 on-call experience.
• Must be available for after-hours and weekend work.
Professional Commitment:
Being a product based company we heavily invest in developing functional/ technology/ leadership skill sets in our team members. So candidates who are willing to commit to a minimum of 2 years need to apply