PostgreSQL DBA

Job Description

Job Description – PostgreSQL DBA We at Pine Labs are looking for those who share our core belief - “Every Day is Game day”. We bring our best selves to work each day to realize our mission of enriching the world through the power of digital commerce and financial services. Role Purpose We are looking for a skilled PostgreSQL Database Administrator to join our dynamic IT team. The ideal candidate will be responsible for the installation, configuration, maintenance, and performance optimization of PostgreSQL databases including designing and implementing database schemas; managing security and access. He will handle backup and recovery, troubleshoot issues, and may participate in database migration projects. If you have a passion for technology, a commitment to excellence, and the skills and experience required to excel as a PostgreSQL Database Administrator, we look forward to receiving your application and discussing how you can contribute to our team's success. Responsibilities we entrust you with Database Setup and Configuration: Installing PostgreSQL, configuring instances, setting up client authentication, and managing connection parameters. Database Design and Schema Management: Designing database schemas, tables, and relationships, implementing indexing strategies, and ensuring normalization. Security and Access Control: Implementing security measures, managing user roles and permissions, and auditing database activity. Performance Monitoring and Optimization: Monitoring database performance, tuning queries, optimizing storage, and identifying performance bottlenecks. Backup and Recovery: Implementing backup and recovery plans, ensuring data integrity and availability in case of failure. Troubleshooting and Support: Investigating and resolving database issues, providing support to users and developers, and documenting troubleshooting procedures. Migration Projects: Participating in database migration projects, including migrating from other database systems to PostgreSQL. Automation and Scripting: Automating tasks using scripting languages to streamline administrative processes. Documentation: Maintaining documentation for database configurations, procedures, and troubleshooting steps. Server sizing: Estimating the service configuration based on data volume and performance requirements What matters in this role Relevant work experience 10+ years of experience in relevant field BE/BTech in computer science or technology PostgreSQL Expertise: Proficiency in PostgreSQL syntax, features, and administration tools. SQL: Strong understanding of SQL, including query optimization and data manipulation. Database Design Principles: Knowledge of database normalization, indexing, and other design principles. Operating Systems: Understanding of operating system concepts related to database performance and stability. Security: Knowledge of database security practices and authentication mechanisms. Scripting Languages: Familiarity with scripting languages like Python or Bash for automation. Troubleshooting: Strong analytical and problem-solving skills to diagnose and resolve database issues. Communication: Ability to communicate effectively with developers, users, and other team members. Ability to work independently and collaboratively within a team. Experience with Linux operating systems and scripting languages. Knowledge of PostgreSQL on AWS and OnPremises is mandatory What we Value in Our people You take the shot: You Decide Fast and You Deliver Right You are the CEO of what you do: you show ownership and make things happen You own tomorrow: by building solutions for the merchants and doing the right thing You sign your work like an artist: You seek to learn and take pride in the work you do Show more Show less