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.