PostgreSQL Developer

Immediate need for a talented PostgreSQL Developer. This is a 06+ Months Contract opportunity with long-term potential and is located in Plano, TX (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID:26-31962Pay Range: $55 - $58/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location). Key Responsibilities:Design, develop, and maintain PostgreSQL databases, schemas, tables, views, indexes, stored procedures, functions, and triggersPlan and execute database migrations from legacy relational database platforms to PostgreSQLAssess source and target database environments and identify migration risks, dependencies, and compatibility issuesConvert and optimize database objects, queries, and data models during migration effortsPerform data transformation, validation, reconciliation, and post-migration testingTune PostgreSQL performance through indexing, query optimization, execution plan analysis, and database configurationSupport backup, restore, replication, and high availability strategiesTroubleshoot database performance issues, migration defects, and production incidentsCollaborate with application developers, DevOps, infrastructure, and security teams to support platform modernizationBuild and support cloud-based database and application workloadsImplement and support infrastructure as code, CI/CD pipelines, and deployment automationWork with cloud networking, monitoring, access control, and security best practicesSupport production systems and participate in incident resolution and root cause analysisDocument technical designs, migration plans, operating procedures, and support processesKey Requirements and Technology Experience:Strong hands-on experience with PostgreSQL development and administrationCloud engineering experience supporting workloads in AWSProven experience leading or supporting database migration projectsProficiency in SQL, database design, normalization, and relational data modelingExperience with stored procedures, functions, views, triggers, and indexesStrong understanding of query optimization, performance tuning, and execution plansExperience with ETL, data transformation, and data validationKnowledge of backup, restore, replication, and high availability conceptsFamiliarity with transactions, locking, isolation levels, and concurrency controlAbility to troubleshoot complex technical issues in database and cloud environmentsStrong communication, documentation, and problem-solving skillsExperience migrating from Oracle, SQL Server, MySQL, or other RDBMS platforms to PostgreSQLExperience with PostgreSQL extensions and advanced featuresExperience with large-scale, business-critical, or enterprise migration projectsExperience supporting cloud-native architectures and modern DevOps practicesOur client is a leading IT Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here.