Looking For DBA/DataOPS/Oracle and PostgreSQL

Willing to work from 3:30PM to 11:30PM window.

About the Role:

Platform DataOps Engineer

Key Responsibilities

Database Administration & Development:

• Experience with maintenance operations including patching, upgrades, refreshes, and backup/restore.
• Supports DB release deployments: creating/modifying tables, columns, objects, and executing bulk DMLs.
• Strong understanding of lower environments and change propagation across them.
• Hands-on with Oracle 19c, RAC, DB services creation, and high availability (HA) configurations.
• Experience with export/import using Data Pump.
• Must have managed PostgreSQL databases for at least 4 years, including data migration.

Delphix:

• Experience with provisioning, refreshes, engine upgrades, and using the Delphix Toolkit.
• Hands-on with the masking engine, including rule setup and validation.
• Worked directly with Delphix Engineering to resolve critical issues.

Oracle Performance Tuning:

• Skilled in stats collection, SQL Plan Management, and resolving performance issues under pressure.
• Hands-on with tools like Oracle OEM, AWR, and SQL Monitor.
• Proven ability to troubleshoot and optimize queries in live production environments.
• Experience with table partitioning and online redefinition.
• Same skills required in PostgreSQL as well.

AWS Services and Databases:

• Experience with data migration from Oracle to PostgreSQL using AWS DMS.
• Worked with S3 buckets, Athena, and Step Functions for data processing workflows.
• Hands-on with DynamoDB and understanding of purpose-built AWS databases.
• Familiar with EC2, EBS, and other supporting AWS services.
• Good understanding of networking concepts in AWS (VPC, subnets, security groups, etc.).

Automation:

• Automated tasks using Shell scripting.
• Built and managed Jenkins pipelines using Groovy scripts.
• Proficient with GitHub and related Git tools for version control and collaboration.
• Comfortable working in VS Code and equivalent IDEs.

Collaboration & Agility:

• Work in Agile teams, collaborating with developers, QA, and product owners.
• Contribute to sprint planning, retrospectives, and DevOps best practices.

Learning Agility & Innovation:

• Quick learner with a strong ability to adapt to new technologies and processes.
• Enthusiastic about continuous learning and exploring modern tools, including AI-based solutions.
• Proactive in adopting innovations that improve efficiency and team productivity.