Database Administrator & Expert

Job Description

As an experienced PostgreSQL Administrator at our company, your role is crucial in supporting our product development teams to build efficient and scalable data-driven applications for the container shipping industry.**Key Responsibilities:**- **Database Design & Management:** - Collaborate with the product development team to design, implement, and maintain scalable database schemas meeting business and application requirements. - Develop and maintain data models ensuring consistency and optimal performance. - Design tables, indexes, and constraints for high data integrity and performance.- **Performance Tuning & Optimization:** - Analyze slow-running or poor-performing queries and optimize performance through proper indexing, query restructuring, or caching mechanisms. - Conduct performance tuning, including tuning the PostgreSQL parameters for optimal database performance. - Work on improving database performance, scaling database operations, and addressing bottlenecks.- **Cloud Database Management (AWS Aurora PostgreSQL):** - Manage and administer AWS Aurora PostgreSQL clusters ensuring high availability, backup, recovery, and disaster recovery planning. - Optimize the use of cloud-based resources in AWS Aurora for cost-effective and efficient use. - Monitor and maintain database systems in cloud environments ensuring data security and availability.- **Security & Compliance:** - Ensure the database architecture complies with organizational security policies and best practices. - Implement database encryption, user management, and access controls. - Monitor database security and address any vulnerabilities or compliance concerns.- **Automation & Maintenance:** - Automate routine database tasks such as backups, failovers, maintenance windows, etc. - Develop and maintain database monitoring and alerting mechanisms to ensure system stability.- **Documentation & Training:** - Create and maintain detailed documentation for database designs, performance optimizations, and cloud database configurations. - Provide technical guidance and training to developers on best practices for schema design, query development, and database management.**Qualifications Required:**- **Experience:** - Over 7 to 11 years of technology experience working in a multi-national company. - 5 years of experience in PostgreSQL database administration, with a strong focus on query optimization, schema design, and performance tuning. - Proven experience managing PostgreSQL on AWS Aurora.- **Technical Skills:** - Strong expertise in PostgreSQL database design, including normalization, indexing, partitioning, and data modeling. - In-depth knowledge of SQL, PL/pgSQL, and advanced PostgreSQL features. - Familiarity with AWS services and cloud database management practices. - Experience with query tuning tools and database backup strategies.- **Performance Tuning:** - Expertise in tuning PostgreSQL databases for high performance. - Proficiency in analyzing and resolving database performance issues in production environments.- **Soft Skills:** - Excellent problem-solving skills and strong communication skills. - Ability to work closely with developers, DevOps, and architects.- **Education:** - Engineering degree in computer science, Information Technology, or related field.**Additional Company Details:**- Nice to Have: - Experience with containerized databases using Docker or Kubernetes. - Familiarity with event-driven architectures using Kafka. - Experience with CI/CD pipelines and Flyway Script.This role offers you the opportunity to leverage your PostgreSQL expertise in a dynamic environment to drive efficiency and scalability in our data-driven applications.,

Keyskills :
PostgreSQLQuery OptimizationPerformance OptimizationSQLTriggersStored ProceduresReplicationDatabase BackupRecoveryDatabase Schema DesignAWS Aurora PostgreSQLPLpgSQLAWS Services