Lockheed MartinMulti Fuction Information System Analyst
May. 2015Manassas VADevelops implements, administers, and maintains policies and procedures for ensuring the security and integrity of the NOVEC mission essential Database systems. Implements data models, database designs, data access, oracle database installations, ASM Installations and configurations RMAN configurations, disaster recovery and table maintenance. Resolves database performance and capacity issues, and replication and other distributed data issues. Data Designer with experience with developing databases systems. o Implemented and designed centralized DR solution for database systems and application systems in the NOVEC environment
o Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures. o Provided Backup a new backup strategies for all database systems to fix database inconsistencies and performance issues.
o Main point of contact for all new database upgrades and patches. Ensuring disaster recovery has been implemented in all database systems
o Provided primary administrative support for Oracle10g and Oracle11g databases in LINUX and HP-UX, and Windows environments.
o Defragmentation of tables and indexes for improved performance and effective space management.
o Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
o Database server and SQL tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.
o Developed efficient code and making efficient use of the resources leading to better performance and optimization
o Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.