| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Tel: PHONE NUMBER AVAILABLE
email: EMAIL AVAILABLE
Objective
To join a prestigious organization as a Sr. Database / Application Administrator, and participate in the success and development of the company through the use of Information Technology and cutting-edge methodologies and practices.
Career Profile
10+ years experience as an Oracle Database Administrator, 5+ Years Oracle application DBA, Also SQL Server (5 years).
Personal Skills
Creative programming skills and problem analysis
Fast learning
High productivity
Hard working
Self management
Technical Expertise
Oracle 12c, 11g,10g, 9i, 8i (10+ Years).
Oracle 11gr2 upgrade, implement scan technology.
12c, 11g, 10G Grid control and Oracle RAC in Linux Redhat AS v.4
Oracle streams, Oracle weblogic server 12c
Oracle Resource Manager
RMAN scripting
Oracle RAC 10g and ASM, ASMFS
SQL Server 7, 2000, 2005, 2008 (5 Years)
Java, ASP and Dot Net frame work
Tivoli TSM (4 year) & Backup exec (2 years).
Unix AIX 5L (3 year),
Sun Solaris 8, 9 and 10 (2 year).
HP UX 11 (5 year)
Sun fire 6800 and Sun SPARC HW.
Oracle Fusion and Oracle data integrator.
Install and configure RAC with four nodes.
SQL Plus, PL SQL (4 Year).
Oracle Enterprise Manager, Schema Manager, Security Manager (2.5 Year).
Supporting DB2 and UDB (6 month)
ITIL knowledge from the government contract, ITIL processes including Problem and Change Management, and Configuration and Release Management
Windows SharePoint, Lotus Domino, IIS.
PeopleSoft (2 year)
Working Experience with SQL server versions 6.5,7.0,2000.
MySQL Installation and Administration version 5.x
Set-up cluster servers to provide high availability for customers, AA (Active-Active model), AP (Active passive model).
Work Experience
Baptist Health South Florida November 2015- Current
Sr, Oracle (80%), SQL Server DBA (20%) Consultant
Systems supported.
1 PeopleSoft
2 DWH system (8T)
3 Horizon Lab
Main role and responsibility:
Oracle
Work with the PS Admin team to upgrade the PS environment from people tools 8.5 to People tools 9.2. This involves move to a new powerful HW, reduce the clustering nodes from 3 to 2 one node evicted
Install and configure Oracle RAC and ASM and GI.
Upgrade Oracle Grid control from 11g to 12C
Install Data Masking plug-in to satisfy audit requirements for non prod copies of production
Build shell scripts to refresh 10 non prod databases nightly from prod backup
Install and upgrade to Oracle 11gr2 upgrade, patch set 3.
Work on a POC project for evaluating an enterprise backup strategy, some of the products involved on the POC (DDBoost, CommVault, Avamar etc )
Migrate ASM disk to bigger LUNs to reduce disk numbers on a disk group.
Install quarterly PSU patches on all eligible systems
Work with the ETL developers to fix performance issues in DWH system
Implemented flash back option in the DB for faster recovery between patches
Implemented Oracle fine grain auditing to pass auditing
SQL Server
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Expertise in T-SQL writing stored procedures, triggers and functions.
Worked with developers to tune the SQL queries using SQL Profiler.
Worked with Star Schema, Cubes and Analytical services.
JM Family (P2P Staffing) September 2014- November 2015
Sr, Oracle (80%), SQL Server DBA (20%) Consultant
Systems supported.
1 PeopleSoft
2 Inventory and allocation database
3 IR databases
Main role and responsibility:
Oracle
Install and upgrade to Oracle 11gr2 upgrade, patch set 3.
Build 3 node RAC and implement SCAN technology, and DNS registration
Most of our systems use ASM storage
Install quarterly Oracle PSU patch
Install and configure Oracle RAC and ASM and GI
Install and implement the production server on Linux platform
Work with Development team to write SP, functions, packages that holds business rules
Upgrade Grid Control 10.2 to Cloud control 12cR1.
Install and configure Oracle physical stand by for 11gr2 for every production system
Install and configure logical standby databases to allow for business reporting
Build and configured ASMFS on RAC 11gr2 for non database files
Implement Database custom monitoring scripts and block defection mechanism
Work closely with ETL developers to enhance their ETL load by integrating stats and histogram statistics for better execution plan
Implement database cashing for lookup tables
Implement flash back on most databases for PeopleSoft bundle install
Setup Grid control monitoring Template for different environments based on different thresholds. And setup alert mechanism for various each severities
Implement a demo ODI work flow as an alternative to ETL work flow for bench marking
SQL Server
Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
Implementing stand by servers and Log shipping.
Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and AAG.
New HORIZON September 2011- September 2014
Sr, Oracle (70%), SQL Server DBA (30%) Consultant
Security clearance level 1
Systems supported.
1 Nuclear applications, timesheet application and custom apps
2 Oracle Fusion and Oracle data integrator
3 SAP farm
4 - ERP SAP systems and Passport
5 BI database for Bruce Power
Main role and responsibility:
Oracle
Upgrade Grid Control 10.2 to Cloud control 11cR2.
Monitor Oracle and web logic servers using Oracle Cloud and setup rules to send alerts for 24/7 support.
Experience in Data warehousing concepts such as dimensional modeling, Star Schema and snowflake schema, galaxy schema, Data marts, Dimensions and facts identification.
Experience in writing the Technical Design Document
Oracle OWB, ODI and OBIEE
Install and configure Oracle fusion and Oracle data integrator
Modify existing ETL jobs in Oracle Data Integrator (ODI).
Develop data extracts from the data warehouse environment using ODI
Creating schedulers in OBIEE using ibots.
Performance tuning in OBIEE repository level and reporting level.
Install and support Oracle web logic server 12c and 11g.
Migrate 4 NUC databases across platforms from Solaris to AIX using RMAN
Build and configured ASMFS on RAC 11gr2 for non database files
Implement Database custom monitoring scripts and block defection mechanism
Experience in development of Data Warehousing and Business intelligence solutions.
Experience on Oracle Warehouse Builder 11g R2
Experience in Oracle Discoverer (Administration, Desktop)
Having good knowledge on data modeling tool (Erwin).
Excellent problem solving skills with strong technical knowledge, good communication, and interpersonal skills.
SQL Server
Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
Expertise in T-SQL writing stored procedures, triggers and functions.
Worked with developers to tune the SQL queries using SQL Profiler.
Worked with Star Schema, Cubes and Analytical services.
Provided 7 x 24 Production support for the database and application issues.
Knowledge of Analysis Services & Reporting Services, SQL Server Clustering and Log Shipping
Experience on 64 bit SQL Server 2012 / SQL Server 2008 R2 systems and MSCS Configurations
Scotia-Bank September 2010 September 2011
Sr, Oracle (70%). SQL Server (30%) DBA Consultant
Systems supported.
1 Energy
2 Wall street
Main role and responsibility:
Oracle
Oracle 11gr2 upgrade, implement scan technology in 3 node RAC.
Implement IPMP Oracle 11gr2 patches.
Debug node eject from the cluster and implement Oracle patch to fix the eject problem on SunOS version 10. ASM does not have this issue.
Install and implement Oracle GRID, Oracle physical stand by for 11gr2
Install and implement Oracle Net-backup module for Oracle to backup ASM FRA backups to tape
Write shell scripts to check backup log files and send severity 1,2 and 3 alerts.
Install and configure Oracle SCM/ERP
Tune and configure large SGA configuration 18GIG SGA size
Build 2 RAC clusters two node each with data guard configuration for DR
Installed and configured 2 node ASM RAC.
Build and configured ASMFS on RAC 11gr2 for non database files
SQL Server
Have good experience with partitioned schemas, partitioned tables and indexes, creating Filegroups using SQL Server 20005.
Good experience with SQL Server 2005 online Indexing and Recoveries features.
Experience in migrating packages from DTS to SSIS
Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases: MySQL
MySQL
Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
Effectively configured MySQL Replication as part of HA solution
HIROC April 2010 August 2010
Write shell scripts to check backup log files and send severity 1,2 and 3 alerts.
Write stored procedures, packages, functions for some business reports and dash board.
Wrote web based application using Java and ASP with SQL server engine. The app is for medical research. Demo link can be shared when needed
Implement OS authentication for ETL tools.
Develop data extracts from the data warehouse environment using ODI
Experience in Data warehousing concepts such as dimensional modeling, Star Schema and snowflake schema, galaxy schema, Data marts, Dimensions and facts identification.
Experience in writing the Technical Design Document
Tune and configure large SGA configuration 18GIG SGA size
Build and configured GRID Control server and monitoring template
Build and configured data guard and perform switch over test
Implement RMAN backup scripts to DISK and tape
Setup SQL Server mirroring and cluster service for SQL Server 2005
Migrate databases from SQL server 2000 and 2005 to 2008
We used ER-Win to create data Model for our WH database, different process follows as well as gather reporting requirements
Direct Energy Jan 2008 March 2010
Sr, Oracle, SQL Server DBA
Systems supported.
1 SAP ECC 5.0, Upgrade
2 PeopleSoft version 8.5 in UDB and Oracle
2 Clarify CRM system tuning
3 Allegro trading system 500GIG OLTP application
4 DWH (Data warehouse) 2.3TB
8- Install and Implement 10G Grid control
Main role and responsibility:
Oracle 11gr2 upgrade, implement scan technology.
Design and implement RAC ASM database, physical and logical dataguard system for OLTP database.
Implement and design failover and switch over systems
Implement and design flashback system on a physical dataguard database to accommodate business reporting needs
Implement and tune large OLTP application with a reporting component to it using RAC and streams.
Upgrade Oracle 10g RAC to 11g release 1 RAC
Install and implement resource manager in SAP, PS and Clarify database
Install and implement table cashing mechanism keep pool on Clarify
Adjust Kernel parameters to accommodate large SGA (18GIG).
Tune and configure large SGA configuration 18GIG SGA size
Configure RMAN repository for Clarify and SAP system.
Install and upgrade 10g to 11g database
Write and impalement PL/SQL procedure to create and split partitions on the fly before batch processing in DWH system
We used ER-Win to create data Model for our WH database, different process follows as well as gather reporting requirements
Migrate PeopleSoft database from UDB to Oracle
SQL Server
We used ER-Win to create data Model for our WH database, different process follows as well as gather reporting requirements
Involved in installation and configuration of SQL server 2000.
Applied patches and service packs to keep the database at current patch level.
Responsible for configuration of Microsoft Server/Client Products and implementation.
Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
Involved in Analysis and Design Documentation, User requirements and maintained good documentation.
Designed and implement database logical and physical Schemas using Erwin 3.5.2./4.0
Created DTS packages to maintain central repository. Extensively used different SQL2000 DTS tasks.
Hewlett-Packard July 2007- Dec-2007
Sr, Oracle DBA Consultant
Systems supported.
SAP Systems
-ECC 5.0
-BI7.0
-SRM-MDM 1.0
-EP 7.0
Main role and responsibility:
Install and Configure Oracle RAC in two to four node RAC system using ASM and CRS.
Install and Implement RMAN backup scripts to backup recovery area FRA to tape and set conditions to run right after backups.
Install the configure Oracle streams to move data across systems for business reporting
Install and configure RMAN to backup the RAC system and refresh the reporting system every night
Install and configure Grid Control to monitor RAC systems and setup and alerts and thresholds.
Configure grid Control to send alerts to BMC Patrol and open remedy tickets to be assigned to the appropriate group.
Create and Configure Oracle DataGuard for the SAP RAC system.
Design and implement Migration strategy scripts to move data from Plano TX to Toronto.
Install and Configure BMC patrol to monitor databases and send alerts based on pre-set thresholds.
Adjust Kernel parameters to accommodate large SGA (12GIG).
General maintenance tasks (i.e. rebalance ASM disk after loads, resize tablespaces, etc .)
Configure Load Balance advisory goals based on transaction types
Direct Energy March 2005 to June 2007
Sr, Oracle DBA
Systems supported.
1 SAP ECC 5.0, BW 3.5
2 Clarify CRM system
3 GERS billing system
4 DWH (Data warehouse) 2.3TB
5 PeopleSoft version 7, 8 on UDB version 7
6- Peace upgrade from 6.1 to 8.03 10G Grid control
7- Install and Implement 10G Grid control
Main role and responsibility:
Install and upgrade Oracle on main client management system Clarify from Oracle version 8.0.6 to 10.2.0.2.
Build and design UNIX server s layout in accordance to OFA.
Migrate backup systems from SQLBACK tracks to RMAN central repository.
Build a home grown UNIX tool RMF (RMAN management facility) to backup any oracle database (8, 8i, 9i,10g) based on a parameter file that has all the client requirements
Backup destination (disk or NetBackup)
Number of generations
Archive destination check frequency
Archive log threshold
Rman resync frequency
Catalog location(s).
Design and test DRP strategy for major systems using EMC SRDF technology.
Design and implement Oracle security measures to insure secure DB links.
Design and implement central Oracle stats-pack gather tool for all major systems.
Design and implement resource management scripts to limit the DB resources for some reporting tools and adhoc users.
Develop / implement Archive backup and recover methodology, maintain archived data on tape / backup devices.
Backup and restore the database, develop, test & perform disaster recovery plans.
Design and develop RMAN NetBackup scripts.
Setup and design a standby database using 8i managed recovery and Logical standby database via Data Guard.
Adjust Kernel parameters to accommodate large SGA (12GIG).
Install and Configure Oracle 9i RAC in Linux Red-Hat for a financial document repository application. Also, install and configure RMAN to backup this RAC environment.
Install and Configure Oracle streams for business reporting.
Implement table cashing jobs to improve database and application performance (Keep pool), and adjust necessary latches.
Implement Oracle Resource Manager to prioritize database resources across multiple interfaces.
TD Bank April 2002- March 2005
Sr, Oracle / SQL Server DBA
Systems supported.
1 AP application Oracle financial 11i
2 Siebel application
3 Wealth management application (XEYE)
4 Capstone Credit application and Capstone DWH 24k hits / week . serving 225K customers in Ontario alone
Main role and responsibility:
Install and upgrade Oracle financial from Oracle 7.3.3 to 8.1.7 to 9.2.0 application level 11i
Financial Data Repository, Payment Inquiry Application, as well as Oracle forms and Reports
Database physical and logical design for a DWH .system.
Build and design Central RMAN database for the TD systems.
Install the configuring OEM for 24 *7 monitoring for all databases.
Configure SMTP and paging services for OEM.
Develop / implement Archive backup and recover methodology, maintain archived data on tape / backup devices.
Develop RMAN repository database to backing up 16 different instances with three types of catalogs (8.0.6, 8.1.7 and 9.2.0) catalogs.
Design and develop RMAN Tivoli backup scripts.
Install and configure TSM client.
Setup and design a standby database using 8i managed recovery and Logical standby database via Data Guard.
Adjust some Kernel parameters to accommodate large SGA size (ex: SHMMAX, vxio:vol_maxio, maxphys)
Install STATSPACK and analyze output reports for performance enhancement.
Deal with Oracle data block corruption and monitor block corruption with STATSPACK.
Negotiate Oracle license with Oracle Corporation sales rep. for different Bank platforms (Production, user acceptance test, development and disaster recovery).
Install and configure RAC, AIX HACMP/ES for capstone HA servers
Install and configure Database redo logs in raw devices for high performance.
Database average size 200GIG to 1.5 Tera-bytes.
-Install and configure 10g in Linux machine for a POC.
-Install and configure SQL Server 7 and 2000 Server.
-Manage SQL Server security profiles.
-Implement and configure SQL Server log shipping.
-Implement and configure SQL Server transactional replication.
-Performance tuning SQL statement for SQL server DB(s)
-Implement and maintained log shipping for SQL Server DR solutions.
-Installed and configured MySQL on Linux and Windows environments.
-Managing/Troubleshooting MySQL 5.0.22 and 5.1.24 in production and developer environments on Linux (5.0, 5.1)
Ministry of Solicitor General. Jan 2001 April 2002
Lead Oracle / SQL server DBA
Systems supported:
1 - Police 911 systems on 34 municipals police agencies 24/7 mission critical (Oracle).
2 - Police Record management system mission critical (SQL server).
3 Correction offender tracking system mission critical (Oracle).
4 - Courts record audio system 8am to 6pm not mission critical (Oracle).
5 - ITIL processes including Problem and Change Management, and Configuration and Release Management
Main role and responsibility,
Install / Upgrade the Oracle Server and application tools. Configure oracle database engine.
Creation of ongoing monitoring of the Databases to pro-actively manage the databases.
Logical and physical design and data modeling using ER-WIN.
Allocate system storage and plan for future storage requirements for the database system
Develop data models, normalize create primary database storage structures (tablespaces).
Create primary database objects (tables, views, indexes, synonyms).
Develop stored procedures, database triggers, different PL/SQL scripts for various functions.
Modify the database structure, as needed, from information supplied by application developers.
Enroll users and maintain system security, users access restrictions and profiles.
Ensure compliance with oracle license agreement.
Control and monitor user access to the database, optimize & tune the database performance.
Develop / implement Archive backup and recover methodology, maintain archived data on tape / backup devices.
Backup and restore the database, develop, test & perform disaster recovery plans.
Develop RMAN repository database for backing up 5 different instances with 8.0.6 & 8.1.6 catalogs.
Design backup strategies for other justice system using cold and hot backups scripts.
Manage databases on multi data management systems and move data between RDBMS.
Ensuring smooth flow of data between databases, application interfaces and network.
Contact Oracle Corporation for technical support.
Develop / Implement data security strategies, capacity planning.
Develop and performing data model as well as system architecture presentation for project group / management.
Apply application patches and develop back out procedures.
Participate in the root cause analysis for production issues, and performance issues.
Configure and maintain the 911 system for police, HA (cluster environment)
On call Support the police 911 systems 7 * 24 and other Integrated Justice databases. I have got OPTIC security clearance for that level of support.
Develop and Execute a DRP (disaster recovery project) for the Police application at IBM facility.
SQL server.
Install / Upgrade the SQL Server and application tools. Configure SQL server database engine.
Creation of ongoing monitoring of the Databases to pro-actively manage the databases.
Logical and physical design and data modeling using ER-WIN.
Develop stored procedures, database triggers, different T-SQL scripts for various functions.
Setup and configure SMTP server and setup database events to proactively monitor the SQL server databases 24 / 7.
Setup and Install cluster server to high availability systems.
Colliers International March 1999 DEC 2000
DBA Oracle / SQL Server.
Maintaining 15 servers across Canada and USA with three different databases.
Install and configure Oracle and SQL server database servers.
Planning and implementing the backup and recovery strategy.
Setup and configure EM for monitoring the databases
Allocate primary storage and planning future storage requirements.
Setup multi-master site replication for the development environment.
Create tables (Fields Primary Key Foreign Key Unique Constraints)
Manage table spaces and data files.
Backup / Restore (On tape Parallel Striped Backup Multi disk backup)
Create stored procedures, trigger and indexes
Import, export and distribute data
Monitor and fine tune databases
Set up and configure replication
Database modeling and logical design using ER-Win.
Wrote Visual Basic program to extract information from firewall and print a web usage report either by site or by department using ADO 2.1 object and DAO 3.6 object
NCR Oct 1997 To Jan. 1999
VB-Developer DBA Oracle / SQL Server.
NCR International Company is one of the largest computer software developers and distributors in the Middle East and in the entire world. NCR Software specializes in the Arabization and other languages of computer technology and new development for there Retail System (Back office, Front Office) with new technology using Visual basic and Oracle Client Server Architecture, Three-Tier Applications using Windows NT Network MSDN (Microsoft development network) and banking applications.
Programming Languages:
Data Engine, Microsoft Visual Basic, OLE, RDO, DAO, Oracle, SQL Server, Crystal Reports
ODBC, Three-Tier Applications
Install and configure Oracle databases.
Creating tables (Fields Primary Keys Foreign Keys Unique Constrains sequences - packages)
Backup/Restore (On tape Parallel Striped Backup Multi disk backup)
Create stored procedures, trigger and indexes
Secondary Role: VB Programmer
Senior programmer that was responsible for the development of a cheque printing system
Design and implement our library in DLLs.
General design and time plans of the system modules
Wrote Visual Basic code under NT and Win95 using Visual Basic 5 and 6.
Implement clients extra requirements
Lead a team of Programmer/Analysts in writing divide code to some classes and DLLs functions to be easily to modified
Also, as team member, responsible for the development of the back office
Write General Ledger module and Payroll module running on Windows 95 as client
And database on Oracle using Visual Basic 5.
Create the installation program and establish the test protocol.
Create the installation procedure on the client side.
Programming using Visual Basic skills
Visual Basic ver. 3, 4, 5 and 6 both under NT and 95.
Active X controls, RDO, DAO, OLE
Crystal Report for professional reports
ODBC drivers
Made Visual Basic classes and DLLs.
Develop under Client-Server architecture
Other skills
Develop under Windows NT Server and workstation
Using MS Access, build in Macro s and Query s and fire it from Visual Basic
Good knowledge of Visual C++
Cegelic CGA Co. June 1995 to Oct. 1997
Junior SQL server and Oracle programmer
Programming languages:
Data Engine, Power Builder, Access and Visual Basic Oracle.
Develop applications for under ground Metro (Subway)
Database application to store each transaction on gates and TOM (Ticket Office Machine) by Access, SQL, Crystal Reports and Visual Basic.
Responsible for sending data files from the mainframe to terminals using serial transmission (by Turbo C)
Design the backup strategy for the SQL server and Oracle databases.
Education
B.Sc,
Ain-Shams University July 1995
Faculty of Engineering
Communication and Computer Science
Additional courses
Oracle RAC @ Oracle University March 2002
People Soft data upgrade ver(8) Dec. 2000
People Soft Database Management tools Sep. 2000
People Soft Tools I Aug. 2000
Visual basic Client Server programming course, Microsoft August 1997
SQL Server administration and implementation, Microsoft Oct. 1997
Windows NT4 administration, NCR. Sept. 1997 |
