Dalip isn't taking new orders for this project right now. Here are some similar projects to explore.
You will get DB2 LUW, Sybase, PostgreSQL, Google Apps Scripts and Google Sheet solutions
Project details
I have 10 years of experience in Administrating DB2 LUW and Sybase databases from version 8x to 11.x. Hands-on experience on PostgreSQL database as well.
I have good experience and knowledge of UNIX Bash Shell Scripting. I have written many scripts for my ongoing projects.
I have good experience and knowledge of Google Apps Script and Google Sheets Automation.
I have worked with many US and UK clients and promise to deliver good quality work.
I have good experience and knowledge of UNIX Bash Shell Scripting. I have written many scripts for my ongoing projects.
I have good experience and knowledge of Google Apps Script and Google Sheets Automation.
I have worked with many US and UK clients and promise to deliver good quality work.
What's included
| Service Tiers |
Starter
$15
|
Standard
$20
|
Advanced
$35
|
|---|---|---|---|
| Delivery Time | 5 days | 6 days | 7 days |
Number of Revisions | 0 | 0 | 0 |
Schema Diagram | - | - | - |
Permissions Setup | - | - | - |
Import/Export Data | - | - | - |
Admin Panel Setup | - | - | - |
About Dalip
ORACLE and DB2 LUW Administrator
Bengaluru, India - 11:27 am local time
Experience in:
* Oracle database migration from one Exadata cluster to another with minimum downtime.
* Quarterly Oracle Exadata servers patching for X6, X7, X9 and X10 Compute Node, Storage Cell node and Switches patching.
* Quarterly Oracle Exadata patching of GI, RDBMS and JDK patching.
* Oracle database movement using export/import utilities.
* Oracle Backup and restore using RMAN.
* Archive/Purge tables to history tables and compress using exchange method in Oracle.
* Design and develop database architecture for database systems on
Non-DPF and DPF environment.
* Lead and co-ordinate teams of data administrators in the development and implementation of data policies, standards and models.
* Design, build, upgrade and update database management systems to latest DB2 LUW patch on AIX, Linux, SunOS and Windows from Versions 8 to 11.5.
* Maintain and monitor DB2 Backups and Storage management.
* Database recovery redirected restores (Single and Multi-partition).
* Thorough understanding on SQL queries like DDL, DML, DCL, TCL and DQL.
* Worked on SQL and Q replication.
* Manage HADR failover and failback.
* Knowledge of HADR with TSA (DB2HAICU).
* Worked on CDC setup.
* Migrated Oracle to Postgresql database.
* Worked on Foglight Monitoring Tool, Nagios Tool and DBWatch tool.
* Ticketing tools like Service Now (SNOW), Drive IT and Clarify.
I have good experience in creating bash shell scripts. I have created many bash shell script for my current and previous clients.
I have mentioned below some of my work:
Automate manual jobs through Shell Scripting (like Production Table/Index Fragmentation Script, Production Table Growth Script,
DB2 Health Check Script for channel applications, NOMN Generation Script, DB2 DB Size Script for PROD and QA Region, REORG and RUNSTATS Script for DB’s in PROD, QA, DEV and SIT Region, Monitoring Backup Script which will show which backups are running after 6:30AM EST, Counting Number of Unzipped logs Script which will be sufficient to run the backup, Production and QA Tablespace Monitoring Script, Production and Lower region OBI backup monitoring scripts, Automated Snapshots for channel applications, Backup and Log deletion script deletes backup and logs for mentioned retention period, Tablespace Status (REOG pending, Backup Pending etc.) Script, Archiving logs of database script for DPF and NON-DPF environment etc.) through shell scripts.
IBM Websphere:
• Worked on Websphere setup.
• Setup prodiles in websphere application server.
• Worked on SoapUI by troubleshooting the issues from application end by entering end point URL and request which provides us with response for analysis.
POSTGRESQL:
• Migrating and upgrading PostgreSql from lower to higher version.
• Migrating oracle to PostgreSql using ora2pgtool.
• Migrating MSSQL to PostgreSql using sqlserver2pgtool.
ORACLE:
• Build, Install, setup and configure oracle databases.
• Design, build, upgrade and update database management systems to latest Oracle patch
• Backup and restore of databases.
• DC to DC Migration of oracle and cross platform RDBMS.
SQL Server:
• Migrating and upgrading SQL server from lower to higher version.
• Troubleshoot SQL server issues..
• Migrate MS SQL server to MYSQL.
AWS Bash Script
• Created bash script for transferring files from aix server to s3 bucket.
• Created bash script to establish connection between Linux and aix servers to aws cloud.
Additionally:
I have good knowledge and experience of Google Sheets, Google Apps Scripts and Google Documents.
Migrating WordPress to AWS EC2 instance.
Worked on snowflakes pushing data from snowflake to azure using data pipeline.
Steps for completing your project
After purchasing the project, send requirements so Dalip can start the project.
Delivery time starts when Dalip receives requirements from you.
Dalip works on your project following the steps below.
Revisions may occur after the delivery date.
Client purchases the project and sends requirements.
Client reviews and approves your work, and you get paid.