Mohammed A. Aleem, OCP, MCDBA, MCITP

Shrewsbury, MA 01545 E-mail: acekb5@r.postjobfree.com Home Phone#:

508-***-****

OBJECTIVE

Seeking a Senior Oracle DBA position in East Hartford, CT with the

motivation of an Oracle DBA career and being a Connecticut resident as

well.

QUALIFICATIONS

Oracle Certified Professional (10g Administrator with Hands-on Training on

11g) - July 2012

4 years of Oracle DBA experience with 10g (10.2), 11g (11.1 and 11.2) -

2010 to Present

Expert in Data Guard Setup for HA and DR Solutions with more than one

Standby databases

Expert in Setting up TAF (Transparent Application Failover) for Databases

in Data Guard Environment

Skilled in RMAN - Backup job creation/maintenance and database cloning

using DUPLICATE command

5 years of experience working on UNIX environment (IBM AIX 4.3/5L, and

Tru64 Unix at U Mass Lowell)

Microsoft Certified IT Professional (MCITP) for SQL Server 2008 - June 2011

Microsoft Certified Database Administrator (MCDBA) for SQL Server 2000 -

March 2007

A strong academic background with a BS and an MS degree in Computer

Science/Engineering

20 years of professional experience which includes 5 years of teaching CS

at a Public University and -

15 years of IT/IS/System Analysis, ETL Architecting, Database

Administration, and Team Leading

10 years of MSSQL and 4 years of Oracle DBA Production Support Experience

in 24x7 availability environment

Management Experience

Team Lead DBA for 2 years - At MorphoTrust USA, I was hired as the Lead DBA

in NE Zone. A few months after joining, I worked with my manager in hiring

two Senior DBAs to form my team. Have been supervising them directly in

terms of assigning DB support tasks, setting up priorities, helping them

technically or resource-wise to get tasks completed in a timely fashion,

conducting daily Team meetings and writing Weekly Status reports to my

Manager; have also been creating/editing/managing DBA projects like

Production Migrations and Setting up new DEV/QA/UAT Environments; taking

part in Annual Review process providing feedback of team members'

performance to my manager. I have both of an Oracle and an MSSQL DBA in my

team. (May 2012 to Present)

Assistant Director of Information Systems at QCC for 6 months- While on

this position, I performed director's duties at his absence, being part of

IT management, for six months. I managed a group of 3 Systems Analysts

while the Director used to be absent at work; managed the department for a

month while the director was in Europe on a month-long vacation (March 2006

till August 2006)

Tech Lead for SQL Server Development at FCHP for 2.5 years- In the CBAM

project, I had the tech-lead role for 3 SQL Developers/ETL architects whom

I guided and helped technically through the entire period of the project. I

had also led a project, managing resources together to get log shipping

work based on FTP-ed Transaction logs, for development environment Database

refresh. (April 2008 till August 2010)

Management Training: Successfully completed "Manager's Toolbox: Recharged!"

- A two-day training workshop conducted by HR Specialists and Executives of

MorphoTrust USA - August 2013

ORACLE DBA SKILLS

Expert in -

Installing Oracle Instance on Windows Platform (Win 2003/R2 and 2008/R2)

and Linux (Fedora 16)

Setting up Data Guard for HA and DR Solutions, with Data Guard Broker,

Automatic Failover and TAF

Migrating Oracle Databases to higher versions of Oracle on new H/W

platforms using either exp/imp or expdp/impdp utilities

Creating new databases/instances when needed

Duplicating/Cloning Production Database to Non-Production Instances using

either RMAN Restore or 11g DUPLICATE Command Syntax

Managing RMAN Backups with scripts being executed from Windows Scheduled

Tasks; Managing Retention Policy, Backing up, Deleting and Crosschecking

Archive Logs following the Retention Policy

Managing Tablespaces for regular and Partitioned Tablespaces; adding data

files regularly to keep pace with database growth without outage;

Monitoring Tablespace usage by Up.time Service Monitors every hour

Managing OneNode RAC instances and Configuring/Relocating SCAN Listeners on

AIX over RS/6000

Optimizing databases by Rebuilding Indexes and Computing Stats, using a

Dynamic SQL generating ALTER INDEX and RECOMPUTE STATISTICS

Reconfiguring SGA Parameters, adding/moving control/archive log files,

extending DB_FILES parameter

SQL SERVER SKILLS

Expert in -

. Installing/Configuring, Upgrading/Migrating, and Tuning SQL Server 2000,

2005, 2008/R2, and 2012 Instances/Databases on Windows 2003/R3, 2008/R2

and 2012

. Installing, Configuring and Managing SQL 2005/2008/2012 Failover Clusters

for High Data Availability and SQL 2012 AlwaysOn High Availability Group

and HAG Listeners for HA+DR Solutions

. Using Failover Cluster Manager for SQL Cluster Administration

Functionalities

. Configuring SSRS (with and without IIS), Developing/Deploying of SSRS

Reports through Visual Studio

. Implementing Transactional Replication (for Reporting Servers) and Log

Shipping for a Standby Server/Reporting Server with Read-Only mode

. Implementing Database Mirroring in SQL 2005/2008 and Managing/Maintaining

. Using EM/SSMS, DBCC Commands, and Configuration Manager (SSCM) for DBA

functionalities

. Using Performance Monitoring Tools: SQL Alerts, Activity Monitor, SQL

Profiler, Dynamic Management Views, Performance Monitor/Resource Monitor

Counters and Third-Party tools, like Up.time

. Analyzing Query Performance using Estimated/Actual Execution Plans,

DTA/Workload file, and DMVs

. Tuning Query Performance by taking appropriate measures like, adding

necessary Indexes, Optimizing Databases performing Index

Rebuild/Reorganization and Update Statistics through Weekly Agent Jobs

. Developing/Migrating and Deploying DTS/SSIS Packages using BI

Studio/Integration Services

. Writing T-SQL Scripts, Creating/Altering Stored Procedures, UDF, and

Database Triggers

. Architecting and Implementing Database Backup/Restore, Recovery

Procedures and Agent Jobs with Schedule

. Working with Sr. Managers/Directors of other functional groups,

OS/Networking and Application Support

PROFESSIONAL EXPERIENCE

MorphoTrust USA (a subsidiary of SAFRAN)

Lead SQL DBA (with Oracle responsibilities) - May 2012 to Present

Supporting/managing SQL Server (2005, 2008/R2) and Oracle(10g, 11g R2)

database servers for 24x7 availability; Troubleshooting, monitoring and

fixing performance issues; new implementations/installations of SQL or

Oracle engines/instances; delivering database artifacts related to

security & investigations to State and Federal agencies like RMV, DMV and

County Sheriff's offices. Along with hands-on DBA work, I have been

supervising a Sr. SQL DBA and a Sr. Oracle DBA in the team, myself being

the Team Lead.

Oracle Responsibilities: Have been the Primary Support Oracle DBA for the

State of NJ MVC, RI DMV and SIMS (Secured Inventory Management System) used

by 9 States, performing day to day DBA functionalities.

Installation/Migration/Upgrade Projects Performed:

Migrated SIMS Production Oracle database from 10.2 to 11g R2 (11.2.0.3.0)

to a new HW platform, using exp/imp. Setup Data Guard to a Standby Server,

and configured Data Guard Broker Interface (DGMGRL); successfully performed

a Failover, with Apps working smoothly Database on Standby Server(Jan 2014)

Helped Oracle DBAs assigned to the state of IL in a similar Oracle

migration project. I worked on setting up an Active Data Guard on a test

environment and then documented the whole process which was then followed

by the DBA team.(Fall 2012)

Created a Test environment for WI DMV, taking a metadata export from the

Production database and setting up a new database on a VM on MorphoTrust

domain; fixed public synonyms after the import for applications to work

correctly (March 2013)

Fixed SCAN Listener issues RAC One Node Database of State of NJ where a

wrong Setup was making SCAN Listeners not registering Database Services

after a Failover (December 2013)

Fixed the Archive Log Backup Issue of the CIS Database where a target

location on a USB drive was the cause of the failure; found it by analyzing

the logs and contacting Oracle Support Engineers.

Did many new Installations of Oracle 11gR2 on both of Windows 2003/2008 64-

bit, Windows XP/7 (32-bit) and Linux environments.(x86 based Fedora 16)

American Tower Corporation (ATC - NYSE: AMT), Southborough, MA

6/2011 to 5/2012

SQL DBA (on a senior role)

Have been performing the responsibilities of a Senior Production System

DBA, including but not limited to supporting Windows Servers (Physical and

VMWare) housing SQL Instances; Managing users, SQL Backup and Recovery,

SQL deployments, Monitoring and Fixing Performance Issues, Enhancing

existing SQL Instances and installing new ones as needed/requested;

Performing database migrations and upgrade of SQL versions to recent

levels; have implemented Database Mirroring for Mission critical databases

as an High Availability Solution.

On an added role, I have been administering IBM Cognos 8.4.1 Gateway and

App Servers for Content management along with the management of Content

Store database, users' security, content deployments, exports/imports.

Specialized Technology Resources, Inc (STR), Enfield CT 8/2010 to

6/2011

Senior Production Support DBA

Have been administering production SQL environment and resolving issues

with all enterprise databases on clustered (Active/Passive) and stand-alone

instances, with a few 0.5 TB in size. STR is a global company and users of

the databases are spread over the world including EU and China and

databases are actively being accessed round the clock. I have been taking

care of user/security management, database backup and recovery, job setup

and monitoring, performance monitoring; installing and configuring SQL 2008

R2, and upgrading 2005 to 2008.

Also, have worked as a backup Oracle (10.2) DBA for Oracle Financial

Systems.

Fallon Community Health Plan(FCHP), Worcester, MA 4/2008 to

8/2010

Senior SQL Developer/Architect with Non-Production DBA role

. Architected the ETL processes for CBAM Project (Core Business

Applications Modernization)

. Developed SSIS packages (75+, some of them are complex) for the above ETL

Processes

. Managed/maintained QNXT Plandata and QNXT custom databases for 50

developers

. Promoted SSIS Packages developed by myself and other developers to TEST

and QA Servers

. Developed stored procedures(100+) and other SQL objects to be used with

above SSIS packages

. Helped fellow SQL developers with technical guidance, solving problems

in T-SQL and SSIS, effectively working as a Tech Lead of the SQL

Developers' Team

Plymouth Rock Assurance Corporation, 695 Atlantic Ave, Boston 11/2007 to

4/2008

Senior SQL DBA

Managed, maintained, and enhanced SQL Server 2000/2005 Instances for

Production and DEV/QA Servers on a Clustered and Replicated Environment

with 24/7 uptime of the databases; performing SQL Production deployments

from developers, and application team, approved by management(Change

Control Management). Have managed more than 50 SQL instances, both stand-

alone and clustered instances; upgraded to SQL Server 2005 on a planned

basis.

Public Consulting Group, Inc. 148 State Street, Boston 6/2007

to 11/2007

Senior Database Administrator

Performed the following DBA functionalities on a regular basis:

Creating/updating/modifying the Maintenance Plans for database

backups/optimization tasks on standalone and cluster nodes; executing SQL

Profiler Trace(s) and Performance Monitor with appropriate counters to

diagnose SQL performance/slowness/blocking problems; configuring Red-Gate's

SQL backup Jobs to work efficiently for almost 2000 databases on the

cluster nodes; moving databases to AT&T datacenter servers for better

performance, maintaining the cluster nodes(N+1 Active/Active) with

installing/updating security patches, adding/removing cluster nodes,

failing over and failing back to perform the maintenance work;

creating/setting user privileges to facilitate application access under the

security policy of the company; fixing the database and transaction log

backup problems as they arise; installing and configuring new SQL Server

2005 instances on new in test/stage environments.

EMC Corporation (Microsoft Practice Group) 8/2006 to

6/2007

Consultant SQL Server DBA/Developer

Projects completed at EMC Client Sites:

. TrendWatcher SSIS Project at Enterasys Networks, Andover, MA (April-June,

2007)

Architected an ETL process that extracts data from SAP databases and loads

into the Reporting SQL Server(s); developed a number of SSIS packages to

accomplish the task, replacing all T-SQL Scheduled Jobs used so far;

converted a good number of DTS packages to SSIS, some containing ActiveX

Scripts.

. DIA SQL Migration Project, Denver Colorado (March, 2007) - Migrations of

SQL Databases to a new clustered environment, implemented with a newer

EMC SAN device.

. DoCoMo USA Labs, San Francisco California (March, 2007) - SQL In-place

Upgrade of SQL 2000 instances to SQL 2005; performed using remote login

to servers. Used Upgrade Advisor for problems/resolutions.

. SAN Data Recovery Project at New York Life AARP, Tampa Florida(December

2006)- A data migration/data recovery project to recover 4-day worth of

missing data from an old SAN storage device that stored SQL Server 2000

databases

. SQL Assistance Project - a SQL Developer role

10-week long project at Fallon Community Health Plan HQ at 10 Chestnut St,

Worcester, MA where I have re-written and/or fixed bugs in a number of

stored procedures and user defined functions in the Customer Service

database of the organization, tested those on the Test and Staging by users

and finally promoted to the Production Server; took part in the deployment

of a new release of Customer Service web application for SQL objects part.

Quinsigamond Community College(QCC), Worcester, MA 11/2001 to

08/2006

Systems Analyst Programmer/Assistant Director of Information Systems

Implemented and then managed/maintained QCC Datamart - a SQL Server 2000

based Data Warehouse database, integrated with Cognos tools for OLAP Cubes

and Reports.

On a regular basis, I have worked with Informix RDBMS to maintain, upgrade,

and enhance database application (Jenzabar CX) as required; performing

system level administrations to maintain the AIX file system growth and

file system cleaning; monitoring and tuning system performance; performing

backup and recovery; creating users accounts and setting their privileges;

creating spooler devices on the AIX system to be used with the Jenzabar CX.

Also, have been handling the help desk calls from Jenzabar CX and Cognos

users around the QCC campus, including faculty and staff members. This has

been helping the user community to get their problems solved and encourage

using the database application effectively. After 4 years of service, I was

promoted to be the Assistant Director of Information Systems, where I

performed director's duties at his absence - was part of IT management for

6 months before moving to EMC Corporation.

Access Measurement Systems Inc, Ashland, MA 05/2000 to

10/2001

Database Applications Developer

Have developed the following applications, along with helping application

users with problems/issues:

- A Customer Service database (in Access 97 front-end and SQL Server

7.0 back-end)

- Project Profile: I developed a VB6.0 application using ADODB

connections to SQL Server 7.0 Database

- Data Migration Project: Planned and implemented the migration of the

backend data source of the

organization from Access 97 to SQL Server 7.0 using SQL Server

Import/Export Wizard.

Universal Asset Technologies, Boston, MA 10/1999

to 04/2000

Senior Programmer/Analyst

Developed a) Regulated Management of Waste (RMW) - A database application

for the University of Connecticut Health Center, in Access 97 with fancy

data entry screens, data-editing, archiving facilities, added a

barcode/printer interface to generate barcodes or read them back to the

database. b) Asset Transactions Interface Program (to generate fixed

length ASCII output for database transactions related to an Inventory Item)

in Access 97, for Missouri State Highway Patrol, Jefferson City, MO. Also,

worked with an application development team project for Southern

Connecticut University, used Oracle 7.3 as backend data source.

Rajshahi University, Bangladesh

Assistant Professor of Computer Science Jan 1994 till August

1999

I taught undergraduate students in the Department of Computer Science &

Technology for 5 years before Immigrating to the USA. I taught both of

theoretical and laboratory classes for Programming Languages (FORTRAN77,

Turbo C), Data Structure, Algorithms, and Software Engineering. Rajshahi

University is the second largest Public University of Bangladesh which was

established in the Northern Bangladesh in 1953.

EDUCATION

University of Massachusetts, Lowell, MA 01854

M.S. in Computer Science February 2005

GPA: 3.3

University of Engineering & Technology, Dhaka, Bangladesh

B.S. in Computer Science & Engineering November 1993

GPA: 3.9

SALARY REQ: $130k - $140k/yr, health benefits and 401k matching

VISA/Citizenship: U.S. Citizen

Contact this candidate