Database Administrator Resume Baltimore, MD - Hire IT People

OBJETIVE

IT professional in Business Intelligence, Database admin and Systems Architect with expertise in requirement gathering, analysis, architectural, component, interface design and development for successful projects.

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Baltimore, MD

Responsibilities:

Installing and configuring oracle databases and MySQL servers
Managing a 1 - 3terabyte Database with over 600 concurrent users; Installing and upgrade of Oracle software. Patching with Opatch.
Performance tuning, using ADDM, AWR, SQL Advisor; using Enterprise Manager to tune databases.
Security and granting privileges; using encrypting, authentication, auditing, and authorization.
Using Fine Grain Access Control.
Backup and restoration of databases using RMAN. Hot and cold backup including disaster testing, and incremental backup.
Data migration; import and export of databases. Used SQL*Loader, DATAPUMP and OS commands to copy files and migrate data.
Develop logical and physical dataflow models for ETL applications. Codes, tests, implements, and automates complex processes
Meet all defined requirements of the project
Provide production support of existing ETL processes
Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
Provide regular project updates to Information Analysts and management as needed
Managing networks, configuring Listeners and monitoring Oracle Net configurations
Communicate issues, risks, and concerns proactively to management
Document ETL process thoroughly to allow peers to assist with support as needed
MYSQL Admin .Experience with 5.5.

Contractor Oracle DBA

Confidential, New Jersey

Responsibilities:

Support developers, writing and altering codes using PL/SQL
Fine tuning programs and application development; program tuning and integration
Migrating large data from development to production databases.
Design database and transfer data from legacy tables to new data structures; extraction and data mining.
Supported and troubleshot to detect and correct problems.
Setup brand new machines including Oracle software installation, Oracle side configuration, third party backup software and backup testing.
Experiences in working with DBMS automation scripts, and deploying scripts.
Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity).
Performed performance tuning.
Generated weekly, monthly, and quarterly reports and contribute to resource planning.
Data migration using import & export utility, data dump, SQL*Loader, and SQL*Developer

Database Administrator

Confidential

Responsibilities:

Managed over 20 databases with a minimum size of 1Terabyte
Coordinate changes to Oracle database environments; troubleshoot application code with developers, test, and implement changes with a deep understanding of these database management systems
Use of the OEM functionality including diagnostics and tuning pack features, setting up and responding to alerts,& job scheduling
Implemented the use of Oracle Recovery Manager (RMAN) to back up the databases
Performed import and export as needed and scheduled nightly export on database
Performed of bulk load into the database using SQL Loader; table creation, partitioning and maintenance
Performed fine grain database auditing, user profile resource control; Managing Oracle Wallet and transparent encryption
Schedule jobs using various Oracle tools - OEM; Scheduled and monitored jobs with CronTab and other Unix tools
Administered database user accounts; manage spaces, passwords, profiles and roles, privileges, and resource control
Administered Real Application Cluster (RAC) and Data guard on 10g, 11g and 11gR2

Computer IT Support

Confidential

Responsibilities:

Worked as the Assistant Head of IT Support providing technical leadership for a team of 6 IT support staff
Preparing new computers for first use; installing software, coupling and assemble of computer parts and testing.
Preventing and corrective maintenance of computer and other IT devices within the organization and accounting for their usage.
Planning and resource sharing in the IT department.
Daily maintenance of computer hardware and pheripherals like CPU, Monitor, Scanner, Printers, UPS, Digital readers.
Training PC users within the organization on computer functions.
Troubleshooting and attending to IT related issues.
Using computer packages like MS Word, Excel, Access, Outlook, and Powerpoint for analyzing business projects for a $1Million department.
Developing financial and auditing reports weekly using accounting software like Peachtree and MS products.
Handling other ticketing and escalation issues as assigned by the IT Head.