Postgres DBA (Junior)

Artemis Consulting, Inc. - Linthicum, MD

Full-time
POSITION OVERVIEW

Postgres DBA (Junior)
4+ Years in administering on-prem/cloud-based multiuser environment with expertise in planning, designing, building, and implementing complex database systems.
Full-time - Onsite in Linthicum, MD
ABOUT ARTEMIS CONSULTING

Artemis Consulting is a D.C. area-based IT Services and Management Consulting firm that is on the Inc. 5000 list of the fastest growing companies in the U.S. Our teams are collaborative, self-motivated, and focused on creating value for our clients. We are a flourishing company where you have an opportunity to learn and grow with your peers. We believe in getting the job done and having work-life balance. We offer competitive salaries with a comprehensive benefits package including employer-subsidized health, dental & vision insurance, 401(k) matching, 10 paid Federal holidays, paid vacation, and sick leave.

JOB SCOPE AND RESPONSIBILITIES

Serve as a Postgres DBA as part of a large development team for a state level enterprise application. The individual in this position will provide technical expertise and support in the use of DBMS, evaluate and recommend available DBMS products to support validated user requirements and provide the full range of database administration support to enterprise systems.

Responsibilities of this role include but are not limited to:
  • Provide technical expertise and support in the use of DBMS.
  • Evaluate and recommend available DBMS products to support validated user requirements.
  • Define file organization, indexing methods, and security procedures for specific user applications.
  • Create and maintain database objects such as tables, views, index, constraints, etc. for data platform and custom applications.
  • Develop, implement, and maintain database backup and recovery procedures for the processing environments, and ensures that data integrity, security, and recoverability are built into the DBMS applications.
  • Drive end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
  • Design and develop logical and physical database designs from application requirements.
  • Design and implement automation using scripts, must be proficient in scripting.
  • Design and implement replication and backups for mission critical/tier-1 applications.
  • Design and implement automation using scripts, must be proficient in scripting.
SKILLS AND QUALIFICATIONS

Must be flexible, able to work in a highly collaborative environment, juggle multiple tasks at once, and work independently and collaboratively as needed. Must have superior interpersonal skills and strong communication skills. Be comfortable working directly with the Project Manager to support emerging client needs as well.

  • At least four (4) years of experience in administering on-prem/cloud-based multiuser environment with expertise in planning, designing, building, and implementing complex d
atabase systems.

  • In-depth knowledge of the EDB PostgreSQL DB architecture.
  • Experience with AWS cloud base Postgres database administration.
  • Driven end-to-end availability, performance monitoring, and capacity planning for PostgreSQL, using native and 3rd party tools.
  • Implemented automated methods and industry best practices for consistent installation and configuration of EDB PostgreSQL for production, pre-production and non-production environments.
  • Administrated PostgreSQL databases throughout the non-
non-production (Sandbox, development, test, UAT, Training), pre-production (Staging) and production lifecycles in an AWS environment.

  • Experience with optimizing database performance through exhaustive pro-active testing and ongoing real-time monitoring.
  • Experience in testing database security and enterprise policy guidelines according to established best practices.
  • Experience in monitoring and maintaining the backups for database recoverability for all production databases.
  • Experience working in the database domain with at least four (4) years of experience managing all operations of RDBMS databases such as Oracle/SQL Server/DB2 with a minimum of two (2) years of EDB PostgreSQL DB.
PREFERRED EXPERIENCE

  • Experience working in Agile teams
  • Ability to work independently and in an awesome team setting
  • Experience or exposure with automation tools such as Jira, Jenkins, Ant, Maven
  • Excellent communication skills
EDUCATION

  • Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline.
OTHER REQUIREMENTS

  • Work location is Linthicum, MD
  • We cannot sponsor candidates; Corp-to-corp candidates may be considered
  • Background and credit check is necessary
Artemis Consulting is an equal-opportunity employer, committed to diversity and inclusion. All qualified candidates will receive equal consideration for employment without regard to disability, race, color, religious creed, national origin, sexual orientation/gender identity, or age.

Artemis Consulting utilizes e-Verify to check employment authorization