Hiring PostgreSQL Database Administrator For

Greetings from Garmin

We are hiring PostgreSQL Database Administrator for Garmin. Please go through the below JD.

About Company:

Garmin Ltd. is an American multinational technology company founded in 1989 by Gary Burrell and Min Kao in Lenexa, Kansas, United States, with headquarters in Olathe, Kansas. Since 2010, the company is incorporated in Schaffhausen, Switzerland. The company specializes in GPS technology for automotive, aviation, marine, outdoor, and sport activities. At Garmin, we like to work hard and play hard. It comes easy when you work on cool products with hard-working individuals who share the same passion. We make products that are engineered on the inside for life on the outside. We do this so our customers can make the most of the time they spend pursuing their passions. We think every day is an opportunity to innovate and a chance to beat yesterday. See more at

Job description:

POSITION SUMMARY: We are looking for PostgreSQL database administrator, who will be working with development team, to provide technical and operational support activities of Database Servers, including logical and physical database design support, troubleshooting, performance monitoring, tuning, optimizing and efficiently managing technology using tools and scripting.

ESSENTIAL FUNCTIONS:

• Participate in application development projects and be responsible for the database modeling, database design, data profiling, and data querying.
• Develop procedures, functions, packages, triggers, collections, indexes, constraints, views, sequences, optimized queries using joins and subqueries in support of application development.
• Responsible for Tune and optimize database objects
• Responsible for the monitoring, uptime of all production databases and manage data security and privacy.
• Responsible for regular databases maintenance activities (e.g., Vacuum, Re-indexing, Archiving, Monitoring, alerting, and error analysis on logs).
• Responsible for regular backups and recovery of databases, includes PITR (Point in time recovery) based on the requirement.
• Responsible for Configuring replication setup between Production and DR sites.
• Responsible for applying patches (version upgrades) to PostgreSQL.
• Participate in a 247 support and perform other duties as assigned.
• Responsible for performing database migrations across environments.
• Hands-on experience with Barman backups, WAL archiving, and restores.
• Responsible for capacity planning and managing tablespaces/storage.
• Participate in implementing and maintaining high availability solutions.
• Responsible for configuring monitoring and alerts for database health.
• Hands-on experience with documenting SOPs, backup, and DR procedures.
• Participate in coordinating with IT/app teams for incidents and changes.
• Responsible for staying updated on PostgreSQL best practices and security.

EXPERIENCE AND SKILLS REQUIRED:

• Graduated in technical discipline or equivalent professional experience in computer science (BE / B.Tech / M.Tech / MCA / M.Sc) and a minimum of 5 years relevant experience.
• Must have strong analytical, verbal and written communication skills.
• Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
• Must have strong knowledge of Linux, RockyOS.
• Demonstrates ability to solve moderately complex technical problems independently.
• Experience with application deployment by using CI/CD.
• Experience with Docker deployment

DESIRABLE SKILLS:

• Basic understanding on GIS, spatial database (PostGIS) and queries.
• Knowledge on issue tracking/ticketing systems like Jira, ADO.
• Proficient understanding of code versioning tools such as Git, SVN
• Knowledge on scripting languages like Python, shell scripting (e.g., Bash, Perl)
• Technical certifications.

Thanks

Sohini