Sql Server Golden Gate

Resume

*** **** ***** *******@*****.***

Mississauga, # 647-***-****

L5B 3W4 OCP: 9i / 11g

Rameez Fakih

SUMMARY

Extensive experience as DBA with Standalone and High Availability on different flavors of UNIX, Windows. An Innovative thinker with proven experience in designing, implementation, migration and supporting the next generation database solutions. SPECIALTIES

Database - Oracle 8i,9i,10g,11g,12c,19c, Exadata, ExaCC, Exalogic, Golden gate,

SQL server 2008, 2012, 2014,2016 MySQL, Informix, MongoDB Application - PeopleSoft, SAP

Storage - SAN, NAS, NetApp, 3 PAR

Process - ITIL, ITSM, Agile, Remedy, Service Now, HP OpenView Cloud - Oracle, Amazon AWS, Azure, GCP

OS - Solaris 11 (zones), RHEL, AIX, HP-UX, Windows Tools - TOAD, Microsoft Studio, SQL Developer,OPS, Erwin, Nagios, Jira, Control_M, ILOM, Exachk, Diagtool,Zeke, OSwatcher, BCV and OEM13c

Scripting – Bash, Python

SKILLS SUMMARY

• Installing, Configuring, Upgrading, Patching, Migration, Maintenance and tuning of Oracle 8i/9i/10g/11g/12c, Grid Control, Golden Gate with Standalone, RAC and Exadata

• Have experience in 12c, Exadata and Solaris to support Supercluster Machine

• Installing, Configuring, Upgrading, Patching, Migration, Maintenance and tuning of SQL server 2008/2012, Clustering (Active-Active), Mirroring and Always On

• Administration of Informix database

• Real application testing using SQL performance analyzer and Database Replay

• Exadata X2-2, X3, X5-2, X6-2 and X-7 Managing disk, wait events, supporting infiband switches, ports and infiband fabrics

• Implemented golden gate using exadata DBFS architecture

• Setup Rman backups on Oracle ZFS appliance

• Monitoring exadata machine using ADRCI, ILOM, Exachk, Diagtool, OSwatcher and EM12c

• Maintenance of cell storage for disk and flash card replacement

• Planning exadata QDPE quarterly patches by implementing Standard Operating Procedures

• Exadata administration using DCLI and Cellcli

• Reporting Database machine failures using ASR and OCM

• Encryption using Guardium

• Migrating 11g database to Pluggable container database PDB on 12c

• Configuration and Administration of Active DR with Far sync

• Query tuning expertise using 10046 and 10053

• Monitoring the performance of Database server using Nagios and OSWatcher

• Performing capacity planning required to create and maintain the Database

• ITIL, ITSM process using remedy, ServiceNow for Incident, change, KPI’s and problem management

• Excellent Presentation, Communication and Analytical skills.

• Ability to interact effectively with people, Sincere and committed.

• Exhibit the traits like Self-confidence, Self-starter, Curiosity, Result oriented

• Compatible in team environment and to work well independently PROFESSIONAL EXPERIENCE

ShopiAds Inc Jan 2021 – Dec 2024

Cloud Infrastructure & Database Administrator

• Design and Managed cloud infrastructure for application and database

• Define the architecture of MongoDB Cloud Infrastructure in Atlas

• Implemented aggregation for search and autocomplete

• Implemented backup and recovery plan

• Testing restoration processes to ensure data recovery plans are effective

• Implementation plan prepared for migration covering Application and database dependencies

• Monitored Infra & Database health and applied patches

• Performed database upgrades when required

• POC done on DEV/QA/UAT before moving to PROD

• Change management, Incidents and Task process using Clickup Arisoft (Client Loblaw) Oct 2018 – Dec 2020

Cloud Database Administrator

• Define the architecture of Oracle Cloud Infrastructure during migration from on-premises to cloud for successful deployment, security, and availability

• Creation of Virtual network, Server, and Database on cloud platform

• Implementation plan prepared for migration covering Application dependencies

• Database Migration to Oracle cloud Exacc X7 from Aix 11g to RHEL 12c

• Implementation of TDE encryption using Software and HSM

• Implementation of compression using Advanced method

• POC done on DEV/QA/UAT before moving to PROD

• Diagnosing and fixing application connection to cloud server

• Golden gate implementation and support

• RAT using SQL performance analyzer for automating the remediation of any SQL regressions because of the system change and Database Replay to assess the impact of any system change at server level

• Testing of backup and recovery on 12c

• Change management, Incidents and Task process using Service Now JM Group (Client SunLife Financials) Mar 2017 – Mar 2018 Senior Database Administrator

• Database Migration from 11g to 12c on cross platform RHEL to AIX

• Implementation of encryption using Guardium

• Golden gate implementation and support

• Using Oracle Wallet for GG configuration

• Backup using RMAN and Data pump

• Checking health of database including system and database statistics

• Configured heterogeneous service to use non-oracle databases

• Configuration and maintenance of DR

• Using 13c OEM for Grid control for Monitoring

• Patching of RAC and non-RAC databases

• Change management, Incidents and Task

• Implementing application releases on SQL server and Oracle database

• Configuring and Deploying of SSIS packages, SSRS reports and SSAS cubes

• Refreshing databases for Oracle and SQL server

Corning Incorporated Feb 2015 – Aug 2016

Lead Database Administrator

• Corning has 900 databases with different version from 8i to 12c on Standalone, RAC, Exadata using application (PeopleSoft and SAP)

• Managing Exadata Hybrid X2-2, X3-2, x5-2 on 12c using ASM

• Migrating 11g database to Pluggable container database PDB on 12c

• Planning QDPE quarterly patches by coordinating with Oracle support team and adding additional one-of patch if required, also validating all the required changes are implemented successfully

• Golden gate is implemented using DBFS architecture

• Implemented Exadata features like Hybrid columnar compression, parallel querying, data sharding, pinning hot tables to flash

• Creating ASM disk group on different section of disk as hot and cold for DATA and FRA using grid disk

• Cell administration using cellcli

• Database and Exadata patching during maintenance

• Monitoring database, cluster, infiband, storage and switches

• Performed disaster database recovery of production server using flashback and backup

• Monitoring infiband switches, ports and infiband fabrics

• Configuration and maintenance of DR

• Implemented 12c OEM Grid control for Monitoring

• Handling P1, P2 incidents

• Change management, Incidents and Task are managed by Service Now

• Performing day-day DBA task like cloning, Database releases, Sox compliance …etc British Petroleum June 2012 – Feb 2015

Sr.Principal Infrastructure Engineer

• Implemented 4-Node SQL Server 2012 Always-On high availability group on Windows 2012 fail over cluster service including Clustering and reporting server

• Administered and maintained Production/UAT/DEV/Deployment environment for Windows servers, SQL servers.

• Setup and implemented backup/restore policy on database production servers.

• Scripted daily/weekly/Monthly automated maintenance jobs, shrink database log files, rebuild/reorganize indexes (indexes defragmentation), archive\clean up large tables.

• Configured database mail and stored procedure to send alerts to monitor database health.

• Traced SQL blocks and deadlocks to analyze the root cause of blocks and deadlocks issues.

• Checking health of database including system and database statistics

• Imported/ exported data on SQL server by SSIS and T-SQL scripts

• Backup and restore, data migration, code promotion among production servers, deployment servers, R&D servers, and QA servers.

Vodafone Aug 2011 – May 2012

Datacenter Specialist

• Leading the ISEC department for keeping all non-compliances for databases in check in accordance with ISEC policies.

• Performing S A & D for database migration, server activations / de-activations, etc.

• Leading the team dealing backup, Recovery / creation / dropping users on databases, and ensuring that the activity is carried out in a complaint manner.

• Planning the application of CPU patches on all databases in accordance with the compliance policy of N-1 patch.

• Role of Dispatcher for DBA pool. Dispatching tickets in accordance with the rules and regulations laid down by GDF

• Implementing Global Delivery Framework on the site. 247 Real Media and iCrossing SEP 2006 – Aug 2011

Assistant Manager

• Managing database sizes ranging from 50 GB to 27 TB. Databases are on diverse platforms such as Solaris, AIX, HP-UX, Linux, and Windows.

• Administration and Support provided for Informix databases

• Configuration of new databases including RAC and DR

• Migration of database, Database cloning and Applying database patches

• Handling Sev 1 and Sev 2 issues.

• Handling backup using RMAN and Export

• Test Recovery of databases and Refreshes whenever required

• Bulk data loading using tools like SQL Loader and informatica

• Handling RAC databases, patching of RAC and non-RAC databases.

• Handling performance issues.

• Data purging and table, indexes defragmentation

• Upgrading database from 10g to 11g

• Maintaining failover using vcs

Double-click /Google March 2005 – SEP 2006

Database Administrator

• Part of custom report team for implementing SQL reports as per client requirement

• SQL Statement Tuning by using appropriate Optimizer Mode

• Working on data warehouse for Generating Reports for the client using optimized methods

• Planning and implementing new functionality in the database as per Application requirement taking care of database Integrity.

• Scheduling reports to execute on defined timings

• Provide costing to clients based on complexity of the reports NextStep Infotech May 2003 – March 2005

Database Administrator

• Monitored Oracle 8i Release 8.1.7 and Oracle 9i Release 2 (9.2.0.1)

• Maintenance of databases of 119GB and 286GB each in 24*7*365 environment.

• Export and Import Activity for performing builds on test environments.

• Analyzing tables and Indexes on regular predefined intervals.

• Maintenance of primary database storage structures and primary objects, managing undo/rollback segments

• Using Configured scripts to automate database changes and maintenance

• Planning and implementing backup / recovery procedures of database

• Managing users, maintaining systems security, controlling, and monitoring database access

• Worked with development to implement release updates on production environments

• Solving Developer’s problems related with Database

• Created user guides, test case and user documentation Education

University of Pune India 2002

Bachelor of Computer Science

Contact this candidate