*ORACLE DBA with Postgres and Cassandra : Salt Lake City, UT*


*6 months*



*Telephonic hiring *



Seeking a confident, top class Postgres Database Administrator to work with
our Engineering/Development and DevOps teams as well as support our new BI
and ETL initiatives in our Salt Lake City Office.

You’ll support new and existing Postgres database systems, both internally
managed and Amazon RDS instances, help guide best practices in database
administration, introduce innovation with automation, and develop and
support ETL processing for our Data Warehouse. The DBA will be responsible
for maintaining these environments running in an AWS Linux/Unix environment.

You should have advanced knowledge of Postgres Utilities, creation and
implementation of fully functional Postgres databases, ability to maintain
multiple development, QA and production Postgres environments with strong
experience in performance tuning on Postgres.



*KEY ACCOUNTABILITIES:*

This role requires a motivated self-starter who can hit the ground running,
quickly taking on tasks and applying their strong, prior experience to
tackle the challenges presented. This would include:

Responsible for providing day-to-day support and maintenance for existing
and PostgreSQL databases.

Build database scripts to support ETL, OLAP, OLTP, Data Warehouse, and
operations

Search for, identify, and correct data access performance and content
quality issues

Assist in troubleshooting and resolving problems within our environment

Individual contributor performing both data design, modeling, and coding

Design and build database solutions that are both highly available and
highly performing.

Administration, management, and monitoring of all Postgres database systems.

Help support proper backup and disaster recovery procedures.

Good understanding of Database Architecture, Performance tuning of
databases,

Pro-actively Identify bottlenecks and resolve them quickly.

Proactive monitoring of Postgres databases for performance and scalability

Update skills continuously with emerging technologies and apply them as and
when needed.

Work with developers on performance tuning, query optimization, index
tuning.

Support PostgreSQL database in AWS.

Maintain a positive, upbeat, “can-do” attitude.



*SKILLS SUMMARY:*

BS Degree in Computer Science or equivalent work experience.

5+ years relevant DBA experience

3 to 5 years of experience with Postgres

1 to 2 years of experience with Cassandra

3 years of experience working in Linux and UNIX environments - MS Windows a
plus

Strong understanding of Postgres performance tuning (partitioning,
striping, data warehouses, data marts and other advanced physical data
modeling techniques)

Strong experience in replication, clustering, tuning, sizing

Proven knowledge and experience in designing database schemas to align with
development and business goals and objectives

Experience in a 24/7 production environment support

Strong experience supporting mission critical relational databases

Expert level of Postgres knowledge

Experience with backups, restores, recovery (xDB/Slony/ Pgbouncer)

Experience with High Availability Solutions and sharding

Proficient in tuning database processes and queries

Experience in supporting Postgres databases in AWS

Excellent written and verbal communication skills

Strong teamwork, decision-making, documentation and analytical skills

Shell programming, SQL, bash

*Garima Gupta | Technical Recruiter | Apetan Consulting LLC*

*Tel: 201-620-9700* <201-620-9700*> 133 |   gar...@apetan.com
<gar...@apetan.com> *

 | garimaapetan...@gmail.com

-- 
You received this message because you are subscribed to the Google Groups 
"Citrix and Sap problems" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to citrix-and-sap-problems+unsubscr...@googlegroups.com.
To post to this group, send email to citrix-and-sap-problems@googlegroups.com.
Visit this group at https://groups.google.com/group/citrix-and-sap-problems.
For more options, visit https://groups.google.com/d/optout.

Reply via email to