07/25/2024 updated
SP
100 % available
Senior Database Administrator - Lead Technology, Database Administrator, IT Technician
London, United Kingdom
Worldwide
Masters in Network Management and Cloud ComputingAmazon Web ServicesAmazon Elastic Compute CloudAmazon S3Microsoft AzureCloud ComputingCluster AnalysisDatabasesDesktop ComputingLinuxDevOpsDisaster RecoveryVMware ESX ServersVMware ServersSubnettingLog Shipping
EC2, S3, VPC, Amazon Web Services, Cloud Computing, CloudWatch, Clustering, Storage Management, Database Installation, Database, databases, computers, DevOps, Disaster Recovery, Linux, Load Balancing, Log shipping, Microsoft Azure, SQL Server databases, Microsoft SQL Server, Network Management, Oracle, Data guard, Oracle database, Oracle 11g, 12c, Oracle Golden Gate, Oracle Enterprise Linux, Real Application Clusters, PLSQL, password management, Performance Tuning, peripherals, RMAN, RedHat, Routing, SQL, SSIS, SSRS, Shell Scripting, Subnetting, VMWare ESXi
Experience
Professional experience5 - 10 years
Freelancer since2024
Languages
EnglishFluentHindiFluentTeluguNative speaker
Project history
* Fulfilled backup, restore, refreshing databases as per the client specifications as a part of assigned
responsibilities.
* Demonstrated proficiency in performing Oracle database switchover and switchback using DGMGRL to
guarantee seamless and uninterrupted functionality.
* Proficiently performed data refreshing of lower environments using Oracle utilities EXPDP and IMPDP to
facilitate effective testing for optimal system performance.
* Restored RMAN backups for audit purposes, ensuring compliance with regulatory requirements.
* Conducting daily monitoring and troubleshooting of scheduled jobs and disk spaces across all SQL Server
databases
* Installation, configuration, upgrading and managing of Oracle 11g, Oracle 12c databases.
* Implement RAC and Data guard setup and management.
* Successfully implemented automation for periodic data refresh resulting in a 50% reduction in resource
involvement, while ensuring client satisfaction and meeting their requirements
* Engaged in collaborative efforts with cross-functional teams such as Development, DevOps, and Testing,
to proficiently diagnose and resolve intricate technical challenges.
responsibilities.
* Demonstrated proficiency in performing Oracle database switchover and switchback using DGMGRL to
guarantee seamless and uninterrupted functionality.
* Proficiently performed data refreshing of lower environments using Oracle utilities EXPDP and IMPDP to
facilitate effective testing for optimal system performance.
* Restored RMAN backups for audit purposes, ensuring compliance with regulatory requirements.
* Conducting daily monitoring and troubleshooting of scheduled jobs and disk spaces across all SQL Server
databases
* Installation, configuration, upgrading and managing of Oracle 11g, Oracle 12c databases.
* Implement RAC and Data guard setup and management.
* Successfully implemented automation for periodic data refresh resulting in a 50% reduction in resource
involvement, while ensuring client satisfaction and meeting their requirements
* Engaged in collaborative efforts with cross-functional teams such as Development, DevOps, and Testing,
to proficiently diagnose and resolve intricate technical challenges.
Project: Wells Fargo Bank
Senior Database Administrator - Lead Technology
Synechron Technologies, Bangalore, India Apr' 17 - Jul' 19
* Expertise in conducting Disaster Recovery (DR) drills using DGMGRL.
* Utilised best practices to simulate potential disasters and test the failover capability of the system, ensuring
business continuity and data availability.
* Collaborated with cross-functional teams to identify and resolve any issues that arose during the DR drill,
providing timely solutions to ensure system integrity.
* Executed patching on 11g and 12c databases, bolstering system security and guaranteeing consistent
stability.
* Upgraded 11g databases to 12c, ensuring system compatibility and stability.
* Conducted thorough pre-upgrade testing and post-upgrade validation to identify and resolve any issues
that may arise during the migration process.
* Created detailed documentation of the upgrade process and provided training to team members on the
new features and functionalities of the 12c database.
Senior Database Administrator - Lead Technology
Synechron Technologies, Bangalore, India Apr' 17 - Jul' 19
* Expertise in conducting Disaster Recovery (DR) drills using DGMGRL.
* Utilised best practices to simulate potential disasters and test the failover capability of the system, ensuring
business continuity and data availability.
* Collaborated with cross-functional teams to identify and resolve any issues that arose during the DR drill,
providing timely solutions to ensure system integrity.
* Executed patching on 11g and 12c databases, bolstering system security and guaranteeing consistent
stability.
* Upgraded 11g databases to 12c, ensuring system compatibility and stability.
* Conducted thorough pre-upgrade testing and post-upgrade validation to identify and resolve any issues
that may arise during the migration process.
* Created detailed documentation of the upgrade process and provided training to team members on the
new features and functionalities of the 12c database.
* Implemented efficient strategies for tablespace creations, optimising performance and storage utilisation.
* Established streamlined procedures for user creations, ensuring adherence to security policies and robust
password management practices.
* Established streamlined procedures for user creations, ensuring adherence to security policies and robust
password management practices.