Optimize and enhance database structure during the transition to PostgreSQL to improve performance, security
Plan and coordinate the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines
Convert Stored Procedures as needed from MS SQL Server to PostgreSQL
Tune autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
Set up development, test, UAT and production environments with Production data as needed
Set up Scalability, High Availability and Disaster Recovery to ensure 99.99% uptime
Assist the software developers on all issues related to the database
Qualifications:
At least 2 years of extensive hands-on experience with managing PostgreSQL databases.
Strong understanding of PostgreSQL Architecture, Performance Management, User Management and Security.
Exposure to Cloud Data Migrations & Cloud Native databases like Aurora is desirable
Reasonable exposure to SQL Server is a must
Experience designing, implementing, and supporting complex architectures such as high availability, disaster recovery and scalability for mission critical, 24*7 environments.
Independently manage processes, automation, best practices, and documentation. Possess good communication skills as this position will require interacting with multiple application teams.
Job Types: Full-time, PermanentBenefits:
Flexible schedule
Health insurance
Opportunities for promotion
Pay raise
Promotion to permanent employee
Schedule:
8 hour shift
Day shift
Flexible shift
Supplemental Pay:
13th month salary
Overtime pay
Ability to commute/relocate:
Makati City: Reliably commute or planning to relocate before starting work (Required)
Beware of fraud agents! do not pay money to get a job
MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.