Senior Postgres Developer / Architect

Optimal Solutions And Technologies Washington , DC 20319

Posted 2 weeks ago

Optimal Solutions & Technologies (OST, Inc.) is focused on excellence. We specialize in providing Management Consulting, Information Technology, and Research Development and Engineering services.

The fundamental distinction of the OST team is its business knowledge in both the public and private sectors. We serve the aerospace & transportation, association & nonprofit, defense, education, energy, financial, healthcare, and technology & telecommunications industries. OST is successful because we listen to our clients, we learn from our clients, and we know our clients.

Job Duties (Description of specific duties in a typical workday for this position):

  • Create scripts to develop new or updates to existing database schemas in a clustered DB environment hosted on Kubernetes

  • Develop other database scripts - scheduled jobs, synchronization checks, etc.

  • Lead analysis and migration of business rules currently stored in DB domain to application domain

  • Apply database patches

  • Plan and conduct automated Postgres database upgrades as required

  • Implement and mitigate security access to Postgres Database

  • Manage passwords, accounts, profiles to maintain security certification

  • Conduct backup and recovery

  • Conduct file transfer

  • Monitor database performance and tune as required

  • Ensure security controls are implemented to ensure compliance with DoD and DHA standards

  • Submit Postgres Security Report and track to resolution

  • Document processes and procedures such as clones, refreshes, recovery, and flashbacks

  • Document disaster recovery plan and conduct exercise to ensure plan is executable

Requirements (Years of experience, Education, Certifications):

Ph.D. degree in related discipline plus ten (10) years of related experience; or Master's degree in related discipline plus twelve (12) years of related experience; or Bachelor's degree in related discipline plus fourteen (14) years of related experience; or seventeen (17) years of related experience:

  • BS degree

  • Fourteen years of experience

  • Database Development

  • Database Security

  • Database performance and tuning

  • Database Upgrades

  • Database disaster planning and recovery

  • Ability to write custom scripts to automate database administration scheduled jobs or tasks

  • Must be a creative thinker who can work well on a team

  • Must be US Citizen

  • Secret Clearance

Nice to Have: (skills that are not required, but nice to have)

  • Experience with Kubernetes environment and Running Postgres pods in K8s

  • Experience performing database administration for DoD / DISA systems in classified environments

  • Experience working with DISA management, system administrators, network team/CCC, and service desk to coordinate necessary changes to systems.

  • Experience with Liquibase to deploy DB changes

  • Postgres Database Certifications

This is a full time position paying a base salary, full benefits, and has possible bonus potential based on merit and performance. To be considered for this position, please apply online with a cover letter and MS Word resume.

OST is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oracle Postgres DBA

Central Business Solutions, Inc

Posted 1 month ago

VIEW JOBS 12/16/2020 2:19:05 PM 2021-03-16T14:19 <strong>Position Role/Tile: Oracle Postgres DBA</strong><br /> <strong>Location:  Washington, DC.</strong><br /> <br /> <br /> <strong>Job Description:</strong><br /> Database Administrator 2 administers organization's databases, using database management system to organize and store data.  <br /> The Database Administrator 2 ascertains user requirements, creates computer databases, and tests and coordinates changes.  <br /> This individual interacts with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases.<br /> Level 2 performs more varied and difficult tasks compared to Level 1, yet has less autonomy than Level 3.<br /> <br /> <strong>Technical Skills Preferred: </strong> <ul> <li style="padding: 0; margin: 0;">Preferred    </li> <li style="padding: 0; margin: 0;">Oracle, Postgres    </li> </ul> <br /> Education Level: BA<br /> <br />  <br /> <br /> Central Business Solutions, Inc,<br /> 37600 Central Ct.<br /> Suite #214<br /> Newark, CA 94560. Central Business Solutions, Inc Washington DC

Senior Postgres Developer / Architect

Optimal Solutions And Technologies