SUMMARY:

Technically savvy and solutions - driven Oracle Database Certified leader with over 12+ years of IT experience with the design, architecture, testing and management of financially focused enterprise Oracle database systems for various environments, specializing in Oracle Database, Infrastructure Monitoring Tools (OEM/HP OM9) and IBM Mainframes spanning all phases of Software Development Life Cycle and Support in banking, finance and retail domains. Expertise in designing databases to support business applications, ensuring system scalability, security, performance and reliability, while identifying opportunities of process improvement and automation, ensuring backup and recovery processes are efficient and secure, and working with in-house and offshore DB operations teams and business partners to architect database solutions that meet business requirements and constraints. Expert in directing database solution architecture, Oracle database administration, Data Guard, failover, High Availability, Recovery Manager, Grid Control, scripting, Monitoring and Oracle Enterprise Manager Cloud Control.

EXPERTISE IN:

• IT/Database Architecture
• Oracle High Availability
• SOX Compliance/Reporting
• 24x7 Operations Management
• IT Planning & Transformation
• Process Improvement
• Offshore Operations
• ITIL and SDLC
• Database Upgrade
• Infrastructure Monitoring
• Data Migration
• Mainframes

MAINFRAME SKILLS:

Operating Systems: OS/390, Z/OS.

Hardware: IBM Mainframe S390.

Software Products: COBOL, IMS-DC, IBM MQ Series, SQL, JCL, CICS, Connect Direct, REXX, SORT, CA7, Control-M, TSO/ ISPF, IBM Utilities.

Databases: DB2.

Tools: / Technologies VSAM, ISPF, IDCAMS, File AID, QMF, SPUFI, File AID, Endevor, Xpeditor, Inter test,BMC, Change management tools such as AHD, Service Desk Manager.

Domain Expertise: Retail, Banking Applications, Payments, Swift Messaging, Trade Finance, Transaction Banking, Saber Credit Management, Merva, Finacle.

PROFESSIONAL EXPERIENCE:

Confidential

SENIOR ORACLE DBA

Responsibilities:

• Acted as Senior Oracle DBA/Oracle SME to design, install, configure, maintain, upgrade, monitor and support Oracle Databases on Unix Platforms in an environment involving 12c/19c Databases, RAC, ASM, Data Guard, Exadata (20.X), Golden Gate for the client CIBC Bank.

Confidential

SENIOR ORACLE DBA

Responsibilities:

• Acted as Oracle Delivery DBA/Oracle SME to design, install, configure, maintain and support Oracle Databases on Unix Platforms and setup and support Database and Unix infrastructure monitoring using OEM and OM9 tools.
• Provide database related consulting services for architecture, migration, design and performance tuning for Confidential application teams.
• Perform software installations, upgrades, setup and test back-up and recovery, performance tuning, and troubleshooting of Oracle databases on version 11g and 12c.
• Installed, upgraded and managed 10gR2 and 11gR2 Grid, 12c Grid, OMS, and agents in environment with over 80 databases.
• Produce and maintain document requirements for failover, database monitoring, auditing, back-up and maintenance during production, disaster recovery and maintenance window hours.
• Create, manage, and implement database standard operating procedures for DBA team and also review and recommend various proactive DB management strategies.
• Built, lifecycle management and Support of 10g, 11g, 12c Oracle Databases involving RAC, Data Guard, RMAN, OEM, ASM, Cluster ware environment.
• Expert experience in troubleshooting and resolving urgent/critical incidents on production Oracle Database systems, OEM and OM9 monitoring Tools.
• Strong RMAN backup/recovery experience on very large databases.
• Performed installation, Creation, Configuration and Maintenance of Oracle Database Servers on all Unix Platforms in different environments like Production, Development and UAT.
• Experience with database security and database encryption
• Experience with deploying database security patches and remediation of database vulnerabilities.
• Taking logical backup of the database using Export / Import and Data pump utilities.
• Performing Backup, Restore and Recovery operations using RMAN and troubleshooting issues related to backup failure, recovery catalogue etc.
• Maintaining the health and performance of database through regular monitoring of
• OEM, Alert Log and Trace files.
• Well versed with 11g/12c/13c OEM navigation and usage
• Using the Oracle Enterprise Manager 13c for real time database monitoring and management activities.
• Expertise in managing Oracle database in Linux/Solaris/AIX
• Hands on experience on Oracle Physical Standby Database Data Guard setup to maintain Oracle disaster recovery solution
• Hands on experience with 12c/11gR2 ASM, Data Guard, RMAN, RAC, flashback and high availability cluster ware concepts
• Resolving within the SLA, the tickets generated by OEM through Service Desk Manager (Ticketing tool) in our Queue for issues such as table space, Backup failure, any instance related errors, performance degrade etc and participating in high severity incident bridge calls.
• Generating AWR, ASH and ADDM Reports through OEM as well as SQL Plus on proactive and on demand of requester
• Patch and upgrade of Database components
• Conversant in working with Metalink, SR handling
• Worked in Agile (Scrum) environment using Confluence and Jira

Confidential

SENIOR LEAD DEVELOPER AND SOLUTION DESIGNER (MAINFRAMES)

Responsibilities:

• Worked on the roles of Application Solution Designer and Lead Application developer on IBM Mainframe Technology for the development and upgrade of critical Payment, Trade Finance and Transaction Banking applications of Confidential .
• Experience in full project life cycle, complete Software Development Life Cycle on the project built using the Agile Methodology
• Involved in the estimation, planning, business requirement gathering, design discussions and proposing solution design approaches to business, creating and reviewing High (HLD) and low level designs (LLD)
• Hands on experience to code and test large number of COBOL programs running on IBM mainframe S390, Z/OS using DB2 databases.
• Involved in dress rehearsal, transition of code to support teams, production code implementation and warranty support

Confidential

SYSTEM ENGINEER (MAINFRAMES)

Responsibilities:

• Provided production support which includes providing emergency production fixes and on - call support for 24 hours for application running on IBM Mainframes.
• Involved in coding, preparing test cases and reviews, testing and implementing and monitoring quality standards.
• Developed and debugged large number of online and batch programs which deal with COBOL, IMS-DC, DB2, MQ s, CICS, VSAM, JCL, and CA7.
• Solving Production Trouble Tickets - Perform Root Cause Analysis, Prepare the Specs for changing impacted programs to fix the issue, Do Code changes according to the Specs, Perform Unit testing and then migrate the code changes to Production and Coordinate with the business users in closing the tickets.
• Hands on experience with OS/ 390, Z/OS, COBOL, DB2, IMS-DC, CICS, MQ Series, JCL, VSAM, ISPF, File Aid, SORT, Xpeditor, InterTest, Endevor, BMC, IBM Utilities, CA-7, Control-M.