PostgreSQL Developer/Administrator

4 weeks ago

Hamilton, United States Dedrone Full time
Job Title: PostgreSQL Developer/Administrator

Company Overview:
Dedrone is the world's most trusted smart airspace security company. Hundreds of commercial, government and defense customers around the world rely on Dedrone's comprehensive, command and control (C2) solutions to protect against the persistent and escalating threat from drones while enabling "good" drones to fly. By leveraging AI/ML, Dedrone is the only solution that provides continuous, autonomous interrogation and verification of drones that enables both multi-sensor and multi-mitigation options onto a single fused "pane-of-glass". Whether on-premise / air-gapped or in the cloud, Dedrone customers can easily detect, track, identify, analyze, and mitigate drone threats.

We are seeking a highly skilled and experienced PostgreSQL Developer/Administrator to join our dynamic team.
The ideal candidate will have a strong background in database design, query development, and performance optimization.
This role requires a deep understanding of PostgreSQL internals, index design, replication mechanisms, and experience with cloud environments, particularly AWS. A bonus skill would be proficiency in Java development.

You Will:
  • Design and implement robust, scalable database schemas to support business processes.
  • Develop and optimize SQL queries for maximum efficiency and performance.
  • Create and maintain indexes to improve database performance and response times.
  • Conduct regular query tuning and server optimization to ensure smooth database operation.
  • Understand and leverage PostgreSQL internals for effective database management.
  • Set up and manage replication configurations to ensure data consistency and availability.
  • Collaborate with development teams to integrate databases with business applications.
  • Manage database security, backup, recovery, and upgrade processes.
  • Monitor database performance, identify bottlenecks, and implement improvements.
  • Provide technical support and training to team members on PostgreSQL features and best practices.
  • Stay up-to-date with the latest trends and advancements in database technology.
  • Experience with AWS services related to databases, such as RDS, EC2, and S3.
  • (Bonus) Experience with MS SQL Server
  • (Bonus) Develop and maintain Java applications that interact with PostgreSQL databases.
You Have:
  • Bachelor's degree in Computer Science, Information Technology, or related field.
  • Proven experience as a PostgreSQL Developer/Administrator with a strong portfolio of database projects.
  • Deep understanding of database design principles and data normalization.
  • Expertise in SQL query writing, query optimization, and index tuning.
  • Experience with PostgreSQL replication setups and database scaling strategies.
  • Solid understanding of PostgreSQL internals and configuration.
  • Proficient in managing cloud-based database systems, particularly in AWS environments.
  • Excellent problem-solving skills and attention to detail.
  • Ability to work independently and in a team-oriented environment.
  • Strong communication and documentation skills.
  • (Bonus) Proficiency in Java development and understanding of Java-based application frameworks.


At Dedrone, we believe that great ideas come from anywhere. We support a collaborative environment and value open participation from individuals with different ideas, experiences, and perspectives. We believe having a diverse team makes Dedrone a more interesting and innovative place to work, and we strive to make Dedrone a welcoming and inclusive place for all.

  • Contract/Project Administrator

    1 day ago

    Hamilton, United States Axis Interior Systems Full time

    Job DescriptionJob DescriptionJob Description:Contract/Project Administrator is responsible for aiding and managing administrative function of the project. This position must be able to work independently, as well as part of a team, and will be responsible for conducting their work in a professional, accurate, and timely manner. This position will report...

  • Public Health Nursing Administrator

    2 weeks ago

    Hamilton, United States City of Hamilton Full time

    Job DescriptionJob Description                                            The City of Hamilton is an EEO & AAE. Minorities and women are encouraged to apply.This is responsible and difficult administrative supervisory and technical work involving the planning, organization, direction, supervision and coordination of the operations of...

  • Senior Learning

    4 weeks ago

    Hamilton, United States StandardAero Full time

    Senior Learning & Development Manager Location: Cincinnati OH Build an Aviation Career You're Proud Of At StandardAero, we use our ingenuity and know-how to find solutions for the simple to the most complex challenges in aviation. Together, we get the job done and done well. Our stability, resources, and respectful culture supports you in building a solid...

  • Chair & Associate Professor/Professor Mathematical & Physical Science

    1 week ago

    Hamilton, United States Miami University Full time

    Chair & Associate Professor/ProfessorJob no: 502889Department: Mathematical & Physical Science - Hamilton CampusLocation: Hamilton, OH, Middletown, OHWork type: FacultyCategories: Administration, TeachingStatus: Full TimeTemporary: NoJob Title:Chair and Associate Professor/Professor Job Summary:Chair and Associate Professor/Professor for Mathematical and...

  • Chair & Associate Professor/Professor Commerce

    2 weeks ago

    Hamilton, United States Miami University Full time

    Chair & Associate Professor/ProfessorJob no: 502888Department: Commerce - Hamilton CampusLocation: Hamilton, OH, Middletown, OHWork type: FacultyCategories: Administration, TeachingStatus: Full TimeTemporary: NoJob Title:Chair and Associate Professor/Professor Job Summary:Chair and Associate Professor/Professor to provide academic and administrative...

  • Business Development Manager

    4 weeks ago

    Township of Hamilton, United States Genesis Global Group Full time

    **Job Summary**: Responsible for developing, monitoring, and closing new business deals with new clients in the biotech in an assigned territory. **Essential Functions**: - Develop sales strategy for the assigned territory in collaboration with Global Director Business Development - Develop relationships with potential customers in the biotech industry...

  • HR Generalist

    2 weeks ago

    Hamilton, United States Primary Health Solutions Full time

    Job Type: Full-time/exempt Job Location: Administration office - 300 High Street, Hamilton, OH 45011 Come make a difference with us! We are the destination for servant leaders to provide comprehensive and exceptional care. We meet people where they are and partner with them on their journey towards wellness. Primary Health Solutions is a non-profit,...

  • Remote - Business Development Manager - MSP Staffing Services (100% Commission-Based)

    2 weeks ago

    Hamilton Township, United States Inuson International Inc. (i3) Full time

    This is a remote position. Inuson is a leading provider of Managed Service Provider (MSP) staffing solutions, specializing in delivering top talent to businesses across Canada and Australia. We pride ourselves on our commitment to excellence, integrity, and customer satisfaction, offering tailored staffing solutions to meet the unique needs of each client...

  • HR Intern

    2 weeks ago

    Hamilton, United States Primary Health Solutions Full time

    Job Type: Temporary Job Location: Administration office - 300 High Street, Hamilton, OH 45011 Hours: Monday - Friday from 9:00am - 3:00pm (May - August) Come make a difference with us! We are the destination for servant leaders to provide comprehensive and exceptional care. We meet people where they are and partner with them on their journey towards...

  • Deputy Director of Athletics for External Operations

    23 hours ago

    Hamilton, United States InsideHigherEd Full time

    The Deputy Athletics Director provides leadership for assigned areas of oversight and coordination for the activities of the Office of the Athletics Director. This position is a highly visible leadership role requiring an individual with outstanding interpersonal skills, including diplomacy, tact and political savvy.The individual in this position must be...

  • Associate Athletics Director for Business Operations

    23 hours ago

    Hamilton, United States InsideHigherEd Full time

    The Associate Athletics Director for Business Operations provides strategic and effective leadership of the business and financial operations for the Colgate Athletics Department. This position is a highly visible leadership role requiring an individual with outstanding interpersonal skills, including diplomacy, tact and political savvy. This position will...

  • Care Coordinator, Butler County Campus

    1 month ago

    Hamilton, United States Best Point Education & Behavioral Health Full time

    Job DescriptionJob DescriptionPositions available at our Butler County office, in both our campus based outpatient and our school based programs. Full time position with benefitsDelivers an array of community-based services, which meet the individualized mental health needs of the children and families served. Performs a variety of functions in multiple...

  • Direct Support Professional

    2 days ago

    Hamilton, United States 1st Americare Full time

    Job DescriptionJob DescriptionDuties- Provide direct care and support to individuals with developmental disabilities in a residential setting- Assist individuals with daily living activities, including personal hygiene, meal preparation, and medication administration- Implement individualized care plans and ensure the safety and well-being of individuals at...

  • Dsp (Direct Support Professional)

    1 day ago

    Hamilton, United States 1st Americare LLC Full time

    Duties - Provide direct care and support to individuals with developmental disabilities in a residential setting - Assist individuals with daily living activities, including personal hygiene, meal preparation, and medication administration - Implement individualized care plans and ensure the safety and well-being of individuals at all times - Support...

  • Quality Manager Compliance and Regulatory UPM

    4 days ago

    Hamilton, United States United Performance Metals Full time

    ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned. Formulates and administers company policies relating to regulatory, statutory, industry, and customer requirements and develops long-range goals and objectives. Implement communication, monitoring, and enforcement of compliance standards. Develop, assess, improve, and...

  • Office Operations Manager

    2 days ago

    Hamilton, United States Superior Insurance Partners Full time

    We are seeking an experienced and detail-oriented Office Operations Manager to oversee various operational functions within our organization, specifically focusing on client services processes and systems. Reporting directly to the Agency Principal, the successful candidate will play a crucial role in leading a Client Service team to deliver high-quality and...

  • Office Operations Manager

    8 hours ago

    Hamilton, United States Superior Insurance Partners Full time

    We are seeking an experienced and detail-oriented Office Operations Manager to oversee various operational functions within our organization, specifically focusing on client services processes and systems. Reporting directly to the Agency Principal, the successful candidate will play a crucial role in leading a Client Service team to deliver high-quality and...

  • Office Operations Manager

    2 days ago

    Hamilton, United States Superior Insurance Partners Full time

    We are seeking an experienced and detail-oriented Office Operations Manager to oversee various operational functions within our organization, specifically focusing on client services processes and systems. Reporting directly to the Agency Principal, the successful candidate will play a crucial role in leading a Client Service team to deliver high-quality and...

  • Practice Manager FULL TIME

    2 weeks ago

    Hamilton, United States Bitterroothealth Full time

    Job Description Posted Monday, April 29, 2024 at 6:00 AM BITTERROOT'S BEST EMPLOYER 2022 & 2023 State of Montana "EMPLOYER OF CHOICE" 2022 Practice Manager opportunity in beautiful Hamilton, Montana!! Bitterroot Health is seeking candidates to fill a Practice Manager position in our Medical Clinics. The Practice Manager provides effective leadership and...

  • General Clerk

    4 weeks ago

    Hamilton, United States LADGOV CORPORATION Full time

    Position Title: General ClerkJob Description: We are seeking a highly organized and detail-oriented individual to join our team as a Payment Processing and Administrative Support Specialist. In this role, you will play a crucial part in the efficient operation of our office by managing the collection and assembly of cost data, processing payment application...