Manmohan Mann

586-***-**** Sterling Heights, MI *8314

ad305o@r.postjobfree.com www.linkedin.com/in/manmohanmann

Oracle Database Developer Database Administrator

Highly effective Database Developer and DBA (Oracle) experienced in development and administrative skills. Demonstrated career history of exceeding project deliverables, corporate performance metrics, and customer expectations. Expertise in OLTP, DSS and batch processing environments utilizing SQL, SQL*Plus, PL/SQL, Python, UNIX, MVS, VM CMS, C, and C++.

EMPLOYMENT HISTORY

Kapsch TrafficCom NA, Austin, TX May 2021 – August 2022

(Remote, Contract thru Source360 Group)

Senior Database Developer

Provide operational and development (DevOps) support of tolling and trip building applications for the Washington State Department of Transportation (WSDOT) and Riverside County Transportation Commission (RCTC) utilizing Oracle 12c/11g

Worked independently, within small teams, and cross-functional teams to mitigate and root cause production issues to meet service level agreements.

Reviewed and provided suggestions for standardization to ease development and management of the code base of PL/SQL, Oracle DB, MySQL, and Python.

Quickly learned the high-level technical and business rules of the application and provided knowledge transfer to team members.

Translated complex technical issues to the appropriate business language so that the business facing accounts could effectively communicate issues to the end customers.

Supported multiple application teams enhancing interfaces between lane-side, application, database, and the back-office billing departments.

General Motors, Warren, MI February 2014 – February 2019

Data Integration Developer

Supported development and enhancements of an application to allow business users to author soft parts for flashing at dealerships or over-the-air. OLTP and Data Warehouse environments.

Provided guidance on the decision to utilize a 3-node RAC Oracle 12c DB (with ASM) for the application.

Provided input into the OLTP and Data Warehouse data model designs utilizing Erwin.

Performance tuning of the OLTP and Data Warehouse environments by reviewing and updating stats, creation of appropriate indexes, and overall design of table and index structures.

Utilized DB Links, Golden Gate, and IBM DataStage to move data (via ETL processing) from the OLTP environments into the Data Warehouse environment.

Provided database (Oracle 12c) support from both a development and operational perspective utilizing SQL, SQL*Plus, PL/SQL, Partitioning, indexing, SQL Developer, TOAD for Oracle, and OEM.

Utilized Oracle Context for enhanced search functionality.

Developed interfaces and ETL processes between multiple systems and applications (Both within and outside the company) to either obtain the necessary information and/or share with delivery systems.

Interfaced with the database and Golden Gate teams to setup and support 10+ interfaces.

Developed UNIX scripts (Kornshell and Bash) to both push data into the database and pull data to interface with other vendors, systems, and applications.

Utilized SVN for configuration management of database source code.

Performed database deployments in SIT, UAT, Pre-Prod, and Production environments by creating the necessary change tickets and packaging of database DDL and DML scripts.

Supported access for QA team and business users by creating the necessary roles and database ids.

Created and provided tablespace creation scripts to the DBA team.

As necessary, added space to existing tablespaces.

Researched and resolved production issues, in part by generation and analysis of AWR and ADDM reports.

Worked with application teams to utilize Spark SQL for the processing of large application datasets.

Manmohan Mann ad305o@r.postjobfree.com Page Two

HP Enterprise Services, Pontiac, MI September 2009 - January 2014

Oracle Database Administrator Developer

Provided database support for the migration of Team Center from Oracle 10g on a Sun Solaris platform to Oracle 11g on a Oracle Linux platform.

Supported a proof of concept to utilize Golden Gate as an interface between SQL Server and Oracle.

Cloned databases using cold backups, hot backups and RMAN.

Supported the divesture of a business division by splitting an existing database.

Team member in the development and enhancement (SQL, PL/SQL, Windows batch scripts) of an application to manage warranty claims, document root cause, and share warranty cost with suppliers.

Provided database support for the migration of an application from a SUN and Oracle 9g to a LINUX and Oracle 10g platform. (single node with ASM.) And subsequent upgrade to 11g.

Team member on multiple projects in OLTP, Data Warehouse, and Data Mart environments; in part utilizing ETL processes to massage and move data.

EDS, an HP Company, Pontiac, MI August 2008 - September 2009

Oracle Database Administrator Developer

Supported the transition of the support of applications and databases to DBAs in India.

Implemented Transparent Data Encryption (TDE) to support the storage of PII information.

Supported tech refresh of OnStar to a new set of servers and databases.

Production support of Sprint databases including setting up new (RAC and non-RAC) databases (with and w/o ASM) and replicating existing databases using RMAN.

Database enhancements (SQL and PL/SQL) to an application used to classify and categorize vehicle parts.

Supported development and enhancements of an application to allow engineers to find vehicle parts.

Enhancements to an application to allow engineers to identify and use existing parts.

Generation of XML files to feed from a product development database to Teamcenter, a product lifecycle management (PLM) system.

Supported development and enhancements of an application to allow business users to categorize and prioritize warranty claims for quick and broad resolution. Supported by an Oracle OLTP database as well as Data Warehouse database to provide reporting and analysis.

Team member of multiple projects in OLTP, Data Warehouse, and Data Mart environments; in part utilizing ETL processes to massage and move data.

Electronic Data Systems, Troy, MI May 1997 - August 2008

Oracle Database Administrator Developer

Supported applications for Oracle 7, 8i, 9i, 10g and 11g databases.

Generated and utilized Statspack and then AWR and ADDM reports to monitor and tune database systems (RAC and non-RAC and with and w/o ASM) according to customer’s business requirements.

Performed run-time-improvements (RTI) of problematic SQL statements and database health checks for customers.

Created database users and roles.

Designed and implemented roles to enhance database security infrastructure.

Planned, managed and supported migration of Oracle databases from version 6 through 11.2 and implemented Oracle patches.

Monitored backup jobs.

Assisted in the design of an archival strategy.

Interfaced with local and off-shore DBA resources in India and China.

Unix Developer

Participated in the development of an interface between an MVS-based system and a web-based, SQL Server system using Pro*C, Oracle Forms 6i and KORN shell scripts.

Developed an interface to load data from a Manufacturing ERP system into MAXIMO.

Manmohan Mann ad305o@r.postjobfree.com Page Three

Web Developer

Enhanced manufacturing reports on intranet web sites.

Helped a major diesel engine manufacturer meet federally mandated stricter fuel efficiency standards.

Responsible for enhancements to HTML and ASP web pages, DTS packages and SQL Server stored procedures.

Helped develop and coordinate test plans for a migration from SQL Server 7.0, Windows NT to SQL Server 2000 and Windows 2000.

EDUCATION

AWS Certified Cloud Practitioner (2021)

Oracle 18c Workshop I (2020)

Bachelor of Science in Computer Science and Mathematics (Double Major)

UNIVERSITY OF MICHIGAN-DEARBORN, Dearborn, Michigan

Contact this candidate