Database Administrator (Oracle and PostgreSQL database )

Position Description:

Role Summary:Manages Oracle and PostgreSQL databases to ensure high performance availability security and data integrity.
Key Responsibilities:

. Install and configure Oracle and PostgreSQL database software in silent mode.
. Create and manage CDB/Non-CDB databases.
. Administer user access security policies and storage structures.
. Implement and manage backup recovery and disaster recovery strategies.
. Configure PostgreSQL streaming replication and high availability solutions.
. Ensure data consistency across replicas.
. Perform routine maintenance (vacuuming reindexing statistics optimization).
. Monitor and optimize query performance disk usage and connection limits.
. Apply patches and minor upgrades with minimal downtime.
. Collaborate with application and IT teams on database requirements.
. Provide timely support for database-related issues.

Skills & Qualifications:

. Strong SQL PL/SQL PSQL and PL/pgSQL skills.
. Proficiency in Oracle 19c and PostgreSQL 11 administration.
. Hands-on experience with Oracle and PostgreSQL tools (OEM RMAN Data Pump Data Guard pgdump pgrestore pgbasebackuppgupgrade & GoldenGate).
. Expertise in Oracle patching upgrades partitioning indexing and statistics management.
. Solid knowledge of database performance tuning (query optimization vacuuming indexing).
. Oracle Certified Professional (OCP) preferred.


Eligibility:

. Bachelors degree in engineering Computer Science Information Technology or a related field.
. Minimum of 5 years of professional experience in Managing On-premises and cloud environments

Proficiency in setting up and managing on-premise databases

Skills:

• Database Administration
• Database Tuning
• Oracle
• Performance Tuning
• Postgre SQL

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our teamone of the largest IT and business consulting services firms in the world.