Database Consultant

Summary

Information technology professional with extensive experience in delivering high quality systems for Telecom, Pharmaceutical, Insurance, Retail, Manufacturing, Hi-tech companies, Energy and Utilities.

20+ Years of IT experience, out of which around 18+ Years as Database SME of Oracle Databases and knowledge of Oracle MAA, Oracle 10g APEX Server and Oracle 9iAS under Solaris 10/9, HP Tru Unix, Red Hat ES Linux 7.x/8.x, SUSE Linux, Unix, Windows 2016, 2019 platform.

6+ Years of experience in DB Administration of MSSQL 2012/2014/2016/2019. Database migration from MSSQL 2012 to 2019. Experience in configuring Reporting Service (SSRS). Configuring and implementing Database Mirroring, Log Shipping, SQL Mails, Database mails.

3+ Year of experience in AWS and have sound knowledge in various migration techniques for moving Database from on premise to AWS (DMS, SCT, native backups, export/import).
Sound knowledge of EC2, VPC, S3, CloudWatch, RDS, Dynamo DB, Route 53 etc. Worked on migration project (Datacentre migration to AWS). Migrated on premises databases and legacy databases to AWS.

Plan, design and Oracle RAC installation, configuration, administration of ASM, cluster control. MSSQL Always on configuration and installation. GRID and DB from upgrade from Oracle 12c to Oracle 19c. RAC database migration from Oracle 12c to Oracle 19c.

Golden Gate Installation, configuration, maintenance, and troubleshooting.

Plan, build, upgrade and OEM 13c installation, target addition to OEM, configuration of notification, alerts, incident, setting alerts threshold.

Perform DB patching, Cloning, DB Installation, troubleshoot issues/errors/incidents, Collaborate with Oracle support for bugs & issues resolutions and personal research. Patching of Oracle with RU and security patches and MSSQL with security and DB patches.

Create and maintain Dataguard configuration for disaster recovery and to manage planned maintenance.

Expertise in Database Migration from Oracle to Oracle, MSSQL to MSSQL, on prem to Cloud (AWS and OCI).

Oracle Cloud OCI, deploy database in Oracle 18c and 19c environment, manage different administration task backups, recovery, security, performance and monitoring through the Oracle Database Cloud Service consoles and Cloud tooling. Create, delete, stop, restart, patch and upgrade a database deployment. Monitor the database deployment by using the DBaaS Monitor utility. Manage users at all levels (Oracle Cloud Service, compute node and database).

Oracle Autonomous Database Configuration, migration in OCI Cloud.

Expectations

Senior Database SME.

Employment Preferences

Expected Base Salary

**5,000 AUD

Expected Hourly Rate

**0 AUD/hr

Academic Degree

Experience

Skills

• Operating Systems
• RHEL 7.x
• Solaris 10
• Windows 2016
• Databases
• Oracle 19c
• 18C
• 12C
• 11G
• MSSQL Server 2012
• MySQL
• PostgreSQL
• AWS RDS
• DynamoDB.
• Reporting
• SSRS
• SQL Server Reporting Services
• Tuning
• Monitoring
• RAC 19c
• Data-Guard 19c
• DB Cloning
• Standby Databases
• RMAN
• TKPROF
• EXPLAIN PLAN
• STATSPACK
• AWR.
• Tools
• Utilities
• OEM
• Oracle Management Server
• SQL
• Loader
• SQL Server
• Export
• Import
• TOAD
• Data Pump
• Query Builder
• Net Backup
• VB
• Crystal Report
• MS Access
• Oracle Streams
• Putty
• Plus
• SSMS
• 2012 2019
• Programming Others
• PL-SQL
• Shell Scripting
• Python.
• Advance Replication
• ETL
• Golden Gate.
• Backup Tools
• EMC
• NetApp
• VERITAS Netback Up
• CommVault.
• Cloud
• AWS
• OCI