Employment Services

We help you find the correct IT placement

DBA - Postgres

St. Louis, MO 63105

Posted: 09/12/2019 Employment Type: Contract Job Category: Database Technologies Job Number: 12841

Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the Kansas City, St. Louis, and Denver Areas.

 

We are currently looking for a DBA  to join our team.

 

Responsibilities
  • Work with Subject Matter Experts to locate and understand the data then analyze and implement business requirements within time and cost restraints
  • Build database scripts to support ETL, DDL, OLTP, Data Warehouse, and CrUD operations
  • Create documents and coordinate deployments
  • Develop data quality and data migration strategies
  • Search for, identify, and correct data access performance and content quality issues
  • Assist in trouble shooting and resolving problems within our SOA environment
  • Ensure data integrity for existing and new database
  • Develop and maintain automated unit tests that improves data quality
  • Participate in design and code reviews
  • Coaching and mentoring less experienced engineers
  • Define, develop, communicate and implement standards, processes and procedures for the department
  • Identify issues and escalate risks to project leadership, if necessary

 

Required Qualifications
  • 3+ years Postgres DBA hands on experience
  • Expert Postgres DBA knowledge including upgrades, backup/recovery, patching strategies/capabilities and day to day support of application development personnel
  • Strong understanding of Postgres performance tuning (partitioning, striping, OLAP, data warehouses, data marts and other advanced physical data modeling techniques)
  • Strong understanding of SQL tuning and optimization of query plans
  • Strong understanding of ensuring data integrity including entity, referential integrity, check constraints and database triggers
  • Proven knowledge and experience in designing database schemas to align with development and business goals and objectives
  • Proven knowledge in database auditing and capability to document compliance
  • Strong understanding of database capacity planning and data purging techniques
  • Advanced knowledge of character set encodings
  • Strong and proactive leadership ability
  • Strong communication skills with the ability to transcend the organization with appropriate levels of detail
  • Strong teamwork, decision-making, documentation and analytical skills
  • Must be committed to incorporating security into all decisions and daily job responsibilities
  • Applicants for employment in the U.S. must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future

 

Preferred Qualifications
  • Bachelor' s degree in Computer Science, Computer Information Systems, Management Information Systems, or related field preferred
  • UNIX scripting skills are preferred
  • Experience with Postgres cluster is strongly preferred
  • Experience working in an Agile environment is a plus

 

Adaptive Solutions Group offers a competitive compensation and benefits package that includes medical, dental, STD/LTD, life insurance coverage, 401k, paid vacation and holidays.

Adaptive Solutions Group is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, and veteran or disability status.
postgres, etl

Nick Bilpush

Send an email reminder to:

Share This Job:

Related Jobs:

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