Database Engineer - PostGreSQL - Direct Hire

New York, NY

Employment Type: Direct Hire Industry: IT Job Number: 932714 Pay Rate: Negotiable

Job Description

Lighthouse Technology Services is partnering with our client to fill a direct-hire Database Engineer role! This role is fully remote and client does provide H1B visa sponsorship.

This role is responsible for both building and running a database infrastructure that is reliable, scalable, and easy to use. We’ve helped this client grow their current team of great people over the years and are excited to assist them again.

The team is responsible for understanding the organization’s evolving requirements and evaluating and productionizing the technologies that will help the business reach its goals. We are looking for someone with experience working with PostGreSQL – somebody who understands database fundamentals and how the properties of different  database systems interact with applications and operating systems. This is a hands-on role - designing, coding, configuring, debugging, and monitoring.

What You’ll Be Doing:

·         Building proof of concepts to test out new solutions

·         Teaching/Mentoring DBAs working in more traditional technologies (MSSQL, Oracle) and helping to expand their database vocabulary

·         Maintaining scalable, reliable, and  robust database environments by monitoring for problems and diagnosing and addressing those problems as needed

·         Assisting application teams with performance tuning, query optimization, and  index tuning.

·         Building tools and scripts to simplify, automate, or solve  the problems DBAs are asked to address

·         Provide 24x7 escalation support

·         Automating most common operations, building tools to improve the reliability and observability of our infrastructure.

·         Working across specific DBMS implementations to design for the reliability and operability of our databases infrastructure. 

What You’ll Need To Have:

·         5+ years working with PostgreSQL and one of {Cassandra, Oracle, or MSSQL}

·         5+ years working in Unix/Linux environments. Should be comfortable using Linux/UNIX command line tools

·         Prefer 3+ years working with Kubernetes and OpenShift

·         Experience PostgreSQL and related products (with Patroni, haproxy, pgbackrest, pgmonitor and pgbouncer, etc.)

·         Exceptional communication skills - this role will require collaboration with stakeholders in both business and technical leadership roles across the organization

·         Exceptional problem-solving skills and attention to detail

·         Proficient at tuning database processes and queries

·         Ability to work cooperatively with both software engineers and  system  administrators

·         Solid working knowledge of computer science fundamentals including OS, Networking, Data Structures, Algorithms, Concurrency, and Distributed Systems

·         Prefer the ability to design, author, and release code in at least one language like Python, Go, Perl, Java or similar

·         Comfortable implementing both functionality and tests, and reviewing others’ code

·         Experience in system automation - writing and enhancing automation tools and infrastructure.

·         Prefer experience with Python, Terraform, and Ansible.

·         Ability to anticipate how systems fail, how failure can be designed monitored for

·         Prefer a good understanding of design/Implementation of Big Data technologies like  Hadoop, Spark, Hive, MongoDB, Kafka, RabbitMQ, Zookeeper, Spark, ELK, etc 

Apply Online

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.