To see other DBA job opportunities,
please visit http://dba.fyicenter.com/
PostgreSQL Database Administrator
Duties and Responsibilities:
Responsible for the monitoring and uptime of all production databases.
Total ownership of gobaltoís postgres and redshift databases.
Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
Provide logical and physical replication support for postgres to postgres or postgres to redshift.
Responsible for developing, tuning and troubleshooting Amazonís data migration services.
Work with data engineers to develop data-centric solutions, provide development support such as query tuning, SQL development, environment setup, and debugging.
Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need downtime.
Develop Stored Procedures and Database Triggers in support of application development, if needed.
Participate in application development projects and be responsible for the database architecture and design.
Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
Responsible for developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release.
Responsible for regular backups and recovery of databases.
Responsible for regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
Responsible for pro-active remediation of database operational problems.
Responsible for Query tuning and preventative maintenance.
Participate in a 24◊7 support rotation.
Support complex web-based applications.
Perform other duties as assigned.
5-7 years of relevant experience.
PostgreSQL 9.4+ experience required.
Knowledge of Amazon DMS and redshift is a huge plus.
Must have strong analytical, verbal and written communication skills.
Must have experience in PostgreSQL database architecture, logical and physical design, automation, documentation, installs, shell scripting, PL/ SQL programming, catalog navigation, query tuning, system tuning, resource contention analysis, backup and recovery, standby, replication, etc.
Must have strong knowledge of Linux.
Strong understanding of command line and server administration.
Knowledge of shell scripting (e.g., Bash, Perl).
B.S. in Computer Science, Mathematics, or Engineering or equivalent work experience.
Education: Bachelorís degree
Experience: Minimum 5 years of experience
Local Preferred: Yes
To apply for this position, please visit
DBA FYI Center