David John
Database Administrator at International Software Systems Inc- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
English -
Topline Score
Bio
Credentials
-
Oracle Certified Associate
Oracle
Experience
-
International Software Systems, Inc.
-
United States
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Database Administrator
-
Jul 2014 - Present
Maintain a High Availability Oracle Database System under the Linux Platform•Utilized RMAN to clone the database through active database and implemented active standby database for Data Guard•Performed database auditing and granted privileges to users through system object roles•Conducted OS Balancing and Tuning I/O by tracking tablespace and file system I/O statistics•Managed Redo log files in archive log mode for online backup•Installed, configured, and managed OEM (Oracle Enterprise Manager) for routine administration, database monitoring, replication process and performance tuning•Developed scripts for heath check alerts/database monitoring and database uptime/downtime status, and sizing issues using grid control (OEM)•Installed, configured, and maintained standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection•Implemented features of Oracle 11g such as Automatic Database Diagnostic Monitor (ADDM), and Automatic Workload Repository (AWR) for monitoring database performance•Installed, configured and managed 10g and 11g ASM storage
-
-
-
Jelani Consulting, LLC.
-
United States
-
Software Development
-
1 - 100 Employee
-
Database Administrator
-
2014 - 2016
• Extensive experience in Oracle 11g R2, 10g Database• Experienced in using 11g features Data pump, AWR, ASM, ADDM, Grip Monitoring and Oracle Enterprise Manager • Implementation of Oracle Backup and Recovery strategies usingRMAN ( Recovery Manager) •Responsible for Database maintenance, backup, recovery, patching, upgrades, performance turning and user access control • Extensive experience in Oracle 11g R2, 10g Database• Experienced in using 11g features Data pump, AWR, ASM, ADDM, Grip Monitoring and Oracle Enterprise Manager • Implementation of Oracle Backup and Recovery strategies usingRMAN ( Recovery Manager) •Responsible for Database maintenance, backup, recovery, patching, upgrades, performance turning and user access control
-
-
-
U.S. Department of Homeland Security
-
Government Administration
-
700 & Above Employee
-
Database Administrator
-
Apr 2010 - Jun 2014
•Configured the necessary parameters for Flashback database settings and Flash Recovery Area, then used RMAN to issue Flash Recovery Commands•Implemented Flashback technology of Oracle 11g, 10g along with Recycle bin for quick recovery of the databases and database objects•Created database packages, procedures, functions, triggers, views, materialized views using Oracle PL/SQL•Maintained database schemas and dictionaries utilizing knowledge of Data Dictionary Language (DDL) and Data Manipulation Language (DML) tools, and conducted PL/SQL scripting and coding•Restored schema objects for database users utilizing logical backup•Resolved database issues such as fragmentation and table space sizing. •Collaborated with development team in database performance issues and with systems administrators to setup storage requirements•Performed user management, creation, monitoring and management of database users, altering passwords of users and granting and revoking system/object privileges, roles, auditing user actions in the database•Assisted database developers and end-users with on-call 24x7 remote support•Ensured daily RMAN backups were completed and valid for restore and recovery•Monitored tablespace growth and expanded tablespaces through resizing and added data files
-
-
-
US Navy
-
United States
-
Armed Forces
-
700 & Above Employee
-
Operations specialists
-
Jul 2002 - Apr 2006
• Operate a variety of computer-interfaced detection, tracking and height-finding radars• Plot a ship's position, heading, and speed, using computerized or manual trigonometric methods• Maintain a tactical picture of the surrounding seas by plotting and maintaining a visual representation of ships, submarines and aircraft in the area, including friendly, neutral, hostile and civilian contacts• Use secure and non-secure radio in communicating, in plain voice or coded signals, with other air, sea or land units to coordinate tactical and combat evolution• Operate common marine electronic navigation instruments including radar and satellite systems, plot own ship's position and movement on charts and make recommendations in navigation to the officer of the deck• Provide target plotting data to the command and control based on information received from target tracking devices• Make recommendations to command and control regarding tactical and combat procedures• Assist in the coordination and control of landing craft during amphibious assaults• Communicate with spotters, plot and make calculations to adjust fire during naval gunfire support missions
-
-
Education
-
University of Maryland Global Campus
Cyber/Electronic Operations and Warfare