| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEProfessional SummaryI have over 18 years of experience in Database Administration, with expertise in GoldenGate, Cloud Technologies, MongoDB, PostgreSQL, Azure, and AWS. My experience includes database administration on both on-premises and in the cloud, with a strong track record of managing 24x7 mission-critical very large Databases & Applications while ensuring cost-effectiveness.CertificationsOracle Certified Professional Cloud Database Administrator (OCP)Oracle Certified Database professional in Database Administration. (OCP)Oracle Certified PL/SQL AssociateAWS Certified Cloud PractitionerMicrosoft Certified DeveloperWork Authorization: USA CitizenIndustry Served: Leading Healthcare, E-Commerce, Vehicle History & Insurance ClientsTools:Oracle, MongoDB, PostgreSQL, Cloud Tooling, AWS, Linux, GoldenGate, ASM, OEM, EXADATA, WebLogic, Oracle Cloud, JAVA,JSON, PL/SQL, Shell Scripting, Azure, AWSVirtualization, Docker Container.Technical SkillsOracle GoldenGateCloud Technologies Oracle, Azure & AWSOracle GoldenGate Install, Configure & PatchingGoldengate Troubleshooting, Replication Lags, Process Abend issuesGoldenGate Performance troubleshootingGoldenGate Heterogeneous data replication from Oracle to DB2Handling bi-directional GoldenGate replication and data issuesGoldenGate MonitoringParameter changes and tables additions and modificationGoldenGate Mappings source and target objectsException & Error handling in the GoldenGateGoldenGate MicroservicesMongoDBInstalling MongoDB on servers and configuring it for production use.Setting up configurations like storage engines, replication, and sharding as needed.Managing snapshots and backups in cloud environments.Managing user roles and permissions.Monitoring replica set health and ensuring data consistency.Monitoring shard health and performance.Applying patches and updates to keep MongoDB up to date.Cost Estimation and Resource PlanningScaling resources up or down based on workload demands.Migrated oracle databases from on-prem to Oracle OCI in ExadataMigrated databases to Oracle, AWS RDS and Azure CloudCreated & set up backup procedures in the secure Cloud Bucket.Setting up Alerts for to monitor Cost & Service AvailabilityUsed Cloud tools to create various resources in Oracle OCI & Amazon AWSCreated Cloud Infrastructures such as Buckets, Instances, Servers, DBaaSCreated & configured VM Servers in Cloud .Configured Cloud database with OEM & Added enhanced monitoringDeveloped and tested disaster recovery plans and procedures.PostgreSQLInstalling PostgreSQL database software on servers and configuringBackup of PostgreSQL databaseTest PostgreSQL database restore.Monitoring database performance and identifying and resolving performance bottlenecks.Managing database access and security by configuring rolesConfiguring high availability solutions such as replication, clustering, or failover.Applying patches in PostgreSQLCore Database AdministrationMySQLInstalled Oracle 10g to 19c Real application cluster databases.Created Data Modeling & Schema Designing.Infrastructure as a service(IaaS), Database as a service DBaaS, PaaS, and Software as a service Model in Oracle cloud.Administered Oracle Non-RAC and RAC databases.Managed ASM Disks & Diskgroups.Physical Standby Databases for Disaster recovery.Database Flashback.Applied Oracle Patches for bug fixing and database upgrade.Upgraded databases from 10g,11g to 12c & 19cDatabase Refresh from Production to Other Databases.Data Extractions, Database Replication.Oracle Job Queue, Batch Jobs.User Management, Database AuditingRMAN, Backup and RecoveryBatch processing using PL/SQL, Java., Control-MInstall and Configure MYSQL Databases in various environmentsDatabase Performance Tuning MySQL Databases.Trouble shooting and fixing problems using proactive approaches.Tune queries by rewriting, creating indexes, allocating spaces, studying SQL plans & tracing the execution.MYSQL Backup and RestoreMySQL Data refresh, Dev test Environments.Database SecurityCreated roles and procedure for database security and Application access.Wrote script for Securing database by creating user profiles.Enable Database auditing, monitoring & alerting.Setup Enterprise database authentication via OIDFine Grained Access Control, Database Auditing, Data AnonymizationWork HistoryClient: Accenture USA. OCT 2014. Mar 2024Client: Kansas Department of HealthRole: Database AdministratorEnvironment: Oracle 12c,19c RAC, JAVA, PL/SQL, Oracle Goldengate, Cloud, Exadata,OEM 13c, MongoDB,PostgreSQLOracle RAC, Exadata, ASMInstalled and configured Oracle databases (11g, 12c, 18c, 19c) and Oracle 13c grid control on Linux and Aix platforms.Planning and executing database migrations from on-premises or other cloud platforms to the cloud.Managed and maintained databases on Oracle Cloud ( Exadata/ExaCS).Successfully upgraded databases from Oracle 11g to 12c, 18c, and 19c.Orchestrated database migrations from on-premises to Oracle OCI on Exadata Machines.Proficiently administered databases in various development, testing, and production environments.Applied patches to keep databases up to date and secure.Add/Remove Oracle ASM Disks, Created ASM DiskgroupsConfigured Oracle Enterprise Manager (OEM), Added Hosts, Databases and other TargetsCreate ACFS from ASM DiskgroupsApplied Java and GoldenGate patches.Created and managed standby databases using Oracle DataGuard for disaster recovery.Oversaw Oracle RAC installation, administration, and maintenance.Wrote SQL and PL/SQL code to support business.Migrated on-premises databases to Oracle Cloud.Participated in scalability testing and proactively improved database performance.Ensured database security and fine-grained access control.MongoDBInstalled MongoDB on servers and configuring it for production use.Setting up configurations like storage engines, replication, and sharding as needed.Managed snapshots and backups in cloud environments.Managed user roles and permissions.Added and Removed tables in the Existing EnvironmentManaged replica set health and ensuring data consistency.Monitored shard health and performance.Applied patches and updates to keep MongoDB up to date.Monitored MongoDB collections and related data on MongoDB Atlas.Performed MongoDB upgrades on various platforms.GoldengateInstalling Oracle GoldenGate software on source and target systems.Configuring GoldenGate instances for various replication topologies.Setting up GoldenGate parameters to define replication processes.Tuning GoldenGate parameters for optimal performance based on system resources and network conditions.Handling filtering and transformation of captured data.Creating and configuring GoldenGate replication groups, trails, and extracts.Defining replication paths and mappings for data movement.Setting up GoldenGate Data Pump processes to move data between source and target databases.Monitoring GoldenGate processes and components.Troubleshooting GoldenGate replication issues, such as lag and process failures.PostgreSQLInstalling PostgreSQL database software on servers and configuringBackup of PostgreSQL databaseTest PostgreSQL database restore.Monitoring database performance and identifying and resolving performance bottlenecks.Managing database access and security by configuring rolesConfiguring high availability solutions such as replication, clustering, or failover.Applying patches in PostgreSQLMySQLInstall and Configure MYSQL Databases in various environmentsDatabase Performance Tuning MySQL Databases.Trouble shooting and fixing problems using proactive approaches.Tune queries by rewriting, creating indexes, allocating spaces, studying SQL plans.MYSQL Backup and RestoreMySQL Data refresh, Dev test EnvironmentsEnterprise Holdings Inc, St. Louis, MO March 2013 - May 2014Environment: Oracle 12c, RAC, JAVA, PL/SQL, PostgreSQL, Linux, ASMRole: Database AdministratorCreated ASM and standard non-ASM databases to meet varying business requirements.Designed database schemas and objects, including tables, indexes, triggers, and sequences for E-CAR online and batch systems.Developed code for database functions and stored procedures using PL/SQL.Implemented custom scripts for space usage alerts in table spaces, data files, and databases.Established robust backup and recovery strategies using RMAN and custom scripts tailored to business needs.Created and maintained roles, procedures, and scripts to enhance database security.Implemented audits, triggers, and alerts to monitor and secure sensitive data.Provided day-to-day support to customers, resolving database access issues promptly.Monitored database performance using custom scripts (e.g., PM3) and documented findings.Managed data replication from production to other databases using GoldenGate.Created and scheduled database jobs using tools like Scheduler, Ctrl-m, and Tivoli.Efficiently performed data export/import using Data Pump.Monitored and reported on database performance statistics.Implemented robust database security measures and monitoring protocols.Assisted developers in code promotion and collaborated with team members for database-related projects.Facilitated off-hours business and customer support.Estimated disaster recovery plans, documented scenarios, and communicated with users to define database projects.Created and maintained ASM Standby databases.Managed proper backups and maintained comprehensive documentation.Analyzed AWR reports to troubleshoot performance-related issues and optimized database performance.Evaluated backup strategies to enhance database recovery and restoration processes.Designed, implemented, and managed security roles.Created and maintained Data Guard and RAC setups of different configurations.Conducted database upgrades to Oracle 11g.Organized and participated in meetings to explore new database features and plan disaster recovery strategies.Collaborated with cross-functional teams to support the business and facilitate deployments of TEST, DEV, and PROD databasesduring off-cycles and quarterly releases.Managed multiple PostgreSQL databases.Created backup plans and tested PostgreSQLDeveloped and deployed scripts for various deployments in payment, ECS, and Ecars databases.University Of Missouri, Columbia Mar 2010 - Mar 2013Environment: Oracle, SQL Server, .Net, ASP.NET,VB.NETRole: Database AnalystEnvironment: Oracle 10g, 11g, SQL Server, .Net, SQL, PL/SQLSupported alumni system by creating oracle database objects and wed portal to support alumni business and customers.Worked on Sunguard portal for campus solutions and support oracle database objects in the backend.Rewrote and old mally code in ms apps and created and used oracle database object to develop alumni address, studentinformation product.Prepared database for RMAN backup and documenting backup Scenarios.Making Sure all backups are successful and cooperate with system Admin for tape backupImport export data using oracle data pump.Worked with Developers to solve problems and promote codesCreated Stored procedures, triggers and other database Objects.Applied Database patches as necessaryCopy data from Production SQL server to Oracle databaseTesting Oracle Databases after any major changesCreated shell scripts to run jobs in windows and Linux.Used Export/Import and Data pump to move data from one database to other or storing these backup for future use.Assisted Developers in Design Application Schemas, Data ModelingManaged Oracle Users, Grants, RolesAdministered all database objects, including tables, indexes, views, sequences, packages and procedures.Setup and maintain documentation and standardsReplicated Data from one database to other databases using materialized viewCreated New Database objects & new Procedures, ScriptsAssisted Solving day to day new development & Production issues related to database & Java web based front end, Data refresh,Worked with end users and other members of different departments.Worked as part of a team and provide 7x24 support when required.CARFAX Inc Oct 2006 - Feb 2010Role: Oracle Application Developer / DBA in Agile EnvironmentEnvironment: Oracle 10g, 11g, JAVA, SQL,PL/SQL, Agile Methodology, Linux, Oracle Designer, MongoDB, ASP.NET,VB.NETResponsibilities: -Worked as Database Applications developer role in Agile EnvironmentData replication using Database Links and Materialized viewsDatabase Refresh from Production to Test InstancesDatabase monitoring, Job queuesCreate Oracle RAC database.Managed Real Application Cluster switch over, failover via DataGuardCreated Indexes, rebuild Indexes to save space and Speedup QueriesMongoDB Proof of concepts for Vehicle History document databasesWrote various SQLs, Stored Procedures, Triggers, FunctionsIdentified the use of Database Security, Role Management etcWrote Batch jobs using PL/SQLInstalled MongoDB on multiple Servers for VHDB databases.Created MongoDB backup plansManaged and Troubleshoot MongoDB node replication.MongoDB user managementSQL tuning by Re-writing queries and adding IndexesParticipation in database design & Modeling, Upgrade & Maintenance processMaking Sure standards are implemented through database objects naming such as Tables, Users, Indexes, Constraints etc,Performed Automated testing Continuous Integration.Object Oriented Design and development of Java Classes, Objects etcPerformed off hours On-Call production support responsibilities as neededDeveloped Common Classes, Procedures used in various projectsCoordinated with the end user, DBAs and Analysts to ensure the changes in the application is meeting all the requirement and performing well in the production system.Worked as part of a team and provide 7x24 support when requiredEligible to WorkUS Citizen |
