Job SummaryWe are seeking an experienced PostgreSQL Administrator/DBA with over 8 years of expertise in managing, maintaining, and optimizing production-class databases for high-performance applications.The ideal candidate will have a deep understanding of database best practices, high availability (HA) setups, and managing heavily utilized production environments.This role requires a proactive individual who can ensure the database infrastructure is reliable, scalable, and secure while working closely with developers, system architects, and other stakeholders.Key ResponsibilitiesInstall, configure, upgrade, and maintain PostgreSQL databases in production and development environments.Ensure optimal database performance through monitoring, troubleshooting, and fine-tuning.Manage database capacity planning, including growth projections and storage optimization.Design, implement, and maintain HA solutions such as replication, clustering, and failover mechanisms.Develop and test disaster recovery plans to ensure minimal downtime and data loss.Perform query tuning and indexing to optimize application performance.Analyze and resolve bottlenecks in data access or processing.Implement and enforce database security best practices, including user access controls and encryption.Conduct regular audits to ensure compliance with organizational and regulatory requirements.Set up monitoring systems to track database health, performance, and anomalies.Automate routine tasks like backups, data migrations, and maintenance jobs using scripts or tools.Work closely with development teams to understand data requirements and recommend best practices for schema design.Document database architectures, processes, and procedures.Required Skills and Qualifications8+ years of hands-on experience managing PostgreSQL databases in production environments.Expertise in designing and implementing high availability (HA) architectures (e.g., streaming replication, Patroni, etc.).Proficiency in database performance tuning, query optimization, and indexing strategies.Strong knowledge of database security principles and implementation.Experience with backup and recovery solutions (e.g., pgBackRest, Barman).Familiarity with monitoring tools like pgAdmin, Prometheus, Grafana, or similar.Proficient in writing advanced SQL queries, stored procedures, and triggers.Scripting experience in languages such as Bash, Python, or Perl for database automation.Solid understanding of Linux systems, including shell scripting and basic server management.Familiarity with containerized environments (e.g., Docker, Kubernetes) and cloud database solutions (e.g., AWS RDS, Azure PostgreSQL).Preferred QualificationsPostgreSQL certifications (e.g., PostgreSQL Certified Professional).Experience with other database systems like MySQL, MongoDB, or Oracle.Familiarity with CI/CD pipelines and DevOps practices.Knowledge of big data technologies like Hadoop, Spark, or Kafka.Key AttributesStrong problem-solving skills and attention to detail.Excellent communication and collaboration abilities.Ability to work under pressure and meet tight deadlines.Proactive and self-motivated in keeping up with the latest database technologies.What We OfferCompetitive salary and benefits.Opportunity to work on cutting-edge projects with a talented team.Flexible work environment and learning opportunities.

About SKO: SKO is a London / Pune based developer of software products used in shipping cruise industry. Please visit www.skosystems.com and browse SKOs product catalog, available at https://1drv.ms/b/s!AtIGIyzAQKNohtM-zoswfblRb3Cwpg?e=qIbFEM, for more information.POSITION OVERVIEWSKO is seeking a highly skilled Ionic React Developer with project management and leadership abilities to lead its development team. The ideal candidate will be proficient in Ionic, React, Redux Toolkit, Capacitor, TypeScript, and modern front-end development while also possessing strong managerial skills to oversee project timelines, team coordination, and effective problem-solving.KEY RESPONSIBILITIESTechnical Responsibilities:Develop, maintain, and optimize cross-platform mobile applications using Ionic React and Capacitor.Write clean, maintainable, and scalable TypeScript and JavaScript code.Implement state management using Redux Toolkit and optimize performance.Ensure seamless integration with backend services and third-party APIs.Troubleshoot, debug, and resolve technical issues in a timely manner.Conduct code reviews and enforce coding best practices.Stay updated with the latest trends and advancements in Ionic, React, and mobile development.Project Management:Lead & Mentor a team of developers, ensuring smooth collaboration and technical excellence.Plan, track, and deliver project milestones while ensuring adherence to timelines and budgets.Bridge communication between technical teams, stakeholders, and clients.Manage Agile/Scrum development cycles, conduct stand-up meetings and oversee sprint planning.Identify risks, roadblocks and conflicts in the project and implement solutions proactively.Prepare reports on project progress, performance, and deliverables for management.Assist in hiring and onboarding new team members, ensuring skill alignment with project needs.Problem Solving & Decision Making:Assess project challenges and make strategic decisions to improve workflow.Adapt to changing project requirements and manage scope creep effectively.Resolve technical and managerial conflicts within the team.Handle client expectations and ensure high-quality deliverables.KEY REQUIREMENTSTechnical Skills:Strong expertise in Ionic Framework, React, Redux Toolkit, Capacitor, TypeScript and JavaScript.Experience with mobile app deployment on both iOS and Android.Familiarity with REST APIs, authentication mechanisms (OAuth, JWT), and third-party integrations.Understanding of CI/CD pipelines, version control (Git) and cloud services.Experience in writing unit tests and automated testing frameworks.Project Management & Leadership Skills:Proven ability to manage projects and lead teams in a fast-paced development environment.Experience in Agile methodologies (Scrum/Kanban) and sprint planning.Excellent communication, problem-solving and decision-making skills.Ability to prioritize tasks, handle multiple projects and meet deadlines.Strong analytical mindset with a focus on risk management and process improvement

Key Responsibilities:Manage end-to-end recruitment processes, including sourcing, screening, and interviewing candidates.Collaborate with hiring managers to understand job requirements and create effective recruitment strategies.Utilize various job portals, social media, and networking to attract top talent.Conduct initial candidate assessments and coordinate interview schedules.Maintain and update recruitment databases and applicant tracking systems (ATS).7 to 10 years of prior experience working as in internal recruiter with either an insurance company or an Insurance IT company