Brenda A. Mujahid
4313 Rose Glen Place
Midlothian, VA 23112
[Send email to request phone number] 47-5680 (cell)
CORE COMPETENCIES
Oracle 10g Enterprise Edition, OEM Grid Control RAC, Oracle 9i (9.2.0.4), 8i
(8.1.7, 8.1.6, 8.1.5); 8.0 (8.0.5), 7.0 (7.3.4); Oracle Enterprise Manager
9.2.0.4; Schema Design / Maintenance; Oracle PL/SQL and Utilities (SQL Loader,
LSNRCTL, NAMESCTL, NetConfiguration Manager),MS SQL Server Enterprise Manager;
HP-UX 11i, Sun OS 5.8, AIX 4.3, Windows XP/NT/2000/98/95; SAS 6.0, Business
Objects 5.1.3, , S-Designer / Power Designer, ErWIN 3.0
WORK EXPERIENCE
Perot Systems@Owens and Minor
03/07 – 06/09
9120 Lockwood Boulevard
Mechanicsville, Virginia 23116
Sr. Oracle Database Administrator
Principal Database Administrator for RAC cluster 10g production application
databases and 9i Decision Support Systems (DSS) data warehouse database
instances. Support database and applications for multiple environments,
including Oracle RAC, ASM (Automatic Storage Management) and Recovery Manager
(RMAN). Maintained and created new logical database partitions in large
distributed databases for EDI interface data to support order processing in
production and development environments. Modified UNIX shell scripts to support
routine database maintenance and ETL. Performed on-call rotation as a member of
the distributed DBA team providing 24/7 support on rotation for all Oracle
databases and SQL Server 2000. Troubleshoot Remedy incidents and complete
assigned request tasks. Complete release management change tickets and impact
assessments. Manage advanced queuing processes as needed at the OS level.
Monitor server resources and resolve database-related resource issues as
appropriate (i.e. SGA parameters, memory segments, NFILE, and dbstartup).
Computer Resource Team@Owens and Minor
12/06 – 03/07
4190 Innslake Drive
Glen Allen, VA 23060
Oracle Database Administrator
Technical lead for Netezza data warehouse appliance proof of concept. Work
closely with Netezza systems engineer to complete offsite installation and
configuration of appliance. Create extraction/transformation routines and load
jobs to capture Oracle data for import into Netezza. Import Oracle Business
Objects repository data into development schema for Netezza report testing. Use
Business Objects Supervisor and Designer to manager Netezza universe definitions
and database connectivity. Install Netezza odbc drivers on Business Objects Web
Intelligence server for connectivity to Netezza database. Develop technical
documentation for review of project milestones and statuses.
McKesson Medical Surgical
12/03 – 07/06
8741 Landmark Road
Richmond, VA 23228
Information Warehouse Database Administrator
Principal Database Administrator/Database Architect for MedSurg Information
Warehouse Infrastructure (IWI) development; backup database administrator for
SHPROD and other MedSurg production server databases. Principal technical
Business Objects liaison for MedSurg/COE activities. Perform schema-level exports
and imports to support application development requirements. Participate in
design review process for the creation of database ERD diagrams and database
schemas. Use Oracle Designer to support development and implementation of IWI
database metadata requirements. Analyze and validate existing application
database table structures in SHTEST/SHPROD as well as other schema metadata for
new IW database design; generate required validation reports and schema diagrams
from data catalog and database objects to support data migration from Oracle
8.1.7.4 database to 9.0.2.4. Create data-specific tablespace work areas with
designated data file storage to minimize disk contention. Set up primary /
foreign key referential integrity to support fact / dimension table look-up and
indexing for real-time OLAP and data mining
IOTA Innovative Technologies, Inc.
07/2003 – 08/2004
8762-B Landmark Road
Richmond, VA 23228
Oracle OCA / OCP Technical Program Manager
Sr. Technical Administrator for Oracle 9i DBA certification training program.
Administer, manage, and develop Oracle 9i certification evening training program
for Oracle 9i certified associate business systems support and certified
professional DBA course training. Develop course syllabus and curriculum;
coordinate class schedules; install and configure all related Oracle 9i software
to include Oracle 9.2.0.1 enterprise database and client in Windows 2000/XP
environment; create all user training accounts and populate training database to
support training activities; utilize Oracle Enterprise Manager, SQL Loader, and
other utilities to manage data and database instances.
Keane Federal Systems, Inc.
07/2002 – 07/2003
Defense Commissary Agency (DeCA)
Ft. Lee, Virginia
Principal Consultant – Oracle Database Administrator
Oracle Database Administrator for Central Human Resource Information System
(CHRIS) production and development HR reporting distributed database environment
for Oracle HR 11i. Manage nightly data transfer migration process from multiple
Oracle database servers in an Oracle 8i/9i HP-UX 11/Win2000 distributed database
environment; locate and abort hung UNIX processes; initiate logical database
shutdown/startup and recovery; perform media recovery and database backup
procedures using RMAN and SVRMGR; resolve program errors and download failures
and initiate download recovery at point of failure; create and maintain Korn and
Bourne shell scripts; modify Perl script file parameters as needed to meet new
download requirements; modify, create and debug PL/SQL packages and procedures;
analyze objects and optimize queries using query optimizer; perform schema and
user management activities to include user and object privilege grants and role
creation; alter database object storage parameters to accommodate changes in
database environment; upload table data with SQL loader script files from
external media; initiate database exports/imports; monitor database alert logs,
archive logs, OS-level processes and other trace and error logs to troubleshoot
failures.
MODIS/Computer Consulting Group
05/2000 – 06/2002
Philip Morris, USA
Quality Systems Integration and Control
Richmond, Virginia
Oracle DBA/Consultant
Design and create Oracle database ERD diagrams and ROLAP/MOLAP star / snowflake
schemas in ErWIN and Oracle Designer to support development and implementation of
QSIC Product Quality Complaint Handling and Evergreen Reporting Systems. Analyze
and validate existing application database table structures and other schema
metadata; generate required validation reports and schema diagrams from data
catalog and database objects to support data migration from Oracle 7.3.4 database
to Oracle 8.1.5/8.1.6. Create data-specific tablespace work areas with designated
data file storage to minimize disk contention. Set up primary / foreign key
referential integrity to support fact / dimension table look-up and indexing for
real-time OLAP and data mining; call / load data into PL/SQL dimensions and
session variables in the workspace using complex SQL queries and object
permeations. Install Oracle client software for database connectivity in WinNT
4.0, Win2000 and UNIX AIX 4.3; work within UNIX AIX directory structure to create
folders required to support internal and external data imports and exports (FTP,
etc.); generate UNIX shell scripts to create ETL batch programs, program log
files, compressed backups, and other OS-level procedures.
Test connectivity and transfer of data between Oracle NT 7.3.4 / Oracle 8/8i and
Ms SQL to Oracle 8i databases. Utilize ftp and OS scheduler functions to migrate
flat files between Ms SQL and Oracle 8i. Define UNIX AIX user groups to support
access to project-specific files and folders (i.e. FTP files, etc.) in shared
development environment; develop Bourne/Korn shell scripts to call SQL loader and
other SQL programs from the OS chron file to meet nightly file transfer
requirements; modify shell scripts, OS files, and SQL scripts using UNIX VI
editor; configure and test SQLNet/Net8 connections to Oracle NT 7.3.4 and UNIX
AIX 8.1.5/8.1.6 Oracle databases from Oracle 8 client. Coordinate, plan, create,
test, and debug PL/SQL procedures and UNIX AIX scripts to complete data migration
from development and test environments to production server.
Kelly Engineering
12/1998 – 05/2000
Newport News Shipbuilding
Information Systems Support Services
Data Conversion Consultant
Warehousing/Shared Data Environment (SDE) conversion team SAS developer for high
security Department of Defense contractor in IBM MVS to HP-UX cluster
client/server environment; use basic UNIX commands to navigate files. Modify and
develop SAS and COBOL applications. Analyzed data extract attributes from SAP,
ORACLE, Aspect, and other database application sources for SAS reporting
requirements. Developed report programs and SAS datasets as needed in IBM MVS SAS
v.6.4. Modified JCL to read and unload data extracts from tapes. Restored and
recovered generation datasets using ISPF facilities.
Virginia Department of Health
08/1998 – 12/1998
Office of Information Management
Richmond,Virginia
Sr. Database Administrator
Quality Assurance Officer for the Office of Information Management. Managed
logical and production database analysts, network security officer, and
application quality assurance specialists. Plan, manage, and coordinate
performance tuning and maintenance activities for Oracle 7.2.3/7.3.4 databases in
HP-UX cluster environment. Coordinate the creation of databases, schemas, and
roles. Managed database change control process. Assessed logical/physical impact
of requested structural changes. Evaluated business processes and applications to
identify critical application needs for all strategic business areas for the
Department of Health. Planned and organized logical recovery procedures for
critical business areas to enable continuity of business operations to include
alternate site operation feasibility studies. Identified data access requirements
for all forms of stored media, manual and automated. Assessed business risk for
each identified business center and related business applications, to include
probability of failure and expected loss created by failure. Established remedial
plans to upgrade or retire applications that pose significant business risk to
critical operations.
City of Richmond, Department of Information Technology
10/1996 – 08/1998
Systems Development
Richmond, Virginia
Police Support Team Project Manager
DIT liaison to Police Public Safety Project Team. Planned, managed and lead
complex criminal justice automated systems and application development.
Coordinated performance of regular system maintenance activities for production
applications; supervised development staff and consultants in the preparation of
entity relationship / system flow diagrams, internal external system interface
requirements, business analyses, functional requirements and design
documentation, needs assessments, organizational / workflow breakdown structures,
program specifications, system test plans, and other systems development life
cycle documentation needed to support process and database re-engineering from
DB2 to Oracle; analyzed and document data requirements to support
logical-to-physical DB2-to-Oracle data re-engineering; evaluate and establish
PL/SQL program requirements for DB2 to Oracle data migration; manage development
of functional requirements for new application development and existing
application enhancement; evaluate migration strategies and methodologies to
migration from mainframe environment to client-server OS environments to include
data retention of historical data on mainframe as a backend infrastructure
solution for long-term data archival.
Commonwealth of Virginia, Department of Corrections -
03/1994 – 10/1996
System Management Information Systems Department
Richmond, Virginia 23225
Systems Analyst
Administrative Support Manager for Medical Services, Internal Affairs, Employee
Relations, and Finance Administration. Plan and organize logical recovery
procedures for critical system applications to enable continuity of operations to
include alternate site operation feasibility studies. Identify data access
requirements for all forms of stored media, manual and automated. Assess business
risk for each identified application area, to include probability of failure and
expected loss created by failure. Participate in RFP preparation and vendor
evaluation process for the development of an new offender management system.
Supervise application development and maintenance for DEC VMS transaction-based
inmate accounts payable and accounts receivables applications written in VMS
Cobol and SAS to include: inmate medical co-pay accounts receivables, inmate
payroll accounts payable, and inmate trust accounts payable. Create program
specifications for Cobol and SAS modifications; supervise application development
and maintenance for statewide access to IBM CICS applications for agency
financial, payroll, and personnel reporting systems: Commonwealth Accounting and
Reporting System (CARS), Budget Proposal System (PROBUD), Commonwealth Integrated
Payroll Processing System (CIPPS), and the Personnel Management Information
System (PMIS). Provide user access and reporting for DEC / IBM system
applications. Supervise application development staff in the development of
program specifications, program modifications and applications development.
Prepare project initiation documents, needs assessments, application models and
other requirements documentation as may be needed. Prepare project cost estimate
documentation. Coordinate with other IT staff to establish project task list and
deliverable dates. Schedule customer walk-through, meetings, and sign offs.
Evaluate vendor software and hardware.
10/1992 – 03/1994
Division of Community Corrections
Richmond, Virginia 23225
Human Resource Data Processing User Liaison
Plan and implement the transition from existing PC-based, standalone, automated
criminal case management systems to IBM CICS / DB2 applications, or other desktop
technologies. Imple-ment desktop training and support for DOS 6.X, MS Windows,
MS Office / PowerPoint / Word/Excel. Participate in the planning and
implementation of local area networks (LAN) for Novell 3.1 and Windows for
Workgroups. Planned and scheduled site implementation for 45 locations in a 5,000
user statewide network for system conversion activities such as data conversion,
pre-conversion activities, system/network deployment, and training. Provide
day-to-day management of assigned system pre/post-conversion project development
tasks such as site installation follow up and installation support, development
and systematic deployment of user training, and system exception processing.
Develop user requirement specifications for development of system modifications
and enhancements. Monitor system hardware and software performance.
Commonwealth of Virginia, Department of Social Services,
Division of Child Support Enforcement –
12/1990 – 10/1992
Richmond, Virginia
Agency Management Analyst
Special Projects Analyst in Data Services Unit. Provide field support to central
and tidewater regional and district offices; review automation requests; prepare
feasibility studies and requirements documents for system design and analysis to
develop and implement PC-based applications based on user specifications.
Establish training and procedures; prepare user manuals, data element
dictionaries, and other user training materials as needed. Provide application
training as well as general application support. Perform system administrator
functions for child support account information voice response system;
troubleshoot system errors; monitor utilization of automation resources.
Participate in the general design and implementation of new automated child
support enforcement systems; analyze user requirements and establish performance
benchmarks. Perform security officer functions for ACF2 access to child support
and other state agency CICS resources. Implement security policies and
procedures. Provide technical support for existing child support systems in CICS,
UNIX, MAPPER, and NATURAL/ADABAS environments.
Commonwealth of Virginia, Department of Health Professions -
07/1989 – 12/1990
Richmond, Virginia
Agency Management Analyst
Design and implement spreadsheet and relational data base applications to
compile statistical reports for agency staff; evaluate and develop system
training needs assessment as needed. Develop and implement in-house training
seminars for software installed on the IBM 9370 mainframe. Manage host PC
file/print sharing services and processes for IBM PS/2 3270 access; monitor
training effectiveness; complete technology surveys to evaluate customer needs
and interests; create and maintain training manuals; provide day-to-day end user
support for applications; troubleshoot user software-related problems.
EDUCATION
Bachelors of Science, Psychology, May 2007, cum laude
Virginia Commonwealth University,
College of Humanities and Sciences
ORGANIZATIONS
Psi Chi National Honor Society in Psychology
Golden Key International Honor Society
OTHER TRAINING
Oracle 10gi Database Administration, OCP Certification Coursework
Oracle 9i Database Administration, OCP Certification Coursework
Oracle 8i Database Administration, OCP Certification Coursework
Oracle 8i PL/SQL Coding Techniques
Relational Database Analysis and Design
Introduction to TSO/E REXX,
IBM ISP Dialog Management Services
DB2/SQL Application Programming and Design
Basic SAS, Advanced SAS
SPSS 14.0
|
