OBJECTIVE:

To find a challenging position as an Oracle Database Administrator that will enable me to demonstrate my experiences, knowledge, and skill.

SUMMARY:

My early part of working experience was devoted to utilizing IT technologies, especially managing/administering scientific information database/system, to support scientific research, while my later part of experience has been engaged in typical IT environment as a database administrator. I have over 10 years of well - rounded practical Oracle database administration experience. I have an active Secret Clearance with DoD.

TECHNICAL SKILLS:

MS Office: 2007 Professional, Abinitio, Installing & Configuring SW Visual Basic Programming, Crystal Reports, Microsoft Visio HTML, Java Script, Pascal,Unix Script, SQL-Station C Programming, SQL-Station, SQL*Loader, Oracle Discoverer 10, UtraEdit-32 Toad 11.5

MS SQL Server:  2008, 2005 MS SQL Server Management Studio

Microsoft: Baseline Security Analyzer SQL Server Enterprise manager

Grid Control:  (Veritas) NetBackup

Operation System Experience: HP/Unix, Sun Solaris 10, Ubuntu, Windows 2010,Red Hat Linux 5

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Database Administrator

Responsibilities:

• Allocation of system storage and planning for future storage requirements for the database and related functions.
• Modification of the database structure, as necessary, per direction given by the application developers. Candidate should be able to advise development staff on implications of any proposed changes.
• Design, implementation and maintenance of database security procedures. Ensures compliance with Oracle License agreement.
• Controls and monitors user access to the database.
• Plans and executes backup and recovery activities (Control Files, Redo Logs, Rollback Segments, System Data Files, etc) to insure timely and complete recoverability. Maintains archived data on tape or other media as defined. Backs up and restores the database (On line and Complete) to assure restoral capability.
• As necessary, contacts Oracle Support for technical assistance in resolving problems in a timely fashion.
• Complete Software Readiness Review Checklists (Take Action As Required).
• Stays current with Oracle’s emerging product line and with new additions that may complement existing applications.
• Perform 24 by 7 rotation Oracle DBA production support.
• Manage Oracle RAC and ASM Production Database
• Installing Oracle Quarterly Critical Patch Updates
• Refresh Database using RMAN Active Duplication
• STIG Production Database according to DoD guidelines
• Provided Cost analyses for purchasing Database Server equipment and also provided IT budget inputs for customer service related programs.
• Working with Developer to modify/update to current system for Database requires for new require.
• Provided resource effort to support the projects
• Worked with IT architecture team to design new Database requirement
• Developed a guideline supporting for Database support unique situation
• Created implementation plan for Create/configure Database and documenting the configuration for the Baseline installation.
• Developed a procedure and profile to secure Database for unauthorized access
• Identified vulnerabilities, monitor the database and stay upto date with latest oracle patch and following DoD Security Technical Implementation Guides.
• Reviewed the audit Database log and devloped disaster recovery plan
• Presented operaton status to Senior Staff and as well as provided recommendation.

Confidential, Arlington, VA

Oracle Database Administrator

• Creating a RMAN backup script for Production Database and Development Databases Army National Guard
• Upgrading database from 10g to 11g
• Setting up tablespace monitor script
• Performed the deployment of mayor application coded release and daily maintenance release.
• Provides assistance to various clients as required for database design, implementation, and troubleshooting
• Develops and maintains expertise in use of automated tools for database design and implementation.
• Installing Oracle Quarterly Critical Patch Updates
• Advises applications development staff and users on database solutions to business problems, data architectures, data base management system facilities and capabilities, and the operation and tuning of

  databases.

• Performed 24 by 7 rotation Oracle DBA production support.
• setting technical and process related standards and documenting them to improve the team’s productivity
• Perform general troubleshooting on all database related issues and document the solution steps
• Conduct technical evaluations on new products and features and provide recommendations and directions for implementation
• Create technical documentation on all critical processes (Example: Standby log shipping, Security best practices, Performance tuning methodology etc

Confidential, Silver Spring, Maryland

Oracle Database Administrator

• Creating a RMAN offline and online backup script for Production Database and Development Databases for Confidential
• Creating  and maintaining tables, indexes, synonyms and other schema objects
• Troubleshooting data loading processes
• Managing database instances and Oracle listeners
• Installing Oracle 11g Quarterly Critical Patch Updates
• Creating and maintaining database administration SOPs
• Creating  and maintaining tables, indexes, synonyms and other schema objects
• Performing data migration
• Managing database tablespaces
• Perform 24 by 7 rotation Oracle 11g Production support as well as development
• Setting up Recovery Tablespace point in Time script
• Creating RMAN duplicate/clone Database process

Confidential, Rockville, Maryland

Oracle Database Administrator

• Install Oracle Database Security patches on all CTEP Production Databases at NCI at NIH
• Review physical databases design with developers and create objects in development, maintenance, testing, training, and production environments.
• Run diagnostic tools to identify database performance bottlenecks, and take appropriate corrective actions to improve database performance. Work with development teams to tune SQL queries.
• Create database users, and assign appropriate roles. Run vulnerability scan software to detect security vulnerabilities, and apply CPU patches. Participate in Security Plan implementation.
• Train/Guide users and developers on optimal usage of database resources. Answer developer questions. Confer with co-workers to determine impact of database changes on other systems.
• Set-up database backup/recovery jobs, and monitor them. Perform disaster/recovery simulation tests. Participate in Disaster/Recovery Plan implementation.
• Setup and manage document management systems. Expand the reach of existing document management solutions to other areas and applications. Research and recommend optimal document management solutions.
• Manage Oracle 10g database and Oracle 10g SOA suite Production.
• Install/Configure 10gAS, 11g Web Center,WebLogic, Middle Tier, and 11g Database
• Handled Administration of SQL Server SQL 2000, SQL 2005, SQL 2008 and SQL 2008R2.
• Up gradation of Database from SQL Server 2000 to 2005 and 2008
• Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
• Setup Log Shipping for a stand by servers
• Set up Log Shipping, MSSQL Mail, SMTP
• Performed all the SQL Severs 2000,2005, 2008 Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, monitoring error logs, jobs etc.
• Planned & executed upgrade such as Service Pack, Hot fixes on SQL Server 2005 and 2008
• Capacity Planning -- Analyzed the Database Growth and reported future space requirements.
• Created Backup & Restore Plans (Full, Differential and Transactional).
• Manage Microsoft SQL Server 2005 and 2008 production
• Upgrade 10g database to 11g
• Perform 24 by 7 rotation Oracle DBA production support.

Confidential, Greenbelt, Maryland

Oracle Database Administrator

• Installing and upgrading the Oracle server and application tools
• Allocating system storage and planning future storage requirements for the database system
• Creating primary database storage structures (tablespaces) after application developers have designed an application
• Creating primary objects (tables, views, indexes) once application developers have designed an application
• Modifying the database structure, as necessary, from information given by application developers
• Enrolling users and maintaining system security
• Ensuring compliance with your Oracle license agreement
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database
• Planning for backup and recovery of database information
• Maintaining archived data on tape
• Managing and refreshing 5 development sites: this includes refreshing a subset of data from production site, managing user creation and administration
• Backing up and restoring the database
• Respond to and resolve database access and performance issues
• Contacting Oracle Corporation for technical support
• Used Unix Shell Scripts to automate space management, error-checking
• Work with development and operations staff in resolving problems quickly and efficiently.
• Performed the deployment of mayor application coded release and daily maintenance release.
• Installation, Upgrade and Configuration of Oracle (9i, 10g)
• Performed 24 by 7 rotation Oracle DBA production support.

Confidential, Rockville, Maryland

Computer Assistant

• Manipulation of data submitted: Rearrangement of columns, using range fill, and removal of unnecessary fields. Creation of empty structure for importing the data.
• Assist Computer Specialist analyzes database structure and design for modifications/improvements.
• Create reports for branch program analyses, and other data requirements. Select tables, fields, group, totals and criteria. Revise reports by modifying criteria and refreshing data.
• Export data from IMPAC II into Excel or a delimited format for reporting purposes.
• Import various sources of exported data into database.