SUMMARY:

• Over ten years’ experience in Relational Databases and Data Warehouse Management Systems.
• Consistent hands on leader, with a strong work ethic, experienced with strategic proactive & sustainment solutions, development of effective SOPs, business development, client relationship management, and data profiling.
• Detail - oriented professional who possesses excellent problem solving/analytical skills, with the proven ability to effectively troubleshoot and resolve issues.
• Proven experience with database change control tools, data migration, tracking, monitoring, and reporting from database tracking systems, such as Oracle Discoverer, Database backup recovery, and advanced replication.
• Experienced with Confidential STIG implementation/documentation process.

TECHNICAL SKILLS:

• Datapump PL/SQL Oracle 9i, 10g, 11g, 12c Oracle Grid
• SQL Plus Worksheet SQL Developer Merant Tracker Erwin
• MS Visio MS Access MS Project Open Project
• Citrix Metaframe Lotus Notes Novell Ghost
• HTML JavaScript VNC PhotoShop
• Subversion Win SCP Fireworks Desktop Publishing
• UNIX (Solaris 8, 10) SQL Server 2003 Windows 2000, 2003, XP Linux (RedHat 4.8, 5.2)
• PeopleSoft HR 8.4 (Centos, Red Hat 5) Oracle APEX SSH/SSO
• Recovery Manager (RMAN) Oracle Middleware (Weblogic Server 11g, Oracle Discoverer 11.1.1.3, Apache) Informatica DataPump Confidential 4.3.8.1 PostgreSQL (8.2.15)
• Pivitol AWS (Amazon Web Services)
• Oracle OBIEE Oracle Business tool (Oracle Discoverer Administrator, Oracle Discoverer Desktop)

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Identify and recommend solutions to complex technical issues as needed.
• Design and develop SQL queries, PL/SQL packages, functions and/or stored procedures
• Ensure that databases are properly designed from a logical, physical, performance, and data governance perspective.
• Perform routine database management operations on Oracle 11g databases running in Linux environments.
• Provide reports on database health (performance, availability, issues, etc.)
• Support the databases and systems by performing database maintenance, backups, recovery, data cleaning/audits, etc.
• Install and upgrade database software and implementation of Confidential STIGs.
• Perform daily/weekly/monthly/quarterly query analysis and performance tuning.
• Monitor database health.
• Monitor system servers and associated hardware to ensuring system integrity.
• Document and maintain data/hardware related artifacts.
• Perform other tasks as needed

Confidential

Oracle DBA

Responsibilities:

• Install Oracle 12c on Linux
• Upgrade Oracle database from 11.2.0.2 to 11.2.0.4
• Upgrade Oracle database from 11.2.0.4 to 12.2.0.2
• Perform backup on Oracle 12c via RMAN
• Responsible for design, development, and documentation of database strategies, system monitoring and improvements to database performance and capacity, and planning for future expansion requirements.
• Responsible for planning, coordination, and implementation of Data warehouse, and Data Marts.
• Set security measures, processes, and exercises for database backups, and DR (Disaster Recovery) practices, and DR exercises.
• Research and create requirements for Data mart strategy, tool selection, functionality and design.
• Database functionality development, testing, staging, UAT, and implementation to Production.
• Establish and document S.O.Ps to monitor processes, and changes to system parameters for efficiency and performance.
• Establish, set, and document requirements for table space management for data warehouse.
• Establish monitoring for data warehouse performance and tuning processes.

Confidential

DBA

Responsibilities:

• Ensure database accessibility and availability for 24/7 environment.
• Manage Confidential Database Daily Log Files, Database Server Log Files, and management Utility Log Files.
• Manage Monitoring Confidential using Command Center.
• Perform daily Maintenance using gpstate, pg acitivity stat, gpssh, pg locks, gp bloat, gp skew, gp logs, gpcmdr.
• Monitoring Confidential Systems and Enabling System Alerts Notifications, Checking System State, Checking Disk Space Usage, and Checking of Data Distribution skew.
• Perform routine password management using Confidential setup, configuring LDAP, PgAdmin using pg hba.conf, configuring LDAP, PgAdmin, SMTP on Confidential .
• Perform Weekly Maintenance activity such as reindexing, partition monitoring, and running gpcheckperf and monitoring Database and performance using Pivotal MoreVRP.
• Perform weekly maintenance task in reindexing, partition monitoring, vacuum, running gpcheckper and tuning Production Databases using gpcheckperf, gpexplorer utilities, explain query also managing routine Maintenance activity like daiy backups, segment monitoring and issuing gpcheckcat checks.
• Tuning Confidential Database using gpcheckperf, gpexplorer utilities, explain query by managing routine Maintenance activity gpcheckcat, vacuum, backups, segment monitor.
• Worked with Developers in tuning Confidential Database Queries, PL/SQL in Stored Procedures, Functions, and Triggers.
• Confidential Maintenance Tasks by Routine performance tuning using Vacuum, Vacuum full, Vacuum Verbose, Analyze Table, Analyze Columns and Reindexing.
• Installed, Configured and Administered Confidential /PostgreSQL Databases in the Dev,
• Staging and Prod environment.
• Successfully copied, moved and transferred Oracle data across Confidential Databases and Performed agent installations and product upgrades.
• Supported full Rack ( Confidential ) Data Computing Appliance Model GP1000 appliance with one Master and Standby running parallel in a 16 Segment instances for our ETL Informatica V9.1 with BII work flow Reports.
• Perform Daily/Weekly Backup of the Production Confidential entire Databases and tables using parallel Bkup, and non-parallel Bkup Method gpfdist, gpload, pgload to a flat file/Tape copy to the Data Domain and EMC VNX SAN Network Storage.
• Troubleshoot any related Database Networking problems by pinging the Hostname from client location to ensure post open and to validate proper user access to the right database by verifying the max connections in the postgresql.conf parameter file.
• Work with the Network Team to solve network problems and Troubleshooting Connectivity in ping the Hostname from client location to whether other clients connectivity by verifying the max connections in the postgresql.conf parameter file.
• Perform Confidential Database Segment recovery during any Segment failures and checking omreport for disks, memory, chassis system events to help prevent and form of Segment failures.
• Backing up Confidential tables, Database parallel, non-parallel and Data loading using noparallel copy, parallel Loading using gpfdist and gpload.
• Recovered failed Confidential mirrored and non-mirrored segment instances and managed existing instances to be able to add and to remove Segment hosts in a Greeenplum Database.
• 24/7 Bridge Call Support production and Staging Databases and daily Maintenance using gpstate, pg acitivity gpstate, gpssh, pg locks, gp bloat, gp skew, gp and logs, gpcmdr.
• Created SR tickets for Confidential database production issues with Pivotal Support Technical Center and follow up SR to provide the maximum client intel support.
• Setup Confidential Database Backup and tested out Restore strategies.
• Daily Database Back up and restored Confidential Database using GPcrondump/PGcrondump utility.
• Create System Specific Procedures for managing Confidential Database Administration gpdump/gprestore using gpcrondump and used gpdetective tool in Data Domain environment.

Confidential, Bethesda, MD

Oracle DBA

Responsibilities:

• Provide guidance, leadership and support for resolving database performance issues and troubleshooting of production issues, as well as, support for data architecture in cooperation with the architecture branch.
• Interface closely with all functional areas within eRA Operations (Middle Tier, Ops Infrastructure) acquiring building knowledge and expertise in each functional area.
• Provide functional customer service and technical assistance to eRA developers, testers, users, and other functional areas within eRA, at all times effectively representing eRA Operations.
• Provide technical and strategic support to eRA Operations leadership staff for planning and process improvement initiatives.
• Serve as a point of contact for escalations regarding DBA specific issues, exhibiting comfort while interfacing with highly educated specialists as well as users with little, or no, technical knowledge.
• Provide 24x7x365 support for multiple databases within eRA, including participating in and supporting on- call duties.
• Document DBA related processes, support/patch application deployment (at times participating in overnight deployments known as Enterprise Releases).
• Perform Account Creation and Modifications, as well as, auditing duties within database.
• Update and maintain the current eRA Data Administration function and documentation.
• Support the eRA Data Administration function to install, configure and manage Oracle databases.
• Research and implement process improvements and technology solutions, enhancing the current eRa database design and construction.
• Provide regular review of current baseline of health of Data and Database with proactive plans to maintain up-to-date functionality and features required to support eRA program evolution.
• Provide expert guidance, leadership and support for migration to and support of high availability and redundancy for data and databases in collocated and remote sites.
• Represent eRA Operations interests in early stage SDLC processes.
• Play a key role in executing the Database Change Control Process (DBCC). • Participate in database upgrades and refreshes.
• Provide, maintain, and document compliance with patch/capacity management processes and procedures.
• Thorough knowledge and understanding of the System Development Life Cycle (SDLC).
• Experience with IMPACII, Commons, and other eRA application.

Confidential

Sr. Oracle DBA, Sr. Systems Engineer

Responsibilities:

• Drew System/Project Architecture diagrams, business processes/data models using Architecture Repository of Integrated Information Systems (ARIS) and the COTS tool ERWin for Data Modeling, as well as, other EBS (E- Business Suite).
• Used Merant Tracker to track changes, deliverables, and designated tasks to keep track of different projects going through the SDLC (System Development Lifecycle).
• Delegated and assigned tasks to team mates, PeopleSoft, Java developers meeting deadlines created by DEV/QA Team.
• Worked on Oracle Applications, Backend and Frontend, to test out specific modules and reporting tools, gathering analysis for different systems.
• Represented DBA Team at status meetings.
• Monitored, maintained, planned/implemented database creations, and maintenance on the Classified and Unclassified networks.
• Created and modified user accounts, granting privileges on Backend, to go on Oracle 11g Applications Servers for user testing and test cases.
• Signed off on development tests, as well as, test cases to be deployed in Production environment via Merant Tracker.
• Planned upgrades and migrations for Oracle databases.
• Planned migration from MySQL to Oracle 11g.
• Worked with engineering team to maintain Oracle RAC System.
• Made sure all of the databases were within government security, policies, and regulations.
• Documented all major processes, as well as, made sure they were aligned with Oracle Best Practices.
• Made sure all projects and tasks were completed within each project’s assigned deadline.
• Tested, monitored, and signed off on all DEV and QA projects prior to implementation of a Production environment.
• Documented and kept version control on all processes and stored them in file share.
• Responsible for the DBA, Sys Eng. (Systems Engineering), CM (Configurations Management), IA (Information Assurance) for PMO Office.
• Responsible for testing/approving, all process, upgrades, migrations, documentations, and version control for all environments before implementing into Production environments.
• Analyzed new processes, as well as, performed Risk Management to ensure no harm was done to other environments and applications.
• Responsible for all maintenance windows, ensuring all implementations were executed smoothly.
• Worked with Security Team to monitor/ audit database environments for any vulnerabilities.
• Run audits for Confidential Stigs
• Worked with IA/Security Teams, ensuring systems met compliance with new changes that were made for usage in Oracle Forms and Reports just released in new deployments/rollouts.
• Worked with client Project Managers to ensure workflow plans and timelines are followed and done in a timely manner.
• Worked with clients/government representatives to introduce, discuss, and present future plans of the teams, ensuring they were along guidelines/requirements.
• Responsible for ensuring all IA approvals, accreditations, and auditing were within regulations.
• Represented Confidential (Electronic Document Agency) and PMO (Program Office) whenever meeting with clients plus other government representatives.
• Mediated between different client systems during conferences.
• Recommended best practices/processes to client system representatives that were referenced from policies, procedures, and requirements.

Confidential

Systems Design Architect

Responsibilities:

• Delegated and assigned tasks regarding the XML developers, setting up scripts, jobs, and processes meeting assigned deadlines.
• Developed application, development, network, and technical architectures.
• Analyzed codes and defined business logic.
• Provided suggestions for database development tasks, as well as worked with data architects to design database objects.
• Support the cleaning of JLLIS data and indexing of JLLIS database tables.
• Worked with Project management team to work out Workflow, and WBS (Work Breakdown Structure) effectively ensuring processes, timelines and deadlines for deliverables were met.
• Develop XML schemas and support web services.
• Wrote manuals database's function.
• Comply with DISA standards for system interoperability, test and, if required, certification throughout design/development.
• Provides consulting support to projects during the vision and strategy, architecture, and development phases (Methodology).
• Worked with prime and team of 6-10 sub-contractor resources, (company, and client and third-party resources), in my area of expertise to the conclusion of a project’s phase (Management).

Confidential

Oracle DBA/PeopleSoft DBA/Siebel Admin Team Lead/Manager

Responsibilities:

• Participated in research on system requirements, environments, and policies on Contract Proposals.
• Represented the DBA Team as Sr. Lead DBA.
• Delegated and assigned tasks to team mates, ensuring deadlines were met.
• Provided technical consultation for requirements on projects.
• Assisted software testers with how to properly test and document plus go through test procedures and documents.
• Installed PeopleSoft Application on Windows Server.
• Installed People Tools 8.49.
• Installed and configured Siebel 8.1 Tools and Siebel 8.1 Database for custom Automation.
• Configured Application Server and Web Ser for custom configuration.
• Documented Procedures and stored them in KX (Knowledge Exchange).
• Lead Development Teams to implement and maintain various Custom projects for demos, and rollouts for clients.

Confidential

Oracle DBA

Responsibilities:

• Presented Demos, best/worst case scenarios, and recommendations to clients.
• Set up VM Ware servers and Oracle databases for secure lockdown environments.
• Set up Oracle Data Guard on Oracle 10g database on LINUX servers.
• Created and populated RMAN catalog.
• Set up cron jobs for RMAN Level 0 backups and cumulative backups.
• Documented Oracle Data guard configurations.
• Customize different DR policies/procedures based on application.
• Plan and demo DR exercise.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle 10g on LINUX (Red Hat 5) Servers.
• Installed Oracle 10g and create Oracle 10g databases on VM WARE servers.
• Re-organized data structures and Oracle setup on RedHat Servers.
• Created database and schemas for RATIONAL/Informatica Servers.
• Created user accounts schemas, and table spaces for development and production environments.
• Researched/Performed Migration from Red Hat 5.2 to A.I.X with Oracle 11g.
• Advised clients on best strategy for various processes.
• Analyzed PL/SQL scripts and determine business rules.
• Worked with Data Architects to test development plans and procedures.
• Developed prepare and present best strategies for various roll outs and releases.
• Recommend Hardware and Software applications to help stabilize environments.
• Developed and document different scenarios for advanced replication.

Confidential, Washington, DC

Oracle DBA

Responsibilities:

• Set requirements, standardize, and stabilize environments with consistent hardware/software plus document the process for engineers.
• Applied Oracle patchsets on DEV Windows, and LINUX Servers.
• Reviewed, coordinated approved, and executed Oracle tasks. DBA Team Lead for issues, updates, policy/ procedure changes, maintenance issues with developing, and application teams.
• Monitored Oracle databases with Oracle Grid Used DATAPUMP and teradata
• Documented all changes, policies, and procedure.

Confidential, Mclean, VA

Oracle DBA / Senior Consultant

Responsibilities:

• Managed, delegated, and assigned tasks to team mates (with deadlines) for DEV, QA Team.
• Monitored over 30 Production Databases, 6 Disaster Recovery databases, 35 Development databases, 25 QA databases.
• Responsible for reviewing, coordinating and executing all “simple, and “complex,” Oracle Change Requests’ for the team.
• Monitored any Telelogic (Synergy), Kintana, and Vantive requests that were in queue for the DBA Team.
• Consulted and assisted developers with changes requested in DEV/QA environments
• Installed Oracle 9i/10g on Solaris Servers in Production/Development/QA environments
• Installed and create Oracle 9i/10g Databases on Solaris servers
• Researched Oracle Grid.
• Researched Rman to do backups on Oracle 10g databases.
• Implemented Backup policies and procedures on Oracle 10g /9i.
• Implemented Security policies and procedures on Oracle 10g /9i.
• Maintained database security while working with customers/clients to perform regular/customized schema, and database refreshes.
• Assisted Developers, Data warehouse Team to perform duties in Production environment.
• Documented steps for every task and place it on Sharepoint Server.
• Worked with QA testers to ensure project deployments were carried out in Production environment without problems.
• Worked with PeopleSoft DBAS’ and Developers with database refreshes.
• Worked with PeopleSoft DBAS’ on projects to bring out new projects ebenefits.bah.com .
• Made sure all users/schemas have proper privs and make sure job processes run successfully.
• Installed SQL Server 2005 on Windows Servers.

Confidential, Mclean, VA

Oracle DBA / Interbase DBA

Responsibilities:

• Installed and create Oracle 10g Databases on Windows / Linux servers.
• Performed regular maintenance and performance tuning on Interbase /Oracle 10g database.
• Researched Interbase options of better performance tuning, backup, validation, and restores.
• Assisted Linux admin., to create and run crons to do daily maintenance, and backups on Oracle 10g /Interbase.
• Assisted Windows admin to create and run scheduled tasks do daily maintenance, and backups on Oracle 10g and Interbase.
• Researched Rman to do backups on Oracle 10g databases.