Sql Database Administrator

Sql Database Administrator

Makati, National Capital Region | ILLIMITADO, INC. | Posted today

Responsibilities :

• Migrate MS SQL Server database to PostgreSQL
• 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.

Job Types : Full-time, Permanent

Benefits :

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

Makati, National Capital Region | ILLIMITADO, INC.

Posted today

Responsibilities :

• Migrate MS SQL Server database to PostgreSQL
• 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.

Job Types : Full-time, Permanent

Benefits :

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

Be The First To Know

About the latest Sql database administrator shifting Jobsin Taguig

Set Email Alert:

Job title

Location