Senior PL-SQL Developer - Database Support

Description :

Location : India Except Mumbai

Department : Engineer-Data Engg

Responsibilities :

We are seeking a seasoned PL/SQL Developer with 5 to 6 years of experience to join our database support team. This role demands strong expertise in Oracle and MySQL databases, along with hands-on experience managing AWS cloud-based database services.

The ideal candidate will be responsible for ensuring the stability, performance, and reliability of database-driven applications in both on-prem and cloud environments.

Key Responsibilities :

- Provide advanced L2/L3 support for PL/SQL applications across Oracle and MySQL platforms.

- Develop, maintain, and optimize stored procedures, triggers, packages, and complex SQL queries.

- Monitor and tune database performance using tools like Oracle Enterprise Manager, MySQL Workbench, and AWS

CloudWatch.

- Manage AWS database services such as RDS (Oracle/MySQL), Aurora, and DynamoDB.

- Collaborate with DevOps and infrastructure teams for cloud deployments, backups, and disaster recovery.

- Perform data migrations, ETL operations, and schema updates across environments.

- Document technical solutions, incident resolutions, and support workflows.

- 5 years of IT experience

REQUIREMENT :

- Strong knowledge in Oracle SQL, PL/SQL, My SQL

- Querying and manipulating the tables using DDL, DML and TCL commands.

- Develop and modify stored procedures, Functions, Packages, Triggers, Views, and other database objects.

- Experience on Migration from Oracle to MY SQL database.

- Proficient in identifying bottlenecks and optimizing queries.

- Analyse requirements and design technical solutions to meet business needs.

- Having experience on Unix/Shell scripting is very helpful.

- Help determine best design approaches

- Strong command of Oracle and MySQL database systems, including performance tuning and query optimization.

- Experience with AWS database services (RDS, Aurora, DynamoDB) and cloud-native database operations.

- Proficiency in scripting (Shell, Python) for automation and monitoring.

- Familiarity with CI/CD pipelines, version control (Git), and infrastructure-as-code tools (Terraform, CloudFormation).

- Solid understanding of ITIL processes and incident/change management tools (e., ServiceNow, JIRA).

- Excellent problem-solving, communication, and documentation skills.

Requirements :

- Strong knowledge in Oracle SQL, PL/SQL, My SQL

- Querying and manipulating the tables using DDL, DML and TCL commands.

- Develop and modify stored procedures, Functions, Packages, Triggers, Views, and other database objects.

- Experience on Migration from Oracle to MY SQL database.

- Proficient in identifying bottlenecks and optimizing queries.

- Analyse requirements and design technical solutions to meet business needs.

- Having experience on Unix/Shell scripting is very helpful.

- Help determine best design approaches

- Strong command of Oracle and MySQL database systems, including performance tuning and query optimization.

- Experience with AWS database services (RDS, Aurora, DynamoDB) and cloud-native database operations.

- Proficiency in scripting (Shell, Python) for automation and monitoring.

- Familiarity with CI/CD pipelines, version control (Git), and infrastructure-as-code tools (Terraform, CloudFormation).

- Solid understanding of ITIL processes and incident/change management tools (e., ServiceNow, JIRA).

- Excellent problem-solving, communication, and documentation skills