Accountable for monitoring and uptime of all production databases
Estimate PostgreSQL database capacities; develop methods for monitoring database capacity and usage.
Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any need for downtime
Participate in application development projects and arrange for the database architecture and design
Contribute to 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
Complete regular backups and recovery of databases
Designing disaster recovery strategy for postgresql and sql server instances
Provide consistent maintenance on databases (e.g., Vacuum, Reindexing, Archiving).
Lead pro-active remediation of database operational problems
Responsible for Query tuning and preventative maintenance
Participate in a 24×7 support rotation
Support complex tomcat web-based applicationsQualifications
5-7 years of relevant experience
Bachelor degree in Computer Science, Math, Engineering
PostgreSQL 9.6+ and MS sql server experience required
Must have proficiency 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.
Deep/wide knowledge of Linux and windows OS
Understanding of command line and server administration
Command of shell scripting (e.g., Bash, Perl)
Strong analytical, verbal and written communication skills
Ability to thrive in a fast-paced environment and able to match stakeholder expectations to urgently deliver exceptional results