| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEDBA Blog https://dbasadda.blogspot.comWorking as a Database Administrator with over 12 years of experience in the IT industry as an Oracle DBA /Netezza DBA/AWS Cloud Migration 10 years as a PostgreSQL DBA in Community Edition. Experience in Cloud Database migration for homogeneous and heterogeneous databases. My core expertise lies in the Design, Installation, Administration, Performance Tuning, Backup, Recovery, Production support, Troubleshooting, Implementation, testing, Cloning, Upgrades, Patching, multi-node installation & Migration of Oracle 11g, 12c and 19c databases on UNIX (HP-UX, Sun Solaris, Linux and AIX). I have niche experience in leading and managing the mid-size to large teams both onsite as well as offshore. Strong experience in managing large databases sizes ranging from 30GB to 10TB and has excellent knowledge in RAC, Data Guard, Export/Import, expdp/impdp, RMAN, SQL*Loader, Oracle Enterprise Manager (OEM).I have very good hands on experience working in a production environment along with design continuity of business plan for database and provides support and recommendation with high quality performance metrics.Expertise in supporting AWS Cloud infrastructure, Oracle database Administration, Oracle DB Migration to Oracle 12c & 19c /PostgreSQL/Aurora PostgreSQL RDS Cloud, Production support. Supporting and consulting for global customers like Capital One, Guitar centerTECHNICAL SKILLS:Operating Systems: HP-UX 11.23i, Solaris 9.0/10, RHEL 5,6,7 AIX 5.1, 6.1Databases: Netezza 6.0.2/7.0.2/7.2.0 Oracle 10g R2, 11g 12c, 19c, Postgres 9.5,9.6,11,12Oracle & PostgreSQL on EC2 and RDS, SQL server, TimescaleDB 2.2Applications: Connect: Direct Server, FA Select., secure y FTP+Remote Proxy (FTP secure), Oracle RDBMS 11g R2, 12c,19c Oracle Data Guard 11g R2, 12c and 19c Oracle Grid Control 10g R2, 12c SQL, PL/SQL, Performance Reports AWR, ASH, ADDM. Oracle & PostgreSQL on EC2 and RDS.Languages: SQL, PL/SQL, Shell scripting in Kron-shell, C-shell,Tools: OEM, RMAN, SQL*Plus, SQL*Loader, Oracle Export/Import, Toad,CA Remedy for ticket management, Netezza Admin tool,Aginity Netezza Workbench, Golden Gate, AWS Could Monitoring, Jenkins,UCD, GitHub, BitBucket, DataDog . HAProxy, Patroni, etcd, Dremio, PingIDFannie Mae Oct 19 Till DateRole: Lead Database EngineerProject: Fannie Mae, Reston, VADescription: The Federal National Mortgage Association, commonly known as Fannie Mae, throughout the United States. I am working as a Database Engineer. There are more than 30 production and Test/DEV/QA Oracle/postgresql and Migration of Oracle to PostgreSQL/Aurora PostgreSQL RDS Database on AWS cloud EC 2 and on Physical servers.Responsibilities:Experience in Working with RAC Databases.Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.Supporting 30+ production instances of large databases of Oracle and Postgresql.Configuration of Golden Gate in RAC and Non-RAC environment.Configuration, Implement and manage ping identity Directory.Configuring PingDirectory Server and installation of Ping Directory packages.Setup Golden Gate monitoring using JAGENT in OEM 12c.Configuration of Golden gate on NFS and DBFS.Managing Oracle Database with RAC and Non-RAC with ASM file system.Experience in High Availability of system with GRID infrastructure.Experience in Managing PostgreSQL Database in HA using Patroni, HA Proxy, etcd on EC2 server.Experience in Managing PostgreSQL Databases in AWS RDS.Experience in Managing PostgreSQL timescaleDB Databases on ec2Experience in applying critical patches and patch sets whenever required.Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.Experience in Cloud Database migration for homogeneous and heterogeneous databases like Oracle to PostgreSQL and Aurora PostgreSQL RDS.Experience in using pgbouncer is to lower the performance impact of opening new connections to PostgreSQL.Experience with PGBouncer and how it is related to High availabilityExperience in Platform Development, Maintenance and DevOps experienceExpertise in Launching and managing AWS Services, Configuring launched instances with respect to application requirements.Proficiency with Platform Migration from On-Prem to Cloud technologies.Experience in Continuous integration (Jenkins)Expertise in configuring the storage and S3 buckets. Working on database migration using AWS Schema conversion tool and Database migration service.Help application team to Build servers using AWS, Attach/Detach volumes, Create AMIs, perform rehydration of EC2, Creation of Security groups, auto scaling and ELBs.Experience in writing Lambda function, Step functions, SNS, Event Subscriptions.Experience in writing automation job using Jenkins for launch of AWS EC2 instances.Supporting Oracle DB Migration to AWS Cloud.Serve as support for database administration tasks including configuration management, backup/recovery, performance optimization, and space managementPerform database deployments and provide support for application releasesGood knowledge of High Availability (HA), Always On and Disaster Recovery (DR) options for MSSQL ServerYou are proficient with SQL Server 2005/2008 / 2008 R2 / 2012 & 2014 optimization, fine-tuning, and scalability techniques with knowledge of SSISEnvironment:Cloud - Amazon Web Services (AWS), EC2, RDS, DMS, Volumes, AMIs, CFTsOracle 12c and 19c production databases and standby databases on Linux 5, 6,7, PostgreSQL community Edition 9.3, 9.4,11,12 MS SQL Server.Capital One Bank May 17 Oct 19Role: Lead Database AdministratorProject: Capital One Bank, Richmond, VADescription: CapitalOne Bank is the largest chain of online banking and Credit Card throughout the United States. I am working as a DBA. There are more than 50 production and Test/DEV/QA DB with RAC, ASM in Oracle 11g, 12c, and 19c Postgresql Database on AWS cloud EC 2 and RDS and on Physical servers.Responsibilities:Supported 50+ production instances of large databases of Oracle and Postgresql.Managing Oracle Database with RAC and Non-RAC with ASM file system.Experience in High Availability of system with GRID infrastructure.Experience in applying critical patches and patch sets whenever required.Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.Up-gradation and Migration of Database from 10g to 11g, 12c and then applying patches whenever required.Handling 11g RAC on nodes for high availability.Experience in Working with RAC Databases.Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.Developing and Implementing Disaster Recovery (DR) Plan using Datagaurd.I along with team implemented physical Standby database using Datagaurd.Supporting oracle and PostgreSQL RDS services in Amazon Cloud Services.Expertise in Launching and managing AWS Services, Configuring launched instances with respect to application requirements.Expertise in configuring the storage and S3 buckets. Working on database migration using AWS Schema conversion tool and Database migration service.Help application team to Build servers using AWS, Attach/Detach volumes, Create AMIs, perform rehydration of EC2, Creation of Security groups, auto scaling and ELBs.Experience in writing Lambda function, Step functions, SNS, Event Subscriptions.Experience in writing automation job using Jenkins for launch of AWS EC2 instances.Supporting Oracle DB Migration to AWS Cloud.Experience in Source code mgmt. using GitHub, Job execution using Jenkins.Supporting 12C, 11g, 10g RAC Environment with ASM Storage. Worked on setting up Oracle RAC environment.Environment:Cloud - Amazon Web Services (AWS), EC2, RDS, DMS, Volumes, AMIs, CFTsOracle 11g 12c and 19c RAC and non-RAC production databases and standby databases on Linux 5, 6,7, PostgreSQL 9.3, 9.4,11 Community Edition.PROFESSIONAL EXPERIENCE:Catalina Marketing Oct 16 May 2017Role: Lead Database AdministratorProject Vault Retailer Integration, St. Petersburg FLDescription: Catalina Marketing is the largest promotion and coupon supplier to retailers and consumer in the world and throughout the United States. I am working as a DBA. There are more than 50 production and Test/DEV/QA DB with RAC, ASM in Oracle 11g, 12c and 19c and Data warehousing on IBM Netezza 7.0.2.5 /IBM Pure Data 7.2.0.5., PostgreSQL 9.3, 9.4,11 Community Edition.Responsibilities:Supported 100+ production instances of large databases of Oracle and Netezza.Managing Oracle Database with RAC and Non-RAC with ASM file system.Experience in High Availability of system with GRID infrastructure.Netezza Full and Incremental Backup, Restore, NZ_DDL_Backup, Schema Backup and Prod to Dev refresh databases.Users, Roles, grants, Groups, Security and Resource utilization of Netezza.LDAP configuration on IBM Puredata systems (MAKO 7.2.0.5).Call Home setup, Netbackup Client Installation, FailOver Testing on IBM Puredata systems (MAKO 7.2.0.5).NZ online and Manual Vacuum Health Check, Cluster Health check in Puredata.Netezza Monitoring setup like SNMPV2, Check Views, Disk Monitor, Table Size Skew, NZ Portal configuration.Netezza Maintenance activity like Hostbackup, Nz groom, NZ Gather Stats, Performance Load report.Expert technical design and Netezza database administration knowledge and automation of all backup restore Monitoring and maintenance activity.Exposure in nznackup, nzrestore, nz_migrate and all IBM utility.Experience in communication IBM and oracle supportLoads databases, reorganizes as necessary, and assists in monitoring database performanceDeveloping and Implementing Disaster Recovery (DR) Plan using Datagaurd.I along with team implemented physical Standby database using Datagaurd.Daily Health Check Up of the Database using staspack, AWR, ADDM & ASH.Rebuilding of Indexes for better performance, maintenance of Oracle Database.Maintaining security of databases and users.Automation of Startup Shutdown on all Production and Development Database.Installation and configuration of Oracle Client software and Tools.Restoration of Data for users in the event of requirement or system crash.Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.Environment:Oracle 11g, 12c and 12c RAC and non RAC production databases and standby databases on Linux 5, 6 platform and Data warehousing on IBM Netezza 6.0/7.0. PostgreSQL 9.3, 9.4,11, Ping IDGuitar Center ITO Jul 15 Oct 16Role: Lead Database AdministratorProject: Guitar Center ITO, Thousand Oaks, CADescription: Guitar Center is the largest chain of musical instrument retailers in the world with 269 locations throughout the United States. I am working as a DBA. There are more than 50 production and Test/DEV/QA DB with RAC, Golden Gate configuration and monitoring, ASM in Oracle 10g, 11g and 12c and Data warehousing on IBM Netezza 7.0.2.5 /IBM PureData 7.2.0.5.Responsibilities:Supported 50+ production instances of large databases of Oracle and Netezza.Configuration of Golden Gate in RAC and Non-RAC environment.Setup Golden Gate monitoring using JAGENT in OEM 12c.Configuration of Golden gate on NFS and DBFS.Managing Oracle Database with RAC and Non-RAC with ASM file system.Experience in High Availability of system with GRID infrastructure.Monitoring and handling of Extract, Pump and Replicat process on Oracle Golden Gate.Netezza Full and Incremental Backup, Restore, NZ_DDL_Backup, Schema Backup and Prod to Dev refresh databases.Users, Roles, grants, Groups, Security and Resource utilization of Netezza.LDAP configuration on IBM Puredata systems (MAKO 7.2.0.5).Call Home setup, Netbackup Client Installation, FailOver Testing on IBM Puredata systems (MAKO 7.2.0.5).NZ online and Manual Vacuum Health Check, Cluster Health check in Puredata.Netezza Monitoring setup like SNMPV2, Check Views, Disk Monitor, Table Size Skew, NZ Portal configuration.Netezza Maintenance activity like Hostbackup, Nz groom, NZ Gather Stats, Performance Load report.Expert technical design and Netezza database administration knowledge and automation of all backup, restore Monitoring and maintenance activity.Experience in applying critical patches and patch sets whenever required.Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.Exposure in nznackup, nzrestore, nz_migrate and all IBM utility.Experience in communication IBM and oracle supportUpgraded the databases to version 11g from 10g. Installed, Setup, Configured Oracle version 11g, 12c on RHEL 6Up-gradation and Migration of Database from 10g to 11g, 12c and then applying patches whenever required.Handling 11g RAC on nodes for high availability.Experience in Working with RAC Databases.Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat and crs_profile.Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF, STATSPACK.Loads databases, reorganizes as necessary, and assists in monitoring database performanceDeveloping and Implementing Disaster Recovery (DR) Plan using Datagaurd.I along with team implemented physical Standby database using Datagaurd.Daily Health Check Up of the Database using staspack, AWR, ADDM & ASH.Rebuilding of Indexes for better performance, maintenance of Oracle Database.Maintaining security of databases and users.Automation of Startup Shutdown on all Production and Development Database.Installation and configuration of Oracle Client software and Tools.Restoration of Data for users in the event of requirement or system crash.Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.Environment:Oracle 10g/11g and 12c RAC and non RAC production databases and standby databases on Linux 5, 6 platform and Data warehousing on IBM Netezza 6.0/7.0. Postgressql 9.3, 9.4Media Math, NY Oct 13 Jun 15Role: Lead Database AdministratorProject: Math Tag, NYDescription: MediaMath is a US based leading provider of online advertising project. Working as a Lead DBA. There are more than 20 production and Test DB with RAC and single Instance in Oracle 10g, 11g and 12c and Data warehousing on IBM Netezza 6.0 and PostgreSQL.Responsibilities:Installation and configuring of Oracle 10g/11g, RAC, ASM Production and Development database server as per the business need.Manage all the Production/Standby databases through OEM Grid control window.Silent mode installation of the Grid Agent on the client Production Databases.Monitor the Performance and Alerts through OEM Grid control.Do works over RAT utility on Dev/Test database before Go-live any Patch/Upgrade.Upgraded the Production and Standby Databases from Version 11201 to 11203.Applying hot patches to the Prod/Dev databases through OPatch utility.Monitoring and maintenance of Dataguard.Resolving the out of sync issues of Standby Database.Exposure in nznackup, nzrestore, nz_migrate and all IBM utility.NZ online and Manual Vaccum Health Check, Cluster Health check in Puredata.Netezza Monitoring setup like SNMPV2, Check Views, Disk Monitor, Table Size Skew, NZ Portal configuration.Netezza Maintenance activity like Hostbackup, Nz groom, NZ Gather Stats, Performance Load report.Expert technical design and Netezza database administration knowledge and automation of all backup, restore Monitoring and maintenance activity.Generate the Hang analyze, System State Dump report while the DB becomes hung or unresponsive and with the help of that report I back the DB to the normal state without bounce the DB.Environment:Oracle 10g/11g and 12c RAC and non RAC production databases and standby databases on Linux 5, 6 platform and Data warehousing on IBM Netezza 6.0.Postgressql 9.3, 9.4Oceaneering International services Limited Sep 12 Sep 13 Role: Oracle DBAProject: OceanetDescription: Oracle DBA on more than 200 production and Test Databases with RAC and single Instance Oracle 10g, 11gR2 and 12c, Netezza 6.0 on Linux 5 platform, which is using PeopleSoft application with Financial, HR and Portal environment.Responsibilities:Installation, upgradation and Maintenances of Oracle Databases on Linux & Windows platforms.Backup of database Logical and Physical and also using RMAN.Perform database monitoring, capacity planning and performance tuning.Recovery of database in case of database crash, disk/media failure, etc.Provided System support for both development and 24/7 production environment.Prepared plans for up gradation of all critical Production Databases from 9i to 10g on Linux and DATAGUARD implementation.Performed capacity planning and sizing of databases based on input from business.Exposure in nznackup, nzrestore, nz_migrate and all IBM utility.NZ online and Manual Vaccum Health Check, Cluster Health check in Puredata.Netezza Monitoring setup like SNMPV2, Check Views, Disk Monitor, Table Size Skew, NZ Portal configuration.Netezza Maintenance activity like Hostbackup, Nz groom, NZ Gather Stats, Performance Load report.Experience in applying critical patches and patch sets whenever required.Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.Configuration of tnsnames.ora, listener.ora and sqlnet.ora files after upgrading databases.Performed database cloning from old system to new system.Used EXPORT/IMPORT for table level and full database de-fragmentation.Transported tablespaces between production and development databases.Recovery of database in case of database crash, disk/media failure, etc.Provided System support for both development and 24/7 production environment.Prepared plans for up gradation of all critical Production Databases from 9i to 10g on Linux and DATAGUARD implementation.Performed capacity planning and sizing of databases based on input from business.Performed database cloning from old system to new system.Used EXPORT/IMPORT for table level and full database de-fragmentation.Environment:Oracle 10g, 11g RAC, Netezza 6.0 and non RAC production databases Linux/ Windows NT platforms with PeopleSoft Application 8.52, WeblogicCMC Limited Sep 10 - Sep 12Role: IT EngineerProject: NumonyxDescription: 43 live, 42 QA, 9 DEV, 34 T&I databases at WWDC and some RAC databases. Databases designed in oracle 10g with J2EE front on Sun solaries 5.9 and HP UNIX. The companies neither make NOR flash memory devices, which are used in cell phones, digital still cameras, MP3 players, and PCs.Responsibilities:24/7 Production Database Administration SupportImplemented Golden Gate for Standby Configuration and developed procedures for Replication.Monitored the growth of the database objects for capacity planning.Has primary responsibility for Oracle Database and Application performance tuning, physical/logical design and optimization and availability.Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and rewind entire database to a particular time respectively.Perform requirements gathering, data mapping, metadata management and database modeling.Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.Cleaning the ORACLE_HOME file system by cleaning the log files, alert log file and listener.log filesIdentified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.Backup and recovery utilizing RMAN.Working with the application support people to resolve database related issues and running the scripts for the application support people.Creating users and database links, snap shots on production and development servers.Maintaining system security, defining of roles, profiles etc.Checking CRON jobs. Monitoring Application specific background processes.Performing Online and Offline database backups on schedule.Developing & Implementing Disaster Recovery (DR) plan using Datagaurd.Scripting of Automated backup for Cold / Hot backups.Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.Environment:HP BL460c Gen8 Blades with (2) 8-core 2.2GHz Intel Xeon E5-2660.CPUs and 800GB, OEL6.4 x86-64 S/w: Oracle 11gR2 Tools: OEM .Grid, Nagios, Monolith, Putty and Net Backup.E-net systems India Pvt. Limited Jun 08 - Sep 10Role: Oracle DBAProject: BSNL Amc.Description: Database designed in oracle 9i/10g with D2K front on Linux environment, its a billing systems database generates bill of customer and also contains customer details and its bills with call time.Responsibilities:24/7 Production DBA SupportPerform requirements gathering, data mapping, metadata management and database modeling.Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.Cleaning the ORACLE_HOME file system by cleaning the log files, alert log file and listener.log filesIdentified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.Maintaining security of databases and users.Reading Alert Log and User trace Files and Diagnosing the Problem.Automation of Startup Shutdown on all Production and Development Database.Backup and recovery using RMAN Utility.Working with the application support people to resolve database related issues and running the scripts for the application support people.Creating users and database links, snap shots on production and development servers.Maintaining system security, defining of roles, profiles etc.Checking CRON jobs. Monitoring Application specific background processes.Performing Online and Offline database backups on schedule.Developing & Implementing Disaster Recovery (DR) plan using Datagaurd.Restoration of Data for users in the event of requirement or system crash.Scripting of Automated backup for Cold / Hot backups.Environment:Oracle 9i/10g production/test databases and standby databases on Linux 5 platform. OEM, Putty, Toad 9.0EDUCATIONAL QUALIFICATIONS:Bachelor of Technology in Computer Science and Information Technology in 2008 from MJRU, Bareilly, India |
