DILTAJ SINGH
Dallas,TX
Summary
A highly experienced Database and Risk Management Executive with over 20 years of expertise in financial services, corporate governance, and operational risk. Proven track record in developing and leading comprehensive Database management frameworks that align with business objectives and regulatory requirements. Adept at identifying emerging risks, conducting thorough risk assessments, and implementing effective mitigation strategies. Strong leadership skills with the ability to build and manage cross-functional teams, ensuring a culture of risk awareness throughout the organization. Demonstrated success in collaborating with senior leadership to drive strategic decisions, optimize risk exposure, and enhance overall corporate resilience.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Risk and Control Manager
Citi
12.2022 - Current
- Successfully designing and implementing a comprehensive risk management framework for Safety and Soundness team in Citi. This includes identifying and assessing risks, developing risk mitigation strategies, and monitoring risk exposure.
- Enhancing internal control processes and systems to improve operational efficiency, reduce risks, and ensure compliance by monitoring CSRA/MCA metrics with relevant regulations and policies. This could involve developing control frameworks, establishing control procedures, and conducting periodic control assessments.
- Thematic Analysis for the Long Dated GEMS. Driving Risk based approach for the Remediation and Prioritization of Tech Risk and Cyber Risk Appetite Metrics. Regular cadence on CIO reports.
- Demonstrating expertise in regulatory compliance by ensuring that organization adheres to applicable laws, regulations, and industry standards. This includes staying up to date with changing regulations, conducting compliance audits, and implementing necessary controls to mitigate compliance risks.
- Conducting comprehensive risk assessments to identify potential threats and vulnerabilities to Citi’s operations, assets, and reputation. Developing and implementing risk mitigation plans and strategies based on these assessments to minimize the impact of risks.
- Collaborating effectively with various departments and stakeholders across the organization, including senior management, finance, and operations teams. Building strong working relationships to ensure risk management and control practices are integrated into business processes.
- Assisting internal or external auditors in conducting audits and assessments, providing relevant documentation, and addressing audit findings. Demonstrating a proactive approach to risk management and control by actively engaging with audit processes.
- Managed multiple Book Of Work activities within Demand management pipeline for engagement and interaction model for Safety and Soundness; estimation process, project sizing and prioritization across all initiatives; evaluation of supply and demand across all teams identifying incremental capacity needs
Database Lead
Citi
10.2016 - 12.2022
- Led the Datacenter migration of databases to prepare the proof of concept, database migration procedures and scripts, worked with Data Guard Activation at the times of upgrade and migration.
- Led and supported Major Oracle version upgrade from 11g to 19c for Business and Franchise Critical databases in Citi.
- Achieved organizational goals by defining, integrating, and upgrading a comprehensive architecture to support applications, platforms, and databases.
- Maintained databases by determining structural requirements, and developing and installing solutions.
- Processes automated across all business domains including operations, sales, and finance.
- Develop, organize, and manage issues, risks, actions items, change control and communication plans
- Lead the process to assure the transition from implementation to "go live" is a smooth transition without outstanding issues.
- Partnered with other teams including Business Teams, Systems Testing, Sales Account Management, Project Management, and Application Support for successful delivery of system enhancements or Change Requests.
- Reviewed project documents for requirements, scope, technical release notes and method of procedures.
- Implementation of Backup, Recover, Disaster Recovery and cloning of 50 TB+ database.
- Diagnosed oracle bugs and coordinating with oracle support to resolve them in timely manner.
- Applied strong process and technology enablement knowledge, to analyze issues and resolve moderately complex problems.
- Troubleshooted and analyzed the issues reported by customer and providing the solution meeting the SLA.
- Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active duplication
- Involved in a team migrating 12TB & 40TB production database using OGG Zero-down time migration.
- Identified and resolved project impacting issues, working with business and technology teams to schedule, test, deliver and implement agreed upon solutions.
Database Team Lead
HCL / PURDUE PHARMA
04.2014 - 10.2016
- Worked as Onsite Database Track lead at Purdue Pharma for both Oracle and SQL Database Tracks.
- Managing 20+ resources at both onsite and offshore. Identifying key areas of business growth align with client needs and growing business.
- Work closely with business sponsors and internal IT teams to evaluate the business scope/objectives, assess impacts to the project and develop the most cost-effective and efficient solutions.
- Collecting Metrics data, conducting risk planning, gap analysis, prioritizing and scheduling the project deliverable per business value.
- Perform business process evaluation in efforts to improve current processes in place within both the business and technical communities.
- Evolves team with retrospectives to continuously improve working together and becoming a highly effective and efficient team
- Quantified monthly scorecard for Project deliveries for code/solution/production failures, Measuring KPI’s and Metrics for performance management.
- Worked with Database Architects and Development teams to understand client requirements.
- Designing and strategizing Database solutions and resolving key issues.
- Worked with different vendors, understanding product requirements, and providing database solutions. Helping with Application upgrades and provide database related support.
- Worked with Oracle licensing team on strategizing licenses for new infrastructure.
- Designed and Implemented 13.1.0.0.0 Cloud Control in Development and Production environment. Worked with Oracle Development team in Bug fixes during the upgrade process.
- Worked closely with architecture team to implement 12c Multitenant infrastructure across Purdue.
- Worked with Quality Analysis team for creating Installation Qualification (IQs) scripts for FDA approvals. Creating Project Identification Documents (PIDs), Test cases and follow the approval process at various stages to get FDA approval for various new projects.
Senior Database Administrator
Citi
01.2012 - 04.2014
- Design, Implement and support multiple scalable, highly available, zero downtime, multi-site load balancing Oracle based 50+ TB Oracle Database systems using Oracle 9i/10g/11g including RAC and ASM, Goldengate, Informatica, Cognos, Tibco and Java.
- Working as DR/HA/MA admin for Citi's RUSA, EFD, CMR (MDM), EDW systems.
- Played vital role in streamlining the CTI databases (600+) on AIX, HP-UX, Linux and Solaris.
- Expert in cross platform database (of any size) migration with negligible downtime. Designed and developed sophisticated frameworks and tools for Oracle databases using PL/SQL, Data Guard.
- Created database, schemas and tablespaces necessary for IBM Websphere Portal server setup such as RELEASE, LIKEMINDS JCR, COMMUNITY, CUSTOMIZATION, JCR, FEEDBACK.
- Played vital role in establishing change control management for database releases.
- Developed strategy and implementation plan to fully integrate the Oracle Advanced Security Option (ASO) to encrypt data at rest, data in transit and database backups.
- Cross platform migration (little Endian to Big Endian) using Transportable Tablespaces on the Test, Development and Production Databases (10.2.0.4 to 11.2.0.3) from linux to HP-UX.
- Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups for OLTP, Data warehouse, and Business object repositories. Fix backup failures, address and implement resolutions.
- Implemented Oracle database 11g Two node Real Application Cluster (RAC) using Oracle Clusterware for achieving high Availability on ASM.
Oracle Database Administrator
Capital Group
02.2009 - 01.2012
- Responsibility includes configuring, administration and troubleshooting CRS/RAC environment and adding Nodes to existing RAC environment for Linux, HPUX and Sun Solaris. Extensively Install Oracle10g, 11g RAC on Linux Platform.
- Managed complex VERITAS HA environment for production, stage and QA for OLTP and OLAP (Data warehousing environments).
- Build and maintain Disaster Recovery solutions (Data Guard and standby database) for critical environments, confirmed with periodic DR Switchover and Failover. Installed and configured Data guard for RAC and non-RAC environments.
- Configured and implemented various replication techniques: Shareplex replication, Oracle Streams, according to different hardware structure and business demand.
- Implemented ASM, Migrate Databases from non-ASM file system to ASM file system with normal redundancy and external redundancy.
- Proactive performance monitoring by implementing Foglight, UNIX scripts and automated jobs (Grid) for alerts.
Oracle Developer
Dell
04.2007 - 12.2007
- Collaborated with cross-functional teams to develop high-quality business applications, resulting in increased operational efficiency.
- Tailored Oracle Forms and Reports according to specific client requirements resulting in higher customer satisfaction.
- Worked with end-users and functional analysts to capture and document business requirements.
- Strengthened system security by implementing proper access controls and monitoring mechanisms.
- Automated many common tasks using crontab including archiving old records and verification of such processes, scripts for proactive monitoring like monitoring the disk usage, the memory usage of the server, monitoring tablespaces and mailing alerts when required.
- Creating and maintaining documentation using standard company practices.
Oracle Database Administrator
IDS Infotech
07.2005 - 04.2007
- Provided advanced systems administration for Linux/Unix. Developed (shell and Perl scripting) system tools and utilities to simplify and support IT operations.
- Upgrading from Oracle 8i to Oracle 9i Database and apply critical patches update (CPU) for latest versions.
- Installed STATSPACK in 9i environment
- Installed Linux with HTTP, NFS and FTP on Desktops and server. Provided Technical support to students. Managed Web Servers: Apache, Tomcat.
- Created, extended, and managed Logical Volume, Raw Volumes. Networks troubleshoot for desktop, Servers. Kept system up to date by regularly installing patches, RPM.
- Maintain and monitor internal web servers and LANs and WANs. Monitored inter-office, labs connectivity to minimize system failures and down time.
Education
Bachelor's of Technology - Information Technology
SSIET
Punjab, India05-2005
Skills
- Risk Assessment & Mitigation
- Regulatory Compliance
- Risk Monitoring and Reporting
- Database Architecture
- Security Controls Implementation
- Incident Response Planning
- Business Continuity and Disaster Recovery
- Vendor Risk Management
- Database Management
- Project/Program Management
- CSRA/MCA Metrics Management
- Resource Management
- Client Relationship & Vendor Management
- Conflict resolution and problem solving
- Training/Coaching/Best Practices
- CSRA/MCA Metrics Management
- Resource Management
- Client Relationship & Vendor Management
- Conflict resolution and problem solving
- Training/Coaching/Best Practices
- CSRA/MCA Metrics Management
- Resource Management
- Client Relationship & Vendor Management
- Conflict resolution and problem solving
- Training/Coaching/Best Practices
Certification
- Certified Information Security Manager® (CISM®) (In Progress)
- OCA (Oracle 11g)
- OCP (Oracle 11g)
- Google Cloud Security Professional
Timeline
Risk and Control Manager
Citi
12.2022 - Current
Database Lead
Citi
10.2016 - 12.2022
Database Team Lead
HCL / PURDUE PHARMA
04.2014 - 10.2016
Senior Database Administrator
Citi
01.2012 - 04.2014
Oracle Database Administrator
Capital Group
02.2009 - 01.2012
Oracle Developer
Dell
04.2007 - 12.2007
Oracle Database Administrator
IDS Infotech
07.2005 - 04.2007
- Certified Information Security Manager® (CISM®) (In Progress)
- OCA (Oracle 11g)
- OCP (Oracle 11g)
- Google Cloud Security Professional
Bachelor's of Technology - Information Technology
SSIET
Similar Profiles
Michael SweeneyMichael Sweeney
Licensed Client Service Associate at CitiLicensed Client Service Associate at Citi
Govinda RaghuwanshiGovinda Raghuwanshi
AVP at CitiAVP at Citi
Richard PhillipsRichard Phillips
Sr. Financial Reporting Analyst at CitiSr. Financial Reporting Analyst at Citi