Home

PULI DBA - ORACLE DBA CERTIFIED OCP
resume.dyna@gmail.com
Location: East Brunswick, New Jersey, USA
Relocation: NJ
Visa: GC
Summary:
Around 15+ years of IT experience including Oracle Database Administration (14yrs), RAC (10yrs), EXADATA(7yrs), Vertica DBA (1yr), DB2 (1yr), and MySQL DBA (1yr).
DBA Experience in Oracle Exadata/Cloud, Database 19c/18c/12c/11g/10g/9i Installation, Administration, Multi-tenant, Monitoring, Performance Tuning, Database Backup and Recovery, database upgrade, OEM Cloud Control/ Grid Control, OEM BI Publisher on Linux, Sun Solaris, HP UX, IBM AIX and Windows environments.
Experience in supporting oracle database in Azure Cloud and AWS.
Experience in managing Oracle builds, upgrades/migrations, database security, disaster recovery, patch management and SuperCluster/Exadata in a large complex UNIX and Windows environment.
Experience in Oracle Advanced Security products Audit Vault (OAV), Key Vault (OKV) and Unified Directory (OUD).
Experience in implementing PCI for data security to help secure and protect the credit card system.
Involved in different scenarios of OLTP (Online Transaction Processing) as well as DSS (Decision Support Systems) and Data Warehouse databases.
Experience in implementing the Oracle RAC (Real Application Cluster) with Multi node Cluster in ASM/Filesystem Environment, monitoring, tuning and load balancing RAC Environment.
Experience in Database Cloning to setup test/development database, database migration across platforms using RMAN DUPLICATE TARGET/CONVERT and from ASM to Non-ASM and Vice-Versa.
Skill in configuring/maintaining Standby database using Dataguard for Disaster Recovery. Experience with snapshot standby and active dataguard.
Experience in configuring replication using GoldenGate 12c/19c/21c. GG replication from on-premise oracle database to AWS S3/MySQL.
Experience in Export/Import of Database objects/Schema/Database using Export/Import Utilities and DataPump Import/Export Utilities, Hot/Cold Backup/Recoveries using RMAN for 24/7 database availability and archival techniques such as transportable tablespace using RMAN.
Experience in Performance/Application Tuning, Performance Monitoring, analyzing the AWR/ADDM reports, analyzing the dbms_sqltune, TKProf and Explain Plan results.
Experience in creating/administrating partitioned tables using the new partition features and handling Space Management for Oracle DBs.
Experience in Database Security Administration, Auditing, Oracle Alert and Patch Management. Experience in applying Patches on different versions of Oracle Software.
Experience in configuring row-level security Virtual Private Database (VPD), Transparent Database Encryption (TDE) and Flashback Technology.
Ability to develop data requirements and configure database parameters accordingly.
Experience with SQL, PL/SQL programming, Shell/Perl/Cron scripting to build automation scripts.
Good communication, interpersonal and problem-solving skills. Knowledge of network protocols, multi-tier architecture.
Worked as a Lead DBA - Interacting with clients, senior managers, assigning work to team members, evaluating work, establishing priorities, monitoring progress, and providing leadership on complex projects.
Experience in maintaining, supporting large Database environments and troubleshooting.
Experience in creation/administration of MySQL databases.
Experience in creation/administration of SQLServer Databases. Experience in SSIS, SSRS.
Knowledge of deploying, managing and supporting MongoDB NoSQL databases, setup replica sets, sharding, monitoring using compass, mongo atlas. Knowledge of mongodb performance, security, diagnostics/debugging

Education:
Bachelor s Degree in Engineering, JNTU, India, 2005
Masters in electrical engineering, Bradley University, Illinois USA, 2008


Certifications:
Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator (OCE)
Oracle Database 12c Administrator Certified Professional (OCP)
Oracle Database 10g Administrator Certified Professional (OCP)
AWS Certified Solutions Architect Associate
Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Technical Skills:
Platforms: EXADATA x5-2/X6-2/X8-2/X9/X10M, Oracle Linux 8/7/6, IBM AIX 7/6, SUN Solaris (7, 8, 9, 10), Red Hat Linux, HP-UX 10.2/11.31 superdome, Windows XP/2000/2008/2012/2016
RDBMS: Oracle 19c/18c/12c/11g/10g/9i, ASM, RAC/EXADATA, SQL Server 2008/2005/2000,
MongoDB 2x/3x, Vertica DB 6.1.X/7.0.X, MySQL, DB2
Tools: Oracle Cloud, AWS, TOAD/SQL Developer, SQL*Loader, Export/Import, DataPump Export/Import, DBMS Packages, ASM, OEM, AWR/STATSPACK, RMAN, OLTP/OLAP, VLDB, OLS (Oracle Label Security)/VPD (Virtual Private Database), Oracle Dataguard (Physical and Active), Streams, Oracle GoldenGate, Oracle Application Express, Oracle Partitioning, Event Monitoring Service, DBArtisan, CA-Erwin, Shareplex Replication, Oracle Developer2000, Clusterware, Mongo Compass/Atlas, VERITAS NetBackup and SQL Backtrack.
Languages: SQL, PL/SQL, T-SQL, UNIX Shell Scripting, Perl Scripting, C, C++, Core Java/ JDBC, HTML, Visual Basic, DBMS Packages

Professional Experience:

COX Communications Feb2022 Jul2024
Database Administrator

Cox Communications is the largest private telecom company in America, serving six million homes and businesses. With exciting investments and innovations across transportation, communications, cleantech and healthcare, family of businesses - which includes Cox Automotive and Cox Communications.
Supporting Oracle builds, upgrades/migrations, database security, disaster recovery, patch management and SuperCluster/Exadata in a large complex UNIX and Windows environment.
RAC Clusterware administration, Configuration and Patching.
Developing end - to-end Oracle RAC solutions, single-instance (ASM) builds, configuring OEM and Data Guard including Active DG.
Setting up replication solution using Goldengate for oracle to oracle and also oracle on-premise to AWS S3/RDS/Ec2.
Managing security products Oracle Advanced Security products Audit Vault (OAV), Key Vault (OKV) and Unified Directory (OUD).
Handle mission critical 24/7 prod environments to ensure high availability
Data Guard configuration, implementing and maintaining standby databases.
Oracle SuperCluster/Exadata, database sizing and capacity planning.
Database migration from old exadata to new exadata clusters.
Database upgrade from 12.2 to 19c.
Databases performance tuning and sql analyze using AWR reports and tuning packages. Evaluate and solicit feedback on processes to identify areas of improvement for optimizing transactions.
Backup/Restore of oracle databases using RMAN to disk/ZFS.
Support for development, test, and production environments
Environment: EXADATA X8-2/X9/X10M, Oracle Database 19c/12c, Oracle Linux 8/7, RAC, Goldengate 12c/19c/21c, AWR & ADDM, RMAN, Shell/Perl Scripts, AWS Cloud, Oracle security products AuditVault/KeyVault/OUD.


The Metropolitan Transportation Authority, New York, NY Apr 2020 Feb2022
Database Consultant/Performance Tuning

The Metropolitan Transportation Authority (MTA) is a public benefit corporation responsible for public transportation in the U.S. state of New York. The MTA is the largest public transit authority in the United States.
Supporting PCI environment databases and ETL applications
Plan the multi-tenant/non-multitenant architecture/configuration for the Dev/Test/Prod/DR database environments for clustered, non-clustered environments.
Database technical design, storage configuration, space management, backup and recovery, disaster recovery, troubleshooting
Implemented Goldengate replication for HA and DR purposes. Install, Configure, troubleshoot and support GoldenGate Replication between different version of Oracle Database and across GoldenGate releases.
Configure GoldenGate Downstream Mining and Integrated components for Active-Active replication. Conflict Detection and Resolution in Active-Active Replication Environments Using Oracle GoldenGate.
Development and maintenance of integrated databases and technical assistance in the design of new systems and/or modifications to existing systems including data modeling.
Develop and maintain database administration procedures and operations to optimize database availability.
Perform the capacity planning required to create and maintain the databases.
Upgrading the databases from 10g/11g to 11g/19c or 12c/19c
Database refreshes from production-development-stage
Backup/Restore of oracle databases using RMAN to disk and data domain.

SQL Tuning and troubleshooting databases (improving existing SQL and PL-SQL code, creating triggers, procedures, and packages) - tuning instances for optimal performance. Tuning database for better performance using AMW/ADDM/OEM report and manual scripts. Tuning the SQL queries using dbms_sqltune, explain plan and TKProf. Use DBMS_SQLTUNE, DBMS_SQL_MONITOR packages for real- time SQL monitoring.
Implementing database security policies, unified/mixed auditing, and privilege/role management
Implement table partitioning for object management and performance.
Testing/Implement TDE in new database for Tablespace encryption.
Applying one-off patches and release update patches to the database machines
Assist Application Developers with performance tuning of SQL, queries, and database objects.
GoldenGate Troubleshooting and configuration.
Support for development, test, and production environments
Environment: EXADATA X6-2/X8-2, Oracle Database 19c/12c/11g/10g/9i, Oracle Linux 7, HP-UX 11.31 superdome, ETL DataStage, RAC, Goldengate 12c/19c, SQL/PLSQL, TOAD/SQL Developer, AWR & ADDM, RMAN, Shell/Perl Scripts.

NY Statewide Financial System, Albany, NY Jul 2015 Mar 2020 Exadata/Database Consultant/Performance Tuning

The Statewide Financial System (SFS) is New York State governments accounting and financial management system. The SFS facilitates the management and flow of information between and among state agencies, state control agencies (the Division of the Budget and the Office of the State Comptroller), the State legislature, vendors doing business with New York State, and the general public. Launched in April 2012, the SFS replaced the OSC Statewide accounting system and multiple agency financial systems. The enterprise resource planning (ERP) system was built with the goal of enabling the State of New York to perform its fiscal and business management tasks more effectively, transparently, and efficiently than ever before. SFS vision is to continually expand the capabilities of New York State agencies by connecting agency business needs with integrated financial solutions. SFS uses data masking on the application side for credit card, SSN information.
Supporting PeopleSoft Financials and Supply Change Management application system.
Plan the multi-tenant/non-multitenant architecture/configuration for the Dev/Test/Prod/DR EXADATA database environments for clustered, non-clustered environments.
Creation/Configuration/management of Oracle 19c/18c/12c/11g databases. Installation/configuration
/maintenance of Oracle RAC/ASM databases and troubleshooting RAC performance issues.
Research and implement more advanced modules and features of the databases (e.g., replication, clustering, partitioning, etc.)
Oracle Cloud DR configuration/testing/implementation.
Exadata Storage Snapshots feature testing.
Working with oracle team on adding new storage servers to the exadata machine.
Databases migration from IBM AIX to Exadata Oracle Linux using export/import datapump.
Upgrading the databases from 11g to 12c, 12c to 18c, 18c to 19c.
Performed Zero downtime Migration and upgrade at same time using GoldenGate.
Patching exadata database machines, coordinating with the UNIX team.
Created Standby Database for Disaster Recovery using Dataguard, second standby setup in the Oracle Cloud.
Cloning the databases using RMAN DUPLICATE from standalone to RAC and vice-versa.
Implemented Goldengate replication for HA and DR purposes.
Conflict Detection and Resolution in Active-Active Replication Environments Using Oracle GoldenGate.
Backup/Restore of oracle databases using RMAN to disk and data domain.
SQL Tuning and troubleshooting databases - tuning instances for optimal performance using AMW/ ADDM/ OEM report and manual scripts. Tuning the SQL queries using dbms_sqltune, explain plan and TKProf. Use DBMS_SQLTUNE, DBMS_SQL_MONITOR packages for real-time SQL monitoring.
OEM 13c/12c setup, administration, and troubleshooting. Exadata discovery and management.
Creating reports using OEM BI Publisher.
Implementing database security policies, unified/mixed auditing, and privilege/role management.
Testing/Implement TDE in new database for Tablespace encryption. And, for Database DR in the cloud.
Assist Application Developers with performance tuning of SQL, queries, and database objects.

Co-ordinate with the application and database vendors for resolution of problems.
Developing shell scripts as needed for the management/monitoring of the databases.
Using Log Miner to analyses the redo log files.
Using Swingbench for load testing and benchmarking oracle database server.
Develop and document standards for proper PeopleSoft database administration.
Working with the Analytics team on the table partition process/procedures.
Participate/lead internal meeting sessions providing project status updates and track open tasks for confirmed completion.
Documentation of database RAC/Standalone Creation, backup procedures, upgrade, patching and other db operations.
Provide standby and on-call support as and when required.
Environment: EXADATA X6-2/X5-2/X8-2, Oracle Cloud, Oracle Database 19c/18c/12c/11g, OEM 13c/12c, OEM BI Publisher, Oracle Linux 7/6, IBM AIX 7.1/6.1, PeopleTools 8.57/8.54, PeopleSoft 9.2/9.0, RAC, Goldengate 12c, SQL/PLSQL, TOAD/SQLDeveloper, AWR & ADDM, RMAN, Shell Scripts, ODI, Swingbench.

CSC, Rensselaer, NY Feb 2014 Jun 2015
Senior DBA/Database Architect (Oracle, DB2)

CSC (Computer Sciences Corporation) is a global leader in providing technology enabled business solutions/services, provides Next Generation IT Infrastructure Services, Cloud Computing, Cyber Security, Big Data, Consulting and Industry Focused Application solutions. Databases relate to the NYHX (New York Health Exchange) project.
Plan the architecture/configuration for the dev/test/prod/dr database environments for clustered, non-clustered environments.
Knowledge and work experience of database administration on Exadata machines.
Creation/Configuration/management of Oracle 12c/11g databases in clustered, non-clustered environment. Installation/configuration/maintenance of Oracle RAC/ASM databases and troubleshooting RAC performance issues.
Upgrading the databases from 11g to 12c, then to multitenant architecture.
Installation/Administration of OEM Cloud Control 12c and monitoring the databases through alerts. Upgrading the OEM OMS from 12cR2 to 12cR4.
Setting up database links from Oracle database to DB2 database using Gateway DRDA/ODBC.
Backup/Restore of oracle databases using RMAN.
Setup auditing/VPD/TDE for security/management.
Tuning and troubleshooting databases (improving existing SQL and PL-SQL code, creating triggers, procedures, and packages) - tuning instances for optimal performance. Tuning database for better performance using AWR/ADDM/OEM reports and manual scripts. Tuning the SQL queries using explain plan and TKProf.
Used DBMS_SQLTUNE, DBMS_SQL_MONITOR packages for real-time SQL monitoring.
Implementing Oracle TDE Transparent Data Encryption in all our new/existing databases for Tablespace encryption.
Working with developers on query optimization and SQL code deployments.
Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries.
Created Standby Database for Disaster Recovery using Dataguard. Testing of Switch Over and Failover process functioning. Responsible for monitoring the archivelog shipping to the standby system. Scripting the database refresh procedure to automate it.
Database security administration, account creation, privilege management.
Implementing database partitioning and managing indexes.
Implementing unified/mixed auditing and managing audit data.
Perform root cause analysis on failures. Resolve performance tuning related issues and queries.
Execution of project and co-ordination between DBA and application team.
Working with the users and resolving the issues related to the databases. Maintained UNIX Shell Scripts to monitor/manage databases.
Exposed to DB2 databases in development/test/production environments.
Create/manage/administration of Vertica databases using Vertica admin tool and VSQL.
Adding new nodes to the Vertica cluster for performance.

Upgrading Vertica from 6.1.X to 7.0.X and the management console.
Developing shell scripts as needed for the management/monitoring of the databases.
Documentation of database RAC/Standalone Creation, backup procedures, upgrade, patching and other db operations.
Supporting Peoplesoft applications.
Environment: Oracle 12c/11g, DB2 10.1 fp4, Exadata X4-2, IBM AIX 7.1 PowerPC, PeopleTools 8.54, PeopleSoft 9.0, RAC, SQL/PLSQL, TOAD/SQL Developer, OEM 12c, AWR & ADDM, RMAN, Goldengate, Shell Scripts, NetBackup.

Veracode, Burlington, MA USA Jan 2014 Feb 2014
Senior Oracle DBA

Veracode provides the world s leading Application Risk Management Platform. Veracode's patented and proven cloud-based capabilities allow customers to govern and mitigate software security risk across a single application or an enterprise portfolio with unmatched simplicity. Veracode was founded with one simple mission in mind: to make it simple and cost-effective for organizations to accurately identify and manage application security risk. Veracode testing tools enable PCI security compliance.
Resolve critical/major database outages and issues.
Co-ordinate between offshore and on-site team and close the escalated issues.
Execution of project and co-ordination between DBA and application team.
Tuning database for better performance using Oracle Tools and manual scripts.
Problem troubleshooting and fixing production database issues.
Oracle 10g database administration and troubleshooting
OEM 12c administration and troubleshooting
Generated AWR/ADDM reports and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, and database growth.
Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries.
Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.
Used TDE Oracles Transparent Data Encryption and Oracle Wallet to encrypt some of the data in the database.
Working with the users and resolving the issues related to the databases.
Participate in the ongoing database maintenance activities and application upgrades.
Working with developers on query optimization and SQL code deployments.
Environment: Oracle 11g/10g, SunOS 5.10, RAC, SQL/PLSQL, TOAD, OEM 12c, AWR & ADDM, RMAN, NetApp, Shell Scripts.

Novartis (NIBR), Cambridge, MA USA Jul 2012 Dec 2013 Senior DBA/Oracle/Vertica/MySQL & Offshore Lead

The Novartis Institutes for BioMedical Research is the global pharmaceutical research organization for Novartis. The NIBR research network is comprised of more than 6,000 scientists, physicians, and business professionals working together across 10 locations around the world to discover innovative medicines that treat diseases with high unmet medical need. The duties involved in database upgrades, patching, OEM administration, performance tuning, database configuration, managing dataguard standby databases, space management, shell scripting, backup/recovery, job automation, providing 24/5 support. Involved in monitoring 400+ production/ test/ development/staging database instances.
Creation/Configuration/Architecture of Oracle database in clustered, non-clustered environment.
Installation/Administration of OEM Cloud Control 12c and monitoring the databases through alerts. Setup of additional OMS for OEM.
Involved in installation/configuration/maintenance of Oracle RAC/ASM databases and troubleshooting RAC performance issues. Adding/Removing the nodes for a better architecture.
Troubleshooting Replication, RAC and other Oracle related issues and implementing resolutions.
Performing day-to-day database administration tasks including installation, upgrades, backup/ recovery, monitoring, disaster recovery procedures (switchover/failover) and database cloning across environments, patching.
Upgrading/Patching oracle databases from 10g/11g and 11gR1/11gR2, applying latest PSUs.

Migration of databases from Windows to Linux and standalone to RAC and vice-versa.
Managing/Resolving issues related to standby databases.
Setting up replication between databases using GoldenGate without any data loss. Bidirectional replication.
Configure GoldenGate Studio or Integrate with OEM.
Performance tuning the databases with issues.
Backup/Restore of oracle databases using RMAN/NetBackup.
Databases/Schema refreshes using Datapump utility.
Managing database links, MVs, profiles and user s security.
Checking/Managing the space issues with databases and adding datafiles and new disks to the ASM.
Maintained UNIX Shell Scripts to monitor/manage databases.
Documentation of database RAC/Standalone Creation, backup procedures, upgrade, patching and other db operations.
Identifying performance root causes proactively and finding solutions on both application and database ends.
Used DBMS_SQLTUNE, DBMS_SQL_MONITOR packages for real-time SQL monitoring.
Involved in SQL Query tuning and provided tuning recommendations to time/CPU consuming queries.
Set up of database monitoring using OEM, shell scripts and database scripts.
Implemented transparent data Encryption TDE. Used TDE with both Encrypted columns and Tablespaces.
Mentoring junior/mid-level offshore DBAs.
Working with the users and resolving the issues related to the databases.
Assisting development team on implementing best practices.
Setting up database inventory for the environment.
Creating MySQL databases, administration, and backup of the databases.
Involved in setup, installation and maintenance of Vertica database clusters and servers.
Provide Vertica Architecture Consulting to Customer in support of solution design activities.
Create/manage/administrate Vertica databases using Vertica admin tool and VSQL.
Knowledge in various Vertica column store database, database configuration parameter, K-safe and projections.
Testing new features of Oracle Database 12c.
Participate in the ongoing database maintenance activities.
Working with developers on query optimization and SQL code deployments.
Supporting peoplesoft applications.
Environment: Oracle 12c/11g/10g, MySQL DB, Vertica 6.1, Linux/Solaris/Windows NT, PeopleTools 8.54, Peoplesoft 9.0, RAC, SQL/PLSQL, TOAD, OEM 12c, AWR & ADDM, RMAN, ASM, NetBackup, UNIX Shell
Scripts.

Commonwealth of Massachusetts DPH, Boston, MA USA Sep 2008 Jun 2012 Oracle/SQL Server DBA

Commonwealth of Massachusetts, Division of Health Professions Licensure (DHPL) is an agency with 8 boards of registration. The boards are responsible for licensing and regulating the activities of over 330,000 individuals, corporations and partnerships. The project involved in configuring Oracle Real Application Cluster (RAC), Managing Dataguard Standby databases, upgrading the Oracle/SQL Server, Replication from Oracle to SQL Server, Database Space Management, Performance Tuning, Automating Jobs, Backup/Recovery of Test/Productions databases, Shell/SQL/PLSQL Scripting, Data Conversion and Reporting and providing 24/7 support. Involved in monitoring 15 production/development/test database instances.
Installation, Configuration and Patching of Oracle Server 11g/10g and SQLServer 2008. Upgraded oracle databases from 10g to 11g and SQLServer from 2000 to 2008.
Responsible for the technical support of mission-critical databases running on Oracle, SQL Server and/or other database management systems.
Involved in the design/configure/install/maintenance/support of Oracle RAC/ASM. Involved in performing RAC database backups/recovery using RMAN. Adding new nodes in a RAC environment for performance improvement. Involved in troubleshooting RAC performance issues related to interconnect and ASM. And troubleshooting RAC database issues using OEM.
And involved in setting up the Grid Control, deployment, and monitoring.
Involved in Setup of schema replication from Oracle to SQL Server. And monitoring the replication status and troubleshooting the issues.

Setting up and resolving issues with Oracle Data Guard environments and data replication using oracle GoldenGate.
Involved in backing up and restoring the databases using RMAN.
Running diagnostic tools to identify database performance bottlenecks and taking appropriate corrective actions to improve database performance. Working with development teams to tune SQL queries. Troubleshooting Oracle performance and non-performance related issues independently and in conjunction with other DBAs.
Partitioned tables using the new partition features of 11g/10g for performance improvement.
Involved in testing and tuning SQL, stored procedures, and functions; analyzing the database schema including indexes and views to suggest optimization; analyzing and tuning the Oracle installation to ensure optimum performance. Tuning the SQL queries using explain plan and TKProf.
Recreated the database links, created profiles, configured row-level security VPD to provide more secure environment for controlling access to databases.
Migrated databases from Windows to Linux using RMAN Convert and database from non-asm to asm.
Involved in Monitoring of Oracle Databases using UNIX scripts for tablespaces monitoring, object growth and checking Alert logs for errors etc.
Maintained UNIX Shell Scripts to monitor/manage database.
Developed SSIS packages for data import and job automation.
Developed reports using SSRS package.
Environment: Oracle 11g/10g/9i, SQL Server 2000/2008, Linux/Windows NT, RAC, SQL, PL/SQL, TOAD, OEM, AWR & ADDM, RMAN, ASM, STATSPACK, UNIX Shell Scripts.


Ramco Systems Ltd., Bangalore, India May 2005 Jul 2006 Oracle Developer/Junior Oracle DBA
Keywords: cprogramm cplusplus user experience business intelligence sthree database information technology hewlett packard procedural language California Colorado Massachusetts New York

To remove this resume please click here or send an email from resume.dyna@gmail.com to usjobs@nvoids.com with subject as "delete" (without inverted commas)
resume.dyna@gmail.com;4219
Enter the captcha code and we will send and email at resume.dyna@gmail.com
with a link to edit / delete this resume
Captcha Image: