NADEEM KUNDLIK

SUMMARY **+ years of experience

Solutions-oriented Database Administrator with a proven track record of success in the analysis, design, development, and support of robust database-driven applications that directly support bottom-line business needs.

Dynamic database design, architecture development, and integration talents, resulting in stable, scalable, and secure database-driven systems on Linux/Windows

Highly adept at promptly and thoroughly mastering new technologies and adapting to existing corporate infrastructures, producing results immediately on hire in cross-functional IT roles.

Well-refined analytical and troubleshooting skills, providing direct support to users at all levels of computer proficiency.

EDUCATION

·B.Sc. (Microbiology) from Mumbai University, May 2001

·HSC from Mumbai Board, March 1997

·SSC from CBSE Board, March 1995

Employment Summary

October 2021 – Till Date

BNP Paribas as Sr Oracle/MSSQL Database Administrator

September 2020 – September 2021

NetConnect Pvt Ltd as Consultant

March 2020 – June 2020

Cognizant Technology Solutions India Pvt Ltd as M - Infra Ops Specialist

October 2014 – March 2020

Cognizant Technology Solutions US Corp. as M - Infra Ops Specialist

December 2012 – October 2014

Cognizant Technologies Pte Ltd as Sr. Infra Ops Specialist

June 2009 – November 2012

Softenger Pte Ltd as Senior Database Administrator

September 2008 – June 2009

Nityo Infotech Pte Ltd as Senior Database Administrator

November 2006 – September 2008

3i Infotech Ltd as a Database Administrator

September 2004 – September 2006

Raffles Software Pvt. Ltd. as a Database Administrator

February 2004- September 2004

IT Source India Ltd. as an Associate Customer Support Engineer

Skills

Operating Systems : HP UNIX 11, Solaris 5.9/5.10,Windows NT 4.0/2000, Linux RHEL 5.5/6.2/7/8

Database : Oracle 9i,10g/11g/12c/19c RAC Database Administration,

Exadata Administration, MSSQL Server 2000/2008/2012/2016

Database, Oracle Golden Gate (9,10,12,19)

Scripting : UNIX Shell Scripting

Protocol : TCP/IP, FTP, Telnet

Languages : C, C#

Programming : HTML, XML,ASP.NET,VB

CERTIFICATION & TRAININGS

·19c OCP ( Oracle Certified Professional)

·Diploma in Advanced Computers with .Net technology(ACD.Net)

·Participated and Completed the Cognizant Performing People Manager Program

·Currently pursuing Data Science related technologies and languages

Professional Experience

BNP Paribas, HongKong Oct 2021– Till Date

Role: Sr. Oracle/MSSQL Database Specialist

Perform & Support L3/4 Oracle DBA duties for various Business domains.

Perform & Support L1/2 MSSQL/Sybase duties and help in first level of troubleshooting and analysis

Perform BAU/OnCall duties for Oracle/MSSQL/Sybase related alerts and escalations

Undertake all technical escalations for Database issues and participate in high level troubleshooting for resolutions

Using AWR/ADDM and ASH reports to diagnose any kind of performance issue and use performance tools like SQL profiling to resolve them.

Participate and coordinate in Infrastructure wide activities and events

Responsible for planning,coordination and execution of Oracle Database Migration activities . Act as the escalation point for the team in issues encountered during migrations.

Responsible for creating and maintaining various SPOC’s for the team to follow for various major & critical database activities/issues

Enabling TDE encryption for providing enhanced DB level security and supporting issues related to the same.

Responsible for handling and resolving all type of issues related to ASM, RAC, Oracle Data Guard, Oracle Golden Gate

Undertake Business driven projects and lead from the front to drive and coordinate all Database related tasks to ensure timely delivery and support .

Review and implement Database related Production Changes over the weekend and comply with the Change Management policies

Provide regular updates/progress to all the stakeholders for Business critical deliveries

Coordinate with Infrastructure teams for planning and executing major database related events

Undertake all Oracle Golden Gate requirements (Installation, Configuration, Maintenance) for strategic purposes.

Actively participate in incident calls in providing timely updates for the audience and give expert suggestions to help resolve/workaround the issue .

Take part in Non-Production deployments along with Development team to trace and track fixes before rolled out in Production.

Work and follow up with Oracle Support for complex issues/matters and derive the best solution/option as applicable .

Work closely with Application support teams to assist and help them with all type of queries and suggest best solutions for better database performance

Work with Internal/External Auditors to review and implement recommended audit solutions on databases

NetConnect Pvt Ltd, India Sept 2020– Sept 2021

Role: DB Consultant

Client: Oracle ACS, Mumbai

Perform L3 DBA duties for one of the esteemed clients of Oracle

Engage in escalated production issues from the client management and assist in analysis and resolution

Work with L1/L2 DBA teams in guiding and resolving complex/persistent performance related issues.

Using AWR/ADDM and ASH reports to diagnose any kind of performance issue and use performance tools like SQL profiling to resolve them.

Conduct full DB performance reviews and document all the findings along with best practices and recommendations.

Installation & Configuration of 18c OKV Master (Oracle Key Vault) server for storing wallet keys in HSM

Migrating local database wallet keys to HSM managed wallet

Enabling DBV (Database vault) and TDE encryption for providing enhanced DB level security

Planning and Coordination of highly visible migration(SuperCluster Exadata) projects and indulge in providing crucial inputs and observation during UAT testing

Installation & Configuration of GoldenGate 19c on Exadata/RAC cluster. Involved in setting up table level replication for data synchronisation between databases to minimise cutover downtime.

Cognizant Technology Solutions, USA Apr 2018– June 2020

Role: Senior Database Administrator (L3 & Infrastructure)

Client: Wyndham Destinations, USA

Oracle :

Principle Oracle Lead managing Offshore & Onsite Database Administrators managing & administering 11g/12c RAC databases and ensure 24*7 availability of business critical systems

Provide day to day DBA support in a client centric environment for databases in Wyndham Destination as an L3 DBA with active involvement in resolving Production Incidents

Participating in monthly meetings with the customer to discuss the project status & making the strategies on project rollouts and guiding the team to achieve the desired goal.

Using AWR/ADDM and ASH reports to diagnose any kind of performance issue and use performance tools like SQL profiling to resolve them.

Planning and implementation of Big scale activities like Datacentre Movement and Disaster Recovery tests.

Create and maintain customised Database Health-Check Report for 200 Production databases through Unix shell scripting for the Database team for daily COB tasks

Automate and schedule object level statistics to be executed after huge ETL workloads on databases for optimizing Business critical reporting.

Troubleshoot and Resolve any ASM /RAC/CRS related issues

Involved in Database Capacity Planning and Maintenance activities for Storage efficiency.

On Call coverage for Database related P1/P2 Incidents and Issues. Active participation in Problem Management

Engage in Client Management by active interaction and periodical meetings to provide update on Database activities and performance.

Lead & manage all Database Infrastructure projects with active involvement in Pre & Post deployment phases.

Closely working with SAs, Storage and Network Admins to design to customise normalise & implement new Infrastructure across the Database realm.

Deployment of mass changes across Wyndham environment to fulfil audit and regulatory requirements by achieving SLA guidelines

Build, Migrate & Upgrade databases of all sizes to 12cR2 including RAC and non-RAC

Handle all RMAN Backup & Recovery situations with Veritas Netbackup. Engage with Backup Team for troubleshooting and resolving Database Backup & Restore operations within the defined SLA.

Managing database security. Creating users and roles and assigning different roles to users.

Refreshing UAT/ development databases from production databases using RMAN backup/restore, export/import and datapump.

MSSQL:

Experience in Installation, Configuration and administration of MS SQL Server 2008 & 2012 in production, test and development environments.

Experience participating in all phases of the software development life cycle (analysis, design, implementation, testing, debugging, documentation, release, and maintenance)

Engage in designing, developing and maintaining stored procedures, views, tables, T-SQL scripts, etc. as well as creating associated documentation.

Experience in Creating and Managing databases and adding data files and log files to database when required.

Experience in configuring and maintaining High availability features like Log shipping, Replication and Mirroring.

Experience creating Logins and users in the SQL server environment and granting permissions to the user and logins.

Experience in Creating scheduled, alerts and Maintenance plans.

Maintain Database backups for restore and recovery operations

Cognizant Technology Solutions, USA Oct 2014 – Mar 2018

Role: Senior Database Administrator (L3 & Infrastructure)

Client: UBS Bank, USA

Configure Install & Troubleshoot ASM, OEM Monitoring,OTG, Data Guard Broker & Golden Gate with Heterogeneous platforms

Provide day to day DBA support in a client centric environment for databases in UBS Bank as an L3 DBA with active involvement in resolving Production Incidents

Coordination for changes which spans different regions to provide a seamless transition.

Using AWR/ADDM and ASH reports to diagnose any kind of performance issue and use performance tools like SQL profiling to resolve them.

Planning and implementation of Big scale activities like Datacentre Movement and Disaster tests.

Work extensively in customising and testing on HP DMA patching tool with python for automating pre and post patching tasks with exception handling. Troubleshoot failures at all stages and implement appropriate failure recovery.

Automate Simphana Backup Deployment steps through UNIX shell scripting along with checks to ensure fast and efficient rollout across the environments.

Work with Database engineering team in troubleshooting and resolving DbaaS related scripts for Database Build and Patching activities.

Closely working with SAs, Storage and Network Admin to design to customise normalise & implement new Infrastructure across the Database realm.

Deployment of mass changes across UBS environment to fulfil audit and regulatory requirements by achieving SLA guidelines

Build, Migrate & Upgrade databases of all sizes to 12cR2 including RAC and non-RAC

Handle all RMAN Backup & Recovery situations with CommVault adaptation.

Lead & Drive major Infrastructural Projects like TRR Simpana for Backups, HP DMA

Implementation for Database patching across the client environment

Engage in Exadata Database Administration & Maintenance.

Cognizant Technologies Pte Ltd, Singapore Dec2012- Oct 2014

Role: Senior Database Administrator (Change Management)

Client: UBS Bank, Singapore

Responsibilities:

Manage and Lead a team of DBA’s specialized in Oracle/MSSQL/Sybase for the Change & Integration Team (C&I)

Ensure adherences and compliance of all team members to the policies of Cognizant and its Client. Project management duties and report to the UBS stakeholders.

Plan, Implement & Support various database changes through Change management

Responsible and Accountable for delivering work related in the Database Operational area.

Interact with the Client for feedbacks/suggestions and discuss the overall Performance of the team through knowledge sharing sessions & discussions

Track the members Performance and Skills through periodical assessment

Delegate & Overlook Change Management work and Projects among the team members

Softenger Pte Ltd, Singapore June09- Nov2012

Role: Senior Database Administrator

Client: UBS Bank, Singapore

Responsibilities:

Responsible to Guide and Lead 8-10 member DBA team for all the RDBMS (Oracle, Sybase, and MSSQL) streams for 24*7 Production support in Shift rotation

Responsible to Guide in both Technical & Process Oriented activities as the Oracle Stream Lead and impart Training and Infrastructure knowledge to the New Joiners in the team.

Performing Business Continuity drills for critical databases, i.e. failover /switch over drills for various regions.

Handle & address all Technical & Operational escalations within the shift

Evaluate and analyze to suggest Improvements within the Team and processes.

Handling proactive/reactive performance issues on application using 10046 and 10053 SQL trace, Statspack and by monitoring real-time session waits and stats.

Conduct Team meetings and discussions to track growth and performance

Implementation and supporting the various database changes through Change management across Business Groups.

Involved in guiding end (Business) users with proper pre-requisites and steps for Major and Critical Changes on Production Databases.

Nityo Infotech Pte Ltd, Singapore Sept08–June09

Role: Senior Database Administrator

Client: UBS Bank, Singapore

Responsibilities:

Provide 24 x7 Support on mission critical databases, which involves on Oracle 9i and Oracle 10g. Handling of around 6500 databases across globe with varying size of 50gig to 6TB across Business Groups ( IB, WMI, GAM)

Handling escalations from junior members of the team and helping them to troubleshoot common Database related Installation, upgradation and patching of Oracle Databases, with appropriate approved downtime on approved Versions of Oracle.

Building/rebuilding Data Guard for critical business databases. Troubleshooting issues over Data Guard

Performing Business Continuity drills for critical databases, i.e. failover /switch over drills for various regions

Performing scheduled cloning activity for various prod databases and UAT Dbs. ( RMAN and SQL Backtrack )

Handling proactive/reactive performance issues on application using 10046 and 10053 SQL trace, Statspack and by monitoring real-time session waits and stats.

Providing Training and Infrastructure knowledge to the New Joiners in the team.

Setting up and Troubleshooting OTG and GG (Golden Gate) Replication.

Implementation and supporting the various database changes through Change management across Business Groups to support Application releases & events

3I Infotech. Ltd., Mumbai Nov06 – Sept 08

Role: System Engineer (Production Support)

Client: ICICI Bank -Mumbai

Responsibilities:

Administration, Tuning and Managing Oracle 9i databases ranging from 70GB to 5TB on SUN Solaris & AIX platform using HP and Hitachi SAN Storage

Administering 3 Mission Critical Databases for ICICI Bank Credit Cards and ICICI Bank Retail Loans depts.

Creation of entire database DR using Oracle Data Guard for ICICI Bank Credit Cards dept.

Cloning of databases for MIS and UAT purposes.

Maintenance of Partitioned tables at regular intervals for better performances

Coordinating with Application owners for database related issues & give them suggestions regarding new fixes & features

Proactive Performance monitoring & Database Backup Management

Installation of Oracle Binaries, apply patches & apply security patches.

Planning growth of database objects & extent management.

Hardening and Auditing of databases as per ICICI Bank Security Policy.

Raffles Software Pvt. Ltd., Mumbai June ‘05 – Sept ‘06

Role: Database Administrator (Database Consultant for “Hewlett Packard India Pvt. Ltd”)

Client: Bank of India -Mumbai

Responsibilities:

Managing and Handling Oracle and SQL 2000 Databases on Unix and Windows platforms

Planning and Creating Databases on UNIX and Windows Platforms.

Maintaining and monitoring daily Database Activities (Backups, Database Growth etc.)

Member of Disaster Recovery Team- Planning, Documentation and Implementation

Managing and Troubleshooting Application (FINNACLE) related services

Handling User-End queries & ensuring Audit compliance on Databases.

Achieving SLA targets and Escalation Matrix.

Responsible for synchronization of Standby Databases by changes on Primary databases.

Analyzing Indexes and Tables after completion of Migration Procedures.

Reorganization/Reallocation of Data files and Tablespaces & Schema related Objects

Standardization and Regularization of Critical Business Processes by Planning and Documentation.

Responsible for performing Performance Checks at regular intervals and Analyzing Performance Statistics of the Databases using STATSPACK.

Handling Row Chaining, Row Migration, Fragmentation of Tablespaces and Tables and related Performance Issues.

SQL Server Database Administration.

SQL Server Installation on various systems

SQL Server installation on Failover Cluster

Creation of Database

Backup & Restore

Automate the database & transaction log backup using script

Monitoring the status of Data files and Transaction logs

Adding Data files

Implementing the Security on SQL Database

Raffles Software Pvt. Ltd., Mumbai Sept ‘04 – June ‘05

Role: Database Administrator (Database Consultant for “Hewlett Packard India Pvt. Ltd”)

Client: Intelenet Global Services [IGS] -Mumbai

Responsibilities:

Engage in various activities for Application Software (Savvion) like User creation, Job Assignment, Customizing User Scripts for Report Generation.

Monitoring, Maintenance & Troubleshooting of Database Schemas (Tablespaces, Data files etc.) And related activities.

Implementation of Backup Plans (Hot Backup and Export dump) of Database and Application servers.

Restoration and Recovery of Database

Monitoring of Alert and User trace files of Database.

Applying and Updating Application Patches.

ustomer Level Interaction

IT Source India LTD Feb‘04–Sept ’04

Role : Associate Customer Support Engineer (Consultant for ICICI Infotech)

Client: ICICI Bank LTD (Loan Dept)-Mumbai

Responsibilities:

Monitoring FinnOneApplication servers –User Load and Utilization

Troubleshooting of Application Software (FinnOne)

Escalation of Database and Network related issues.

Resolving User Related Queries.

MIS Tasks

User Creation in FinnOne and Related jobs.

Undertaking EOD and EOM Activities

Applying and Updating Application Patches.

Providing Online Support to End Users on Technical Issues related to FinnOne.

PROFESSIONAL ACHIEVEMENTS & AWARDS

oPart of the Database Group which was awarded with “Cognizant Spotlight Award” for 2016

oAwarded the “A Difference Maker Award” by Cognizant

oRecognized and Awarded with the ‘UBS Singapore IT Outsource Award’ for 2010

oBy UBS AG.

oRecognized as an Active Member of the Disaster and Recovery Team By Bank Of India IT Department

oAwarded an APPRECIATION TROPHY for being the Part of CBS Team in the 500 Branches Roll Out Phase.

Personal Details

Date of Birth : August 27, 1979

HKID : F1073989

Passport Details

Passport No. : L4547734

Place of Issue : Singapore

Issue Date : 27/06/2014

Expiry Date : 26/06/2024

E-Mail : adzxru@r.postjobfree.com

Mobile: +852********

Contact this candidate