SUMMARY:

• Over 7 years of IT experience, including almost 3 years as DBA in development and production environments.
• Extensive hands - on experience designing, cloning, testing and supporting next-generation database solutions in Oracle enterprise database and PeopleSoft CS Application.
• Adept at implementing, upgrading, and supporting Oracle database administration for Enterprise Production.
• In-depth understanding of security and backup procedures to ensure database integrity and high availability.
• Expertise in Oracle Fusion Middleware (OFM) Application Server (Oracle WebLogic Server (WLS), Tuxedo) Administration and Support. Exposure to Oracle SOA suite.
• Skilled admin of Oracle Enterprise Manager (OEM) Grid Control 11g, Cloud Control 12c.
• Hands-on knowledge of establishing Oracle Gateway to connect Non-Oracle (SQL Server) databases.
• Experience installing and administering Oracle Business Intelligence Enterprise Edition (OBIEE).
• Hands-on experience in writing code in PL/SQL, T-SQL and Shell-Scripting.
• Details knowledge of MS SQL Server database.
• Programming experience in PHP, MySQL and HTML.
• Excellent communication, interpersonal, and analytical skills. Keen attention to details, Proactive.
• Dual Master Degree - Master in Computer Application (MCA) and Master in IT (MSIT) focused on Database and Data Warehouse.

PROFESSIONAL EXPERIENCE:

Confidential, La Crosse, WI

Database Administrator

Responsibilities:

• Oracle 11g and 12c Database Administration in UNIX environments (Oracle Enterprise Linux Red Hat / VMWare environment )
• Planned and implemented upgrades Enterprise Databases (Development and Production) from 11g (11.2.0.4) to 12c (12.1.0.2) on Linux
• Migrated database from physical server to virtual server
• Monitoring and resolving Alert log files for any ORA related errors
• Tablespace Management
• Monitoring Backup jobs (RMAN) and perform hot backups
• Maintain database availability to support non-stop Business operations
• Performed Export & Import of Schemas (Data Pump)
• Implemented Data guard
• Oracle Installation and configuration of Oracle server software and Database Creation Using DBCA
• Apply CPU/PSU and hot fix Database Patches in timely manner
• Troubleshooting on Performance, Analyzing ADDM reports
• SQL Tuning and performance monitoring/enhancement
• Manage Oracle Enterprise Manager (OEM) Grid Control 11g, Cloud Control 12c
• Completed OEM upgrade from 11g Grid Control to 12c Cloud Control
• Wrote multiple UNIX scripts, including one to refresh a test database from production on a nightly basis through a Cron job
• Maintain and troubleshoot database links to connect other non-oracle databases through Oracle Gateway.
• Write code (functions, procedures, scheduled jobs) on SQL, PL/SQL to automate processes.
• Technical Documentation for Database, application errors and maintenance activities, SOP
• Working with DBMS vendor support (Oracle)
• Provide system and database emergency support on a 24x7 basis
• Provision system security and perform system tasks as importing projects, creating run control, schedule jobs, apply bundle.
• Admin Oracle Fusion Middleware - WebLogic server and Tuxedo maintenance, patch and upgrade
• Provision users and manage user security
• Act as a system consultant to existing operations and programming staff
• Installed and implemented OBIEE, provide support and maintenance (patch) WebLogic Console, Fusion Middleware Control, BI Publisher and Analytics.

Application: PeopleSoft Campus Solution 9.0/9.2 and HRMS and OBIEE

Server: VMWare, Oracle Enterprise Linux Red Hat, Window Server

Operating System: Oracle Enterprise Linux 6 and 7, Windows 7 professional, Window 10

Tools: TOAD, WinSCP, OEM 11g and 12c, SQL Developer, CommVault, vSphare, Putty, PeopleTools 8.54/8.55, Application Designer, Data Mover

Confidential, Aurora, CO

Software Quality Assurance Tester

Responsibilities:

• Manually test the functionality of various web - based advertisements over multiple medium
• Dynamically adapt test approaches to the context of each project
• Perform exploratory testing
• Develop and execute test cases, document results
• Log clear, reproducible bug reports
• Advocate for bugs throughout the resolution process
• Work with the Test Lead and Project Manager to ensure timely testing coverage according to project schedules

Operating System: Windows, Mac, Android, iOS

Skills: Manual Testing, Beta Testing, Regression Testing, Exploratory Testing, HTML5

Tool: Mantis

Confidential, Lakewood, CO

Back-end Developer (Intern)

Responsibilities:

• Hands - on coding and testing.
• Error handling or bug fixing (Debugging).
• Help in implementation, creation and management of multiple applications for back end and website.
• Web site updating and editing using several languages such as PHP, HTML, SQL.
• Investigate and verify customer problems referred by technical support.
• Maintain the existing system.
• Issue status consistently communicated to management on time.

Operating System: Windows 7 professional

Skills: PHP 5.0, MySQL, HTML5, IDE SubLime, NetBeans IDE, Linux SVN, MVC

Confidential

Web Developer

Responsibilities:

• Responsible for implementation of programs and build databases.
• Helped in re - launching and redesigning of client s web site.
• Assisted developing the back-end part (database).
• Maintained documentation on service work performed.
• Issue status consistently communicated to management on time.

Operating System: Windows XP professional

Skills: PHP 5.0, MySQL, MS Access, xHTML, IDE Dreamweaver

Confidential

IT Executive (Junior)

Responsibilities:

• Primarily recruited for day - to-day maintenance and technical support.
• Assisted for analyzing requirements to meet user needs.
• Assured software and hardware were properly installed and operated.
• Offered support to a small team.

Operating System: Windows XP/98, DOS