Sql Server Visual Basic

Michael Alexan

Tel: 754-***-****

email: ***************@*****.***

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

Contact this candidate