Database admin

MEHRYAR YOUSEFI

650-***-**** ********@*****.*** LinkedIn: /in/mehryaryousefi/

SENIOR DATABASE ENGINEER

Senior level professional with 20+years of experience providing effective leadership in maintaining computer databases, implementing solutions,and increasingcompanyrevenue.Effectivelyalignsgoaldevelopmentandimplementationstrategiesto promote company objectives and ensure exceptional and on time completion of projects.Progressive professionalexperience encompasses the full life cycle of projects.Foreseesand plans for possible contingencies. MCSA for SQL 2016 Database Administration

MCSA for SQL 2016 Database Development

MCSE for Database Management and Analytics

Oracle 9i Database Administration Certified Associate Certification in Lawson Unix/NT Application Upgrade 7.x-8.x CORE COMPETENCIES

Platforms: Windows, Linux: RHL, Oracle OS, HPUX

Applications: Lawson 7, 8, LSF9; Dynamics AX, CCHSales Tax Office Database: SQL Server 2005, 2008 R2, 2012, 2016 SP2;Azure SQL; Oracle 8i, 9i, 10g, 12c; MySQL Integration: Scribe Insight Software; Dell Boomi;SSIS BI Solution: Jet Global (InsightSoftware); Zap IDE:Visual Studio (SSRS, SSIS, and C#), Lawson Case Tools Languages: T-SQL; PL/SQL; C#; Python (INTMD);Cobol;Quiz; UNIX shells; PowerShell; Perl; HTML,XML, JSON PROFESSIONAL EXPERIENCE

Database Developer Mountain View Medical Lab Inc., Irvine CA 01/2023 – 07/2024 ELIS DDL Azure MySQL Flexible Server Visual Studio .Net Excel Jotform MongoDB DevOps Power Apps

Using .Net, read Excel files and interface to MySQL database tables; read MySQL database tables and write to Excel files.

Use .Net to import JSON or XML files to MySQL database tables.

Integrate data from Jotform to MySQL and MongoDb. Collaborate with my team to create an API called from Jotform’s webhooks.

Integrate data from TrueMed LIMS to MySQL by creating Azure Function HTTP trigger, Azure Function trigger for Service Bus, and API managed by Azure API management.

Write SQL queries to retrieve data from database. Created triggers for audit trail. Created stored procedures to perform queries and update.

Pull Covid test order claims weekly, format and sent to MPP for billing. Primary support to Call Center team for collection of unpaid claims.

Accessioner Medlab2020, Irvine CA 01/2022 – 01/2023 ELIS Excel Word

● Receive and enter sample and patient data into the ELIS software. Prepare sample racks for lab technicians.

● Take inventory of supplies, tidying the labe and help with shipping special order samples to the main laboratory in Irvine

● Completed courses related to HIPAA and Lab safety Senior Database Engineer The Myers-Briggs Company – Sunnyvale, CA 01/2008 – 07/2020 Dynamics AX DDL SQL Server Oracle Azure SQL Dell Boomi Lawson Unix Websphere SSIS SSRS Scribe Insight Utilized Dell Boomi/Scribe for the process of upgrading enterprise resource planning system (ERP) from Lawson to Dynamics AX, reduced downtime and operational times for the company. Consolidated instances to one server eliminating additional Linux servers, resulting in cost reduction and improved database performance.

Customer support role for internal and external customers: Resolve ERP related issues for Accounting, customer service, and warehouse staff. Fulfill requests related to data query for Research and Business Analytics team.

Serve as primary support for Lawson 9 enterprise management program (ERP) and Jet Global infrastructure BI solution.

Function effectively in an agile environment to ensure the successful completion of projects.

Maintain and update enterprise resource planning (ERP) interfaces and database infrastructures to reduce risk of operational downtime.

Streamline data design process to reduce development intervals and costs.

Safeguard use, performance, and stability through the implementation, upgrade, and maintaining configurations of Oracle and SQL Server database software and instances.

Create application facing stored procedures, views, and functions; design and maintain complex reports.

Create data integration in Boomi/Scribe from Oracle and MS Azure Service Bus to Dynamic AX, SQL Server, and Salesforce.

Implement security enhancements aligning with industry standards; facilitate and ensure integrity of data integrations.

Adept in Lawson and Dynamics AX ERP schema. SME for migrating data from Lawson Oracle to AX SQL Server database.

ADDITIONAL PROFESSIONAL EXPERIENCE

Lawson ERP/Oracle DBA Consultant CPP Inc., Mountain View, CA 04/2003 – 01/2008 Senior Programmer / Analyst Kastle Consulting – Santa Clara, CA 01/1996 – 01/2003 Senior Programmer / Analyst Information Access Company – Foster City, CA 01/1995 – 01/1996 EDUCATION

San Jose State University Bachelor of Science (BS) Degree – Computer Science Engineering Foothill College / San Mateo College / De Anza College Completed professional instructional courses in C, C++, C#, Perl, UNIX OS and Shell programming, Visual Basic, Relational Database Concepts and Design, and Java at UCSC Extension, UC Berkeley Extension, and Learning Tree International.

Contact this candidate