ALPHARETTA, GA

Email Address: abml5t@r.postjobfree.com

Phone: 404-***-**** (cell)

SUMMARY:

Highly motivated Database Administrator that possess the ability to align

business needs with technical solutions, with great emphasis on providing

robust solutions to problems. Experienced in maintaining various Oracle &

Sql Server databases in production environments, and has extensive

experience working with industry leaders in the field of Databases systems,

System Administration, and Application support. Other experiences include

working on platforms such as Sun Solaris, Linux, Windows, VmWare configured

systems and advanced application configuration in SAP.

I am seeking a challenging and dynamic position as a Database Administrator

/ Data Analyst with emphasis on technical development, maintenance, and

support of Oracle, Microsoft and Unix applications and their evolving

technologies.

STRENGTHS:

. Excellent oral, written communication skills and team player.

. Effective time management.

. Ability to work in a dynamic environment.

. Strongly self-motivated, capable, and proficient consultant.

. Strong analytical and problem solving skills.

. Ability to easily understand and apply the logic behind business

and application processes.

EMPLOYMENT / PROFESSIONAL EXPERIENCE

Oracle / Sql Server Consultant, Fashweb Incorporated (Sep 2007 - Till Date)

. Created test plans and code walkthrough for the QA and UAT departments.

. Managed database and application builds to staging and production.

. Worked with system administrators in planning out storage, space

management, naming conventions and paths for batch folders, db data

files, redo, log files, and other important data structures.

. Performed operating system, cold, and hot backups of databases on various

oracle platforms.

. Installed and consolidated multiple oracle instances.

. Managed production oracle dbms, sql server and unix cron jobs and

processes for various business units.

. Created Sql Server backups, restore and security encryption using

Litespeed.

. Maintained security administration, created roles and granted necessary

object/system privileges.

. Created backup and recovery procedures and documentation of various

database environments.

. Worked with monitoring technicians to ensure the production checklists

got updated as processes changed from builds applied to various

environments.

Oracle / Sql Server Dba, Netbank / ING (August 2003 - Sep 2007)

Managed databases, applications and legacy builds to multiple environments

and platforms.

Responsibilities

. Installed and configured oracle 8i, 9i and 10g databases on both Sun

Sparc and Windows machines.

. Designed and maintained physical and logical database structures such as

table spaces, schemas, roles, tables etc.

. Maintained applications, jobs and database related batch processes for

various business areas and departments.

. Managed sql server jobs, dts packages, creation, test, failures and

maintenance on various environments.

. Troubleshoot and managed oracle versioning, patches, performance and the

tuning of oracle databases and related applications on Sun Solaris 8 and

9 platforms.

. Lead all database migrations during two IT data-center re-locations.

. Co-Managed the migration of data processes from the banks old 9i database

to the new 10g Platform.

. Monitored the oracle trace utility, sql Analyze, and oracle expert. Tuned

the sga for optimal use of memory.

. Exported and imported data across instances, for test and backup

purposes.

. Created database links across instances for the distributed database

environments and security reasons.

. Identified problem users. Increased buffer cache hit ratio, library cache

hit ratio, data dictionary cache hit ratio, and memory sort hit ratio

using performance manager to optimize the performance of applications

such as oracle forms and the database itself.

. Worked with domain administrators and other dba team members to establish

and migrate process monitoring from IpMonitor to Hp Open View. Other

duties included documenting processes and normal dba duties.

Oracle Analyst, BizDataUsa (Nov 2001 - July 2003) Georgia. USA.

Responsibilities

. Managed and created databases, table spaces, rollback segments, tables,

views, triggers and indexes.

. Created of users, roles, profiles and backup and recovery procedures.

. Installed and implemented sql*net on various hardware, operating system

and communication protocol environments.

. Prepared scripts for adding table spaces, creating tables, indexes, views

and synonyms.

. Regular monitoring of performance, and space utilization.

. Involved in tuning the database to increase the response times.

. Archived the audit records in the sys aud$table.

. Backed up databases running in both archive log and non-archive log

modes.

. Involved in the production support of 24 x 7 databases implemented using

oracle parallel servers.

. Gathered estimated and computed statistics to help with the performance

of various database instances.

. Imported database objects, which have been either truncated or dropped by

accident during data aging process.

. Installed oracle 8 databases and applications such as oracle forms and

report servers,

. Monitored system activity with oracle dba studio, created users, roles,

and profiles.

. Coded and developed forms, reports, packages, and stored procedures.

. Created table spaces, database objects, indexes, synonyms etc.

. Monitored space utilization and simple performance and tuning of both OS

and database servers.

. Generated alert reports, to track table space free space, insufficient

space for temporary segments, rollback segments that have reached their

maximum extension, and monitored the fragmentation of data segments and

improperly sized sga areas.

. Diagnosed problems by running utlbstat / utlstat utilities, monitored

latch contention, tuned sorts and optimized for throughput of critical

queries using explain plan, analyze, tkprof, and sqltrace.

Sap FI/CO Career Skills and Development Training

. Configured and Customized General Ledger, Creation of G/L Accounts, Recon

accounts for Vendors and Customers, Screen Layout rules, settings for

processing open items, special G/L transactions, Automatic account

assignments, Financial statement version, and Line layout.

. Assisting with defining and configuring SAP modules (AA, AP, AR and

GL) according to business requirements and tests configurations.

Conducted prototypes, developed functional specifications and data

mappings.

. Gathered business requirements, functional specifications, test

scenarios, scripts, updates to training documentations, modified existing

end-to-end business processes and documentation accordingly.

. Maintained document types and assignment of document number ranges,

automatic account determination, tolerance groups, validations and

substitutions.

SKILL SET

Database Technologies: Oracle 8, 8i, 9i, and 10g, 11g, Sql Server 7,

2000, & 2005 DBASE III/IV, Access.

Oracle Applications: WebDB, Oracle Designer 6&6i, ERWIN, Enterprise

manager, SQL Navigator, Toad,

Server manager, Sql*Plus, iSQL*Plus, SQL Loader, SQL

Worksheet, Procedure Builder.

Sql Server Utilities: Query Analyzer, Enterprise Manager, Performance

Monitor, Sql Profiler

Operating systems: MS Win NT/2000/2003, Vista, Win Server 2000 & 2003,

Linux, and Sun Solaris 8 & 9.

Web Services: Psp, Jsp, Xml, JavaScript, C++, Modular 2, Turbo

Pascal, Visual Basics, Java.

Other applications: Veritas Volume, Manager, Litespeed, VmWare.

Methodologies: SSADM, UML, Aim Advantage and Rational rose.

ERP SAP ECC 6.0, FI/CO

EDUCATION

BSC in Computer Science (Kingston University, London)

1996 - 2000

PROFESSIONAL QUALIFICATIONS:

Oracle 8i Certified (OCP)

Contact this candidate