Malcolm Smith
Bowie
Summary
Self-motivated and proactive working professional with a proven record of accomplishments in various Information Technology (IT) disciplines. Leadership in team-oriented environments with project-based strategies in support of commercial and federal agency, IT goals and objectives. Currently serves as a specialist within IT Systems Engineering and Cyber Security fields.
Overview
19
19
years of professional experience
Work History
IT Infrastructure Lead-Senior Database Administrator
Great Hill Solutions
Chantilly
07.2023 - 07.2025
- Company Overview: US Department of State, Bureau of Department Technology, Portfolio Management Division
- Systems and Database Administration for Oracle Primavera Portfolio Management
- Support system back-end architecture upgrades and optimization
- Tunes operating system performance parameters, including installing patches, drivers, and mid-tier components to optimize OPPM system performance
- Provides Oracle database administration, backup and disaster recovery solutions
- Monitors database health and remediates problems that could compromise the performance or functionality of the application's environment.
- Serves as the subject matter expert on providing solutions to increase the performance of the application and database functionality.
- US Department of State, Bureau of Department Technology, Portfolio Management Division
IT Infrastructure Lead-Senior Database Administrator
Richard S. Carson & Associates
Bethesda
04.2013 - 07.2023
- Company Overview: US Department of State, Bureau of Information Resource Management, Portfolio Management Division
- Systems and Database Administration for Oracle Primavera Portfolio Management
- Support system back-end architecture upgrades and optimization
- Tunes operating system performance parameters, including installing patches, drivers, and mid-tier components to optimize OPPM system performance
- Provides Oracle database administration, backup and disaster recovery solutions
- Monitors database health and remediates problems that could compromise the performance or functionality of the application's environment.
- Serves as the subject matter expert on providing solutions to increase the performance of the application and database functionality.
- Ensures that the OPPM system complies with all Department of State security policies, FISMA regulations, and adheres to the NIST 800-53 federal publication
- Complete performance tuning, usage trending and analysis for pre-emptive maintenance and growth of the OPPM system
- Explores system to system data integration possibilities with other customers within the Department of State.
- Develops and updates contingency and security plans to ensure continuous availability and accessibility of server resources in the event of an unplanned incident or disaster.
- Develop change management processes and documentation to ensure proper deployment of the OPPM application.
- Serves as the project manager and data custodian to the State Departments Authorization To Operate accreditation process for the Enterprise Portfolio Management application Integrated Management Analytics Technology Resource Information Exchange (iMATRIX). (Years 2013, 2017, and 2023)
- US Department of State, Bureau of Information Resource Management, Portfolio Management Division
Senior Systems Analyst/Deputy Team Lead
Test Pros, Inc.
Sterling
03.2011 - 03.2013
- Company Overview: US Department of State, Bureau of Consular Affairs, Office of Consular Systems and Technology
- Software and Systems Testing and Validation
- Conducted ASP.Net, Java, and MS SQL code reviews for US Department of State in house proprietary applications
- Conducted automation testing and scripting for US Department of State 508 compliant applications
- Database Administration, Engineering, and Testing for SQL Server and Oracle Enterprise Database
- Developed, tested, and deployed database transactional components (Triggers, Stored Procedures, Jobs, etc.) for mid-tier and backend data processing environments
- Active Directory Administration for the System Integration and Testing Environment (SITE) Lab
- Administered group policies, managed AD objects, and conducted AD permissions management for the SITE Lab AD Object Forest.
- Managed and monitored the SITE Lab environment using Windows Server Monitor and VMware ESXi Server.
- Technical Writing and Code review
- Developed and generated software test reports
- Conducted technical reviews of software requirements
- US Department of State, Bureau of Consular Affairs, Office of Consular Systems and Technology
Counter Intelligence Agent/In-store Tech
Geek Squad / Best Buy
Charlotte, NC
03.2007 - 03.2011
- Provided Customer Service and In-Store tech support for customers computer hardware needs
- Completed system, software, and hardware upgrades to personal computers and network devices.
- Performed virus eradication, system recovery, and data migration services for customer owned systems
STA+ Program Manager/Systems Administrator
JCSU STA+
Charlotte
03.2006 - 03.2010
- Served as the Student Technician Program Manager and managed a team of 22 Help Desk Technicians.
- Provided technical support for configuration, installation, problem isolation, and problem resolution of campus servers, Cisco switches, and routers, and client side computers
- Implemented and maintained Access Control Lists on Cisco Routers, monitoring TCP/IP traffic on the campuses intranet.
- Provided patch management for all campus network devices and computer systems.
Education
B.S. - Computer Engineering
Johnson C. Smith University
05.2010
Skills
- Microsoft Windows Operating Systems
- Linux Distributions
- Enterprise Database Platforms
- VMware virtualization platform
- System Administration Tools
- Cloud storage technologies
- Net Framework development
- Oracle Business Tools
- NIST compliance
- Oracle database administration
- System performance tuning
- Backup and disaster recovery
- Database health monitoring
- Change management
- Data integration
- Technical documentation
- Security compliance
- Project management
- Analytical thinking
- Problem solving
- Effective communication
- Team collaboration
- Technical training
- Automated database testing
- Database development
- High availability solutions
- Data audits
- Implementing security measures
- Database schema design
- Query execution plans
- Documentation and reporting
- Data modeling techniques
- Information systems management
- Cloud database management
- Microsoft powershell
- Python
- Data integration strategies
- Compiling data
- Data migration techniques
- Database analysis
- Relational database management
- Backup and recovery strategies
- Disaster recovery planning
- Vendor relationship management
- Microsoft NET framework
- Resource utilization analysis
- Data testing
- SQL query optimization
- Continuous integration and deployment
- Data privacy compliance
- Big data technologies
- Writing queries
- Running backups
- Indexing and partitioning
- Apache tomcat
- Agile methodology
- Database troubleshooting
- Database security management
- Capacity planning and scaling
- Linux operating system
- Database version control
- Cross-platform database support
- Coding data
- Customer needs assessment
- Database administration
- Microsoft visual C#NET
- Database performance tuning
- Systems administration
- Performance monitoring tools
- Data warehousing solutions
- Multitasking
- Data recovery
- Team building
- Teamwork and collaboration
- System analysis
- Active listening
- Problem-solving abilities
- SQL programming
- Performance tuning
Security Clearance
Active Secret-eligible for TS/SCI
Timeline
IT Infrastructure Lead-Senior Database Administrator
Great Hill Solutions
07.2023 - 07.2025
IT Infrastructure Lead-Senior Database Administrator
Richard S. Carson & Associates
04.2013 - 07.2023
Senior Systems Analyst/Deputy Team Lead
Test Pros, Inc.
03.2011 - 03.2013
Counter Intelligence Agent/In-store Tech
Geek Squad / Best Buy
03.2007 - 03.2011
STA+ Program Manager/Systems Administrator
JCSU STA+
03.2006 - 03.2010
B.S. - Computer Engineering
Johnson C. Smith University