Join as a Senior Database Administrator responsible for the design, administration, optimization, security, and resilience of a PostgreSQL database platform across production environments. The role leads database migration initiatives from Oracle to PostgreSQL while driving performance, availability, disaster recovery, and cloud database best practices.
Client Details
The company operates in the insurance industry.
Description
- Ensure the proper design, implementation and deployment of databases in conjunction with the relevant cross functional teams
- Conduct research and make recommendations on database products, services, protocols, and standards
- Work with the Application Support teams and various IT groups to develop database architectures, coding standards, and quality assurance policies and procedures
- Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of databases
- Document and review database design to ensure optimal database performance, providing analysis and recommended improvement opportunities to management
- Lead Database Migrations projects activities (to PostgreSQL platform) in a senior DBA capacity
- Performance and general health / capacity monitoring and day-to-day database administration duties
- Assist with routine maintenance including database rebuilds/re-indexing/expansion and archiving as needed
- Troubleshoot PostgreSQL database/server issues and assist in the resolution of application-related problems
- Provide day-to-day support to production systems as assigned or required
- Administer database security, establish effective security controls, and be primary point of contact for audits
MPI does not discriminate on the basis of race, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, or based on an individual's status in any group or class otherwise protected under applicable human rights legislation. MPI encourages applications from minorities, women, the disabled and all other qualified applicants
Profile
- College Diploma or University Degree in the field of computer science
- Minimum 10 years of practical DBA experience with sound working knowledge of database structure, theories, principals and practices
- Advanced knowledge and experience with PostgreSQL Database Platform including: Software installation and configuration, High Availability and Disaster Recovery, Performance Tuning and Optimization, Backups, Security and Compliance, PostgreSQL internals
- Experience with Database Migrations to PostgreSQL from Oracle Database Platform is a must
- Strong proficiency in Linux administration (RHEL) in On-prem and Cloud Infrastructure. Command-line interface, file systems, shell scripting and user management
- Experience with managed cloud databases (AWS RDS/Aurora, Azure Database for PostgreSQL, Google Cloud SQL) and containerized workflows (Kubernetes, Docker)
- Working technical experience with designing, building, installing, configuring and supporting other than PostgreSQL databases on both Windows and Unix servers (Oracle and/or MSSQL preferred)
- Availability to work weekends and after hours as per business needs
- Optional or preferred vendor/community credentials or certifications (e.g. PostgreSQL or cloud-provider database specialty certifications)
Job Offer
- Temporary contract.
- Hourly pay
- Lead strategic Oracle-to-PostgreSQL migration initiatives with significant business impact.
- Influence database architecture, performance standards, security controls, and HA/DR strategies.
- Gain exposure to modern cloud database platforms including AWS, Azure, and Google Cloud.
This role may use AI‑assisted tools to support initial screening. All assessments and decisions are made by a human reviewer.
MPI does not discriminate on the basis of race, religion, sex, sexual orientation, gender identity or expression, age, disability, marital status, or based on an individual's status in any group or class otherwise protected under applicable human rights legislation. MPI encourages applications from minorities, women, the disabled and all other qualified applicants
