Install Oracle ,Postgres database and troubleshoot various issues related to database patching.
Perform production database health check.
Detect potential issues that may impact production database operation and resolve the issues.
Performs database support for both production and development environments, including the installation of databases, back-ups, replication, restores, patches, and upgrades.
Ability to configure replication as a part of disaster recovery process.
Identify and resolve database issues that impact application performance.
All other duties and responsibilities as assigned.
Strong command of Oracle, Oracle server tools and Oracle Data Guard.
Advanced knowledge of database security, backup and recovery, performance monitoring and tuning standards.
Understanding of relational and dimensional data modelling.
Develop processes for optimizing database security.
Create and manage database reports, visualizations, and dashboards.
Create automation for repeating database tasks.
Be available for on-call support as needed.
Requirements
Bachelor's degree in business or computer science, or equivalent education and work experience combined.
Minimum 3 to 5 years of Oracle/Postgres database administration and Oracle Data Guard experience.
Prior exposure to software development processes and/or methodologies.
Familiarity with on premise and cloud-based implementations.
Database certification(s) preferred.
Prior experience with server class hardware, operating systems, and virtualization.
Deep knowledge of Oracle/Postgres servers/databases and Oracle/Postgres database development and Oracle Data Guard.
Deep knowledge in both OLTP and OLAP database designs and administration.
Proven System Administration skills.
Innovative thinker with a commitment to improve processes and methodologies.
Strong written and verbal communications skills.
Excellent client management & client service skills.
Knowledge and experience preferred with AI-driven development and automation tools such as GitHub Copilot, Copilot Studio, and related platforms to optimize database administration tasks, implement intelligent query tuning, and enhance operational efficiency.