Razorsql partition tables4/27/2023 Data issues that may cause a failure are researched and fixed before running the job to upgrade the database. Monitored scheduled database nightly upgrade on all development servers.Monitored the daily status of OTR servers using SCOM and personal scripts.Administered database objects including indexes, views, tables, clusters, sequences and procedures. Created setup installer project for 64bit platform systems to be deployed to thirty-five client systems using InstallShield Limited Edition.Maintained existing application code by updating and changing code to suit current application request from functional team.Reviewed STIG violation with STIG viewer and applied fixes to reduce vulnerabilities.Compiled 32bit, net codes to be compatible with Microsoft 64bit systems.Restored and recovered database for development and production servers on both standalone and RAC servers.Successfully installed 11g and 12c Oracle software and created a database.Supported and troubleshot production database upgrades for Sever Support Team on Call basis.Set up Rman backup for standalone and Real Application Cluster databases.Upgraded oracle 11g database to oracle 12c on 150 production servers over time using DBUA.Applied Oracle security patches quarterly to both software and databases to limit vulnerability on both standalone and cluster servers.Maintained, troubleshot, configured and recovered both standalone and RAC databases.Cloned Real Application Cluster production database to a test environment.Created oracle wallet for application service accounts for secured access to database.Upgraded Mongodb version 3.2, 3.4 and 3.6.Applied periodic patch to Mongodb boxes.Configured Opsmanager for data backup, recovery and monitoring.Created mongo - connector for elastic search for data collection.Refreshed mongo databases for developers to troubleshoot productions issues.Installed Mongodb 4.0, 3.6 and 3.4 on linux 7 servers including development, test, stage and production.Upgraded and reconfigured a mobile application 2.6 sync gateway to control the cache size and reduce RAM usage on the node.Setting up EC2 instances and building cloud formation for Couchbase clusters.Upgrading Mongodb to its current version, creates Mongodb accounts and manages Mongodb clusters for sustainability and performance Optimization.Maintaining database backup and troubleshooting failures for database recovery and restore.Auditing and configuring both Mongodb and Couchbase clusters to stay in compliance with updated GDPR including Data encryption.Keeping development, QA and Production Mongodb and Couchbase servers up to date with necessary upgrades.Building Disaster Recovery clusters and creating XDCR for data replication across two data centers.Refreshing databases across multiple environment as part of application migration or troubleshooting.Repairing corrupted data to a recoverable state and syncing data across other data bearing nodes.Lead disaster recovery exercise for all united application on mongodb and couchbase databases.Tuning databases performance, creating and building necessary indexes for high optimization.Troubleshooting and configuring sync gateway for data synchronization.Installing, configuring and setting up Couchbase clusters with the highest of 16 nodes.Lead my team to complete annual projects to support United commercial Mobile and Web applications.MS Office: Word, Excel, Power point, Access, cmd Net Framework 4.0, SQL Developer, Cdata sql, Opsmanager, RazorSQL, Robo 3T, Mongodb Compass, cbbackup,cbbackupmgr,Curl, Mongo shell Tools: /Utilities: RAC, DBCA, Listener, TNSPING, RMAN, OEM, Export, SQL*Loader, Opatch, Oracle Warehouse Builder, Data Pump, NETCA, DBUA, Oracle Universal installer, Oracle VM Virtual Box, ADRCI, Stata, Database Application, Net Manager, Toad, DBmanager, PVCS Version Manager, Git, Eclipse, Visual Studio 2015. Languages: SQL, PL/SQL, Batch and Shell Scripting, Java, C# Couchbase, Sync Gateway, AWS, Openshift Ansible, Jenkins, appDynamic RDBMS/Application: Oracle 12c/11g/10g, SQL Server 2012, Oracle SQL Developer, Oracle Enterprise Manager, Toad, SSH,Winscp, Mongodb, Liquibase. Operating System: Linux RedHat, Windows, Unix, Window 2012/2008/2003 Server, DOS
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |