Maintain, monitor, and support complex, mission-critical databases in an operational 24x7 enterprise environment.
Database monitoring, performance tuning, and administration.
Perform database updates and patches to support the system.
Install new software releases, system upgrades, evaluate and install patches and resolve software and hardware related problems.
Work with developers to review schema and SQL changes to application software and make recommendations when needed.
Recommends solutions by defining database physical structure and functional capabilities, database security, data back-ups, and recovery specifications.
Owning, tracking and resolving database related incidents and requests.
Respond to database related alerts and come up with strategic solutions to recurring problems.
Required to work after hours to support production issues or scheduled maintenance or database releases.
Performance tuning on regular generated queries.
Review and assist developers in creating queries and stored procedures.
Manage daily and weekly backups of all database systems.
Manage replication applications for production database systems.
Minimum of 5 years of Database Administration experience that includes multiple RDBMS with majority experience in PostgreSQL.
Experience with PostgreSQL 9.6+ on AWS RDS.
Working knowledge and experience in Linux and AWS RDS platforms.
Working knowledge and experience in NoSQL DB is a plus
Good knowledge of scripting on Linux.
Experience in 24/7 Production environment is highly preferred. Database Administration support including weekends.
Good knowledge of Disaster Recovery.
Strong knowledge of risk assessment techniques.
Ability to develop policies and procedures as they relate to database management.