PROFESSIONAL Summary

• Possesses a proven ability to analyze all aspects of database entry in a multi-dimensional function, in terms of managing multiple tasks and projects with utmost accuracy.
• Displays a high level of energy, integrity and ethics with exceptional ability to deliver outstanding bottom line results with short deadlines.
• Possesses an analytical approach to problem solving and detail specificity.
• Highly organized with focus in prioritizing workload and scheduling follow-ups.
• Excellent writing and organizational skills.
• Extensive experience in Oracle 9i, 10g, 11g Administration.
• Ensures oracle database systems operate efficiently and securely.
• Manages databases from planning and testing stages through implementation and support.
• In depth understanding of security and backup procedures to ensure database integrity and disaster recovery plans.
• Excellent communication, presentation, analytical, problem solving skills and work well with all levels of business.

Professional Experience

Confidential, md 11/2008 - Present
Oracle Database Administrator

• Responsible for installation and verification of the database software on the database server. Duties includes planning, preparation and scheduling of software installation, install Oracle 8i, 9i and 10G on Unix, Linux and Windows, apply patches; upgrade Oracle server and application tools, maintaining the software at the latest stable release level and testing and verification of installed components.
• Applied Oracle Critical Patch Update (CPU) patches on databases.
• Installed and configured RMAN to backup production databases.
• Configured Flashback to restore dropped tables
• Configured Flashback database and Guaranteed Restore Point.
• Performed database troubleshooting and tuning using ADDM, AWR Report.
• Identified, troubleshoot, resolve, document and communicate issues that affect the systems, servers and database related products.
• Use RMAN to perform database recoveries when necessary.
• Performed database design tasks such as enforcing referential integrity standards; create database tables and table dependencies such as indexes, stored procedures, functions, packages, triggers, views, materialized views etc.
• Created databases and developed procedure to migrate and refresh databases between the development and production environments.
• Installed and Configured Oracle 10g/11g software on UNIX.
• Upgraded several databases from Oracle 10.2.0.1 to 10.2.0.4.
• Upgraded databases from 10.2.0.4 to 11.2.0.1
• Performed various DBA Maintenance task such as rebuilding indexes, validating constraints, reorganizing tables using the move command.
• Setup technical procedures and administrative policies for production, test and development databases physical design, administration, maintenance, tuning, backup and recovery.
• Allocated system storage and plan future storage requirements for the database systems.
• Resized database redo logs files by creating new redo logs files and later dropping the existing redo logs.
• Implements automated backups and recovery procedures of databases in LINUX and Sun Solaris environments.
• Created new databases and users: set up exports and other monitoring scripts.
• Implemented database refresh using full export for table level and full database defragment resulting in improved performance and effective space management.
• Handles database server tuning, application tuning, maintaining documentation, and capacity planning and database security.
• Identify, recommend and implement all new database technologies and upgraded oracle database from 10g to 11g.
• Responsible for oracle 11g database logical and physical database design, implementation and maintenance on Unix/Linux, Sun Solaris and windows.
• Performs database tuning, creates database reorganization procedures, scripted alerts and monitored scripts.

Confidential,Manassas Virginia 08/2006 10/2008
Oracle DBA

• Installed, configured, and managed Oracle databases 9i/10g on UNIX, Linux and Windows platforms, manage and support Oracle databases.
• Partitioned tables to improve performance and manageability
• Monitor database instances to ensure availability, ensure uptime
• Created and modified database structures as required by developers due to business or application requirements, creating test databases for testing and training
• Analyzed and administered database security. Control and monitor user access to database. Audit database usage when necessary
• Monitor backup procedures. Provide recovery when needed. Develop and test backup and recovery procedures
• Upgrade RDBMS software and apply patches when needed. Upgrade or migrate database instances as necessary
• Created, configured and designed new database instances on testing and production environments
• Diagnosed, troubleshoot and resolved any database related problems. Work with Oracle Support if necessary to bring problems to a successful resolution

TECHNICAL SKILLS
Windows, Oracle 11g/10g/9i, UNIX, Linux, Sun Solaris, IBM AIX, UML, Microsoft Project, Automatic Storage Management (ASM), Oracle RAC, JMP.

EDUCATION: BSc Chemical Engineering,

CERTIFICATION
OCA: 11g Oracle Certified Associate
PMP Candidate