EXPERIENCE SUMMARY:

• Hold over 10 years of IT experience with 7 years of extensive concentration and proficiency in Oracle 10g and 11g database design, administration and systems analysis geared at optimizing RDBMS functionality and productivity in production and non - production environments.
• I am also knowledgeable with Oracle 12C and great team player with a fast learning curve.
• I can work independently, perfectly and effectively under stressful conditions where speed and accuracy are necessary for business objectives to be met. I do not only have sound verbal and written skills but also mentor less experienced DBAs and write SOP’s. My attention to detail and ability to maximize system resources can be beneficial in the following areas.
• Capacity Planning
• Software Development Life Cycle (SDLC)
• High Availability Implementation
• Database Upgrade and Refresh projects
• Database Security Enhancements
• IBM Informix DBMS
• Backup and Recovery Strategy
• On call 24*7 and offshore Support
• Optimal Database Performance
• Incident Management
• Disarster Recovery Planning and Testing
• Internal and External Communication
• Golden Gate 11g
• Documentation

TECHNICAL SKILLS:

Database Technologies: Oracle 10g, 11g, Informix IDS versions 11.50, 10, 9.4

Operating Systems: Windows 2008, Linux(Red Hat, 5&6), Sun Solaris, HP-AIX

Tools: HP ALM, Clarity, Serena, BMC remedy, E-tes, Deltek, OpsWare, Toad, EM 10&11g, EM 12C, Data Pump, SQL Developer, PLSQL Developer, Tectia SSH, MobaXterm, Tortoise SVN

High Availability Solutions: RAC, Data Guard, ASM and Goldengate 11g

Networking: SQL*NET

Applications: SAP BO, SAP DI, Matrix, PeopleSoft, Apex, ERA

Hobbies: Travel, Soccer, Music and Fashion.

PROFESSIONAL EXPERIENCE:

Confidential, Wshington DC

Enterprise Datawarehouse

• Salient CRGT is a leading provider of Agile software development, data analytics, mobility, cyber security, and infrastructure solutions to help their customers in federal civilian, defense, homeland, and intelligence agencies, as well as Fortune 1000 companies meet critical goals for pivotal missions in the areas of Agile software development, data analytics, mobility, cyber security, and infrastructure solutions. As the DBA of the Data Analytics and Business Solutions (DABS) Infrastructure team supporting Judiciary Data Analytics Office (JDAO) branch of the AO solely responsible for the build, operations and maintenance of the Enterprise Datawarehouse, my responsibilities include;
• Install and configure new RAC databases on ASM to host US courts enterprises data warehouse (EDW) for the Judiciary Data Analytics Office (JDAO)
• Create and maintain database administration documentation
• Work with cross team members of OS, BO/BI, CDC and data architects to develop and deploy EDW applications
• Install oracle client on SAP data services and business object and tom cat web servers
• Responsible for monitoring and maintening smooth functionality of golden gate unidirectional replication on target system
• Resposible for supporting OS maintenance on SAP data services and Business object servers. This include all pre and post maintenance tasks
• Review and improve database architecture setup
• Deinstall and reinstall poorly built RAC clusters across two data centers for JDAO
• Install and / or clone Oracle databases to create/refresh development and test environments
• Enhance database security through role separation and profile parameter improvements
• Perform database patching for bug fixes, and mitigate security vulnerabilities
• Test recovery and support continuity of operations procedures (COOP)
• Perform user administration and support
• Monotor golden gate unidirectional replication on target system using ggsci
• Work with cross team members of goldengate source system to tweak golden gate replicate parameters accordingly
• Stop and restart goldengate manager as needed
• Perform all aspect of database operations and maintenance (O&M)
• Automate, maintain and monitor logs for jobs using dbms scheduler and shell scripts
• Document / enhance backup and recovery procedures
• Document database build procedures and process improvement
• Responsible internal and external communication of process improvement in areas of database security and capacity planning.

Confidential, Columbia, MD

Database Aadministrator/Assistant Lead

• Confidential, a Confidential, is a premier provider of technology and management solutions providing state-of-the-art software modernization, information and identity assurance, and service optimization for healthcare, federal civilian, financial, and regulatory markets. This is the Development Effort Consolidation Contract (DECC) under Centers for Medicare and Medicaid Services (CMS) supporting various lines of businesses for CMS's improved healthcare quality systems environment. My role is a backup team lead aiding with the oversight of daily activities, providing technical guidance to the DBA staff and assisting the Team Lead and project manager with making technical decisions and evaluation of schedules and database designs. I also;
• Aid the Team Lead to oversee the daily DBA activities to ensure work is completed timely, accurately and according to standards.
• Designed, implemented, and supported enterprise data warehousing (EDW). Responsible for Oracle Data Warehouse’s ETL processes for CMS’s Hospital Quality Reporting (HQR), Quality Improvement Organization (QIO) and Physician Quality reporting Systems (PQRS).
• Responsible to provide 24 x 7 database administrative activities over different database servers.
• Responsible for conversion of Informix-based client data transfers to Oracle-based electronic reporting (ER) systems.
• Developed daily reporting system that organized DBA workload and redirected their attention to any items of concern, reducing DBA maintenance and monitoring time from 70% of their day to 20%, allowing for many long-term delayed maintenance projects to be processed.
• Assist Team Lead and database manager in the development of project plans including detailed project estimates and tasks required for database activities.
• Provide database application support to development teams, consult with development teams on database design, optimization, and engage in ongoing database performance tuning efforts to assure optimal performance for database applications.
• Implements and supports database security regulations, policies, and guidelines. Monitors security bulletins to obtain information of potential threats; installs necessary security patches to ensure ongoing database security.
• Creating user accounts and appropriate privileges as well as maintaining database security.
• Design, Test and Implementation through the phases of System Development Life Cycle
• Establish a backup and recovery using daily hot backups, RMAN and weekly full backup.
• Supported development team writing and tuning in PL/SQL stored procedures for Packages Implementing functions, triggers
• Ensured daily RMAN backups are completed and valid for restore and recovery
• Performed daily database administration on production environments
• Started and stopped RAC nodes as needed for maintenance.
• Provided performance tuning, maintaining, and troubleshoot database problems
• Upgraded Oracle database using DBUA or Data Pump Export/Import
• Implemented Migration Strategies based on cost, time, and platforms requirements
• Advanced troubleshooting using trace files, alert log, and external links (Metalink or Oracle Support)
• Analyzing performance issues and providing recommendation based on testing results
• Performing database patching, upgrade and migration as needed.
• Responsible for monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
• Implemented database Refresh (cloning) using full export for table level and full database defragmentation, resulting in improved performance and effective space management.
• Test backups periodically to ensure minimal recoverability time to meet business objectives.

Confidential, Minneapolis, MN

Oracle Database Administrator

Responsibilities:

• Confidential is the nation's #2 discount chain (behind Wal-Mart). The fashion-minded discounter operates about 1,745 Target and Target Super stores in 49 states, as well as an online business called Target.com. Target and its larger grocery-carrying incarnation, Super Target, have carved out a niche by offering more upscale, fashion-forward merchandise than rivals Wal-Mart and Kmart. Target also issues its proprietary Target credit card, good only at Target. After a reversal in fortune that coincided with the onset of the deep recession in the US, Target is growing its grocery business, remodeling stores, and in a few years looking to grow outside the US. My role in this project could be summarized as;
• Working with developers, Architects and data modellers as the sole DBA to plan, design, build and deploy Target’s first ever enterprise inventory and enterprise order management database to establish a consolidated architecture synchronizing orders from Target.com into Target Stores and Super Target Stores.
• Reviewing and repartitioning hash partitioned tables to resolve uneven data distribution within columns of the table partitions.
• Responsible for performing routine checks of a certain assigned number of databases running on 2 and 3 node clusters to ensure their compliance to business objectives and Target’s IT policies.
• Utilizing SQL developer to create and manage database users and objects on a daily basis.
• Providing operational support to developers and application support teams.
• Supporting the Portfolio Solutions team backup strategy for Target eCommerce warehouse.
• Supporting the life cycle management team providing upgrade, refresh and migration as needed.
• Performing whole database, schema and table level refresh from prod to lower environments.
• Perform database health check using OEM 12C
• Provide database maintenance using SQL Developer.
• Responsible for review and approval of database changes across all environments.
• Responsible for all deployments across all environments.
• Troubleshoot and resolve user connectivity and account locking issues.
• Manage database resources through access provisioning and user profiles.
• Installed and configured oracle database software for Oracle Application development environment
• Provide technical support for database maintenance and disaster recovery.
• Planned and scheduled Backup/Recovery Strategy, took logical Backups (with Export/Import Data pump utilities)
• Created primary objects (tables, views, indexes, synonyms, procedures, functions and triggers) to help application developers with the application design.
• Created & Managed Constraints, Database Access, Roles and Privileges.
• Performed database security and user administration via roles, profile, privilege, synonyms and auditing
• Planned backup and recovery of database information. Maintained redo logs and archive them to disk.
• Performed day to day activities: Such as, daily error checks and database health monitoring of physical resources (disk space, memory, CPU, etc.). Performance parameters adjusted as needed.
• Produced backup report to ensure the backups were all successful and troubleshoot if the backup was not successful to find out the root cause of failed backups.
• Maintained Oracle Dataguard Physical standby databases for disaster recovery
• Performed data transfer using Export/Import and Datapump.
• Monitored database for performance and optimization. Tuned database and application performance using Stats pack, AWR, ADDM, Explain Plan and oracle Enterprise Manager (grid control).
• Maintained record of daily data communication transactions, problems and remedial action taken, and installation activities.

Confidential, Hagerstown, MD

Oracle Database Administrator

• First Data is a global payment solutions company that helps government, merchants and financial insttutions deliver high levels of payment solutions, marketing and prepaid solutions, information, anaytics and reporting, derbit/credit card production, ecommerce, online banking and security and fraud solutions . Our DBA team’s responsibility is to support the clients and business unit with the building and management of safe, secure and reliable databases for computation of stakeholders taxes, benefits, bills, payroll, interests, loans, fraud investigations and marketing solutions. Below are some of my responsibilities and achievements as an Oracle DBA on this project:
• Worked with UNIX team to configure huge pages in 64 bit RHEL 5.5 to handle heavy load on large production database with heavy batch activities to resolve performance hit.
• Independently built new 11g R2 databases from scratch on RHEL and AIX platforms from planning, testing through Release Management for validation.
• Reorganized databases and sized database objects to meet standards and improve performance 30%.
• Worked with users to troubleshoot and resolve errors and performance problems with queries and databases and doing database health checks.
• Involved in all phases of database development, from needs assessment to QA, design, and support.
• Worked with users to resolve any database/query performance issues using database advisors and AWR/ASH reports.
• Performed restore/recovery/refresh of databases both on same and alternate servers and other levels of restore/recovery ( like dropped table ) using data pump.
• Applied CPU and PSU patches to both primary and standby databases.
• Worked with senior staff to perform cross platform replication using Golden Gate.
• Backup/Restore of databases/tables/schema using Datapump export/import and transportable tablespaces.
• Ensured that standby database is always in sync with production database
• Performed hot and cold backup using RMAN.
• Installed, configured and managed 10g and 11g ASM storage
• Performed Dataguard switchover as required for maintenance.
• Managed, Troubleshoot and resolved log gap in Data Guard Configuration
• Managed database security by creating and assigning appropriate roles and privileges.
• Installed and configured Oracle Enterprise Manager (OEM) and Grid Control for Oracle 10g & 11g.
• Monitored production databases using OEM and Grid Control.
• Restructure the Oracle RAC configuration by adding and removing nodes along with resolving issues.
• Work closely with developers in various schema/table design tasks and SQL code review.
• Cloning/duplication of production databases as needed for testing, development using RMAN.
• Maintain up-to-date documentation to comply with C&A requirements.

Confidential

Data Entry Clerk

• Provided clerical services at EUFS including reviewing, registering invoices, verifying invoice information and receipts to ensure that sufficient funds have been obligated, and enter data.
• Obtained validating bank information against vendor profile.
• Prepared an administrative approval transmittal sheet to forward invoices to appropriate offices for approval.
• Coordinated with approving officers and vendors to ensure prompt payment.
• Followed up action if approval has not been received.
• Provided assistance on vendor inquiries.
• Investigated invoices lacking all proper data.
• Updated and maintained all logs containing money transfers, funds payed, loans and annuities.
• Prepared necessary documentation for all follow up action.
• Conferred with staff and customers to review and resolve incomplete/incorrect invoices.
• Attended meetings and took minutes as requested
• Scanned documents as requested