Banner Image

Skills

  • Data Migration
  • Jira
  • Plsql
  • Scheduler
  • SQL
  • Unix

Services

  • PLSQL/SQL DEVELOPER

    $50/hr Starting at $100 Ongoing

    Dedicated Resource

    Responsibilities: Database Development: Design, develop, and maintain PL/SQL scripts, stored procedures, triggers, and functions to support business logic and data processing. SQL Query Optimization:...

    Data MigrationJiraPlsqlSchedulerSQL

About

Having professional experience in SQL, PL/SQL and Data migration Developments.

- Played a role in Design, Development, Maintenance & Support in Banking, Finance & Retail Domains.
- Designing conceptual, logical, and physical data models to ensure the database meets business needs and scalability.
- Good experience in SQL Query writing, optimization and handling high volumes of data.
- Experience & Knowledge in Creation & Modification of all the Complex database objects in Oracle.
- Knowledge & Experience in UNIX Commands, Shell scripting & Unix Environments.
- Extensive in Delivering technology, Innovation & Solutions to clients in finance and other domains.
- Quickly diagnose and resolve database-related issues, working closely with development teams to maintain application stability and uptime.
- Implementing data backup strategies and ensuring recovery procedures are in place to prevent data loss.

Key competencies:
- Oracle Data Pump (Export/Import): Expertise in using Oracle Data Pump for high-performance data export and import operations.
Proficient in performing data migration, backup, and recovery tasks using Data Pump Export (expdp) and Data Pump Import (impdp) utilities.

- DBMS Parallel Execute: Expertise in using DBMS_PARALLEL_EXECUTE for parallel execution of SQL statements to enhance performance for large data manipulations.

- DBMS Scheduler: Experience with the DBMS Scheduler package for automating database tasks and jobs, such as backups, data transfers, and reporting. Knowledge of handling complex scheduling scenarios with dependencies, time-based triggers, and execution intervals.

- Development Activities: Delivering an easy use, Innovative, Advanced Technological and bug free code to Client.

- Prod Support Activities: Root causes Analysis, Recreate the issue, Debugging the code, Impact Analysis, DAT Fix, Code Fix & Logical Fix.

- DB Testing Activities: Sanity check, Functional testing, Regression testing, E2E testing & System Testing.

Skills worked: Oracle SQL, PL/SQL, PostgreSQL & Unix.

Optimization Techniques: Query tuning, Bulk
Collect, Table partition , Gather stats, Table Reorg, AWR report, Explain plan, Hint based.

Prod Support: Data patches, Analysis, DAT Fix, Recreate issue, Debugging, Root cause, Code Fix & Logical Fix.

Documentation: Negative testing,Test cases,BRD, Implementation plan, Code check list, Integrated implementation plan & Integration Release plan.

Tools used: SQL Developer, PostgreSQL, TOAD, Git, Jira, Confluence, PVCS & SVN.