| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLEhttps://LINKEDIN LINK AVAILABLEProfessional Experience:10+ years of experience. 7+ experience in Oracle Core DBA and 2+ experience in PostgreSQL Database Administrator with Production, Testing and Development database. Supporting technologies like Data Guard, Backups, RMAN, Data Pump, Patching, Up-gradation, RAC, Disaster recovery.Currently working as Production Support Oracle Database Administrator in HCM Square LLC.Monitoring Oracle10g, 11g and 19c database on Linux and Windows platforms as Core DBA.Experience on RAC Installations, Data Guard Setups, fixing bugs, applying Patches, Managing ASM Databases.Expertise in upgrading databases from 10g to 11g and 12c and 19calong with regular Patching.Experience in Installation, configuration of Postgres 9.6/10/11 databases.Managing the Postgres SQL.conf and pg_hba.conf configuration.Database Roles and Privileges. PostgreSQL manages database access permissions using the concept of roles.Performing backups using SQL dump utilites (pg_dump) and pg_basebackup utilities.Experience on Restore/Recover of cluster databases.Creating an Exadata Cloud at Customer InstanceScaling an Exadata Cloud at Customer InstanceSuspending and Resuming an Exadata Cloud at Customer InstanceStrong experience in Oracle Core Database administration and monitoring including Exposure to Performance of ExadataExperience with migration of Oracle Databases from On-premise to Oracle Exadata Cloud at CustomerExperience with Oracle Enterprise Manager (OEM).Experience with Patch/Upgrade and release management (database, storage node, server, network, Oracle Exadata) Develop and maintain system documentation related to your Oracle Exadata and software configuration
Oracle Exadatas Storage Indexes are a highly effective tool for reducing unnecessary I/O operations, and thereby, improving query performance.Smart Scans offer another layer of performance optimization. Exadatas storage cells are intelligent enough to filter out rows and columns that are not relevant to a query before sending data back to the compute nodes.Smart Scans are especially useful for full table scans and large joins, which are common in complex queries and analytics tasks.Apply process and architectural improvements to continually improve the availability, capacity, and performance of database systems
Backing Up and Restoring Databases on Exadata Cloud at CustomerExperience on upgrade of postgres databases.Experience in setting up and managing physical standby using Hot Standby and Streaming replication.Daily log analysis using pgbadger tool and query tuning.Perform health check of databases. Involved in performance tuning.Providing 24/7 On-call remote Oracle and PostgreSQL DBA support for Global Business clients.I have knowledge on AWS cloud platform and PostgreSQL.Certifications:Oracle Autonomous Database Specialist.Oracle Cloud Infrastructure Foundations Certification.Oracle Cloud Infrastructure Architect Associate Certification.Oracle Cloud Infrastructure Architect Professional Certification.Technical Skills:DatabaseOracle10g/11g/12c/19c, Exadata, ZDLRA, ZFS, AWS, OCI,Azure Cloud, EDB Postgres 9.6/10.x/11Operating SystemWindows 2012, 2008, Red hat Linux/CentOS 7, Oracle Linux, AIXProgramming LanguageC, SQL, Core Java, Core Python, Shell Scripting, Pg/plsql.ToolsData Pump, 13c OEM, SQL Developer,Toad, PEM, PGADMIN, pg_dump, pg_restore, pg_dumpall and pg_ctlMS OfficeExcel, Power PointClient: Pacific Gas and Electric (PG&E)Role: Technology LeadDuration: Dec -2023 to till dateResponsibilities:Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.Upgraded Oracle 11.2.0.3 database to Oracle 11.2.0.4/12C/19C database manually/DBUA.Manual upgrade using the Parallel Upgrade Utility, and other command-line utilitiesProvides a graphical user interface that guides you through the upgrade of a database.DBUA can be launched during installation with the Oracle Universal Installer, or you can launch DBUA as a standalone tool at any time in the future. Enables upgrades to be performed using shell scripts.Provides export and import utilities. Oracle Data Pump can perform a full or partial export from your database, followed by a full, or partial import into the new release of Oracle Database.Export/Import in Oracle Data Pump can copy a subset of the data, leaving the database unchanged.Upgrading CDBs and PDBs using a priority list to group and upgrade PDBs according to their priority.Run the Parallel Upgrade Utility (dbupgrade, or catctl.pl) using the -L option to run the upgrade using a priority list, and to call that list as the upgrade runs.Installing and upgrading the Oracle server and application toolsAllocating system storage and planning future storage requirements for the database systemModifying the database structure, as necessary, from information given by application developersEnrolling users and maintaining system security and Ensuring compliance with your Oracle license agreementControlling and monitoring user access to the database and Monitoring and optimizing the performance of the databaseCreating primary database storage structures (tablespaces) after application developers have designed an applicationCreating primary objects (tables, views, indexes) once application developers have designed an applicationPlanning for backup and recovery of database information and Maintaining archived data on tape, backing up and restoring the databaseContacting Oracle Corporation for technical supportIn a Rapid Home Provisioning upgrade, you carry out a new Oracle Database installation. After testing the database, and modifying it in accordance with the standard operating environment (SOE) that you want to use for your databases, you create an RHP gold image.As a DBA deploys instances of that gold image to servers that have earlier release databases that you want to upgrade. After deployment of these gold images, a DBA can run a single rhpctl command to move files, perform configuration changes, and perform other steps required to use the new binaries.Performs the capacity reduction required to eliminate the unwanted storage and maintain the databases.Space reduction in database by index rebuild, data file shrink and exchange partition with respect to archive the old data into some other archival table space then move the archival data into other server.Creates and maintains all databases required for development, testing and production usage.Installed, configured and maintained PostgreSQL 9.6 and 10.x.Performing logical backups using pg_dump, pg_dumpall and pg_restore utilities and restore specific objects and schemas.Backup and Recovery using hot backup method and pg_dump/pg_restore utilities.Creation of databases and configuration of rules in pg_hba.conf file.Creation of users and assigning roles & permissions to the users.Performed Database Cloning and refresh on to Test environment using pg_dump and cold backup methods.Provides a graphical user interface that guides you through the upgrade of a database. DBUA can be launched during installation with the Oracle Universal Installer, or you can launch DBUA as a standalone tool at any time in the future. Enables upgrades to be performed using shell scripts.Environment: Postgres 9.6/10.x/11, Oracle 12C, 19C.Client: Union Bank of Switzerland (UBS)Role: Technology LeadDuration: Oct -2021 to Dec 2023Responsibilities:Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff.Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.Upgraded Oracle 11.2.0.3 database to Oracle 11.2.0.4/12C/19C database manually/DBUA.Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.Evaluates releases of Oracle and its tools, and third-party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.Creation of databases and configuration of rules in pg_hba.conf file.Creation of users and assigning roles & permissions to the users.Performed Database Cloning and refresh on to Test environment using pg_dump and cold backup methods.Experience on upgrade of postgres databases.Analyse the logs daily and fix any postgres issues reported in the logsPerforming backups using SQL dump utilities (pg_dump) and pg_basebackup utilities.Experience in taking regular Backups.Experience to configure pgbadger and pgbouncerWorking on EDB Postgres databases and work experience on migration from oracle to postgres using EDB-MTK.Good experience on PEM (postgres enterprise manager).Environment: Linux, Exadata, Oracle 11g, 12C, 19C, Postgres 9.6/10.x RHEL 5.6.Company: Burgeon IT ServicesRole: Technology LeadDuration: Apr -2021 to Oct 2021Responsibilities:Creates and maintains all databases required for development, testing and production usage. Create new database users as required.Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.Expertise in performing Switch Over and Switch Back activity from production to standby.Upgraded and Migrate Oracle 11.2.0.3 database to Oracle 11.2.0.4/12C/18C/19C database manually/DBUA.Environment: Linux, Exadata, Oracle 11g, 12C, 19C.Client: Pacific Management Investment Company (PIMCO)Role: Database AdministratorDuration: Aug -2018 to April -2021Responsibilities:Upgraded Oracle 11.2.0.3 database to Oracle 11.2.0.4/12C/19C database manually/DBUA.Oracle performance tuning analysis using Stats pack/AWR/ADDM/ASH reports.First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.Provide and implement performance-tuning recommendations of all components in Exadata database machine.Advice, provide guidance, and develop Disaster Recovery strategies for the Exadata Database machine.Supporting/monitoring 8-node Oracle 11g RAC on Oracle Cluster ware platforms on high availability environment and writing shell scripting for various database maintenance and alerting activities.Deep understanding about Exadata specified features such as Smart Scan, HCC Hybrid Columnar Compression, Flash Cache, etc.Good exposure knowledge in applying patches to the database like PSU patches.Having expert knowledge in Configuring and maintaining RMAN.Data guard Setups, fixing bugs, applying Patches, Managing ASM Databases, and Performance issues on RAC Databases.Collecting and generating hourly stats by AWR Report whenever there are performance issues.Coordinating with other teams like testing / Developers for fixing up issues.SQL Quarantine will need to setup configuration and define thresholds for specific execution plan for given sql id or for all plans for sql_id.The thresholds are similar like resource manager threshold ex: cpu limit, elapsed_time limit etc.Provided 24X7 on call support. Proficient in UNIX/Linux Operating systems.Environment: Linux, Exadata, Oracle 11g, 12C,19C, RAC, ZFS, ZDLRA.Client: Reliance Jio Infocomm Pvt LtdRole: Database AdministratorDuration: Jan -2015 to July - 2018Responsibilities:Successfully implemented and managing Physical Standby Database using Oracle DATAGAURD feature for Disaster Recovery.Create databases for development, testing and production (including RAC databases and NON-RAC databases).Communicating with the Client Technical/Service Leads and satisfying the Client needs yet to their requirements.Resolving OnCall issues including Monitoring, Ticket resolution and Work/ Change requests.Extensive hands-on experience on recovery of data block corrupted databases using RMAN.Performing Refresh activities from Production to Staging/development using RMAN and Data pump.Scheduling and managing crontab Jobs. Managing Archive logs and Full Back up by RMAN.Moving or backing up old archives with RMAN if File system is filled.Identifying and improving poorly performing SQL Statements, adjusting the most important optimizer parameters.Migrating database from Non RAC to RAC Environment, cross plat form migration. Enabling archive log and flash back database. Rebuilding standby database using production backup and making sure DR and PROD are in sync after change.Managing Physical structure of Oracle database like Data files, Redo log files, Control files.Monitoring the growth of Table spaces and taking proper actions.Maintaining security and integrity of database of database systems.Environment: Linux, Oracle 10g, 11g, 12C, RAC.Client: ATT Solutions Pvt LimitedRole: Network EngineerDuration: Sep - 2013 to Dec -2014Responsibilities:Maintaining KPIs SSSR, RRC CSR, VDR, HOSR etc.Maintaining the RF KPIs above the defined threshold through field optimization and parameter Optimization for LTE and VOLTE.Coordination with Survey team for New Site identification for capacity & coverage improvement, RF site survey approval/disapprovals.Manage site process and review milestone (RFE, RFR, RFS)Responsible for VIP customers 4G coverage solution through Wi-Fi, Small Indoor /Outdoor cell in Hotspot area.Planning and prediction for new Outdoor (Macro, Micro and Pico (Small Cells)) and Indoor (IBS) sites based on traffic dimensioning and survey.Analyze customer complains & take necessary actions to resolve.Provide Feedback for site planning, in-building solutions planning & optimization.Environment: Linux, Networking.Educational Qualification:B. Tech - Abdul Kalam Institute of Technological. |
