Manager Oracle

WENDELL KNIGHT

**** ********** **.

Riverdale Park, MD 20737

[E] (202) 277- 8647 [D] 202-***-****

E-Mail Address: **************@*******.***

CLEARANCE: (Top Secret Current and DHS Level 6 Public Trust)

Military Service: United States Marine corps 5 and years.

PROFESSIONAL SKILLS

Oracle 8i,9i,10g,11g and12c Database, Oracle Designer 9i & 6i, PL/SQL Programming, Oracle Forms and Reports, SQL*PLUS, SQL Station, Web DB, Oracle SQL Developer, Oracle Enterprise Manager(OEM), Oracle Grid Control, Oracle Real Application Cluster (RAC), Oracle Replication, Oracle Automatic Storage Management( ASM), Oracle Datapump, Oracle BI Publisher, Oracle Discoverer, Oracle Grid Control12c, Oracle Identity Manager 12c,Erwin, Microsoft Excel, PowerPoint, Windows NT Server, Windows NT Server Enterprise, Windows 2003, Windows 2008 R2,Redhat Linux, Solaris, UNIX, AIX, Windows SQL Server 2005, Windows SQL Server 2012,SQL Server Management Studio, Deltek Costpoint, Time Collection, Impromptu, TOAD, Oracle Application Express, Subversion SVN, JIRA.

EXPERIENCE SUMMARY

Responsible for Installation, Upgrade and Maintenance of a set of Oracle Databases comprising of 7.3, 8.0.5.1, 8.1.5, 8.1.6 and 8.1.7,9.2, 10.2, 10.2.4, 11.2.3,12c on Windows NT, Windows 2003, Windows 2008 R2,UNIX,Redhat Linux, Solaris. Utilized SQL’s Data Definition, Data Manipulation, Transaction Control, and Data Control Language commands.

Proficient in Oracle 8i, 9i,10g and 11g Oracle Architecture installation, SQL, SQL-PLUS, PL/SQL, Application and Database Tuning, Database Backup and Restore, Security and Authorization. Used Net8 configuration, Oracle Built-in Packages, Object-relational techniques, Large Objects (LOBS). Creation and maintenance of Database Objects including Database, Table Spaces, Tables, Indexes, Procedures and Triggers, Views, Snapshots, DB Links, ODBC, JDBC,

Oracle Products include PL/SQL, Enterprise Manager, Designer and Developer-2000. Extensive experience in database installation and management. Operating Systems I have worked on include Windows NT Server 2000, UNIX, Windows 2003, Windows 2008 R2, Redhat Linux, Solaris, UNIX, Windows SQL Server 2005, Hardware Platforms include HP, SUN Solaris, COMPAQ and IBM,

Performed data migrations, backup and recovery, imports and exports for the Docks and IRS Systems.

Wrote script files, PL/SQL procedures and functions with flow control statements, loops, and cursors.

Developed IRS System reports using Oracle Reports and PL/SQL. These reports include master-detail tables, multi-table queries, summary data, matrices and dynamically labeled data.

Created entity based, workflow based client applications using Designer 2000.

Written System requirements for IRS and Docks applications.

Database design, build and implementation of a Department of Energy Dock Correspondence System.

Created user interface screens using PL/SQL and HTML packages.

EXPERIENCE

October 2015 TO

Present Datatechnologyus Senior Oracle Database Administrator Crystal City, VA

As Senior Oracle Database Administrator supporting Headquarters Department of the Army(HQDA) Information Technology Agency Office of the Chief Technology Officer (ITA-OCTO) my duties comprised of installing and configuring Oracle 11g and 12c database management software for 15 Oracle databases on Windows 2008 R2 and Redhat Linux to support the installation, configuration and full Software Life Cycle Development of HP enterprise management tools to include but not limited to Management (BSM), HP Network Automation (NA),HP Server Automation (SA),HP Operations Orchestration (HP OO),HP Universal Configuration Management Database (UCMDB), HP Application Lifecycle Management (ALM) in a SQL SERVER database instance using SQL SERVER Management studio to create the database instance, schema and objects to support the application as well as the customization of these HP tools in test, development and production enterprise environments. As well as being on call in the event of mission critical database failure.

January 2015 TO

October 2015 CACI Senior Oracle Database Administrator Washington, DC

As a Senior Oracle Database Administrator supporting Department Of Justice(DOJ)Unified Financial Management System(UFMS) for the For the Justice Management Division (JMD) my duties are to support and troubleshoot database implementations for Oracle 11g on AIX.Support and troubleshoot database replication and clustering technologies such as Oracle Data Guard (both physical and logical)and ASM file system. Upgrade databases from 11g to 12c. Monitor and configure database security using Oracle Identity manager. Prepare database release scripts and implement database design changes. Implement and maintain database monitoring for high-availability and performance using Oracle Grid 12c and other tools to Write database procedures, functions and triggers and tune database queries. Identify, plan and proactively communicate future capacity needs. Address application performance issues using Oracle AWR, ADDM, explain plan on the query to check for full table scans and work directly with the application administrators to tune SQL and PL/SQL. Identify data recovery needs and design recovery strategies; work with DBA team to develop best implementation strategy. Respond to emergencies that require immediate attention including those that occur off hours. Configured and maintained Oracle Identity Manager on Oracle 11g and 12c to manage users access privileges. I also migrated Oracle Identity Manager from 11g to 12c. Attend and contribute to client and internal meetings addressing database questions and status. Create and/or assist in creation of design, configuration, and operational procedure documents and other project deliverables. Understand work plan activities, and provide accurate status on work completion

EXPERIENCE

January 2014 TO

January 2015 Federated IT Inc. Senior Oracle Database Engineer Crystal City, VA

My duties at Federated IT as the Senior Oracle Database Developer for the Immigration and Custom Enforcement (ICE) Student and Exchange Visitor (SEVP),Student and Exchange Visitor Program Information System(SEVIS) at the Department of Homeland Security are developing database, application and data modeling. Normalization, scripting, testing of procedure/package, and documentation. Writing PL/SQL package, Stored Procedures, Triggers and Views to implement business logic and processing needs for forty applications .Creating views, tables, index, sequence, procedures and functions of new schema for new applications. Writing modifying, executing and developing database scripts in Agile development Sprints, data modeling. Participating in daily SCRUM meetings and end of sprint backlog review.Writing modifying, and executing baseline scripts and data migrations scripts for applications, including grant privileges .Tuning SQL for performance requirement by working with front end developers, product owner to address application performance issues using Oracle AWR, ADDM, OEM to identify long running sql and recommending indexing or bind variables to speed up performance., Project Managers, and team members Using Toad, Erwin Designer to develop database and packages and version control using SVN Subversion version control. Provide production support by trouble shooting reported errors by team members. Perform database programming support and systems design, including maintenance of database dictionaries. Overall monitoring of standards and procedures, file design and storage, and integration of systems through database designing baseline scripts and data migrations scripts for applications, including grant privileges .Tuning SQL for performance requirement by working with front end developers, business analyst.

August 2012 TO

January 2014 Digital Management Inc. (DMI) Oracle DBA Washington, DC

My duties at Digital Management Inc. (DMI) as the senior Oracle database administrator for the Federal Bureau of Investigation(FBI), Information Technology Branch(ITB),IT Engineering Division(ITED), Enterprise Engineering Section(ESS),Identity and Systems Management Unit(ISMU) comprised of installing and upgrading Oracle the database management software and to configure and installed 13 Oracle databases on Windows 2008 R2 and Redhat Linux to support the installation, configuration and full Software Life Cycle Development of HP Business Service Management (BSM), HP Network Automation (NA),HP Service Manager (SM),HP Operations Orchestration (HP OO),HP Universal Configuration Management Database (UCMDB) as well as supporting the deployment of these HP tools in four enterprise environments. This consisted of upgrading Oracle databases from Oracle 10.2.3 to 11.2.0 and installation of Oracle 11.2.0.while also being on call in the event of mission critical database failure. I have created and monitored RMAN backups and implemented recovery procedures. I created/modified and shell scripts to monitor processes and users. I have configured Oracle Data Guard for COOP and disaster recovery in all environments as well as Oracle Multi-master Replication for HP Network Automation. I have installed and configured Oracle Enterprise Manager (OEM). Implement Oracle Datapump for database, Tablespace, Table and Metadata export and import. I have configured database auditing for user actions such as inserts, updates and deletes as well as configured auditing for the SYS user and configured the REMOTE_LOGING_PASSWORDFILE to deny remote logon for the SYS user. I have used Oracle Grid Control’s SQL TUNING ADVISOR to check long running sql and evaluate the execution path as well as to schedule and monitor backup jobs, ASM to check space usage and to create tablespace usage reports. I have configured Oracle Data Guard in a physical standby database configuration and Maximum Performance Mode for disaster recovery and failover using redo log transport. I am also responsible for and have installed Oracle Critical Update patches on the production, test and development databases.

February 2010 TO

August 2012 SRA International Inc. Oracle DBA Washington, DC

My duties at SRA International as the senior Oracle database administrator for the Immigration and Custom Enforcement (ICE) Office of the Chief Information Officer (OCIO) IFS production database at the Department of Homeland Security are to ensure the database is available and functional for users during normal business hours. As well as being on call in the event of mission critical database failure I have created and monitored RMAN backups and implemented recovery procedures when needed. I have installed and upgraded the test, development and production databases from Oracle 10.2.4 to Oracle 11.2.3 on Windows 2003 and 2008.Implemented security fixes. Such as removing unneeded default database users and or changing default passwords as well as locking default user accounts. Also setting remote_login_passwordfile to prohibit remote logons and executing utlpwdmg.sql to enforce password strength in order to be in DHS STIGs compliance after database security audits. I have developed a build script that can be used to recreate the full production database. I have configured database auditing for user actions such as inserts, updates and deletes as well as configured auditing for the SYS user and configured REMOTE_LOGING_PASSWORDFILE to deny remote logon for the SYS user. I have used Oracle Grid Control’s SQL TUNING ADVISOR to check long running sql and evaluate the execution path as well as to schedule and monitor backup jobs, to check space usage and to create tablespace usage reports. I am also responsible for and have installed Oracle Critical Update patches on the production, test and development databases. I led the migration effort of the IFS database to the new ICE data center.

June 2005 TO

February 2010 iSYS, LLC Oracle DBA Washington, DC

My duties at iSYS are primarily as an Oracle database administrator involving daily and weekly maintenance of the Synergy and Standard databases for at the Federal Bureau of Investigation (FBI) headquarters Database Administration Unit. This involves the development and implementation of weekly full and daily incremental backup strategy using Oracle RMAN.Installing and configuriing OEM for monitoring & notification of events, create/modify Solaris cron jobs and shell scripts to monitor processes and users, and overall 24x7 support for production, test and development environments running Oracle.

In addition to the above duties, I'm also called on to assist with tuning or helping developers tune sql & PL/SQL code. Additionally, I'm tasked with tuning our schema objects for optimal performance, manageability, and good practices. I am also involved in the effort to create and implement and update functional pieces of the application and front-end and back-end objects that interact with the database. This entailed creating and running scripts for Oracle Text CTX_IFILTER, CTX_MARKUP FUNCTION, indexes and index synchronization. I installed, configured and administered Oracle Business Intelligent Publisher (BI Publisher) and Oracle Discoverer for reporting. As apart of the DBA Team I administered Oracle BI Publisher I assisted the developers in migrating their reports from Oracle Apex and Flash to BI by deploying .ear and .war files. I implemented Fine Grained Auditing for application security. I created database build scripts using TOAD. I developed scripts to create tables, procedures, functions and packages to enhance the user interaction and administration of the production application. I am also responsible for running upgrade patches and scripts for the Standard production database and application. I have installed, configured and monitored Oracle RAC in a 3 node configuration. I’ve configure Oracle ASM for database storage and storage monitoring. I have participated in COOP testing and disaster recovery using Oracle Data Guard. I am responsible for the Planning and implementation of the distributed architecture for the connected and non- connected sites.

September 2004 TO

June 2005 PEC Solutions Inc. Oracle DBA Fairfax, VA

My duties at PEC Solutions are primarily as an Oracle database administrator involving daily and weekly maintenance of the production database for at the Diplomatic Telecommunication Service Program Office (DTS-PO) of the Department of State. This includes but is not limited to daily check of the alert logs for any error messages, insuring that all listeners of up and running. Also making sure that all nightly exports are being done through Oracle Enterprise Manager and that all cold backups are being done using Oracle RMAN. I must run scripts to check database growth and storage, as well as checking for space-bound objects, and overall tuning of the database. I must also do weekly a weekly purge of all log files ( alert, listener, nmi) to prevent them from growing to large. I am also involved in the effort to upgrade the database from Oracle 8.1.6 to Oracle 9.2. I am also the administrator for the Deltek Costpoint and Time collection system. In this capacity I must add user profiles and maintain user groups. I must also create custom reports using the Impromptu report writing tool.

May 2003 TO

February 2004 Schafer Corporation Database Architect Rosslyn, VA

My duties at Schafer Corporation are building and migration data for the Interpro Architect building System. I had to ensure that the database was DOD CADM (Core Architecture Model) compliant. The creation of database entities, views, indexes and stored procedures using Microsoft SQL SERVER and standard structured query language(SQL) and to provide support and the backup database administrator. To assist on other projects as needed.

EXPERIENCE

October 2002 TO System Analyst

January 2003 BAE Systems Suitland, MD

My duties as a System Analyst encompasses information verification and validation testing (IV&V) of the various applications under development at the Office of Naval Intelligence (ONI), to include but not limited to the Triton System. Also leading the effort to upgrade and develop application testing processes and procedures.

April 2002 TO (Temp) Oracle DATABASE ADMINISTRATOR

May 2002 SPS Technology Inc Bethesda, MD

As an Oracle DBA for SPS Technology my assignment at the National Imaging and Mapping Agency consisted of monitoring, recovery and backups of the database and updating scripts for the client and server side of the application .The database was on a Microsoft NT platform using Oracle 8i and 7.3. The database consisted of approximately 300 tables and the application (a purchasing application) had about 300 users.

July 2001 TO Program Analyst

December 2001 MELE ASSOCIATES Inc. Washington, DC

As Program Analyst with the Department of Energy (DOE), Office of Energy Efficiency my duties are to plan, coordinate, and execute assigned projects, to work with the Project Manager to ensure that all goals, objectives, and time frames are met. To review and evaluate The BRUTIS budget management application. I had to conduct regular analyses of the application Functions, data elements, computer language, and operating systems. Maintain the BRUTIS 3.0 software system for DOE by utilizing Cold Fusion, SQL Server, and JAVA Script. To add user, assign user roles and permission, and add data as necessary.

EXPERIENCE

December 2000 TO Oracle Developer / DBA

July 2001 DSTI Inc. Rockville, MD

My duties at DSTI included the following Tasks while developing an Oracle Three Tier Application for the United States Marine Corps Inquiry Response System (IRS) Application, which was deployed on the World Wide Web. Under the direction to the Senior DBA/ Developer performed installation, upgrade, and maintenance of the database. Also at the database level installation of the Oracle RDMS with setup requirements, upgrade of the database from 8.1.6 to 8.1.7. . I assisted in the documentation and implementation of 24x7 Backup and Recovery strategies I implemented database cloning, Replication using RMAN, Replication manager and NET8 setup. Performance Tuning by planning and implementation of performance at different levels which included database querying, I/O using STATSPACK, UTLBSTAT, UTLESTAT, EXPLAIN PLAN, and TKPROF utilities. I performed user and Security management using Oracle Enterprise Manager and SQL Station. The creation of database objects (table spaces, tables, indexes, procedures, functions, triggers, views). Also migrated the database form Lotus to Oracle using migration tools, I used Oracle Designer 2000 to create application entities, and map relationships. I wrote application requirements and documentation. Oracle Forms and Reports – Used Oracle Forms and Reports, and WEB DB to create user interface screens and reports. I also wrote PL/SQL code to integrate the forms and reports into a client server application that was deployed on the Web using Apache Server and Oracle Reports server

Awards:

MERITORIOUS MAST, 1980

Certificate of Good Conduct, 1982

Sea Service Deployment Ribbon, 1983

McNeil Bolt, (Outstanding service Award) 1997

Certificate of Appreciation, ASSISTANT SECRETARY of Energy Efficiency & Renewable 1998

Assist. Secretary of Energy Efficiency & Renewable Energy Special Award, 1998

McNeil Bolt, (Outstanding service Award) 1998

McNeil bolt, (Outstanding service Award) 1999

Certificate Of Recognition DMI 2013

EDUCATION:

Strayer University APRIL, 1998 to present

Bachelor of SCIENCE DATABASE MANAGEMENT PROGRAM (part-time, ongoing)

Anteon Technical College 2000

Oracle Developer Certificate

Contact this candidate