Job Description:
- Database installation, configuration, and managing PostgreSQL DB on physical and virtual machines
- Database upgrade and migration
- Database optimizations, query analysis and tuning
- Performance tuning for high throughout
- Monitoring and uptime of all production databases. Overall system health monitoring all mission-critical DB farms in global locations
- Estimation of PostgreSQL database capacities; developing methods for monitoring database capacity and usage
- Developer SQL code review to ensure queries are optimized and tuned to perform efficiently prior to production release
- Regular backups and recovery of databases
- Regular maintenance on databases (e.g., Vacuum, Reindexing, Archiving)
- Pro-active remediation of database operational problems
- Query tuning and preventative maintenance
- Developing Triggers/Stored Procedures
- Developing SQL reports
- Leading efforts to develop and improve procedures for automated monitoring and proactive intervention, avoiding/minimizing any downtime
- Involving in the end-to-end development process, from concept to design, build and delivery from the database architecture point of view
- Working on enhancing products and solutions globally, servicing our ever-expanding global customer base
- Working as an integral member of our dynamic development team globally
- Understanding current product features with regard to technology and customer needs
Qualifications:
- BS/MS in Engineering or Computer Science/Mathematical Engineering
- Experience in Telecom or Financial industry
- 3+ years of solid PostgreSQL DBA experience in managing critical 24/7 applications
- 3+ years of experience in administration and management of PostgreSQL
- Complete knowledge of ANSI SQL dialect is a must
- Good Knowledge of architecture and concepts
- Strong knowledge of Streaming Replication and other replication tools
- Strong knowledge of Linux and Windows OS
- Good knowledge in switchover/failover and switchback/failback concepts
- DR setup knowledge
- Shell Scripting knowledge for automating tasks
- Linux administration concepts know-how is a plus
- Previous experience working with development teams and architectural teams
- Ability to analyze and apply critical thinking to resolve complex issues
- Self-motivated with an ability to confidently execute independently with little direction
- Strong team player and relationship building skills