Senior Database Engineer

Overview

On Site
Full Time

Skills

IT Consulting
Cross-functional Team
Cloud Computing
Database Administration
Python
Capacity Management
Performance Appraisal
Reporting
KPI
Performance Management
Proxies
High Availability
Computer Science
Electrical Engineering
Data Quality
Privacy
Analytical Skill
Communication
Estimating
Continuous Integration
Continuous Delivery
Migration
Open Source
Database Design
Query Optimization
Data Integrity
Statistics
JIRA
GitLab
Ansible
Terraform
Database
Management
Red Hat Enterprise Linux
Kubernetes
Accountability
Linux
Operating Systems
Secure Shell
Authentication
Amazon Web Services
Amazon RDS
Remote Desktop Services
Standard Operating Procedure
Batch Processing
Job Scheduling
Writing
Customer Facing
PostgreSQL
SQL
Optimization
Law

Job Details

  • JOB-7365
  • Senior Database Engineer
  • Las Vegas, NV
  • Permanent/C2H
  • Link Technologies (LinkTechConsulting.com), a Las Vegas-based IT consulting firm, is currently seeking a Senior Database Engineer to join our team.

    JOB SUMMARY

    This role works independently or as a key member of a cross-functional team to identify, plan, develop, and implement database applications using AWS RDS, Postgres EDB, and other technologies. This position also serves as the primary contact for the Postgres database platform and handles related escalations. This role is responsible for creating and managing all database objects from design through deployment, applying expert knowledge to design or reuse, configure, and implement database solutions and processes that ensure high availability, efficiency, effectiveness, data integrity, recoverability, and ease of support.

    POSITION REQUIREMENTS
    • Eight (8) years of experience managing Postgres databases within the EDB ecosystem, including five (5) years in cloud environments, preferably AWS, with strong expertise in managing databases like AWS RDS, security policies, user authentication, IAM, and AWS-based database administration.
    • Working knowledge of Lambda, Python, Ansible, and Terraform.
    • Skilled in capacity planning and performance evaluation for AWS RDS and Postgres Distributed environments.
    • Hands-on expertise with AWS RDS, EDB EPAS, and Postgres Distributed.
    • Proven experience managing numerous RDS instances and multiple database versions on large-scale systems.
    • Familiarity with SQL best practices, reporting, and query tools.
    • Extensive experience administering EDB Postgres in live production settings.
    • Experience leveraging Performance Insights, RDS KPIs, and related performance management tools.
    • Deep technical and functional proficiency in PostgreSQL administration, including tools such as PgBouncer, PgPool, RDS Proxy, PGD Proxy, and associated binaries.
    • Direct experience with monitoring and observability tools and practices.
    • Proficient in configuring and maintaining complex RDS databases within AWS, including setup and support for high availability and resilience using Aurora Read Replicas and Global Database.
    PREFERRED

    • Degree in Computer Science, Electrical Engineering, or an equivalent engineering field.
    • Professional certifications in technologies such as AWS, CKA, or EDB.
    ESSENTIAL JOB FUNCTIONS

    • Skilled in writing efficient and secure database code that upholds data quality, privacy, and protection.
    • Strong troubleshooting capabilities with the ability to assess alternative solutions and workarounds; excellent analytical thinking and interpersonal communication.
    • Familiar with strategies and execution of Postgres SQL migrations between on-premises and AWS, including estimation and technical oversight.
    • Solid background in database partitioning and sharding techniques.
    • Strong grasp of CI/CD pipelines and automation using GitLab.
    • Skilled in installing, configuring, patching, migrating, maintaining, and upgrading open-source database platforms such as PostgreSQL and AWS RDS.
    • Knowledgeable in database design fundamentals, query tuning, index handling, data integrity checks, statistics, and isolation levels, with a firm understanding of ACID and BASE models.
    • Hands-on experience with tools like Jira, GitLab, Ansible, and Terraform.
    • Capable of implementing sustainable and effective database coding standards that support architectural best practices.
    • Proficient in managing PostgreSQL across multiple operating systems, including Linux (RHEL), and container platforms such as Kubernetes within OpenShift.
    • Accountable for reviewing patch releases, assessing development patch requests, and communicating potential constraints, issues, and deployment timelines.
    • Advanced knowledge of Linux operating systems and capable of using SSH to access remote systems with both password and key-based authentication.
    • Practical experience handling daily operations for EDB, Postgres Distributed (PGD), and AWS RDS, including performing health checks, assigning tasks, and updating standard operating procedures.
    • Good understanding of batch processing and job scheduling automation.
    • Effective communicator, both verbally and in writing, with demonstrated client-facing experience in problem identification, analysis, and resolution.
    • Experienced in improving Postgres SQL performance using indexing and other optimization methods.
    Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination because of race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Link Technologies