Overview
Skills
Job Details
Hi
Hope you are doing well!
Please find the job description below for a Oracle Database / PostgreSQL Engineer and let me know your thoughts.
Role: Oracle Database / PostgreSQL Engineer
Location: Tampa, Florida-Hybrid 2 days onsite
Visa: EAD
Experience: 11+ Years
Duration: 12 months(Only On W2)
JD:
Seeking an experienced Oracle Database / PostgreSQL Engineer to implement and optimize our customer identity data model within Oracle Database.
The data model design has been completed, and this role will focus on translating that model into a robust, secure, and high-performing Oracle/PostgreSQL database implementation.
Responsibilities:
Translate the completed identity data model into physical Oracle/PostgreSQL database structures (tables, indexes, partitions, constraints, etc.).
Develop and implement database schema, ensuring adherence to design standards and performance best practices.
Implement stored procedures, triggers, and functions to support identity workflows and data transformations.
Optimize queries, indexing strategies, and database structures for scalability and performance.
Conduct capacity planning, performance tuning, and troubleshooting of database-related issues.
Implement appropriate security controls, access permissions, and auditing in alignment with identity and access management requirements.
Mandatory:
Strong hands-on exp with PostgreSQL or Oracle Database (12c, 19c, or later), including schema design, PL/SQL development, and performance tuning.
Proven exp implementing enterprise-scale data models, preferably in identity management, security, or customer data domains.
Solid understanding of data modeling concepts (relational, dimensional, normalization, indexing strategies).
Exp with performance optimization tools, query tuning, and partitioning.
Knowledge of security features (roles, privileges, auditing, data masking, encryption).
Familiarity with ETL, data migration, and integration best practices.
Strong troubleshooting, analytical, and problem-solving skills.
Nice-to-Have:
Exp working on identity data models or within IAM/IGA solutions (e.g., SailPoint, Oracle Identity, Okta).
Exposure to cloud-hosted Oracle databases (OCI, AWS RDS for Oracle, or Azure).
Knowledge of data privacy regulations (GDPR, CCPA, HIPAA) in relation to database design and security.
Exp DevOps/automation for Oracle DB (e.g., Liquibase, Flyway, or CI/CD pipelines for DB deployments).