Sr. DBA Job in American Fork, Utah Us

· Collaborate with others to determine and deploy database solutions to business-prioritized requirements, including business continuance and information security along with functional requirements.

· Install, configure, and test new PostgreSQL databases, perform version upgrades of existing databases.

· Install, upgrade and maintain all PostgreSQL-related server and administration software.

· Perform DB profiling and optimization; analyze and propose schema changes to PostgreSQL databases as needed

· Proactively monitor activity, utilization, exceptions and database health; propose and deploy appropriate improvements; automate repetitive tasks.

· Collaborate with Operation team members to create, publish and maintain database deployment methods and procedures for PostgreSQL databases.

· Collaborate with the Engineering to create and maintain database technology roadmaps and recommend improvements to service being developed.

· Perform database backup and recovery duties; establish standards and schedules for database backups; develop and routinely test recovery procedures for each database; ensure that backup schedules meet the recovery requirements and conforms to all database and data quality policies and standards.

· Provide support to Operation on-call staff as needed.

· Implement and maintain archival and high availability strategies.