Lead Database Administrator
Resume:
**** ****** *** ***** *******@*****.***
Mississauga, #647-***-****
L5M 3N8
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 to 12c, Exadata, Exalogic, Golden gate, Sqlserver 2008, 2012
Process - ITIL, Agile, Remedy, Service Now, HP openview
Cloud - Amazon AWS, TOGAF
OS - Solaris 11 (Zfs, Zones), RHEL, AIX, HP-UX, Windows
Tools - TOAD, Sql Developer, Erwin, Nagios, Control_M, ILOM, Exachk, Diagtool,
OSwatcher and EM12c
Scripting – Bash,Perl
PROFESSIONAL EXPERIENCE
TD Bank Feb 2016 – Aug 2016
Database and Schema cloning from Production to Development
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 12c OEM for Grid control for Monitoring
Patching of RAC and non-RAC databases
Change management, Incidents and Task
Implementing application releases
Corning Incorporated Feb 2015 – Jan 2016
Corning has 900 databases with different version from 8i to 11g on Standalone, RAC, Exadata
Managing Exadata Hybrid X2-2,X3-2 and X5-2 on 11g Grid infrastructure setup using ASM
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
Implement exadata best practices
Creating ASM disk group on different section of disk as hot and cold for DATA and FRA using grid disk
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
Using 12c OEM for 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
Database cloning using RMAN DUPLICATE
Backup using BCV,RMAN Tape backup and Export
Maintaining failover of servers using VCS in case of system crash
Checking health of database including system and database statistics
Configured heterogeneous service to use non-oracle databases
Responsible to improve the Server performance and SQL server optimization
Expert in managing SQL SERVER databases on Window environment (2003, 2008, 2012).
Proficiency and Expertise in SQL Server Replication, Log shipping and Mirroring, Backup/Recovery, Disaster recovery and planning.
Data purging and table, indexes defragmentation
Solving severity 1 and 2 tickets including performance issues
Data pump utility for performing builds on test environments.
Maintaining security of database.
Performance monitoring using OSWatcher and AWR reports.
Applying Application releases w.r.t database by following proper procedures
Using Flashback database using guaranteed restore point for application releases
Following ITIL process for change and problem management
Vodafone Aug 2011 – May 2012
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 and 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
Managing databases sizes ranging from 50 GB to 27 TB. Databases are on diverse platforms such as Solaris, AIX, HP-UX, Linux and Windows.
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
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
Part of custom report team for implementing sql reports as per client requirement
SQL Statement Tuning by using appropriate Optimizer Mode
Working on dataware house 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
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