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:
Fourteen years of experience
Database performance and tuning
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
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.
Optimal Solutions And Technologies