SUMMARY

• 8+ years of experience asOracle PL/SQL technical consultant Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System.
• Technical lead and principal developer over the last 3 years.
• Developed solution to exchange information between Oracle EBS and external applications.
• Consumed SOAP services from concurrent programs and OAF Pages.
• Developed custom modules to increase.
• Created custom email alerts using HTML and JavaScript.
• Sent emails using XML Bursting, PLSQL and Java.
• Developed insideOracleEBS utility to compress big files and sent it by email in zip format.
• Completed AIX and OCA First Level Certification.
• PerformOracledatabase administration tasks include configuration management, backup/recovery, performance optimization, and space management.
• Effective Communication and interpersonal skills.
• Installation ofOracleon Windows platforms with operating system environments.
• Knowledge of SQL and PL/SQL scripting.
• L3 production support and technical knowledge for Automation of DBA tasks.
• Excel in SQL performance tuning, monitoring and PL/SQL development.
• Manage a comprehensive and ongoing Release management and planning program.
• Trained in Amazon Web Services (AWS).
• Experience in Migration ofOracleDatabases from non - RAC to RAC and non-ASM to ASM Instances.
• Experience in Real Application Clusters (RAC) setup with 4 nodes, configuration and cluster interconnection with Automatic Storage Management (ASM).
• Configured and maintained physical standby databases usingOracleData Guard to perform quick disaster recovery.
• Extensively worked on Import/Export and Data Pump Import/Export tools.
• Expertise in implementing partitioning methodologies (Range partitioning, List partitioning, Hash partitioning, Composite partitioning) on tables and indexes for high performance.
• Experience in conducting Joint Application Development Sessions with end-users, Subject Matter Experts (SMEs) Development and QA teams.
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client),Oracle10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.
• Created Physical Standby databases and switch to snapshot standby databases for application testing.
• Applied Critical Patch Updates (CPU) and Patch set updates (PSU) onOracledatabases and interim patches for various bug fixes on database products.
• Over 8+ years of professional experience in the Information Technology mainly worked on Banking, Telecommunications, Insurance domains, Restaurants and involved in software development life cycle processes including requirements gathering, analysis and design, development tools and technologies, release and version control.

TECHNICAL SKILLS

• OracleSolaris
• V Sphere
• PL/SQL
• UNIX Shell Scripting
• Erwin
• Oracle12c
• 11gR2
• 10g
• RAC
• ASM
• Golden Gate
• Linux
• Windows
• Veritas
• Cluster
• Net Backup
• VNC server
• AIX
• OEL 5.8
• OEM12c
• Java
• JavaScript
• Forms
• Shell scripts
• RMAN
• EXPDP/IMPDP
• Partitioning
• OracleFail Safe 3.x
• Disaster recovery
• RmanBackups
• Scripting
• Storage management
• Hp - ux
• Load balancing
• OracleDba
• Dba

PROFESSIONAL EXPERIENCE

Confidential, Illinois

Senior Postgre SQL Developer

Responsibilities:

• Applied Patches to 11g and 12g and used data patch to upgrade 12c databases • Kept team members and management updated on major issues so they have a clear picture of situation.
• Design and implement disaster recovery for the PostgreSQL Database.
• Patch, Upgrade and keep the PostgreSQL DBs current.
• Load data from a text file or csv files or from flat files in a PostgreSQL database
• Administer and troubleshoot PostgreSQL version 11 databases.
• Maintain all Development, QA, Staging and Production PostgreSQL databases within the organization.
• Setup streaming replication, Install & configure Enterprise Failover Management (EFM)
• Install & configure Postgres Enterprise Manager (PEM), Setup alerts in PEM
• Setup Security Baselines Parameters in PostgreSQL
• Prepare AHC report in PostgreSQL, Working on performance related issue in PostgreSQL
• Minor/Major Upgradation in PostgreSQL
• Installed & configured BART in PostgreSQL, Working on PG BACKUP & PG RESTORE
• Provide the training and knowledgebase on PostgreSQL to Customer.
• Prepare the Documentation for all the project level work.
• Work on Oracle to PostgreSQL Migration, Prepare DMA report in PostgreSQL.
• Collaborate with the database administration team to implement EDB PostgreSQL Advanced Servers epas10X and epas11X.
• Setup Security Baseline Parameters in PostgreSQL, Prepare AHC report in PostgreSQL, Working on performance related issue in PostgreSQL
• Minor/Major Upgradation in PostgreSQL, Setup Replication using XDB.
• Provide the training and knowledgebase on PostgreSQL to Customer, Prepare the Documentation for all the project level work.
• Implement data models, database designs, data access, table maintenance and code changes together with our development team.
• Working on Oracle to PostgreSQL Migration, Prepare DMA report in PostgreSQL.
• Create new PostgreSQL database and upgrade existing database as required.
• Troubleshoot database server disconnection errors or timed out errors as it hap
• Environment:Oracle11gR2/12CR1/12CR2, Red Hat Enterprise Linux 7, HP-UX, Solaris 10,Oracle Enterprise Manager 13.1/13.2, Grid Control, PL/SQL, Shell Scripting, Data Guard, RMAN, Data pump, TCPS listeners,oraclewallets, DBLINK, web logic server,oraclemanagement agents

Confidential, NY

Sr.Oracle Dba

Responsibilities:

• Administer over 300 databases across development, QA, UAT and PROD environments via use of command line andOracletoolsOracleEnterprise Manager Cloud 12c.
• Manage large complexOracleRAC clusters with 50+ applications.
• InstalledOracle11g RAC and UpgradingOracle10g RAC databases.
• Upgraded databases from 11g to 12c.
• Set up Active Data guard Configurations fororacledatabase 11.2.0.3 for thirty databases whose size varies from 5 TB to 20 TB on a 6 node RAC.
• Designed Golden Gate configuration for databases & implemented filters with rules to meet the business usage which will reduce load on the production databases for better performance with replication on multiple sites.
• Migrated and upgradedOracle11gR2 Databases from Sun Solaris 10 to Red hat Linux 5 using Golden gate.
• Designed and maintain Database security usingOracleRoles and privileges.
• Monitored and troubleshoot issues for GG process lags or a bended process and fixed issues.
• Applied patch to Golden gate.
• Written shell scripts to automate jobs
• Creating Indexes, rebuilding indexes, analyzing indexes to improve the performance of query.
• Monitored the various database activities by developing shell scripts and using various tools.
• Worked closely with Developers
• Upgraded Databases fromOracle10g to 11g
• Server versions ranged from PostgreSQL 8.2 to 9.5.
• Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.
• Optimize postgresql.conf for performance improvement.
• Review all PostgreSQL logs for problems.
• Ensure night cron jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7/365 high availability Postgres production and development databases.
• Environments: Oracle 11g, RAC, Oracle Data Guard, Oracle Grid Control, OEM RMAN, Golden Gat ASM, SUN Solaris, Linux, Active Data Guard, PostgreSQl 8/9 and Command center., Linux.
• Worked on Flash Recovery Area
• Performed DR switchover / failover practices using Data Broker.
• PatchedOracledatabases using Opatch utility.
• Generated triggers for data integrity, created views to resolve complex queries.
• Used RMAN duplicated database to clone.
• Used export import and Data pump to refresh schemas.
• Identifying the poorly performing queries using Explain Plan, TKPROF, and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.
• 24X7 production DBA support for mission critical databases (300+) up to 12tb in size on various operating systems like LINUX, SOLARIS, and AIX.
• ImplementOracleGolden Gate (OGG) betweenOracleRAC databases as High Availability solution and tune the performance of OGG in high data volume environments.
• Upgrade databases from 11g to 12c.
• Installed and configured multi-tenant databases usingoracle12.1.0.2 and upgraded 11.2.0.4 to 12c
• Successfully upgraded databases to version 12.1.0.4 and applied latest PSU patches.
• Performed rolling grid infrastructure upgrade from 11.2.0.4 to 12.1.0.2.
• Applying Quarterly patches and Version change patch bundles.
• Setup of golden gate replication for to provide maximum flexibility and availability for busin, Maven and GIT.
• Used Jenkins and pipelines to builds out to the Docker registry and then deployed to Kubernetes.
• Created Java based scripts for Selenium RC with JUnit/TestNG as automation frame work.
• Worked with Agile Software Development environment using SCRUM and Kanban.
• Worked on API Gateway in AWS (EC2, Lambda, EBS, RDS, and Dynamo) with AWS CloudFormation.
• Worked on CI/CD pipeline and created sandbox, UAT and Production Environments in Google Cloud Platform.
• Manage the code changes in the project by using TFS tool and used GRADLE to build the web application.
• Worked with UI development under Linux OS (Debian, Ubuntu, and RedHat Linux) and Mac OS.
• Used Zoom, HipChat, and Slack for project tracking and team communication.
• Ran SQL/CQL stress workloads to test storage on Docker swarm using Cassandra and MySQL.

Confidential

Oracle DBA

Responsibilities:

• Written UNIX Shell scripts for monitoring the processes, sessions, transactions on Production RAC database after migration.
• Load data from a text file or csv files or from flat files in a PostgreSQL database
• Troubleshoot database server disconnection errors or timed out errors as it happens.
• Use PgAdmin 4 for database maintenance and user management.
• Upgrade PostgreSQL 10x to PostgreSQL 11x with Zero Downtime
• Written UNIX shell scripts for partition splitting.
• Strong skill in PL/SQL procedures, packages, triggers and replication.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Planned version control of production source code using Clear case.
• Writing SQL scripts, stored procedures, functions and transactions analysis for performance tuning
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes

Confidential

Oracle Applications Developer

Responsibilities:

• Configuration, Administration and tuning ofOracle10g and 9i RAC.
• Used cross platform transportable table space (TTS) to transport table spaces across platforms.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
• Troubleshooting allOracleApps Issues like Forms, Apache and CM.
• Run ADADMIN to compile APPS schema, regenerate forms, reports, generate Jar files.
• Supporting the databases for different applications like nontax, fog light.
• Written Shell scripts to move the Tables from one instance to another instance using Import/Export.
• On-call support forOracleERP Applications and databases.