Summary
Strong leader and problem-solver dedicated to streamlining operations to decrease costs and promote organizational efficiency. Uses independent decision-making skills and sound judgment to positively impact company success. Encouraging manager and analytical problem-solver with talents for team building, leading and motivating, as well as excellent customer relations aptitude and relationship-building skills. Proficient in using independent decision-making skills and sound judgment to positively impact company success. Dedicated to applying training, monitoring and morale-building abilities to enhance employee engagement and boost performance. Customer-focused professional with successful 30-year career in IT sector. Dynamic successful applying Database and in busy business environment.
Overview
31
31
years of professional experience
1
1
Certification
Work History
Manager (projects)
Cognizant Technology
09.2017 - Current
- Installed and Configured DB2, Oracle and SQL server databases.
- Installed and configured failover Microsoft SQL server Cluster for DB2 and Oracle
- Performed database migration from Oracle to DB2 to suit to BPM workflow database.
- Data Cleansing and Transformation as per BPM ( customer requirements)
- Designed and implemented data masking
- Established working relationships across various departments to understand existing and emerging IT requirements.
- Liaised with system administrators to monitor, troubleshoot, triage and provide RCAs for incidents.
- Worked with customers and other third parties to support DBA functions.
- Troubleshooted database issues to create and resolve trouble tickets.
- Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
- Reviewed database design to recommend enhancements or improvements.
- Set up and controlled user access levels across databases to protect important data.
- Modified databases to meet needs and goals determined during planning process.
- Conducted tests to identify issues and make necessary modifications.
- Created and updated database designs and data models.
- Wrote and maintained technical and functional specifications to document database intentions and requirements.
- Developed and updated databases to handle customer data.
- Implemented security measures to protect vital business data.
- Adhered to set schedules to test databases for flaws and reduce downtime.
- Participated in situation management of incidents to support database operations.
- Developed automated processes to manage database creation .
- Proposed database changes to ease monitoring and administrative effort.
- Developed and implemented database backup and recovery procedures, performance tuning.
- Designed and implemented database security requirements.
- Designed and implemented database patch mangement.
- Designed and implemented database upgrades for Oracle, DB2 and SQL server databases.
Senior IT Specialist
IBM Singapore Pvt. Limited
08.2000 - 09.2017
- Second level support for Oracle & DB2 databases
- Designed and implemented Websphere Commerce Server, Websphere Application Server and Websphere MQ.
- Install and Configure Oracle, DB2 and SQL server databases
- Install Cumulative patch update on Oracle, implement DB2 fixpack and Cumulative patch update on SQL server databases.
- Perform database upgrade for SQL server,oracle and db2 databases.
- Design and implement high availability solutions for DB2, Oracle and SQL server.
- Troubleshoot and resolve Database related issues.
- Resolved performance related database issues through tuning of SQL statements, IO and Memory Tuning
- Designed and Implemented monitoring tool for Oracle and DB2 databases (BLUESAT).
- Performed SAP Basis support, Websphere MQ, Websphere Application Server and Websphere Commerce Server
- Performed Database recovery for Database Disaster Recovery Management for Oracle,DB2 and SQL server.
- Designed and implemented database related object for optimal performance
- Implemented process management through creation of checklists and Operations documentations
- Conducted independent technical reviews of current processes and records to proactively identify and correct process and system issues.
- Attended training programs to deepen professional skillset and assisted in training fellow store associates on existing and new training programs.
- Listened and responded to customer requests and forwarded necessary information to superiors.
- Transition Mangement Lead for databases/SAP systems take over from other vendors for outsourced customers.
- Supported crisis management for outsourced customers in Malaysia, Thailand and India.
Customer Support Consultant
Oracle Singapore
09.1997 - 08.2000
- Managed fast-paced call center work to assist high volume of daily customers using multiple internal databases and systems.
- Supported customers throughout incident response, management and resolution to deliver expert assistance for technical needs.
- Assisted sales team by creating proof concept in performance tuning and database implementations.
- Installing, configuring and tuning Oracle databases
- Support Oracle database upgrades.
- For ensuring business continuity, setting up standby databases.
- 24x7 Gold support account Management.
- Perform
Inspector of Central Excise (System's In Charge)
Office of Commission Central Excise and Customs
09.1992 - 09.1997
- Creation, monitoring and maintenance of Oracle Database
- Managing and mirroring of control files and redo log files.
- Creating, activating, monitoring and assigning rollback segments
- Space usage with rollback segments
- Tuning SQL for optimal performance based on Cost/Rule based Optimization.
- Tuning SGA for memory management
- Tuning Data storage for avoid fragmentation, dynamic extension and Chained rows.
- Tuning Data manipulation using SQLLOADER utility and Truncate SQL command
- Tuning Physical storage and Logical Storage.
- Security and Auditing aspects
- Providing system / object / OS level security
- Creation of users, roles, profiles, procedures, functions, database triggers
- Managing of Privileges
- Attaching of database accounts to hosts accounts
- Auditing of Database
- Optimal Backup and Recovery Procedure
- Incomplete and Complete Media recovery.
- Off-line backup and Online backup
- Logical backup / recovery using export / import utility / complete Cumulative / incremental.
- Developed Challan Reconciliation application.
- Developed Monthly Technical Report
- Developed Value added application to identify misused credits.
- Automated process of data loading resulted in avoidance of manual processing.
Education
Bachelor of Science - Bachelor in Chemistry
06.1995
Post Graduate Diploma in Systems' Management - Information Technology
10.1990
Master of Arts - Public Administration
10.1987
Skills
- Expert Knowledge in Database administration( Oracle/DB2/SQLserver )
- Expert knowledge in PL/SQL procedures in Oracle and db2
- Knowledge SAP Basis Administration
- Knowledge in AWS cloud and AZURE cloud
- Database upgrade oracle,db2 and sql server
- Design and Implement high availability solutions for oracle,DB2 and Sqlserver
Certification
Oracle Certified Professional in Oracle8,oracle8i and Oracle9
Certification in AZURE fundamentals
Timeline
Manager (projects) - Cognizant Technology
09.2017 - Current
Senior IT Specialist - IBM Singapore Pvt. Limited
08.2000 - 09.2017
Customer Support Consultant - Oracle Singapore
09.1997 - 08.2000
Inspector of Central Excise (System's In Charge) - Office of Commission Central Excise and Customs
09.1992 - 09.1997
University of Madras - Bachelor of Science, Bachelor in Chemistry
NIIT, India - Post Graduate Diploma in Systems' Management, Information Technology
University of Madras, - Master of Arts, Public Administration
Similar Profiles
Kaushalya PatilKaushalya Patil
Technical Lead at Cognizant TechnologyTechnical Lead at Cognizant Technology
Damione HartDamione Hart
Desktop Support Specialist (Remote/Hybrid) at Cognizant TechnologyDesktop Support Specialist (Remote/Hybrid) at Cognizant Technology
Maitreyee JoshiMaitreyee Joshi
Senior Process Executive at Cognizant TechnologySenior Process Executive at Cognizant Technology