SUMMARY:

• Oracle 11g - Oracle Certified.
• Database administration experience ranging from managing, upgrading, performance tuning, replication, troubleshooting, testing in multiple OS/environments.
• Skilled in reducing cost by driving process improvements. Strong background and proficiency in database design, analysis, data security and integrity.
• Create and manage users and ensure data security by granting privileges, roles and profiles to users.
• Repository Administrating Utility SQL*Net Configuration.
• Operating Systems: Oracle unbreakable Linux, Windows, UNIX (Oracle, Sun Solaris), Linux including Linux scripting skills.
• Languages (& scripting):SQL,PL/SQL, J2EE, PHP, Drupal, Kornshell
• Oracle Experience: Oracle Database 10g/11g, Data Guard, Golden Gate implementation, Oracle Critical Patch Update, Oracle Rightnow Cloud Service.
• Experience in data advanced security administration role in Label security, Audit vault, Data vault.
• Performed database refreshes using RMAN and created standby databases.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

Oracle Database Administrator (DBA)

Responsibilities:

• Responsible for Oracle 11g logical and physical database design, implementation, and maintenance. Reorganize databases and size database objects to meet standards and improve performance.
• Administered and managed 20+ RAC production databases of sizes up to 10TB in various datacenters.
• Performed migrations of Oracle 10gR2 databases from LDOMs (Oracle VM) to Oracle 11gR2 ASM databases.
• Perform daily incremental backup level one and weekly incremental backup level 0.
• Monitored daily RMAN reports and created status update to teh higher management.
• Performed database refreshes using RMAN and created standby databases.
• Managed multiple DataGuard Disaster Recovery and System Replication processes using Streams, ensured synchronization between teh primary and standby database, and performed manual intervention when required.
• Used customized templates to create teh target databases based on teh Oracle components installed in teh source databases.
• Performed migrations as per client standards, regulations, security, policies and procedures. Worked with teh Migration Team, Team Leads and Sys Admins.
• Coordinated teh migrations with teh Application Team and teh Applications DBAs. Performed validation reports comparing teh source and target databases.
• Documented teh procedure for a Data Pump migration of source databases having encrypted data and Oracle Wallet.
• Created new databases, involving importing and exporting; installed and configured database software for Oracle Application development environment.
• Handled database server tuning, application tuning, maintaining documentation, and Capacity planning and database security.
• Provided a 24/7 availability and coverage of technical assistance through teh use of emails and cell phones for mission critical Databases.
• Provided 24*7 support and report to teh Operations Manager and teh VP of Operations.
• Installed Oracle 10g cluster, ASM and database on Windows 2008.
• Assisted teh application developers with performance issues and database change requests.
• Coordinated system maintenance with Support Specialists and System Engineers.
• Managed space allocation and work with teh Storage and Network Engineer.

Confidential

Oracle Database Administrator (DBA)

Responsibilities:

• Collaborated with teh system Administrator to configure any software and hardware requirements that will function with teh Oracle Database
• Responsible for overall strategic planning & redesign of databases: Requirements gathering and Analysis, Design, Test and Implementation through teh phases of System Development Life Cycle.
• Worked with application developers to address and clarify data requirements to resolve technical and functional issues by enforcing corporate business rules through adequate user/resource/object management.
• Reconciled functional and technical problems through interaction with clients by researching and identifying teh defined issues and by fully testing and confirming possible solutions to teh problems encountered.
• Installed, created and configured Oracle 10g and 11g Oracle Databases (Windows and UNIX) platforms using Oracle Database Configuration Assistant or manually by using Oracle Database Dictionary, table spaces.
• Established capacity planning of table spaces, tables, indexes, and databases to allow for growth potential.
• Established, designed, tested and implemented backup and recovery solutions including automated daily hot/cold backups depending on criticality of teh Database - (RMAN, EXP/IMP, DATAPUMP and shell scripts) and database migration.
• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development, test, and production environments.
• Provided performance tuning activities for Oracle database improvement, Tuned Database through initialization parameter, SQL statement and memory by performing routine checks of teh SGA. CPU, Logical and Physical me/O and contention.
• Techniques like applying recent patches and upgrades, appropriate user grants, permissions and profile management.
• Restructured, tuned tracked, proactively monitored database load, fragmentation, contention, and overall performance for optimal performance of teh existing database.
• Monitored database growth, created objects, administered users and tuned expensive SQL statements using EXPLAIN PLAN and SQL TUNING ADVISOR...
• Provided a 24/7 availability and coverage of technical assistance through teh use of emails, cell phones, and PDA’s for mission critical Databases.

Confidential

Business Analyst - Oracle Support

Responsibilities:

• Identified new value sources by conducting industry and client research and Designed/administered business processes and systems.
• Facilitated deliverable transition between project life cycle stages and ensured that key project deliverables were effectively transitioned and placed under configuration management.
• Implemented quality management processes such as process and product quality assurance (PPQA) and other quality-related reviews (e.g., Quality and Process Improvement or QPI best practice reviews)
• Provided system architecture recommendations to reflect OFA Recommended RAID levels and STRIPE Sets.
• Configured UNIX System kernel that is semaphore settings and shared memory.
• Developed Backup and Recovery strategies using both RMAN and operating system scripts for Oracle databases supported. Recovered and refreshed databases made up of one terabyte of business data using RMAN.
• Utilized teh Automatic Workload Repository and Automatic Database Diagnostic Monitor for performance tuning.
• Configured and maintained data loads in huge Data warehousing systems using teh Information Power Center ETL tool; Supported data warehousing and databases.
• Performed troubleshooting and fixed Oracle internal database errors with support from Oracle support. Did security update and patch/bug fixes as recommended by Oracle Support.
• Responsible for database tuning; including table re-orgs; index rebuild; ESTAT report analysis. Detect and tablespace fragmentation and migrations. Tuned SQL queries using “ EXPLAIN PLAN” and TKPROF utilities.

Confidential

Data Entry

Responsibilities:

• Prepares source data for computer entry by compiling and sorting information establishing entry priorities Processes customer and account source documents by reviewing data for deficiencies; resolving discrepancies by using standard procedures or returning incomplete documents to teh team leader for resolution;
• Enters customer and account data by inputting alphabetic and numeric information on keyboard or opticalscanner according to screen format;
• Maintains data entry requirements by following data program techniques and procedures.
• Verifies entered customer and account data by reviewing, correcting, deleting, or reentering data; combining data from both systems when account information is incomplete; purging files to eliminate duplication of data.
• Tests customer and account system changes and upgrades by inputting new data; reviewing output.
• Secures information by completing data base backups.
• Maintains operations by following policies and procedures; reporting needed changes.
• Maintains customer confidence and protects operations by keeping information confidential.
• Contributes to team effort by accomplishing related results as needed.