OBJECTIVE:

To obtain a challenging position in Database Administration, Networking Administration, and System Administration fields that will enable me utilize my technical and team knowledge in helping to administer and manage your IT infrastructure in order to leverage your investments.

PROFESSIONAL SUMMARY:

A professional Project Leader with experience in Relational Database Management Systems, tuning, requirements gathering, analysis, data modeling, and database administration. My experience with databases is concentrated with Oracle and MS SQL server in a distributed, client/server, and web environments. I install database server and client software applications, create databases, establish connections for end - users and developers, ensure databases are up and running as required, and data is available for developers and end users.

TECHNICAL SKILLS PROFILE:

Operating Systems: Windows 9x/NT/2000/2003, XP, UNIX-Sun Solaris, Netware, Red Hat Linux.

Languages: SQL, C++, HTML 4.0, Visual Basic, ASP, A+, Cold Fusion MX7, Access, Excel, PowerPoint, PL/SQL.

Tools: Enterprise Backup Utility (EBU), Oracle Enterprise Manger (OEM), Erwin, Crystal Reports, Oracle Forms&Report, Toad, Putty . SQL Navigator, PLSQL Developer, SQL Developer.

Application Servers: Oracle 8i, 9i, Apache, MS SQL Server.

PERSONAL WORK EXPERIENCE/EMPLOYMENT HISTORY:

Confidential, Annapolis Junction, MD

Responsibilities:

• Responsible for installing Oracle 10g & 11g software and created both Stand Alone and RAC databases to implemented Oracle10g (R2) RAC: ASM storage devices, RHEL4/3 in Installing and, Configuring, to Create RAC CRS and Database Instances by using Response files (silent installation) and SRVCTL commands.
• Auditing Oracle Database in Prod, Dev and Test using Confidential STIG Audit. User activity in database, Structure changes to the database such as creation, deletion or modification of tables, clusters, triggers, and more.
• User account creation, modification and deletion. Role creation, modification and deletion, Role granted to or revoked from user accounts.
• Able to install the agent on both RAC & Stand Alone databases and registered them with the OEM grid (GC) so that the monitoring is enabled for proactive work activities.
• Implemented a standby database operation using Oracle 10g, 11g Data Guard for data loss and also provides graceful switchover and switchback between sites for a planned OS and hardware maintenance.
• High-volume production database support, Oracle Fail Safe implementation (Data Guard), backup plans and implementation, Performance monitoring and tuning (Statspack) with good hands on experience in Oracle advanced technologies such as 10g, 11g RAC, OEM, Grid Control, Data Guard and Replication Down Stream (both logical and physical).
• Managed up to 3.5 TB of Oracle production database administration assignments for Confidential project under ( Screening Gate Way) for Confidential clients.
• Enhance database performance, perform restores, implement recovery procedures , handle performance tuning and conduct regular system backups .
• Ensured technical and functional designs to meet business requirements .
• Backup Daily Oracle Production Database using Oracle (OEM) Scheduler tool via 11g Database Grid Control/Dbcontrol console and enabled Archive logs/Flashback instance Data Recovery mechanism.
• Data Management: Responsible for carrying out various data analytical tasks, verifying data for calculation errors and data irregularity. Prepared various statistical and TWIC and HME applicants (Name and other Changes) through security vetting process reports using Oracle 11g database, Oracle SQL Loader, JAVA applet and other program source.
• Setup disaster recovery plan by implementing Oracle (Down Stream) Replication and Data guard ranging from Development, Staging, and Production databases for the client.
• Backup Databases of Development, staging, and production using the (RMAN) Incremental backup.
• Worked very closely with the team developers and on site Clients during meetings, ongoing projects and furfure projects requirements.
• Also maintain and administer Oracle database on Windows Serer 20 and 64 bit O/S with Microsoft SqlServer database 2005.
• Used Oracle Crystal Report with Business Objects inter face tool to schedule SqlServer daily jobs and reports for the client.
• Data Management: Responsible for carrying out various data analytical tasks, verifying data for calculation errors and data irregularity.
• Prepared various statistical and financial reports with help of Advanced Loan System (ALS) application, SAS, and MS Excel.
• Manipulated SQL data using Oracle data sources. Generated data exports with the help of Business Objects reporting and data manipulation tool.
• Extensive experience in data analysis, data manipulation, database statistics, statistical research, system study, documentation and programming outstanding database and statistical proficiency with excellent communication and interpersonal skills.
• Handled multiple tasks and precedence; take initiative; self-motivated and also keen to work in team oriented and fast paced environment.

Oracle Database Analyst /System Admin

Confidential, Arlington, AV

Responsibilities:

• Run Daily Oracle Database Backups using Oracle Scheduler via 11g (OEM) Database dbcontrol and Enabled Archive logs/Flashback instant Data Recovery mechanism on Production Database.
• Installed Configured Oracle (Grid) dbcontrol and Enabled an Email Notification Alert that constantly Monitors Databases and Servers activities at all times.
• Recovered Crashed Oracle Database 10g through the Database cold backup files.
• Implemented Oracle TimesTen In-Memory db Cache on Windows Server bit to improve-high Memory Performance of the Production Database.
• Also Backup Databases of Development, Test, and Production using the (RMAN) Incremental Backup.
• Working very closely with the Clients and the Team in large to mandate and meet Client’s Requirements and s in a 24/7 Work Shop.
• Document each work flow Process and s and follow (SOPs) as required by the Clients.
• Weekly run Windows Server Security Updates on several managed Server using the System Auto Windows updates or Costumed updates.
• Analyze and troubleshot any un-patched update that failed to run and manually re-run the Update to be successfully.
• Periodically check Windows Site for any available Updates or run the System Update check to apply any new releases.
• Periodically clean up the System Windows Software Distribution folder during Update error message.
• Met with Customers and worked on-site with clients to gather and analyze business requirements.
• Assigned task and worked with dba team according to individual’s work experience and allowed cross- on task.
• Primarily concentrated on production databases as the team lead and worked with team on base to base assignments depending on work priority.
• Brought new ideas to the team in other to enhance application database performance and security with the Server.
• Oversee all dba task work and accuracy especially during new production code change or update deployments.
• Always available to assist the team on ongoing database related issues to meet client’s deadlines and requirements.
• Worked in one-voice-one team mentality with the team and believed in one team effort at all times.
• Successfully migrated and Maintained Oracle Database Version (8.1.7.0) to Version (11.2.0.1) on UNIX Solaris 10 and Windows Server bit/64-bit on all three Database Environments including Development, Test, and Production
• Installed and Configured Oracle Fusion Middleware/Oracle JDeveloper Studio (11.1.1.3.0 ) Tool Kit to generate Oracle Database 11gR2 (ER) Diagram for the Client.
• Managed and secured all three Oracle Work Database Environments of Development, Test, and Production in applying the Oracle Quarterly (CUP/Security) Opatche Set.

Oracle DBA

Confidential, Falls Church, VA

Responsibilities:

• Installed, configured, and created 11g Database to implement a Cold Backup Restore off of 10g Database as part of 11g migration process.
• Prepared Windows DoS Database Create Script that will recreate and transform 10g Database to New 11g Database.
• Applied Oracle Quarterly Patches on all 9i and 10g Database Servers environment both on UNIX, LINUX and Windows O/S Databases.
• Testing the patches before deploying on production.
• Performed Complete Database Recovery using RMAN command when Database needed Recovery.
• Analyzed production tables, indexes and rebuilt indexes on a regular basis.
• Developed & customized Rman backup /e-mail scripts to enhance the manageability and performance of the database.
• Has more than two years of experience in PL/SQL in creating Function, Procedures, Triggers, and Packages and package Bodies.
• Implemented Partitioning of Table and Index for several tables that had row count of approximately 10 thousand records.
• Trouble shoots any Database related issues via remote login or phone help support to the U.S. National Guards in the filed issues such as Replication, Nightly data backup failures, Database tuning and etc.
• After hours Database and Oracle Web Application issue support via cell phone.
• On call support on Weekends to support Guards at any time in all Oracle Database problems including Web Apps such as Patch issues and other related Oracle Database Upgrades.
• Performing Hot backups using Oracle Recovery Manager (RMAN). And occasional cold backups using Oracle export utility.
• Represent DBA Team for any issues such as, updates, policy/ procedure changes, and maintenance issues with parallel teams.
• Consult and assist developers/with changes requested in DEV/QA environments.
• Install Oracle 9i/10g on Solaris Servers in Dev/Test/Prod environments and assures QA.
• Install and create Oracle 9i/10g Databases on Solaris servers.
• Perform regular maintenance and performance tuning on Oracle 10g /9i databases.
• Perform Schema refreshes in Dev/Test from Prod for data integrity upon developers request.

Oracle DBA Analyst

Confidential, Suitland, MD

Responsibilities:

• Applied Oracle Quarterly Patches on all 9i and 10g Database resides on both UNIX, LINUX, RED HAT and Windows O/S Environments.
• Daily monitoring of all Oracle Development, Test and Production Databases based on checking Oracle Alert log email messaging on cell phone and trouble shoot issues as they arise.
• Represent DBA Team for any issues such as, updates, policy/ procedure changes, and maintenance issues with parallel teams.
• Consult and assist developers/with changes requested in DEV/QA environments.
• Install Oracle 9i/10g on Solaris Servers in Dev/Test/Prod environments and assures QA.
• Install and create Oracle 9i/10g Databases on Solaris servers.
• Perform regular maintenance and performance tuning on Oracle 10g /9i databases.
• Perform Schema refreshes in Dev/Test from Prod for data integrity upon developer’s request.
• Cloned Oracle database both in test, and production environment and rename Oracle database in production.
• Run, modify crons to do daily maintenance, and backups on Oracle 9i, 10g
• Research and implements Oracle Database Grid to manage Database instances and Servers.
• Oracle Database migration from 32-bit to 64-bit Windows server.
• Apply Rman setup to run daily backups on all existing Oracle 9i/10g databases.
• Creating primary database objects such as tables, views, and indexes on Oracle 10g.
• Creating user accounts and grants roles/ privileges on Oracle 10g.
• Upgrade Oracle databases to 10.2.0.4 and applied the Oracle CPU patch on all Oracle database environment.
• Implement Security policies and procedures on Oracle 10g /9i.
• Maintaining database security in keeping up to date Oracle Critical Patches on all life Database Instances on both UNIX and Windows Servers.
• Work with customers/clients including team members to perform all regular Database maintenances and any new implementation to the database.
• Assist Developers, Data warehouse Team to perform duties in Production environment.
• Document steps for every task and place it on Share point Server for future .
• Work with QA testers to ensure project deployments are carried out timely and accurate before it applies in Production environment without issues.
• Make sure all users/schemas have proper privs/roles in such that job processes could run successfully as scheduled.

Oracle DBA Admin

Confidential, Washington, DC

Responsibilities:

• Well knowledge of Oracle Database 10g in a 24hr environment.
• Installing and configuring Oracle 10g and use of 10g Console/Grid to maintain day-to-day database support.
• Installing and configuring Oracle 10g Application Servers with 10g databases.
• Manages MSSQL 2005 . Installation, maintenance, and 24hrs monitoring.
• Perform normal database administration support.
• Perform database backups on daily and weekly basis.
• Standardize all databases in regard to database options, backup procedures and security.
• Lock down all production databases from access by non-administrative personnel (i.e. developers, users, etc…)
• Setup and install new databases.
• Provide routine maintenance by applying patches or recommended configuration changes provided by Oracle or Microsoft.
• Consolidate database and application servers when applicable.
• Prepare reports summarizing findings, recommendations or Software Change Requests (SCR)
• Prepare monthly reports summarizing database activity
• Document the progress of the project as required by the individual project
• Knowledge of PLSQL scripts such as creating functions, procedures, packages, and sequences.
• Third Party Application software used to Administer Databases includes: SQL Navigator, PLSQL Developer, SQL Developer and etc.
• Manages Oracle on Windows environment with over 90% knowledge on both Database Server and Application Server.
• Work very closely with developers in deploying their daily-developed source codes.
• Experienced in upgrade of Oracle Database Version and applying patches.

Oracle DBA Engineer

Confidential, Arlington, VA

Responsibilities:

• Successfully Upgraded Newly Oracle Critical Patches on Production, Development, and Testing. Total of 17 Databases upgraded in Oracle 9i UNIX Environment.
• Performed Complete Recovery of database.
• Oracle Portal
• Analyzed production tables, indexes and rebuilt indexes on a regular basis.
• Developed & customized Rman backup /e-mail scripts to enhance the manageability and performance of the database.
• Few knowledge of Oracle Database 10g
• Implemented Partitioning of Table and Index for several tables having row count of approximately 20 thousand records.
• Oracle Single Sign-On (SSO)
• Written UNIX Scripts to perform Daily HOT/COLD and Export Backups.
• Manually Double-check all Database Instance Exports/ Backups each day for accuracy.
• Installing Oracle database server software and creating databases for Clients.
• Successfully Manually Created Databases using UNIX commands.
• Applied Application Server 10g on UNIX Server.
• Oracle Application Server 10g
• File Transferring using FTP/SCP/Exports within Server.
• Third Party Application used to Administer Databases includes: TOAD, PUTTY, SSH, and Oracle Forms&Report.

Oracle DBA Analyst

Confidential, Washington, DC

Responsibilities:

• Successfully applied Patches on Production Database in Oracle 9i and 10g.
• Performed Complete Recovery of database.
• Analyzed production tables, indexes and rebuilt indexes on a regular basis.
• Developed & customized Rman backup /e-mail scripts to enhance the manageability and performance of the database.
• Implemented Partitioning of Table and Index for several tables having row count of approximately 20 thousand records.
• Performing Hot backups using Oracle Recovery Manager (RMAN). And occasional cold backups using Oracle export utility.
• Maintained a high availability production database on both Windows and UNIX platform.
• Experienced with Database Clustering (RAC) and Replication.
• Used HTML/COLD Fusion MX7 in support client’s Front End Application
• Monitored database space utilization and performance of the production databases.
• Moderate experience with UNIX shell scripting and UNIX O/S administration.

Oracle DBA Admin

Confidential, Bowie, MD

Responsibilities:

• Installing the client and server Oracle Software application.
• Responsible for daily database administration including space monitoring, troubleshooting, performance tuning, security administration, database backup reviewing, upgrade and migration, as well as to be 24x7 on-call support.
• Developing SQL scripts to create tables, indexes, constraints, users etc.
• Performing cold and hot backup of databases using Oracle’s export utility and Rman.
• Providing remote technical support using SSH and terminal services.
• General database administration operational support included security administration, schema object management and space management.
• Planning projects: Preparing project plans, worked out a schedule for the project completion and allocated work among the Team members.
• Developing in HTML with Cold Fusion to support front End Application. Monitoring and optimizing performance of databases.
• Routinely applied Oracle Security patches and Upgrade patches on my Production Database, Development and Testing.