Objective

To obtain a position as a Database Administrator or Database Developer.

Experience:

Confidential

Oracle Database Administrator

• Current Secret clearance from the Department of Defense.
• Maintain IAT Level II compliance for Department of Defense Directive 8570.
• Implement DoD/DISA Security Technical Implementation Guide STIG requirements across multiple different Oracle database environments with all environments passing approval process.
• Support Database Administration and Development on various RDBMS, TripleStore, and NOSQL Database Systems to include Oracle 10g/11g/12c, Sybase, Cassandra, Allegrograph, and Microsoft SQL Server for the Army Training Information Architecture ATIA .
• Manage all Oracle 12c, 11g, and 10g database management systems running on AIX UNIX and RedHat Linux operating systems.
• Maintain and manage Apache Cassandra database cluster using DataStax OpsCenter Community Edition software for the ATIA CAR-RS project.
• Responsible for managing/maintaining all ATIA'S MongoDB database servers along with providing oversight on the architecture, production replica sets, and production deployments.
• Monitor all MongoDB Enterprise edition databases for capacity usage and performance to include troubleshooting support if needed using MongoDB's MMS console.
• Manage and maintain the Allegrograph TripleStore database for ATIA.
• Maintain Oracle 12c Grid Control running WebLogic Server 12c Enterprise Edition.
• Upgrade older Oracle 10g environment to Oracle 11g R2, and to 12c.
• Performed backup and recovery via Recovery Manager RMAN , RMAN Catalog, and Oracle Data-pump to include automating all backup systems and maintain all System's Operating Procedures SOP for all ATIA related databases.
• Implement shell scripting with CRON jobs, along with write PL/SQL procedures that are called in Oracle's job scheduler to automate database maintenance task.
• Control access permissions and privileges.
• Implement all current Oracle Critical Patch Updates CPUs .
• Write database documentation, data standards, procedures and definitions.
• Supported database schema and data related change requests for the Army Training Information Architecture ATIA , and Student Information Services SIS databases.
• Ensure all ATIA related database systems are, and remain, SECURITY TECHNICAL IMPLEMENTATION GUIDE STIG compliant.
• Assisted in migrating older ARMY training legacy systems from Microsoft SQL Server over to Oracle 11g database software and documenting the business logic and database code.

Confidential

Oracle Database Analyst

• Current Secret clearance from the Department of Defense.
• Manage the database management system DBMS Oracle 11g 10g running on Hp UNIX and Red Hat Linux operating systems for the United States Coast Guard and TSA Financial Systems. Maintained current Secret clearance from the Department of Defense.
• Three month contract for the Coast Guard and TSA Financial Systems.
• Manage all Oracle Business Intelligence systems OBIEE for TSA financial to include Oracle Application Server, Oracle Discoverer, Oracle Portal, Oracle Forms, Oracle Application Express APEX , Weblogic, and Oracle Fusion Middleware products.
• Leads database integration efforts, focusing on movement and control of database information as systems are transitioned onto secure development enclave.
• Responsible for maintaining all database servers and for initial setup of database systems on new enclave, consisting of both Oracle databases and Oracle BI servers.
• Upgrade older Oracle 10g environment to Oracle 11g R2.
• Performed backup and recovery via Recovery Manager RMAN and Oracle Data-pump.
• Upgrade older Oracle BI environment to Oracle Fusion Middleware 11g and Weblogic.
• Refine the database physical design to meet system storage requirements.
• Install and test new versions of the database management system DBMS .
• Developing, managing and testing backup and recovery plans.
• Control access permissions and privileges.
• Plan, coordinate and implement security measures to safeguard information exchanging between other organizations and protecting electronic data files against accidental or unauthorized damage, modification or disclosure.
• Implement all current Oracle Critical Patch Updates CPUs .
• Coordinate with technical and applications staff to ensure database integrity and security.
• Write database documentation, data standards, procedures and definitions for the data dictionary metadata .
• Consult with testing business systems analysts to define system specifications.

Confidential

Oracle Database Developer Database Administrator

• Current Secret clearance from the Department of Defense.
• Manage the database management system DBMS Oracle 11g 10g, MS SQL Server.
• Support, modify, and expand data schemas in accordance with government data storage standards and defined functional requirements.
• Write stored procedures, triggers and SSIS packages.
• Write queries to support business needs.
• Performed backup and recovery via Recovery Manager RMAN and Oracle Data-pump.
• Refine the database 'physical design' to meet system storage requirements.
• Install and test new versions of the database management system DBMS .
• Developing, managing and testing backup and recovery plans.
• Control access permissions and privileges.
• Plan, coordinate and implement security measures to safeguard information exchanging between other organizations and protecting electronic data files against accidental or unauthorized damage, modification or disclosure.
• Coordinate with technical and applications staff to ensure database integrity and security.
• Perform critical data analysis and generate ad-hoc report.
• Write database documentation, data standards, procedures and definitions for the data dictionary 'metadata' .
• Consult with testing business systems analysts to define system specifications.
• Document functional and technical design specifications from user requirements.
• Develop and provide management status briefings.
• Provide platform integration support meta data .
• Consult with subject matter experts SMEs in Joint Air Missile Defense JAMD domain on data harmonization.
• Coordinate with SMEs on meeting dates, scope of work and deliverables.
• Research and analyze JAMD related documents and material for applicability in domain.
• Provide support as needed to JAN-TE COI MADL .
• Develop and provide management status briefings.

Confidential

Oracle Database Developer Database Administrator

• Current Secret clearance from the Department of Defense.
• Maintains all databases for WEBCOP, a lite weight version of COP.
• Maintains NVMS, Blue Force Tracking, and LRIT data feeds from WEBCOP into the Maritime Domain Awareness COP picture.
• Performed backup and recovery via Recovery Manager RMAN .
• Responsible for applying all Oracle Critical Patch Updates to development and production databases.
• Responsible for providing day-to-day support and maintenance for key Oracle 10g databases and services of our enterprise application platform for the US Coast Guard.
• Worked on installation, configuration, deployment, testing, monitoring and repair of ESRI's server products: ArcSDE, ArcGIS Server, ArcGIS Image Server, ArcIMS.
• Experience with the installation, configuration, deployment, testing, monitoring and repair of Oracle 10g, and fluency with PL/SQL in a GEO1Spatial database environment.
• Configure and upgrade Oracle 10g server software running on Sun Solaris 10 and Windows 2003 servers.
• Stand up and maintained GEOSpatial databases to receive data from an ESRI Tracking Server.
• Setup and monitor Oracle Streams across four different Oracle databases.
• Monitor database events and pro-actively optimize system performance by tuning the databases.
• Experience developing backup strategies and planning data storage.
• Worked on documenting and building physical database environments from table, column, index and view definitions to storage requirements and drive spacing and growth accommodations.
• Work with the team to automate reactive procedures where possible, and to promote rapid response to known issues in a production environment.
• Accountable for maintaining database configurations in compliance with established DOD and US Coast Guard regulations.

Confidential

Systems Administrator

• Worked for the Army's Distributed Learning System DLS project.
• Monitor and respond to the DLS network and servers through Tivoli Netview.
• Help trouble-shoot issues with Microsoft Exchange servers.
• Support the remote diagnosis of LAN- and system-related problems.
• Perform checks and maintenance on all Windows servers.
• Setup and manage user accounts through Active Directory.
• Worked with Hyena software tools to run scripts and manage accounts.
• Documents and logs all problem reports from customers into a trouble ticket/incident reporting system Remedy database to facilitate tracking, work flow management, escalation, and resolution.
• Responsible for trouble-shooting all WANs, LANS, TCP/IP, Windows NT 4/2000/2003 Servers Windows 2000/XP workstations, Unix OS Solaris , VPN devices, Routers, Switches, Hubs, Firewalls, Tape Backup processes, and Tivoli Product Suite.

Confidential

Systems Administrator

• Six month contract for the Navy.
• Worked for the Navy's NEMAIS project.
• Responsible for installing and trouble-shooting all Oracle software with SAP.
• Responsible for installing and trouble-shooting all SAP and Quick Test software.
• Spoke directly to SAP representatives for employer about all SAP support and licenses.
• Monitor and respond to the NEMAIS network and servers through Tivoli Netview.
• Maintain large server farm for the Navy's NEMAIS project.
• Help trouble-shoot issues with Microsoft Exchange servers.
• Perform daily Sun, Oracle, and UNIX checks on servers.
• Perform various backups and trouble-shoot if any backup errors occur.
• Perform checks on all Windows ftp and print servers.
• Perform checks and maintenance on all Windows servers.
• Maintain and log all trouble calls into a Remedy database.
• Setup and manage user account through Active Directory.
• Maintains disaster recovery procedures for LAN and related equipment/software. Performs system backup and recovery activities.
• Maintain and operate Symantec GhostCast Server.
• Remote into users machines using TIVOLI and Windows Netmeeting to solve computer issues.

Confidential

Database Administrator

• Maintained OS-390 mainframe system, and maintained NT system with over 125 stations and 250 users.
• Configure and upgrade Oracle 9 server software running on Sun Solaris and Windows servers.
• Created datasets and JCL program code.
• Develop and maintain an in depth understanding of the database architecture and the general application functionality used to maintain data integrity.
• Performed routine backups on all systems.

Languages

Oracle 10g, 11g, SQL, PL/SQL, Sybase ASE 15.0, IBM OS-390, ISPF, TSO, JISII, JCL, SAP, Quick Test, Windows XP, Windows 2003 2008, Red Hat Linux, Ubuntu Linux, SUSE Enterprise Desktop, UNIX, Sun Solaris, Linux Systems, Microsoft Word, Access,Excel, Front Page, Outlook, Access, and Excel.