Jason Smith Email & Phone Number

Benecia, CA

• Maintain data center viability using SQL, Python, SQL Server Integration Services (SSIS), SSMS
• Perform data modeling, statistical analysis, and forecasting using Python and Excel
• Perform and maintain data reporting using Business Objects, SQL, Python, Server Reporting Services (SSRS), Bursting Manager, CMC
• SQL Server database administration, performance tuning, and index creation

Benecia, CA

... similar to above.

Sunnyvale, CA

• Led a team of support engineers for RiskVision, an on-premises and SaaS Java-based Compliance and Vulnerability Management ITGRC application with Oracle and MySQL database with 850 tables, XML, and Jasper reporting
• Provided Tier 1, 2, and 3 support to customer DBAs, ITOps, DevOps, and Security Engineers at F500 enterprises and government organizations including Civilian, DoD, and Intelligence
• Developed and implemented data governance strategies for 40-plus customers
• Performed Postgres Administration including installation, instance creation, user creation, role assignments, SQL queries, configurations
• Defined requirements for customer compliance, governance, and risk management success and co-develop custom solutions including selection and modification of control frameworks, risk thresholds, incident handling, and.
• Wrote SQL queries to generate reports, monitor DB performance, and troubleshoot performance, data corruption, and data quality issues

• Provided implementation services for Oracle and MySQL including sizing, configuration, performance tuning, writing custom SQL queries, DBA knowledge transfer, and database maintenance procedures
• Led database migration, upgrades, insulation of patches, and MySQL to Oracle migration
• Developed and implemented data governance strategies for 40 plus customers
• Established support policies, procedures, processes and tools for Customer Onboarding, escalations, and knowledgebase, ensuring SLAs were consistently met
• Administered SaaS environments including performance monitoring, log monitoring, and instance configuration and provisioning
• Led product release on Oracle database including design/build testing, quality and reliability testing, modifications, database architecture, and sizing

• Voted by customers as top 3% of all CA support engineers for quality service based on knowledge and dedication to problem resolution
• Resolved network issues by verifying network connectivity and fixing issues relating to TCP/IP, DNS, DHCP, Firewall, Routing, Switching, LDAP, Oracle Net
• Supported CA Clarity Product Portfolio Management application with Oracle and SQL Server databases
• Identified and resolved issues including third party vendor bugs reporting and remediation: Oracle, Apache-Tomcat
• Increased support team throughput by configuring, administering, and maintaining static test servers, writing knowledge base articles, and initiating group knowledge sharing through IM

• Resolved customer issues relating to SQL*LIMS, a laboratory information management system that had strict compliance, data integrity, and security requirements
• Provided SQL*LIMS DBA services including installations, upgrades, migrations, training sessions, database performance tuning and SQL query tuning optimization
• Expanded general product knowledge of customers and internal employees by performing week long technical training sessions and developing PowerPoint presentations
• Assisted with the creation of the installation document on Linux and provided support to the QA team by performing product stability testing

Masters Of Science, Data Analytics, Data Analytics

Ba, Molecular Biology