02/01/2023 updated

MR
100 % available

Database SME, Performance Specialist, Manager of Database Development, Senior Operations Manager

USA
Only remote
BS in IT Management and Cybersecurity
USA
Only remote
BS in IT Management and Cybersecurity

Profile attachments

CV - Michael Robison

Testing (Software)ASP.NETC (Programming Language)HTMLJava (Programming Language).NET FrameworkPHPComputer AnimationMicrosoft WindowsAdobe AcrobatActive DirectoryAdobe IllustratorAdobe PhotoshopAdobe PageMakerIBM AIXAjax (Programming Language)Amazon Web ServicesAnalytic ApplicationsData AnalysisApache HTTP ServerServer ApplicationApple IOSSoftware ApplicationsAtlassian JiraAuthenticationsMicrosoft AzureBaseliningBig DataBusiness Process ModelingC Sharp (Programming Language)UnixC++ (Programming Language)Cloud ComputingApache ImpalaCluster AnalysisProfilingCode ReviewComputer SecurityComputer MaintenanceDatabasesNovell NetWareSAP Crystal ReportsData TransmissionsData DictionaryData GovernanceData IntegrityInformation Leak PreventionExtract Transform Load (ETL)Data WarehousingIBM DB2Database AnalysisDatabase ApplicationRelational DatabasesDatabase DevelopmentDatabase SecurityOracle Data GuardDBaseLinuxOracle DiscovererFile SystemsDistributed Data StoreMicrosoft Dynamics CRME-BusinessPerl (Programming Language)Java Platform Enterprise Edition (J2EE)FoxProR (Programming Language)Google AnalyticsApache HadoopApache HiveIBM Cognos Business IntelligenceInternet Information Services (IIS)IT ManagementWeb PortalsIPv6Virtual Private Networks (VPN)Java Virtual Machine (JVM)JDeveloperPython (Programming Language)Kerberos (Protocol)Lightweight Directory Access Protocols (LDAP)PostgreSQLLoad TestingLog ShippingLogical SecurityMATLABMicrosoft Visual StudioMicrosoft ProjectMicrosoft PublisherMicrosoft VisioMicrosoft SoftwaresMicrosoft SQL ServersWindows ServersMicroStrategyMongoDBMySQLNetwork DiagnosticsNetwork EngineeringOracle Business Intelligence Enterprise EditionOnline Transaction ProcessingOperational DatabasesOracle DatabasesOracle ApplicationsOracle FormsOracle Warehouse BuilderPlatform As A Service (PAAS)Performance TuningScrum MethodologySystems Development Life CycleQuantum ComputingQuickBooks (Software)Red Hat Enterprise LinuxMicrosoft Power BIReverse EngineeringSAS (Software)SeleniumMicrosoft SharePointSiebel CRMSingle Sign-OnSmart CardsSoftware EngineeringPL-SQLSQL DatabasesDatabase EnginesData StreamingSalesforce TableauTCP/IPTeradata SQLTransact-SQLVMware InfrastructureVulnerability AssessmentWeb PagesExtensible Markup Language (XML)SymantecData/Record LoggingWebinspectOracle HyperionGrid Packaging TechologyCyberarkNetezzaSystem AvailabilityApache SparkSybaseSoftware TroubleshootingEr-WinBackendInformation TechnologyVba Programming LanguagePerformance MonitorToad (Software)NessusWikis3-tier ArchitecturesOracle EbusinessSplunkNetwork ServerMultiplatformQualysHardware DebuggingServicenowVMwareOracledb
.Net, Tier 3, ASP, ASP.NET, active directory, Adobe Acrobat, Illustrator, PageMaker, Photoshop, AJAX, AWS, Apache, Hadoop, Hive, Spark, MacOS, backend, back-end, Baseline, Big Data, analytic applications, streamline processes, C, C#, C++, Cloud, Impala, Clustering, code review, Animation, Computer Repair, cybersecurity, Crystal Reports, CyberArk, dBase, analytics, data analysis, data dictionary, Data Governance, Data Integrity, Logging, data flow, data transfer, data warehouses, Database Analyst, database application, Database Development, database engines, Database Security, Database, Databases, distributed database, E-Business, ERwin, XML, data loading, ETL, file storage, FoxPro, Google Analytics, Grid control, HTML, Hardware repair, AIX, Cognos, DB2, IPv6, IT Management, Data Loss Prevention, Computer Science, IIS, JDeveloper, Jira, Java, J2EE, JVM, Kerberos, LDAP, Linux, load testing, Log Shipping, Logical Security, Matlab, Microstrategy, Access, Azure, MS Dynamics, Office97, MS Project, Office project, Publisher, MSSQL Server, MSSQL, MS-SQL, SQL Server, SharePoint, Microsoft stack, Visio, Visual Studio 2008, Windows, Win2000, WinNT, MongoDB, multi-platform, MySQL, Nessus, Netezza, Network Diagnostics, network engineer, servers, NetWare, OLTP, production database, Oracle, Oracle tools, OBIEE, Oracle Business Intelligence Enterprise Edition, Dataguard, 9i, Oracle 9i, Oracle 11i, Oracle 10g, Discoverer, Oracle E-business suite, Oracle E-business, Oracle Forms, Hyperion, Oracle Warehouse Builder, Oracle DB, PHP, PL/SQL, performance reporting, performance monitoring tools, performance tuning, performance optimization, Perl, PaaS, PostgreSQL, Power BI, Profiler, Python, Qualys, Quantum Computing, QuickBooks, R, RHEL, Red Hat Enterprise Linux, RedHat, RDBMSs, RDBMS, reverse engineer, SAS, SQL, Scrum, Selenium, App Server, ServiceNow, Siebel, Single Sign On, smart cards, Computer Applications, software release, Software Development, software troubleshooting, Splunk, Sybase, Symantec, high availability, SDLC, TCP/IP, Tableau, Teradata, Software Testing, Toad, T-SQL, Unix, authentication, VMware infrastructure, Visual Basic, VBA, VPN, VMware, Vulnerability Assessment, Webpage, web GUI, WebInspect, wiki, Windows servers, Windows 2003

Experience

Professional experience10+ years

Languages

EnglishNative speakerFrenchGoodSpanishGood

Project history

Database SME, Performance Specialist

DEPARTMENT OF JUSTICE (COPS)
Long-term position on a long-time contract for the office of Community Oriented Policing Systems
(COPS) at DOJ. Optimize capacity and performance for COPS and acted as Infrastructure Manager. Also
Security Coordinator and Build Master. SME of databases and interaction of multiple environment
layers (NW, HW, OS, DB, App & Web). Load-test, performance tuning and optimization on softwares &
underlying platform, analyzing at a granular level to prevent a high-volume malfunction, like the
Obamacare software release scenario. Software is on a Microsoft stack with C# frontend and MSSQL
backend using dynamic XML to render interactive pages on a VMware infrastructure. Created a
real-time auditing tool with no performance impact like tracing, to observe workflow and data flow.
Drill down and analyze software dynamics to resolve bottlenecks, errors and fine-tune resources to
Best Practices standards. Mentor staff on platform mechanics and T-SQL capabilities and performance
impact. Plan & executed developer systems upgrades. Present findings and issues to client executives
and coordinate resolution with other technical departments. Recommend structure, software and
environ improvements to increase efficiency. Coordinate security audits, DLP and document technical
specs. Implement and execute security probe software and analyze results per DHS mandate and DOJ
criteria. Advise client on cloud aspects and VMware performance. Advise on new hardware purchases.

Senior Technical Advisor, Database Specialist (VLDB, Performance)

DEKATRON
Consulting position with a contracting firm with various projects within the nation, mostly
specializing in federal government environments. Utilized as CTO and acting Director of Engineering,
reporting to the Senior VP. Advisor & SME of IT and electronic industries for the company to allow
executives and staff to leverage knowledge for current and potential contracts and aspects of the
technologies executed within. Evaluating specifications for projects and determining current IT
dynamics and environment. Recommend technical staffing for major projects and role compensation.
Functional area analyst of internal and outside projects to reverse engineer then redesign &
optimize environments. Evaluate softwares to be utilized by the firm and its cost-effectiveness.
Recommend best practices for large-scale database platforms and performance optimization (MSSQL,
Oracle, DB2, Netezza, Teradata).

Senior Database Administrator, Lead (VLDB specialist)

DEPARTMENT OF TREASURY (OFR)
Short-term contract, as Lead DBA for SCI at Treasury - Office of Financial Research (OFR) a new
office with a mission to help very large global financial entities in risk management and prevent
adverse conditions. Maintaining the databases which focus on large-scale data analysis. Subject
Matter Expert (SME) on Big Data platforms to recommend best practices for the environment and
provide database QA for organization and management. The environment is at Terabyte scale and
prepping for Petabyte scale. Uses platforms as MSSQL 2012 and 2014, Hadoop (Hive & Impala),
PostgreSQL, MySQL, SAS and more. Execute changes, troubleshoot long-running issues and mentor staff
on VLDB setup, config and maintenance. Advise on security and auditing. Create processes and
reporting for real-time performance stats and tuning. Resolve issues Kerberos authentication with DB
server links in a multi-domain high-security environment. Enhance processes for automation and
standardization. Knowledge transfer on real-time low-impact customized tracing utility.

Senior Technical Project Manager

BALTIMORE COUNTY PUBLIC SCHOOLS (BPCS)
Short-term contract, as Project Manager for BCPS...a local government entity with a $1.3 billion
annual budget and 20,000+ staff. Running two projects of some complexity...first, the Dept-Unit
project to resolve long ongoing issues technical issues and coordinate synchronization of
Organizational fields and datasets for their CGI Advantage ERP software between various office roles
and department focus (HR, IT & Finance). Next, the Data Integrity project which addresses issues
occurring between many BCPS interconnected systems and resolution for a variety of complex scenarios
as needed. Participated in the Data Governance group which is to assist in standardizing data
definitions, processes and protocols across the entire entity. Advised C-level executives and other
management on various technical and organizational improvements including auditing, software
improvements for custom situations, techniques and standardization

Manager of Database Development

TRI-COR INDUSTRIES
Long-term position with an established federal contracting firm with projects throughout the nation.
Utilized as the equivalent of Director of Software Development and CTO, reporting to the CEO.
Advisor & SME of IT industries for the company to allow business development to have more knowledge
of current and potential contracts and other aspects of the technologies utilized. Primary software
POC either resolves items or delegating to others, as necessary. Make the company more contemporary,
originating new ideas & approaches to leverage technology. Coordinated, finalized and maintain the
new company website and LinkedIn page. Researched & coordinated upgrade of Deltek Costpoint
financial systems into contemporary flexible ERP software, MS Dynamics NAV with modified for Federal
Government Contractors unifying all administrative applications to track activity from A to Z and
allow intuitive integrated use and dynamic distributed environ for the staff nationwide at various
locations and projects. Benefit-cost analysis of softwares & usage. Analysis of company
cybersecurity standards and status, investigated the implementation of file-level DLP softwares to
apply to all company systems. Substituted for IT manager/network engineer when out of office.

DBA/Developer, Performance Specialist

BATES WHITE
Short-term contract doing large-scale data loading and performance tuning & optimization of MSSQL
2008 R2/2012 environment on VM/SAN with fiber bus for economic analysis client for specific cases.
Environ scales up to 1 petabyte, with various databases tuned and import loads up to multiple
terabytes. Recommend various solutions to increase performance and reliability. Optimized code with
embedded T-SQL. Mentored analysts on how to increase performance on their statements and
interactions against their "big data" sources.

Senior Operations Manager

MERKLE
Long-term position managing production operations of various clients' customer relationship
marketing (CRM) platforms and processes. Also managed several other operation analysts in their
capacity serving other clients' solution platforms and execute various initiatives for the
Technology Solutions Group (TSG). Platforms are on MSSQL (2005/2008), Netezza and Teradata on Linux
and Windows servers. Primary contracts are for Nike, Clorox & Urban Outfitters. Most solutions'
requirements are 24/7 monitoring with data warehouses easily reaching 30+ TB. Team interactions with
various staff over Boston, Little Rock, Denver, Shanghai China and more. Working on optimizing
performance on data warehouses and related processes to significantly reduce daily and weekly
production runtimes, including advising staff on performance techniques and workflow auditing.
Redesigned production calendars to be intuitive and comprehensive and production alert listings with
expected production times and related protocol. Automate and streamline processes if possible,
including data/file storage management. Updating and organizing documentation with emphasis on more
intuitive formatting. Troubleshoot and triage processes that may disrupt production or load
incorrect data. Created presentations for an internal operations audit with details on daily/weekly
processes and their challenges. Trained staff on SQL/DB material and mentored on soft skills for
management and communications. Initiating security reviews to fill potential holes. Assist other
client projects with business analysis, optimization, capacity planning and documenting. Monitoring
activity with various applications including Tidal, Informatica, Microstrategy and SAS. Working with
other managers to improve workload, capabilities, productivity, quality assurance and potential
growth within the company, including efforts to diligently resolve any negative matters
**On-call 24/7

EXECUTIVE OFFICE OF THE PRESIDENT (OMB)

DELL
Special Project as Dell's team lead on an augmentation project for the FY2011 budget managing all
databases for the White House's budget department. Platforms are on DB2 LUW (9.5, 9.7) on Linux RHEL
and AIX servers in an environment with Federation, Replication, HADR and Single Sign On. Also
brought in as SME for alternative platforms including Oracle, MSSQL, MySQL, Access, etc. Maintaining
and improving 2 core environments for nationwide use for all government agencies of complex, layered
and often legacy design, including being an SME resource for senior developers supporting many apps
working against these backends. The group comprises of 6 DBAs. Optimize performance on SQL for
underlying objects for websites and interfaces for both internal and national use. Created a new
methodology and design for partitioning fast-growth large LOB tables for improved backup and COOP
dynamics and implemented it on the EOP wiki.
On several special projects including increasing security, capacity planning, user handling, DB
cleanup and client auditing. Built a new testing environment and documented up-to-date methods and
scripts. Advised as SME on Oracle 11gR2 to DB2 9.7 migration and PL/SQL conversion and executed
migration on Linux RHEL server. Executed security reviews for Presidential Records Act (PRA)
notation within EOP wiki. Advised on the setup of enhanced security protocols and methods, including
expanding auditing practices. Also monitored DB activity and performance with DB2 control, Toad and
Quest Spotlight. Remote work is done periodically.
**On call 24/7, including vacations

Senior Database Developer and International Office IT subject matter expert

NATIONAL WEATHER SERVICE (NOAA)
Infinity Digital)
Periodic contract did telecommuting, designing and developing database application to track and
report on projects, their status, employees and related contractors for the HOSIP branch of NOAA.
Customized to staff specifications. Business analysis to translate science project workflows to
ease-of-use forms for staff. Fully automated Access app setup to be shared across a broad network
with granular security setup through Access workgroup utility. Developed utility to allow user and
record auditing and created an advanced querying filter for forms and reports.
Also 2nd role and contract as SME for an NOAA International Office project. Includes being an IT
resource for telecommunications, networking, development and database-related matters for project
managers and scientists setting up a global early warning application. The project includes
interaction with many nations worldwide and being SME for their networking and communications setup
also.

Senior Database Administrator/Team Lead/Consultant

U.S. MINT/LOCKHEED MARTIN
Long-term position managing and supervising all databases and DBA group for Lockheed Martin at the
U.S. Mint. Platforms are on Oracle (9i and 10g), MSSQL (2000, 2005 and 2008) and Access on
Linux/RedHat and Windows servers in an environment with clustering (both Oracle and MSSQL), SAN and
VMware. The primary contract is in Mint headquarters in D.C. and maintaining 19 core environments
nationwide, including being an SME resource for Philadelphia, Denver, San Francisco, West Point and
Fort Knox. The group comprises of 5 various database SMEs. Optimize performance on websites and
interfaces for both internal and global use. Designed IT asset tracking database and methodology for
the asset renewal project. Lockheed IT SME for Mint Data Loss Prevention project and in charge of
database security protocols and defining compliance validations. Automate and streamline processes.
Capacity planning for ARC project including Oracle E-business suite and Financials. Advised on
E-Business suite optimization and troubleshot issues, especially on the OTM component. Implemented
Siebel/Hyperion BI platform (aka OBIEE, Oracle Business Intelligence Enterprise Edition) in
conjunction with Deloitte consulting group and set up security protocols and interactions with
Oracle DB and App Server, maintained and troubleshot platform after the fact. Enhanced backend
security protocol and techniques, setting up auditing, C2 audit, trace reporting and vulnerability
probes with 3rd party apps to set baseline security standards, best practices and documenting
exceptions to government, CIS and NIST standards. Also monitored DB activity and performance with
Oracle Grid control and Quest Spotlight.
**On call 24/7, including vacations

Performance Analyst

CACI
Short-term contract doing performance tuning U.S. Air Force IDECS budgeting application with MS-SQL
2005 back-end and ASP.NET front-end with AJAX and C# through Visual Studio 2008. Analyzed database
activity with real-time performance monitoring tools like Profiler, DTA and Spotlight, also
including dictionary review and ad-hoc performance reports. Resolved long-term front-end issue with
.NET AJAX control toolkit significant. Analyzed both front-end and back-end code for structural
issues, redundancy and other performance affecting aspects and refactored objects for performance,
as necessary. Mentored staff on efficient database interaction with SME knowledge, including an
in-person seminar at the end with the whole development team to train in-depth on noted issues and a
Q&A session on principles for T-SQL performance and database dynamics.

Database Manager of Americas Region

OBERTHUR TECHNOLOGIES
Long-term position managing and supervising all databases and DBA group for Oberthur in North
America and South America. Oberthur Technologies is an international firm specializing in the
manufacturing and personalization of credit cards, smart cards and identification cards. The region
includes large-scale manufacturing plants and offices throughout the 2 continents. The environment
maintained is mainly Windows based, however, includes some UNIX (Sun), Linux and other OS's. The
distributed database platforms include 15+ Oracle (8i, 9i, 10g, 11g) servers, 50+ MS-SQL servers (7,
2000, 2005, 2008), DB2, Access and other varieties of RDBMSs totaling 100+ TB and individual
platforms multiple TB+. The instances number into the hundreds and up to Terabyte size and are
accessed 24/7 internationally by clients including both corporate and government entities. All
database-related matters were dealt with initially by own office to be handled by self or delegated
to the DBA group or other departments, with the group entailing over 8 database admins. Developed
and implemented an improved backup and redundancy strategy. Developed improved security standards
and protocol relating to databases by setting up auditing, trace reporting and vulnerability probes.
Also setup encryption and certified that was inaccessible to even admin staff. Designed databases
and interfaces for the business needs of multiple departments of different scopes or coordinated
plans and staff for implementation. Set standards and protocols for the maintenance and interaction
of databases. Developed new management strategies and tools for IT. Setup new high availability
configuration for client status interface DB with Oracle Dataguard and MSSQL log shipping and
mirroring. Developed documentation guides for the maintenance & setup of platforms & processes.
Mentored staff on database management and interaction. Optimized performance for database engines,
proprietary queries and processes. Advise developers on how to correct code/design and improve
performance. Setup maintenance plans for platforms. Tier 3 troubleshooting issues concerning
RDBMS's. Determined platform reliability & usage and developed plan for obsolescence, repair or
upgrade if necessary. SME and designer for platforms in other global regions. Initially started on
environments solo hands-on, and developed DBA group after a year due to expansion. Work was often
done remotely through cross-country or overseas VPNs. Worked in conjunction with Director of IT, VP
of Software, Plant IT Managers, Plant Lead Developers and Director of Logical Security.
**On call 24/7, including vacations

Senior Database Developer

NORTHROP GRUMMAN/PEROT SYSTEMS
Short-term contract as group lead developer for Perot Systems on their subcontract with Northrop
Grumman on the LINX project for NCIS. The project entails developing ETL for diverse police agencies
as sources and into a centralized repository to be used for investigations within the National
Capital Region. The target repository was within a clustered Oracle 10g database with RAC on Linux,
with a J2EE interface. Analyzed police agency record management system to map out structure to the
standardized target environment. Developed transformations with 10g PL/SQL. Transformations dealt
with large object datatypes, narratives and more in diverse formats. The source could be any RDBMS
available of any version or vendor application.

Senior Database Administrator/Analyst

CORPORATION FOR NATIONAL COMMUNITY SERVICE (CNCS)
Long-term position as a Lead DBA for database administration and management for CNCS headquarters,
the federal department managing Americorp and other nationwide grant-based charity & volunteer
programs. Managed their clustered Oracle 9i, Rel.2 databases for their e-grants environment on a
Windows 2003 OS. Technical POC for all special projects for integration into the core platform.
Optimization and assisting dev staff with database interaction on interfaces including Java web GUI
(J2EE) and Oracle Forms & Reports (4i, 6i & 9i). Troubleshooting issues from migration from 805 &
817 and converting for migration to 10g. Oracle instances installed with JVM & XML components&
Oracle Portal and other low-level security objects both proprietary & Oracle. Building 10g & 9i,
rel2 AS servers and administration of them. Working with various Oracle tools and applications
including Designer (6i & 9i), Discoverer (4i, 9i & 10g), & JDeveloper (9i & 10g). Developed database
management protocols & standards including organization for DBA group communications. Consulted on
data dictionary & standards for new warehouse built on 10g with Oracle Warehouse Builder and set up
OWB for outside projects. Provided SME knowledge administrating Oracle E-business and Financials
platform. Setup Oracle Names Server for universal workstation connectivity. Setup centralized
performance reporting and environment monitoring. Coordinated and implemented security measures to
satisfy government criteria (auditing, trace, analysis, probe applications). Developed documentation
& guidelines for all tasks and builds.
**On call 24/7, including vacations

Senior Database Analyst/Lead Database Administrator

WIRELESS MATRIX (WRX)
Long-term position in charge by self of 24/7 production database environment that handles
high-performance activities, configurations & authorizations for all WRX mobile terminals throughout
North America. WRX manufactures mobile modem terminals that transfer data from portable computers
through satellite & terrestrial telecommunications back to the home offices of companies like FedEx,
UPS & Sears and manages & monitors through a NOC. The multiple DB instances ran on clustered Oracle
9i on Win2000 servers. The various OLTP and DSS databases have objects of high capacity and
performances of over 2400 reads per second, and over 150 writes per second and can grow
significantly daily. In charge of DB administration of Testing & Development environments (Oracle &
MS-SQL). Constant monitoring, analysis and high-performance tuning are involved to handle current
and future capacities. Responsible for setting up HA redundancy and backup with asynchronous
multi-master Advanced Replication, Stand-by databases and Transparent Gateways. Designed & set up
redundant sites with advanced multi-mastered replication, transparent gateways and automatic
failovers. Setup snapshots for data transfer between databases. Setup HA backup recovery with
standby databases. Planned and executed migration from Oracle 8.0.5 Standard to 8.1.7 Enterprise;
then to the 9.2.0.1 platform. Planned and executed restructuring production topology, separating the
application clusters from dedicated DB servers with multiple processors, and large RAM in a global
WAN environment with RAC. Planned and executed new security procedures and fill in holes with
auditing, trace and best practices according to vendor and national standards. Setup & test
potential softwares, packages & utilities integrating with Oracle backend (Oracle 11i, RAC, Spatial,
Partitioning, etc.) to be utilized effectively within our environment. Responsible for monitoring
and troubleshooting billing procedures across continental VPN; testing other alternative databases,
versions and platforms for the WRX environment. Initiated proof of concept setup for Oracle Grid
environment working through Oracle seminars. Documentation of all DB procedures, parameters &
protocols, and training of staff in Oracle implementations. Finally, also created a network shared
Access 2000 databases for CEO, HR, Software Testing (QA) & IT Management.
**On call 24/7, including vacations

Computer Consultant/Developer, Engineer & Administrator

ROBERT HALF INTERNATIONAL (RHI)
Network Admin, & Design (WinNT & NetWare), Database Development & Administration
(Oracle, Sybase, MSSQL, FoxPro, dBase & Access97), Webpage Admin & Design (HTML, Perl/CGI & Java),
System Tech (PC, Apple, UNIX & Linux), Macro Development (VBA), Human Resources Administrator
(OSHA), Advertising Administrator, Payroll Reallocation, Applications Specialist (Office97 Pro,
etc....)

Short Term and alternative projects of interest:

Certificates

Azure Fundamentals - AZ-900

Microsoft

2023


Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in