Management Software Engineer
Resume:
VAIJINATH HOSSALE
Chicago, Illinois ***** • Home: +1-847-***-**** • Cell: +1-847-***-**** • *********.*******@*****.***
Professional Summary
Total 15 years of IT experience as a support analyst with Major IT/Banking industry. Expertise in Production support
area in many managed services engagement in ITIS related project. With the extensive knowledge of Application
Support and Oracle database management, excellent written and oral communication skills. Having 6+ Years of
experience as an Oracle Database Administrator. Proficient in Schema Refresh & Database Refresh Experience in
data management tools like EXP, IMP, EXPDP and IMPDP Handful experience in DB creation and Upgrading
oracle databases from Versions 9i to 10g. Expertise in applying CPU Patch & Quarterly Patch with Patch Set. Having
good knowledge of Oracle 10g Features like Data pump, AWR.. Proficient in implementing Backup and Recovery
Strategy (RMAN) Having good knowledge on Flashback, Cold backup, Hot backup and Recovery.
Skills
Hardware / Platforms : HP-Unix/AIX/Linux/ Solaris
RDBMS : Oracle
Database Tools : RMAN, DATAPUMP, TOAD,SQL
Developer, RSQL
Databases : Oracle 11g, 10g and 9i
Other Tools :
BMC Control M/EM, Autosys, Win SCP and Putty
Excellent problem-solving abilities
Windows and Linux
Excellent communication skills
Work History
Technical Lead, 06/2015 to Current
Cognizant Technology Solutions US Corp. – 211 Quality Circle College Station, TX 77845
As business analyst co-ordinate with IT Teams for any business incidents as per the requirements get it resolved
without any impacts
Coordinate with systems partners to finalize designs and confirm requirements.
Ensured network, system and data availability and integrity through preventative maintenance.
Technical Lead, 08/2011 to 06/2015
Cognizant Technology Solutions – Bangalore, Karnataka, India
Installation, upgrade and configuration of Oracle 10g,11g on AIX Managing database objects, such as tables,
indexes, and views Creating users, assigning Privileges, Roles and Profiles to the Database Users
Managing the storage structures of the database Troubleshooting issues
Diagnosing and reporting critical errors to Oracle Support Services
Backing up the database and performing recovery operations when necessary
Database upgrades and DB Patching, CPU patching
Health Check of all the databases involved in the project Performed Logical Backups using Oracle utilities
like Export, Import, Data pump.
Refreshing development and QA databases from production environment using export/import
Database Cloning using RMAN Backups.
Support all DBA Tasks.
Lead Software Engineer, 05/2005 to 08/2011
Fidelity Business Services India Pvt ltd – Bangalore, Karnataka, India
Project Description
Fidelity Employee Services Company provides HR/Payroll Practices, which together support the entire lifecycle of a client's employee from pre-employment to post employment. The key aspects of this service is Maintaining HR and Payroll data record keeping, Time and attendance processing, Pay processing,
Compensation cycle management, Retirement benefits data processing, and Hiring management.
Responsibilities:
On-call Support for all HR/Payroll US clients Unix/Linux platforms Good understanding of Oracle
Database Server Architecture.
Creation of Database using DBCA & Manual mode and proficient in client installations.
Parameter file/ Spfile management Maintaining datafile, Control Files and Redolog files.
Privileges, Roles and Profile, Password management Tablespace management, User Management and Space
Management Refreshed schemas from prod to dev/stage environments as per client requests.
Creating different users and granting appropriate privileges and roles and implemented auditing for those
users when needed.
Monitoring various database activities like number of users, memory usage, alert log files, trace files and archive
log files.
Enhance database administration by automating administration tasks like developing scripts for database
instance availability, listener availability, check alert log files for error messages, Clean up old log files before log
destination gets filled.
Performed routine checks of space utilization and adding space to database when it's needed.
Performed daily activities like monitoring OS File system usage, Alert logs, trace files, tnsnames.ora & listener.ora
files to understand the health of database.
Creating and Managing table spaces, data files.
Implemented different backups like regular exports & RMAN backups as per the client standards Applied
quarterly patches regularly and bug fix patches when needed Involved in tuning of database using Explain
Plan, SQL Trace etc.
Database links were created to access the data from remote databases.
Taking care of SQL*Net related problems like listeners and connect string.
Asst Manager - IT, 01/2003 to 05/2005
Oriental Bank of commerce – Secuderabad
Analyze database requirements, design the approach, writing / coding the scripts, test for sanity on equivalent
servers and implementing at production databases.
Search for latest patches at oracle sites, test and applying the same on all databases supported by us.
Administering the database through Oracle Enterprise Manager (OEM). Cross checking the change proposals
sent by other wings of IT. Submitting monthly report on all the production databases supported by
Secunderabad Data Center.
Diagnosed and troubleshooted UNIX and Windows processing problems and applied solutions to increase
efficiency.
Provided continued maintenance and support for existing applications
Oracle DBA, 03/2002 to 12/2002
The Malleswaram co-op Bank Ltd – Bangalore,Karnataka, India
Consistently met SLA's and requirements for all production Support activities.
Diagnosed and troubleshooted UNIX and Windows processing problems and applied solutions to increase
company efficiency.
Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
Provided continued maintenance and support for bug fixes and patch sets for existing applications.
Software Engineer, 05/2000 to 02/2002
Telesis Technologies India PvtLtd – Chennai
Consistently met SLA's and requirements for all production Support activities.
Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.
Software Engineer, 05/1998 to 05/2000
Virmati Banking Computer services – Bangalore,Karnataka, India
Implementation & customization
Ensuring & taking daily database Backup
Consistently met deadlines and requirements for all production Migration activities.
Provided continued maintenance support for bug fixes and patch sets for existing applications.
Education
Master of Science: Computer Science, 1998
Marathwada University Aurangabad - Vivekanand college Aurangabad
Bachelor of Science: Electronics, 1995
Gulbarga University Gulbarga - Karnatak College Bidar
Certifications
ITIL Certification : ITIL Foundation certificate in IT Service Management
OCP Certification : OCP DBA (Oracle 10g)
Contact this candidate