This site uses cookies. To find out more, see our Cookies Policy

Database Administrator - PostgreSQL in Troy, MI at North American Bancard

Date Posted: 4/9/2018

Job Snapshot

Job Description

North American Bancard is looking for a Postgres (PostgreSQL) DBA to join the team based in Troy, Michigan. For the right candidate, we could be open to a remote worker based in the Grand Rapids, Michigan area. If you are looking for a challenging position in a fast-paced environment where you make a difference every day, NAB is the place for you. 

The Database Administrator - Postgres is a critical member of the IT Operations team, managing NAB’s production and development databases. You will be responsible for effective provisioning, installation/configuration, operation, maintenance and patching of database systems, within the NAB environment. 

What you will be doing:

  • Maintain Production, Development, and Test databases
  • Ensure availability of the databases in accordance with our service level agreements
  • Ensure recover-ability of the databases in accordance with our set guidelines
  • Repair problems in the databases quickly and correctly
  • Monitor the databases' performance and tune them as necessary verifying the integrity and availability of all resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
  • Provide Database Analysis & Design service to developers and other support groups
  • Offer assistance to developers in designing and tuning database queries and procedures
  • Research and recommend innovative and automated (where possible) approaches for system administration tasks
  • Identify approaches that leverage our resources and provide economies of scale
  • Perform periodic performance reporting to support capacity planning.
  • Make rapid, well-informed, independent judgments in support of NAB’s business-critical systems
  • Participate in on-call escalation rotations for 24x7x365 support; evening, overnight, and weekend, holiday and on-call work may be required 

Job Requirements

What we need from you:

  • Bachelor’s degree in information technology/computer science or engineering field.
  • Minimum of 5 years experience supporting databases in a enterprise environment.
  • Solid knowledge of PostgreSQL 9.x, MS SQL 2012/14/16, with the ability to transfer this knowledge to other team members.
  • Supporting a RDBMS in both Linux and Windows environments.
  • Experience with troubleshooting problems and forming a resolution with IT systems and individuals.
  • Ability to interact with a variety of clients in a clear, concise, professional manner
  • Solid understanding and working knowledge of complete systems development and deployment life cycle and of all facets of systems administration in a large scale IT operations unit.
  • Able to make effective decisions in high-pressure situations, with limited management escalation.
  • Exceptional written and verbal communication skills.

It would be a plus if you had: 

  • Experience in an Amazon Web Services (AWS) environment- RDS, Redshift, EC2, etc.
  • Experience with UNIX / Linux administration
  • Database High Availability / Replication i.e. AlwaysOn, Postgres HA, etc.
  • Scripting experience (Perl, Python, PHP, BASH, etc)
  • AWS Certification and Oracle Certification a plus
  • Microsoft MCDBA a plus

At North American Bancard we celebrate diversity and create an inclusive environment for everyone, we are an equal opportunity employer.

#LI-KH1

Pay Grade: 30I

CHECK OUT OUR SIMILAR JOBS

  1. Developer Jobs
  2. DBA Jobs