Deepika Singla Email & Phone Number

Calgary, Alberta, Canada

Worked on migration of 911 project . Migration of database from on-premises to Cloud.

Gurgaon, India

Client :- Duns and BradstreetWorking on Data Migration project from SQL server to AWS aurora. And also converting SAS code into Python code.

Gurgaon, India

Client - Royal Bank of Scotland (RBS)

Noida

Currenltly working in CSC for a US based Insurance company. Responsibilities:Documented Tech Specs for the proposed data base design.Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.Performed the set up the VSS source code architecture for the client.Performed code reviews.Used SQL Navigator… Show more Currenltly working in CSC for a US based Insurance company. Responsibilities:Documented Tech Specs for the proposed data base design.Developed PL/SQL packages and procedures for the back end processing of the proposed data base design.Conducted PL/SQL training session for co-workers to educate about the latest PL/SQL features, PL/SQL performance tuning.Performed the set up the VSS source code architecture for the client.Performed code reviews.Used SQL Navigator to reverse engineer the model of the legacy applications.Developed Unix shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.Use SSIS to extract and transforma and then load the data into some meaningful form Show less

Delhi

Worked in TCs for a Income tax Project. And mainly worked as a DBA.Interacting with client and team to resolve queries. ◆ Resolving user's day-to-day issues. ◆ Resolving the tickets. ◆ Involved in designing the Backup Strategy Plan. ◆ Used ADDM for taking the advisories. ◆ Monitoring the ASM Disk Groups. ◆ Applied database patches. ◆ Configured DR site. ◆ Distribution of Table spaces among different Disks and creation of Database objects. ◆ Performed… Show more Worked in TCs for a Income tax Project. And mainly worked as a DBA.Interacting with client and team to resolve queries. ◆ Resolving user's day-to-day issues. ◆ Resolving the tickets. ◆ Involved in designing the Backup Strategy Plan. ◆ Used ADDM for taking the advisories. ◆ Monitoring the ASM Disk Groups. ◆ Applied database patches. ◆ Configured DR site. ◆ Distribution of Table spaces among different Disks and creation of Database objects. ◆ Performed Database Cloning and refresh on to Test environment. ◆ Monitoring and maintaining Oracle cluster DB's for their Optimal Performance and ensuring 100% availability of the DB's. ◆ Performed Index Rebuilding to enhance the performance. ◆ Configured Data Guard and tested for failover & switchover. ◆ Creation of table spaces, user maintenance by creation and granting of roles and privileges. ◆ Design & implement the processes for DBA activities and for trouble shooting databases. ◆ Performed database backup using RMAN. ◆ Ensure space management on servers and user management at the database level. ◆ Consistently interacted with client and team in resolving the queries. ◆ Performing database Health checkups. ◆ Performed Database Cloning from Production to Test environment ◆ Generated AWR/Stats pack report for database performance health checkups. Monitor and report status of databases (capacity planning, size/limit, performance, etc.) ◆ Performed Cloning Activity for Databases from Production to Testing Environment. Show less

Gurgaon

Worked in IBM for Banking Project (American Express)Responsibilities also included:FormulatingWriting scripts to create tables and viewsDeveloping PL/SQL procedures, packages, triggers, functionsDeveloping UNIX scripts to import, export operationsMonitoring the query performance using explain plansWorked closely with client to research and resolve user testing issues and bugs.Provided business requirements to Oracle developers to fix bugs or build… Show more Worked in IBM for Banking Project (American Express)Responsibilities also included:FormulatingWriting scripts to create tables and viewsDeveloping PL/SQL procedures, packages, triggers, functionsDeveloping UNIX scripts to import, export operationsMonitoring the query performance using explain plansWorked closely with client to research and resolve user testing issues and bugs.Provided business requirements to Oracle developers to fix bugs or build enhancements.Worked closely with Oracle developers to resolve user-testing issues. Show less

Mohali

All database related works like migration of data by sql loader, Procedure, fuction, fire trigger, cursors, ref cursors, sql queries depends upon client requirement...