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
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