Anburaja Devaraj
Amsterdam
Summary
Skilled Technical Lead successful at marrying technology and business needs in order to meet changing demands and solve diverse problems. Prepared to 17 years of IT experience to take on new role with long-term potential and room for professional growth.
Overview
6
6
years of professional experience
1
1
Certificate
Work History
Database Technical Lead
Ahold Delhaize
Netherlands
05.2018 - Current
- Build activities: Plan, design and setup new database environments as per the business requirement
- Database migration planning and execution from On-Premise DC to Azure Cloud
- Analyzing and setting Azure native monitoring solutions to reduce the monitoring cost
- Database backup analysis and setup with most efficient option in Azure
- Responsible to maintain the Infrastructure cost on the database and resources
- OEM 13c Installation in the Azure and regular upgrades in the existing environment
- Self-heal automation in handling incidents through OEM till to the closure in SNOW
- Incident setup and alert configurations for all database parameters
- Database backup configuration in Azure Commvault
- Database migration: Cross platform migrations Oracle (AIX to Linux) As-IS Migration from On-Prem to Azure Oracle (On-Prem) to SQL migration(Azure) Oracle 12c, 11g(On-Prem) to 19c migration(Azure) Migrating large scale database to Azure cloud with minimal outage SQL server migration from IaaS to PaaS services Management: Weekly service review meeting with Customer and other Product owners
- Tactical meetings with Customer to plan new requirement and improvement areas Co-ordinating with application stakeholders/Customers for planning the LCM activities
- Daily team meeting with the Off-shore teams
- Resource planning and on-boarding to the team
- Planning and scheduling change window for the database patching and upgrades
- Support: Managing 1000+ Oracle, SQL and Progress databases running on Azure Cloud and On-Premise DC Handling Major incident calls and resolving incidents on priority
- Security assessment(CIS Baseline & Database backup/restore) for the ICFR database once in half yearly
- Attending CAB meeting and approving the change/Service request
- Preparing and RCA review with all the stockholder in case of priority incidents
- Scheduling Oracle database growth report through OEM Oracle Database performance tuning, identifying Disk latency issues
- Oracle database upgrade and patching automation
- Progress and SQL server upgrades at regular intervals
- Following ITSM process (Incident, change, Problem Management) Managing Azure storage, identity and subscriptions AZURE SQL and MS SQL server administration Regular planned database refresh from production to non-production databases Patch management once the patch is released(every quarter for Oracle) and every half yearly for MS SQL Vulnerability management review and fixes every month
- Monitoring the backup reports and restore when required.
- Connected with clients to identify needs and provide helpful solutions.
- Provided technical guidance on development projects as well as implementation of new technologies.
- Determined technical requirements for projects and set work deadlines.
- Managed multiple tasks within tight deadlines while ensuring quality control throughout the process.
- Collaborated with other team members to troubleshoot complex issues and develop solutions.
- Analyzed customer requirements to determine appropriate technology solutions.
- Analyzed system performance metrics to identify areas of improvement.
- Facilitated communication between different teams to ensure successful completion of projects.
- Performed root cause analysis for production incidents and identified permanent fixes.
- Participated in architectural discussions regarding design decisions related to scalability and security.
- Guided staff members through technical challenges and identified areas needing improvement.
- Installed patches and upgrades to maintain application stability and security posture.
- Performed security audits to locate potential threats and identify improvement areas.
- Implemented continuous integration, continuous delivery pipelines for automated deployments.
- Coordinated with vendors for resolution of any third-party product related issues.
- Identified opportunities to improve system performance, scalability, and reliability.
- Monitored application health metrics such as error rates, latency, throughput, and took corrective action when necessary.
- Identified opportunities for process improvements to decrease in support calls.
- Devised automation, backup and recovery protocols to preserve and safeguard data.
- Updated software upon release of vendor patches to mitigate vulnerabilities.
- Deployed patches, upgrades, and other changes in order to maintain optimal performance of Oracle Cloud infrastructures.
- Performed troubleshooting on various issues related to the integration of Oracle Cloud products into customer's existing IT environment.
- Participated in client meetings discussing project status updates, deliverables timelines, budgeting concerns.
- Analyzed customer requirements and designed custom cloud solutions to address their specific needs.
- Coordinated installation of software systems and collaborated with user experience team on design and implementation of new features.
- Configured, monitored and maintained Azure Storage Accounts, Virtual Networks, App Services, Web Apps and VMs.
- Monitored performance metrics of various services running on Microsoft Azure platform using tools such as Application Insights and Log Analytics.
- Deployed applications to the cloud using ARM templates with CI and CD pipelines in Azure DevOps.
- Migrated legacy workloads from on-premise data centers to public cloud platforms like Microsoft Azure.
- Managed Azure IaaS and PaaS resources such as SQL Database, Service Bus Queues, Event Hubs and Automation Accounts.
- Collaborated with other teams to troubleshoot complex issues related to application deployment and configuration of services in MS Azure platform.
- Implemented backup solutions for cloud-based systems using Azure Backup service.
- Analyzed cost optimization opportunities for existing resources deployed in the cloud environment.
- Optimized resource utilization and costs associated with running applications by scaling up and down compute resources based on usage patterns.
- Provided technical guidance to project teams on best practices for deploying applications to Microsoft Azure platform.
- Tuned database performance by optimizing query plans and indexes used within MS SQL Server databases hosted on MS Azure Platform.
Sr Database Admin
Target Corporation
Chennai
- Database installation and creation of new database in Oracle 12c environment
- Building Data Guard setup in Chef environment, Database migrations from different Linux server to EXADATA box
- Rolling upgrade in the exadata machines
- Moving the oracle 11g database from exadata to chef environments
- Following the change Management process in executing all the changes in the database
- Managing the service request, Incidents and change request as per the SLA
- Oracle Patching as per the schedules Cross platform migration of oracle from Linux to AIX
- Database version upgrades, Database decommissions after migration to exadata
- Database tuning after the migration or whenever it is required
- Configuring the database backups in RMAN
- OEM configurations changes
- Sprint planning using Agile methodology
- Installed new software releases, patches and upgrades on production servers as required.
Platform Architect
Microsoft
Finland
- Planning and building the new environments in TFS
- New application migration to Cloud from On-Premise
- Co-ordination with the customer and with the offshore teams
- Participated in the sprint planning with the customer and concepting teams
- Project document creation like( SSD, ISG, PAC, Windows and database server maintenance
- Performance monitoring and tuning the databases
- Creating new database for the reporting teams
- Production Issue resolution for the users
- Managing the Version upgrade and patching
- Data refresh in the lower environments with the latest data set from the prod environment
- Project deployments and implementations in prod environments by change management process
- Building the TFS application in Azure environment
- Configuring the mailbox and the application is IIS
- Access management for application and the database
- Data migration from Accept360 to TFS
- Planned the Transition and completed smoothly to other vendor
- SPOC for process improvement using six sigma.
Database Administrator
NOKIA
Finland
- Plan and create the new database
- Managed three teams at offshore
- Timely updated the service delivery documents and weekly/monthly reports
- Setup new oracle stream environment for integrations
- Create scripts to backup database with cronjobs
- Performance tuning whenever required
- Maintenance of Oracle Databases as per the requirement
- Database refresh in the lower environments with the latest backup set
- Monitoring the replications and maintain the databases
- Accept 360 application upgrade using the SQL scripts
- Setup HR Integration database and monitoring the day-to-day updates
- Creating oracle objects for the integrations
- Monitoring the objects growth and space management
- Analyze SQL statements using Explain Plan
- Creation of oracle users, oracle roles, granting privileges and profiles etc.
Database Administrator
Woolworths Limited
Australia
- Installation of oracle 9i/10g/11g(RAC), Exadata, Linux, Windows, UNIX
- Data Guard administration and ASM on Oracle 11gR1/R2 on UNIX (Linux, Solaris)
- Database Backup by using RMAN integrated with Networker tool
- Logical Backup using Export/Import, Data pump (Expdp/Impdp)
- Created shell scripts for monitoring the disk space, datapump jobs and checking the oracle/server process
- Planning and creating the new database in the RAC environment
- Configuring RMAN backup using networker and cronjobs
- Database Fixes and Database Patch Management Support
- Database refresh in the lower environments
- Manage materialized view and table partitions
- Deploy new objects in the prod environment with Change management process
- Managing the logical objects of the Databases
- Analyze and Rebuild Index to rectify segment fragmentation
- Checking Alert Log file for errors and making necessary actions to rectify them
- Frequent analysis of objects or schemas to improve the speed of the database
- Performed database tuning using AWR/ADDM, STATSPACK, TKPROF, SQL TRACE, EXPLAIN PLAN
- Monitoring the objects growth and space management
- Implementing and maintaining database security (create and maintain users, roles and assign privileges)
- Provided 24x7 on-call production database support.
Database Analyst
Barclays Capital
- Migrated the database from MS Sql server, Sybase to Oracle
- Analysis on various migration tool like SQLways, SSMA
- Tested the migration and created the Poc
- Planning and database creation
- SQL tuning as per the need.
Technical Lead
Morgan Stanley
- Creating tables and uploading the data into the database
- Preparing (a) Functional Specifications and (b) Technical Specifications – based on the client requirements Estimation of the work, Preparing Sprint Planning Sheet Technical and Functional KT Sessions to the Leads and Team member Creating procedures for our database and writing queries for the front-end application
- Analyzing data files using scripts
- Creating index schema for the tables
- Taking backup of schema tables in regular basis
- Debugging Stored Procs.
Production Support Executive
Morgan Stanley
- Problem Analysis & Resolution of mission critical issues Resolving the tickets as per the SLA’s and the priority of the issues
- Assigning the Single-sign service to the customers
- Creating procedures and queries as per the client need
- Taking scheduled back-ups at regular intervals
- Problem Analysis & Resolution of mission critical issues Assess the core competencies and develop a plan for needed training Creation of indexes and managing the schema views etc
- Testing out the web contents in various environments Piloting of new applications coming to project Assessing the information needs of Functional and Business Owners
Skills
- Project Leadership
- Continuous Integration
- Customer Relationship Management
- Agile Methodology
- Budget Administration
- Corrective Action Implementation
- Performance Optimization
- Design Development
Certification
- Oracle Certified Professional certification in Oracle
- Oracle Cloud Infrastructure associate
- Green Belt in Six sigma(Process Improvement)
- Microsoft Certified: Azure Database Administrator Associate
- Microsoft Data fundamentals– Database Fundamentals
- Microsoft DevOps Solutions
Timeline
Database Technical Lead
Ahold Delhaize
05.2018 - Current
Sr Database Admin
Target Corporation
Platform Architect
Microsoft
Database Administrator
NOKIA
Database Administrator
Woolworths Limited
Database Analyst
Barclays Capital
Technical Lead
Morgan Stanley
Production Support Executive
Morgan Stanley
Technical Summary
Senior Database Administrator/ Database Architect working in Production support Environment and managing multi-terabyte database environment and mission critical large systems with total of 15 years of experience with TCS in Consulting, Support, Development, Maintenance and Migration of IT systems in various databases
Technologies Worked On
Unix, Windows, Linux, Oracle9i, 10g, 11g, 12c, 19c, MS SQL Server, Azure PaaS, IaaS, Perl, Shell Scripting, Ansible, OEM, Toad, SSMS, Commvault, SQL Developer, ELK, Azure Monitor
Current Projects
- Database Support, Database technical Lead, 05/2018 - Present, Ahold Delhaize, Netherlands, Oracle 11g, 12c & 19c, MS SQL server, Progress, Azure SQL, COSMOS, 16, Netherlands, Plan, design and setup new database environments as per the business requirement, Database migration planning and execution from On-Premise DC to Azure Cloud, Analyzing and setting Azure native monitoring solutions to reduce the monitoring cost, Database backup analysis and setup with most efficient option in Azure, Responsible to maintain the Infrastructure cost on the database and resources, OEM 13c Installation in the Azure and regular upgrades in the existing environment, Self-heal automation in handling incidents through OEM till to the closure in SNOW, Incident setup and alert configurations for all database parameters, Database backup configuration in Azure Commvault, Database migration: Cross platform migrations Oracle (AIX to Linux), As-IS Migration from On-Prem to Azure, Oracle (On-Prem) to SQL migration(Azure), Oracle 12c, 11g(On-Prem) to 19c migration(Azure), Migrating large scale database to Azure cloud with minimal outage, SQL server migration from IaaS to PaaS services, Management: Weekly service review meeting with Customer and other Product owners, Tactical meetings with Customer to plan new requirement and improvement areas, Co-ordinating with application stakeholders/Customers for planning the LCM activities, Daily team meeting with the Off-shore teams, Resource planning and on-boarding to the team, Planning and scheduling change window for the database patching and upgrades, Support: Managing 1000+ Oracle, SQL and Progress databases running on Azure Cloud and On-Premise DC, Handling Major incident calls and resolving incidents on priority, Security assessment(CIS Baseline & Database backup/restore) for the ICFR database once in half yearly, Attending CAB meeting and approving the change/Service request, Preparing and RCA review with all the stockholder in case of priority incidents, Scheduling Oracle database growth report through OEM, Oracle Database performance tuning, identifying Disk latency issues, Oracle database upgrade and patching automation, Progress and SQL server upgrades at regular intervals, Following ITSM process (Incident, change, Problem Management), Managing Azure storage, identity and subscriptions, AZURE SQL and MS SQL server administration, Regular planned database refresh from production to non-production databases, Patch management once the patch is released(every quarter for Oracle) and every half yearly for MS SQL, Vulnerability management review and fixes every month, Monitoring the backup reports and restore when required
- LCM DMS, Oracle 12c, 11g, Exadata, Linux, Platform Architect, Target Corporation, USA, 13, Chennai
- Team Foundation Server(TFS), Windows server 2012, MS SQL Server, IIS, TFS, Platform Architect, Microsoft, 11, Finland
- Accept 360, Oracle 11/10g, Oracle streams, Red Hat Linux, Database Administrator, NOKIA, 11, Finland
- Woolworths (WOW DBA-DevOps), Oracle 9i/10g/11g(RAC), Exadata, Linux, Windows, UNIX, Database Administrator, Woolworths Limited, 6, Australia
- Sybase Exodus Migration, Oracle 9i/10g/11g, Sybase 12.5, DB2, Linux, Windows server, Database Analyst, Barclays Capital
- OSI (Options Symbology Initiative), Sybase, DB2, Shell Script, UNIX, Linux, Windows XP, Technical Lead, Morgan Stanley
- WDEVASG (Web Applications), Sybase, Shell Script, Html, UNIX, Linux, Windows XP, Production Support Executive, Morgan Stanley
Spoken Languages
- English
- Tamil
Whatsapp No
+91-9962502268
Education Summary
Bachelor of Computer Science, Madras University, 2001-2004
Personal Information
- Father's Name: M. Devaraj
- Date of Birth: 11/16/81
- Nationality: Indian
Technical Summary
Senior Database Administrator/ Database Architect working in Production support Environment and managing multi-terabyte database environment and mission critical large systems with total of 15 years of experience with TCS in Consulting, Support, Development, Maintenance and Migration of IT systems in various databases
Technologies Worked On
Unix, Windows, Linux, Oracle9i, 10g, 11g, 12c, 19c, MS SQL Server, Azure PaaS, IaaS, Perl, Shell Scripting, Ansible, OEM, Toad, SSMS, Commvault, SQL Developer, ELK, Azure Monitor
Current Projects
- Database Support, Database technical Lead, 05/2018 - Present, Ahold Delhaize, Netherlands, Oracle 11g, 12c & 19c, MS SQL server, Progress, Azure SQL, COSMOS, 16, Netherlands, Plan, design and setup new database environments as per the business requirement, Database migration planning and execution from On-Premise DC to Azure Cloud, Analyzing and setting Azure native monitoring solutions to reduce the monitoring cost, Database backup analysis and setup with most efficient option in Azure, Responsible to maintain the Infrastructure cost on the database and resources, OEM 13c Installation in the Azure and regular upgrades in the existing environment, Self-heal automation in handling incidents through OEM till to the closure in SNOW, Incident setup and alert configurations for all database parameters, Database backup configuration in Azure Commvault, Database migration: Cross platform migrations Oracle (AIX to Linux), As-IS Migration from On-Prem to Azure, Oracle (On-Prem) to SQL migration(Azure), Oracle 12c, 11g(On-Prem) to 19c migration(Azure), Migrating large scale database to Azure cloud with minimal outage, SQL server migration from IaaS to PaaS services, Management: Weekly service review meeting with Customer and other Product owners, Tactical meetings with Customer to plan new requirement and improvement areas, Co-ordinating with application stakeholders/Customers for planning the LCM activities, Daily team meeting with the Off-shore teams, Resource planning and on-boarding to the team, Planning and scheduling change window for the database patching and upgrades, Support: Managing 1000+ Oracle, SQL and Progress databases running on Azure Cloud and On-Premise DC, Handling Major incident calls and resolving incidents on priority, Security assessment(CIS Baseline & Database backup/restore) for the ICFR database once in half yearly, Attending CAB meeting and approving the change/Service request, Preparing and RCA review with all the stockholder in case of priority incidents, Scheduling Oracle database growth report through OEM, Oracle Database performance tuning, identifying Disk latency issues, Oracle database upgrade and patching automation, Progress and SQL server upgrades at regular intervals, Following ITSM process (Incident, change, Problem Management), Managing Azure storage, identity and subscriptions, AZURE SQL and MS SQL server administration, Regular planned database refresh from production to non-production databases, Patch management once the patch is released(every quarter for Oracle) and every half yearly for MS SQL, Vulnerability management review and fixes every month, Monitoring the backup reports and restore when required
- LCM DMS, Oracle 12c, 11g, Exadata, Linux, Platform Architect, Target Corporation, USA, 13, Chennai
- Team Foundation Server(TFS), Windows server 2012, MS SQL Server, IIS, TFS, Platform Architect, Microsoft, 11, Finland
- Accept 360, Oracle 11/10g, Oracle streams, Red Hat Linux, Database Administrator, NOKIA, 11, Finland
- Woolworths (WOW DBA-DevOps), Oracle 9i/10g/11g(RAC), Exadata, Linux, Windows, UNIX, Database Administrator, Woolworths Limited, 6, Australia
- Sybase Exodus Migration, Oracle 9i/10g/11g, Sybase 12.5, DB2, Linux, Windows server, Database Analyst, Barclays Capital
- OSI (Options Symbology Initiative), Sybase, DB2, Shell Script, UNIX, Linux, Windows XP, Technical Lead, Morgan Stanley
- WDEVASG (Web Applications), Sybase, Shell Script, Html, UNIX, Linux, Windows XP, Production Support Executive, Morgan Stanley
Spoken Languages
- English
- Tamil
Whatsapp No
+91-9962502268
Education Summary
Bachelor of Computer Science, Madras University, 2001-2004
Personal Information
- Father's Name: M. Devaraj
- Date of Birth: 11/16/81
- Nationality: Indian
Similar Profiles
Azer Abou ElsaadAzer Abou Elsaad
Admin 2 Customer Care Representative at Ahold Delhaize USA Services, LLCAdmin 2 Customer Care Representative at Ahold Delhaize USA Services, LLC
Ariet TaalaiAriet Taalai
Senior SDET Engineer at Ahold DelhaizeSenior SDET Engineer at Ahold Delhaize
Ahmed MakhlooqAhmed Makhlooq
Network Engineer at Ahold DelhaizeNetwork Engineer at Ahold Delhaize