Talent.com
Postgres, PL/SQL Database Engineer
Postgres, PL/SQL Database EngineerShrive Technologies LLC • Frisco, TX, United States
Postgres, PL / SQL Database Engineer

Postgres, PL / SQL Database Engineer

Shrive Technologies LLC • Frisco, TX, United States
3 days ago
Job type
  • Full-time
  • Quick Apply
Job description

Job Description

  • Database Engineer with expertise in SQL, PL / SQL, Java, and Stored Procedures (SPs) to design, develop, and optimize database solutions.
  • The ideal candidate will be responsible for performance tuning, process automation, and collaborating with development teams to enhance system efficiency.

Key Responsibilities :

  • Design, develop, and optimize complex SQL queries, stored procedures (SP), functions, and triggers.
  • Develop and maintain PL / SQL scripts, packages, and functions for database automation and process improvements.
  • Implement and optimize database indexing, query performance tuning, and partitioning strategies.
  • Collaborate with Java developers to integrate databases with Java-based applications.
  • Design and maintain ETL processes for data migration, transformation, and integration.
  • Troubleshoot database issues, deadlocks, slow queries, and performance bottlenecks.
  • Manage database security, backups, and recovery strategies.
  • Ensure compliance with data governance and security policies.
  • Maintain documentation for database architectures, configurations, and best practices.

    • Required Skills & Qualifications :

  • 8+ years of experience in SQL and PL / SQL development.
  • Strong expertise in Stored Procedures (SPs) development.
  • Hands-on experience in Java programming for database integration and application development.
  • Proficiency in Oracle, PostgreSQL, MySQL, or MS SQL Server databases.
  • Experience in query optimization, performance tuning, and indexing.
  • Knowledge of database design, normalization, and data modeling.
  • Familiarity with ETL tools, scripting, and batch processing.
  • Experience with Unix / Linux shell scripting.
  • Strong analytical and problem-solving skills.
  • Ability to work independently and collaboratively in a fast-paced environment.
  • Creating DDL for the DBA to execute for creating and maintaining the DB objects.
    • Create a job alert for this search

    Database Engineer • Frisco, TX, United States