Isaak Morales - Data Architect, BI Visions

Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app

Network Power<100 people

Roles

✔️100%

Geos

🇮🇳100%

India

Work Background

Lockheed MartinBusiness Intelligence Specialist

Dec. 2015United States

TRC Companies, Inc.Senior Data Architect

Dec. 2015

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.

MAXIMUSDatabase Administrator

Jul. 2013 - May. 2014Develops, implements, administers, and maintains policies and procedures for ensuring the security and integrity of the( National Polar Data Exploitation )NDE and Polar mission essential Database systems. Implements data models, database designs, data access and table maintenance. Resolves database performance and capacity issues, and replication and other distributed data issues  Database Administrator – Provide Oracle DBA support for multiple large databases in production, development, and test environments for various types of databases - RAC, Single Instance. Only Oracle DBA 2 mission critical databases. This included 2 production databases and 2 development/test databases. User are located all over . Databases were Oracle 7 and Oracle 11g and running on Linux 2.6. Sizes of databases varied from 50 to 100 GB. Following are some of the typical tasks carried out as part of database administration. Created new databases and users, setup RMAN backups, and export. o Implemented email notifications in Oracle Enterprise Manager that sends any issues in the database system. o Database backup and recovery. Used hot and cold backups. Involved in development of scripts to automate backup and recovery procedures for development databases. o Developed and implemented Oracle7 database fix to bring back down database server running on RAC environment. o Installed, upgraded and patched Oracle software and associated applications. o Provided primary administrative support for Oracle7 and Oracle11g databases in LINUX and HP Open VMS 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 tuning. Proactively monitored hit ratios on different components of the SGA. This included tuning of the shared pool, databases buffers and redo buffers.

Merchant Lynx ServicesAccount Executive

Dec. 2012 - Mar. 2013Annapolis, MDServed as key point-of-contact with credit card processing clients to manage accounts and maintain high levels of satisfaction. Collaborated at weekly team meetings focused on marketing strategies and tactics.  Instrumental member of high-performance team responsible for growing market share from zero to 8% within three months.

United States Air ForceDatabase Manager / Systems Administrator / Police Officer

Nov. 2002 - Nov. 2012Multiple LocationsEstablished track record of advancement, distinction, and outstanding performance within multifaceted military career. Communicated with senior dignitaries, colleagues, managers, and members of the community; coordinated planning and delivery of special projects. Assisted with procurement, evaluating equipment requests against budget and provided recommendations to leaders that were later implemented.  Database Manager (3 years) – Hand selected to oversee database operations for visitor center in Hawaii with accountability for performance management, SQL database analysis, and issue resolution. o Acted as designated project manager; created Oracle SQL database and related processes to track all visitors and print passes.  Systems Administrator (4 years) –Hand-picked to Design, develop, and implement new network system for Bolling Air Force Base. Removed viruses from computer workstations and remediated issues; troubleshot LAN problems.  Police Officer (10 years) –Protected individuals, property, and facilities; provided emergency response and mitigated potential threats. Maintained records, Excel spreadsheets, and statistical analyses. o Directly prevented the loss of $2M in assets and protected individuals during 3-year tenure with Investigations group. o Effectively led and supervised 40-member team and achieved 30% decrease in turnover and 10% increase in promotions. o Earned recognition as NCO of the Quarter for adeptly managing investigative reports and preparing accurate instructions and documents.