| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
US Citizen (Will work remotely)Raleigh, NCSummary of QualificationsSenior level IT professional with 25+ years of experience in design, analyse, develop, implement and manage database systems including 10+ years as an Oracle/PL/SQL Developer.Holds certification in Oracle 12C.Well versed in ORACLE 9i/10g/11g/12.2, 19C, PL/SQL, SAP HANA 2.0, Informatica 9.1, Tableau, PERL, Java, Korn Shell, JavaScript, C, SolarWinds, SAS, DB2, Oracle Recovery Manager (RMAN), Oracle utilities, BMC Patrol for Oracle, SCO UNIX, Linux Real Application Cluster (RAC), Version Control Software (ClearCase), Data modelling, and Data guard.Experience in troubleshooting Oracle databases, setting up service requests with Oracle Corporation for unresolved customer issues.Managed MS SQL Server 2008 databases, setting user security and setting up maintenance plans.Solid experience in implementing/supporting SAP products/modules. Solid Experience in SAP oracle database administration tools/methodology/utilities and with general non-sap database administration, like BR*Tools, SAP system copy/refresh, SAP system copy/refresh integrated with database native technology like Oracle rman duplication, restore, SAP GUI, DBACOCKPIT, CCMS, SAP Bundle Patch, MOpatch, Oracle Data Dictionary vs. SAP ABAP dictionary, SWPM/SAPInst, Solman etc.Performed Stress test on Oracle server using Quest product Spotlight & Foglight.Developed tools to monitor Oracle user objects, administration of Oracle database backups and Oracle security and User audit management.Assisted developers in leveraging Oracle features to provide a security model that was easy to maintain, supported all the user roles and prevented unauthorized back-end access to the database.Developed SAP HANA 2.0 information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access).Designed and configured SolarWinds based management of Oracle and SQL Servers to facilitate monitoring and management of mission critical infrastructure including support of user concerns and needs in a timely manner.Administered large scale enterprise databases in multi-terabyte environments up to 163 TB.EducationMS in Atmospheric Sciences North Carolina State University, Raleigh, North Carolina 1983MS in Geophysics Banaras Hindu University, Varanasi, India 1975BS in Maths Banaras Hindu University, Varanasi, India 1973CertificationsOracle 12C Certified.Technical SkillsHardware: SUN, HP, IBM 370/1XX, 43XX, 30XX series, VAX DEC-11/7XX, 8XXX, PDP-11/XX, NCR 35XX/3600, Intel based Servers.Software: PERL, Java, Korn Shell, JavaScript, C, FORTRAN, ORACLE 9i, 10g, 11g, 12.2, SAP HANA 2.0, NoSQL, Informatica 9.1, SolarWinds, INGRES, Sybase, SAS, DB2, PowerBuilder, Deft and 4-Dimension case tools, Erwin ERX, Power Designer case tool, Oracle Recovery Manager (RMAN), PL/SQL, Oracle utilities, BMC Patrol for Oracle, I/Watch by Quest, Quest Spotlight for Oracle, TOAD, Version Control Software (ClearCase), HP/UX, SCO UNIX, Linux, OS/MVS, VM/CMS, SNOW.Relevant Professional ExperienceMcKesson Technology, Irving, Texas November 2022 to PresentOracle Database Administrator/ Developer/ EngineerCurrent responsibilities are as following.Installed configured and administered Oracle databases on 9i, 10g, 11g, 12c, 18c, 19c on RAC and Non-RAC databases on AIX, Linux and WindowsOracle 19C performance tuning and maintenance in Oracle Data Guard configuration.Oracle 19C data encryption in physical standby data guard configuration.Oracle 19C health check, sessions blocking, index quality and tablespace monitoring.Oracle 19C database capacity planning and flashback monitoring.Planned and upgraded Database from 11.2.0.4 to 12.1.0.2 and to 19c eventually.OEM reports for database, archive log backups and agent blackout status.Designed and implemented Oracle Database implementation, upgrade, and migration strategy for SAP.Design and implement SAP on Oracle RAC with Oracle ASM.Help SAP teams migrating data from Sybase to SAP Hana.Supporting and troubleshooting of the migration Oracle databases to SAP HANA.Sybase IQ growth, file system and availability and backup monitoring through custom scripts.Extensive experience with ServiceNow, creating CRQs, incidence and reporting.Indo US Ventures, Raleigh, NC 06/2019 October 2022Oracle DBA/Oracle PL/SQL DeveloperDeveloped PL/SQL code to monitor Oracle Database Systems for database resources monitoring.Analysed existing database structures and made recommendations to improve access speed in PL/SQL code with overall improvement of 20%.Created oracle stored procedures, tables, indexes, pl/SQL and UNIX shell scripts to create files to be transmitted to vendors via extranet automatically every week without user intervention.Fixed the impacted tableau reports associated with complex SQL Queries.Developed new backup strategies to backup data moved to newer hardware.Apex Tool Group, Apex, North Carolina 03/2013 05/2019Senior Oracle DBA /SQL Database DeveloperOracle & SQL Server Database software installation, patching and upgrade to development, test and production servers.Expertise in the creation of databases table spaces, tables, indexes and other database objects.Responsible for Physical and Logical database design on UNIX and NT systems and analysed new database requirements and database specifications: including but not limited to normalization, entity/relationship modelling, sizing, access planning, security, and tuning. Installed and maintained commercial-off-the shelf management systems and related technology, including, WEBDB and developer 2000 server.Knowledge and understanding of Real Application Cluster (RAC) and Data guard.Manage MS SQL Server 2016, 2012, 2008 R2 databases, setting user security and setting up maintenance plans.Administered, designed and developed NoSQL database solutions to users.Additionally, performed database change control requests and configuration management requests. Responsible for designing and maintaining server-based software, pl/SQL and UNIX scripts to retrieve data from an oracle RDBMS based in a client/server architecture and wrote numerous NT and UNIX shell scripts.Created and managed Package Configurations, Package deployment and User-defined Variables for SSIS 2016/2012/2008 R2.Developed reports using SSRS to send information to different Clients and managers.Provided Oracle 12.2, 11g & 9i administrative supports for SAP Basis running on HP-UX in large database environment.Migration of BW 7.3 on Oracle 12.2 to BW 7.3 on HANA 2.0 database.Integration of ECC with HANA Database using the SLT ReplicationDeveloping SAP HANA 2.0 information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access).Designed and configured SolarWinds based management of Oracle and SQL Servers to facilitate monitoring and management of mission critical infrastructure including support of user concerns and needs in a timely manner.Developed PL/SQL code, ORACLE SQL and TOAD queries for data manipulation and analysis.SAP Basis Admin handled performance management in ABAP and JAVA stack and ensure that improvements are identified regularly, and systems are tuned optimally.Administrated Oracle database: Space Management and other Database activities using BRTOOLS.Federal Reserve Bank, Atlanta, GA 08/2012 01/2013Senior Oracle/SQL Database AdminTrouble shooting Oracle databases, setting up service requests with Oracle Corporation for unresolved customer issues.Management and monitoring of Oracle 11g in Oracle Dataguard configuration.RMAN database backups and restore for 11g databases in Linux, Sun Solaris and Linux environments.Grid configurations for hot/ cold and archive log backups & jobs setups.Patch management and version control For Windows and Linux based systems.Managed MS SQL Server 2008 databases, setting user security and setting up maintenance plans.Conoco Phillips, Bartlesville, OK 01/2012 07/2012Senior Oracle Database AdminManagement and monitoring of Oracle 10g, 11g in Oracle Dataguard configuration.Database backups and restores using RMAN and datapump.Oracle database Grid configurations for hot/ cold and archive log backupsBackup and recovery of Oracle 10g & 11g database on AIX 7.1, Linux 6.1 and SolarisMigrated Informatica mappings/sessions/workflows from Dev, QA to Prod environments using various technique such as export, import method, DG/Folder migration in Informatica 9.1Wells Fargo/Wachovia Bank, Charlotte, NC 05/2010 09/2011Senior Analyst/Database AdminApplication development for call centers, define requirements, write specifications and design, develop, test and integrate software including web-based applications.Administering ETL process from Oracle to SQL Server databases.Report generation using SQL and Java Programming language for IVR systems.DSM Pharmaceutical, Greenville, NC 11/2008 11/2009Oracle & SQL Server DBA - SupervisorApplication support for customers in material tracking systems, learning management systems, Documentum, environmental monitoring system, human resources management systems, employee time recording systems and chemical dispensing systems.Performance and tuning of 8.1.7, 9i, 10g, &11g databases for DSM Pharmaceutical.Design, develop and maintain OS level scripts for DBA and Reporting functions.Installation and maintenance of OEM Grid Control, 10g and 11g RAC software.Performed databases backup & recovery.Development and maintenance of PL/SQL code for clinical systems.Unix Shell scripting for pharmaceutical applications.ABB, Inc., Raleigh, NC 11/ 2007-10/2008Oracle DBA & Oracle Application Server AdminDevelopment and maintenance of PL/SQL procedures and triggers for network systems software for major international utility companies.Installation and administration of Oracle 10g Application Server.Performed databases upgrades, backups & recovery of Oracle 9i, 10g & 11g databases under AIX 6.0 and Solaris 9.Provided customer support for Oracle 9i, 10g RAC databases and Oracle 10g Application ServersInstallation and maintenance of Oracle ASM, AWR, OEM, 10g and 11g RAC software.Maintenance and management of Oracle Streams Advanced QueuingDSM Pharmaceutical, Greenville, NC 06/ 2006-11/2007)Oracle & SQL Server DBAApplication support for customers in material tracking systems, learning management systems, Documentum, environmental monitoring system, human resources management systems, employee time recording systems and chemical dispensing systems.Performance and Tuning of Oracle 7.3.1, 8.1.7, 9i & 10g databases for DSM PharmaceuticalMigration of Oracle 7i and 8i databases to Oracle 9i and 10g databases.Performed databases backup & recovery.Developed tools to monitor Oracle database.Configuring the raw disks for Oracle RAC, installed and maintained Oracle10g RAC.Installation and maintenance of Oracle APEX for web application deployment.S & R Incorporated, Selma, NC 01/2005- 05/2006System Manager / Oracle DB AdministratorResponsible for implementation and maintenance of Oracle 8/9i & 10g in UNIX and PC environments.Created and developed Oracle databases test environments on UNIX/Windows platforms.Ensured backup and recovery integrity, maintenance & tuning of multiple databases in the different Oracle environments. |
