Praveen Polasani

Summary

Certified Senior administrator with in-depth experience in all aspects of database Administration.

Skills Summary

Oracle 8i, 9i, 10g, 11g, 12c

Real Application Clusters (RAC)

Performance Tuning

Distributed Databases

Disaster Recovery Solutions

Golden Gate

Data Modeling (Erwin)

SQL Server

Data Pump and Flash-back Recovery

Oracle Enterprise Manager (OEM)

AIX(5,6,7),Solaris,HPUX,Linux,Windows

Database Security and Auditing

Perl/Shell Scripting

Exadata

Major Demonstrated Strengths

Experienced Oracle Data Base Administrator, providing 24/7 production support for Production, Test and Development (11g,10g/9i/8i) databases on Various Platforms.

Proficient worker in mission critical environments, 6000 Databases in 1000+ servers and 1800+ Applications.

Experience in Installation and configuration of Oracle 8i, 9i, 10g, 11g in Unix/Linux, Solaris and Windows environment.

Skilled in regular Database Administration activities such as Upgrades, Patches, TAR Support, Cloning (Hot/Cold/RMAN), Backup and Recovery, Performance Tuning, capacity planning, script development, and documentation.

Installed and Configured Golden Gate on Test, dev and production instances.

Designed, modeled, normalized and implemented logical and physical models

Proficient in server side programming like Procedures, Functions, Database Triggers& Packages.

Expert in utilizing ETL tools, including Oracle Data Integrator, Informatica and Oracle.

Good Knowledge of Oracle single sign-on and oracle web logic server.

Experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving database problems.

Experience in installing MS SQL Server 2005/ 2008/ and updating with hot fix and service packs.

Extensively used the native tools like tuning wizard, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis.

Experience in Data Modeling of Oracle, PL SQL &, Business Intelligence Data Warehousing.

Hands on experience in installing, configuring, and using Hadoop ecosystem components.

In-depth knowledge and experience in full life-cycle of Application deployment which includes Data architecture, Logical and physical database design, Data modeling using Erwin, Writing sql,pl/sql codes for application, testing the application Following stage deployment and load testing and finally go live to production.

Did scripting, wrote stored procedures and packages per the application requirement such as to load bulk data into tables. Used PLSQL to write/created triggers on tables to fire at various incidents like insert, update, delete etc.

Experienced in using 11g, 10g features Data Pump, Flash-Back Recovery, AWR, ASM, ADDM, 10g Grid Monitoring, Recycle Bin.

Experienced in developing RMAN scripts for database back up including hot and cold backup options for both RAC and stand alone instances.

EDUCATIONAL QUALIFICATION:

Bachelor of Engineering - Madras University, INDIA

WORK EXPERIENCE

Client : BNSF, Fortworth, TX.

Role : Senior DBA

Environment : ORACLE 9i, 10g and 11g, 18c, 19c AIX, UNIX

Period : Mar 2020 – Present

Maintained databases including Oracle patching, backup and restore of database and datafiles.

Multiple testing sessions were performed to evaluate and validate migrations to cloud.

Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers.

Worked on RAC databases, maintaining healthy environment, resolving performance issues.

Worked on Dataguard databases, with fast start failover feature and enabled autofailover.

Worked on oracle ODA appliance and migrated multiple databases from version 12 to 19.

Worked on ODA setup, for new and existing databases/servers with RAC & Dataguard setup.

Extensive experience in implementing high availability and Disaster recovery concepts like Log Shipping, Mirroring and Replication (Snap Shot and Transactional).

Expert in Data Integrity, Performance Tuning and Query Optimization.

Member of 24x7 support team on both production and development databases with on-call pager.

Did capacity planning and Created new node clusters on AIX boxes and moved over few crucial existing databases to cater better performance.

Applied Oracle quarterly patches along with bugfix patches rectifications as and when required.

Experienced in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.

Created PL/SQL procedures (jobs) to automate maintenance tasks.

Trained on building Conceptual, Logical and Physical data model.

Dropped and recreated all the indexes for the foreign keys with new column list.

Extensive experience in implementing high availability and Disaster recovery concepts like Log Shipping, Mirroring and Replication (Snap Shot and Transactional).

Created before update trigger for all the tables to set the update_date, update_user columns.

Defined relationships and cardinalities among entities.

Rebuilding of Indexes for better performance, maintenance of Oracle Database

Creating and drop users, granting and revoking permissions to users/roles as and when required.

Developed approaches and frameworks for the enhancement of data quality and integrity.

Worked on identifying facts, dimensions and various other concepts of dimensional modeling which are used for data warehousing projects.

Client : PVH, Bridgewater, NJ.

Role : Senior ORACLE DBA

Environment : ORACLE 9i, 10g and 11g, 12c AIX, UNIX

Period : Oct 2017 – Mar 2020

Implemented oracle RAC server for 2 nodes and 3 nodes in Data guard environment.

Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using Golden Gate.

Worked on Tivoli monitoring and Control-M scheduling for backups.

In-depth knowledge of Software Development Lifecycle (SDLC) and AGILE software development methodologies adhering to best practices and industry standards.

Migrated databases from local severs to cloud, Upgraded databases from 11g versions to 12c.

Installed 11g, 10g RAC on AIX in two, three Node environments, with ASM as storage.

Worked on cold & hot backups and also tested various recovery procedures.

Created and maintained RMAN scripts for database back up including hot, cold for both RAC & standalones.

Configured and used Oracle Flashback for recovery of objects in the database.

Tuned Backup Scripts to automate RMAN and other processes, developed Scripts to automate data pump exports for specific requirements based on client’s necessity, and developed SQL scripts for maintaining administration tasks.

Enforce and maintain database audit and security standards for PCI standards.

Discussed on various denormalization, partitioning and indexing schemes for physical model.

Automation of data load using Korn shell scripting and SQL*Loader.

Worked on forward & reverse engineering processes. Created scripts to implement model changes.

Experience of using Oracle Enterprise (OEM), Grid Control, and Data Guard.

Discuss with users in Designing relevant tables, table spaces, and users for custom applications,

Establish more and proper objects names to make it user friendly environment for them.

Assist on database capacity planning with Design and Build team.

Client : CVS Pharmacy, Woonsocket, RI.

Role : Senior ORACLE DBA

Environment : ORACLE 9i,10g and 11g,12c AIX, UNIX

Period : Sept 2016 – Sept 2017

Migrated database from Omnicare to CVS with all application functionalities.

Implemented Oracle High Availability solution using Oracle 11g Physical Standby. Maintained dataguard and Trouble shoot issues.

Experience in managing Web based OLTP/DSS database systems with over 2 TB in size.

Upgraded database from 10g to 11g and 11g to 12c.

Implemented high level Auditing on databases for security reasons on Hospital records.

Enabled alerting on specific actions performed by both DBA and Users.

Installed, configured, administered and secured SQL Server 20012/2014 on production and Non-production in Clustered and Stand -alone Server Environments.

Worked in implementing SQL Security and object permissions like maintenance of database creating and users and logins assigning roles to the users and managing user permissions.

Worked on Cotrol M as for scheduling auto jobs like backups, cleanups and exports.

Implemented scripts to find out the orphan users in the servers. Successfully migrated logins and users between multiple servers.

Worked with client ITIL tool Service Now for reporting and managing all kind of priority tickets and Incidents.

Very good experience in Installation, configuration and maintenance of SQL Server.

Installing ASM environment and migrating database from NON-ASM to ASM.

Configured GoldenGate to achieve unidirectional and bidirectional replication.

Setup GoldenGate User with necessary privileges.

Resolved replication issues in Goldengate.

Worked on Exadata servers and many migration works.

Client : Children’s Hospital of Philadelphia, PA.

Role : Senior Oracle DBA and Modeler

Environment : ORACLE 9i, 10g and 11.2,11.3,11.4, 12c, UNIX, AIX, Exadata

Period : Nov 2012 – Sept 2016

Member of 24x7 support team on both production and development databases with on-call pager.

Performed Dimensional Modeling (Data Marts, Facts and Dimensions) in both Star Schema and Snowflake Dimensional modeling using Erwin.

Developed, took care of, and maintained logical and physical ERWin data models, along with corresponding metadata.

Experienced in ETL, data transformation, conversion and interface.

Implemented Fast Start Failover on Dataguard on Oracle 11.1 and 11.2 for the purpose of Instant failover whenever the Primary database is down for over a pre-determined time period, the time period being decided upon the Client individual limit.

Highly involved in Implementation of Exadata servers.

Worked on tools like EMC for managing tickets/incidents.

Did capacity planning and Created new 4 node clusters on AIX boxes and moved over few crucial existing databases to cater better performance and auditing too.

Expert in Data Integrity, Performance Tuning and Query Optimization.

Created Procedures and PLSQL blocks to enable auditing on Users’ audit output stored in database and the output of Sys Users is stored in flat files on the file system as the Hospital Data was critical and necessity was to Audit and send alerts to the concerned to monitor.

As these various audit trails quickly grow out of control when database activity increases the two challenges of maintaining file system size and table size were addressed to maintain size limits.

Created the relevant procedures, plsql blocks that enable the Audit and Password verification across 10g and 11g platforms, and the scripts needed to purge the data.

Arcsight Connectors and Loggers were used to retrieve the data and the Email Alerts were individually sent to the required recipients.

Discussed on various denormalization, partitioning and indexing schemes for physical model.

Worked on Normalization and Denormalization techniques.

Rebuilding of Indexes for better performance, maintenance of Oracle Database

Installing ASM environment and migrating database from NON-ASM to ASM.

Upgraded Oracle goldengate v10 to v11 Prepare parameter files for Extraction and Replication

Install, Configure and maintain Single-node and Multi-node cluster Hadoop cluster.

Monitor a Hadoop cluster and execute routine administration procedures.

Client : Lincoln Financials, Omaha, NE.

Role : ORACLE DBA

Environment : ORACLE 9i,10g and 11.1,11.2,11.3, UNIX, SUN SOLARIS

Period : May 2012 – Nov 2012

Installed and Configured GoldenGate Test, dev and production instances.

Cross-Train DBAs on Goldengate configuration and replication.

Configured different levels of replication such as DDL replication, DML replication for table level, schema level, database level using Golden Gate.

Hands on experience with the new version ODI 12C

Worked on migrating all the mappings from ODI 11G to ODI 12C.

Setup different environments like test and dev using database Cloning.

Installation of 9i, 10g and 11g databases for Testing, Development and Production.

Experienced in writing functional specifications, translating business requirements to technical specifications, created/maintained/modified data base design document with detailed description of logical entities and physical tables.

Created PL/SQL procedures (jobs) to automate maintenance tasks.

Implemented a SQL purging process for Old claim data as per business requirement.

Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, Connectivity issues and Security issues etc.

Developed and automated daily, weekly and monthly counts of Claims by Scheduling the SQL Job.

Good Conceptual and Logical Data Modeling skills

Document the plan, execution and process phases and demonstrate the client for approvals.

Monitoring Growth of tables and undertaking necessary re-organization of database as and when required. Write scripts to monitor tablespace and extent growth.

Responsible for smooth rollout and keeping a check for the first cycle of Production runs

Applying patches using OPATCH and patch sets using OUI.

Developer Environment Setup, Support, Cloning and Refreshes.

Maintain schemas accordingly and partition tables for different scenarios.

Client : Fedex, Memphis, TN.

Role : ORACLE DBA

Environment : ORACLE 9i,10g and 11g, UNIX, SUN SOLARIS

Period : July 2011 – May 2012

Worked on Oracle Golden Gate installation, configuration, troubleshooting GG issues,

Dealing issues out of Replication, Reverse Replication and migrate errors.

Experienced in Implementing Oracle High Availability Solution 10g RAC with ASM and Raw Devices and 10g CRS. Experienced in configuring & Managing the ASM

Worked on Relational and Dimensional Data modeling for creating

Logical and Physical Design of Database and ER Diagrams, using data modeling tools like ERWIN

Trained on building Conceptual, Logical and Physical data model.

Dropped and recreated all the indexes for the foreign keys with new column list.

Created before update trigger for all the tables to set the update_date, update_user columns.

Defined relationships and cardinalities among entities.

Responsible for decisions in setting exact privileges and managing user accounts.

Defining and Implementation of Backup and Recovery strategies.

Planned and implemented Disaster Recovery solutions using Oracle 10g Data Guard.

Developed RMAN scripts for database backup and recovery including hot and cold backup.

Troubleshoot SQL server database performance issues and tune database objects.

Experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving database problems.

Created PL/SQL procedures (jobs) to automate maintenance tasks.

Client : Bank of America, Jacksonville, FL

Role : ORACLE DBA (Performance Team)

Environment : ORACLE 9i,10g and 11g, LINUX, SUN SOLARIS 9, IBM AIX,NT

Period : July 2009 – June 2011

Primary DBA for 10 productions and development / testing databases ranging from 100G to 1TB

Member of Performance team which gets escalations from Off Shore and Primary DBA’s

Installation and creation of 9i and 10g databases for Testing, Development and Production.

Installation and Maintenance of Data Guard/Standby database.

Configured and used Oracle FlashBack for recovery of objects in the database.

Upgradation of Database from 9i to 10g and applying patches whenever required.

Developed RMAN scripts for database backup and recovery including hot and cold backup.

Used tools like TKPROF, Explain Plan, ORADEBUG and TRACE file to tune SQL Queries.

Developed RMAN scripts for database backup and recovery including hot and cold backup.

Applying critical patch updates (CPU) released by oracle quarterly.

Discussed on various denormalization, partitioning and indexing schemes for physical model.

Installed and Implemented RMAN Backup & Recovery procedures.

Developed RMAN scripts for database backup and recovery including hot and cold backup options for both RAC and stand alone instances.

Created components detailed design specifications using UML (class, activity, sequence and collaboration diagrams).

Upgradation and Migration of Database from 9i to 10g and applying patches whenever required.

Used ORADEBUG, 10046 and 10053 Trace for troubleshooting the performance issues

Configured Oracle 10g R2 Grid OEM to monitor database and reports defined by the DBA group.

Used Erwin Tool to design Physical/Logical design for Database and schemas.

Developed and executed processes supporting SOX audits of Oracle Applications environments.

Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption)

Client : Bank of America, Charlotte, NC

Role : ORACLE DBA

Environment : ORACLE 10g RAC, 9i, RHEL 4.x, SUN SOLARIS 10

Period : Aug 2008 to June 2009

Installing 9i and 10g, 11g databases on LINUX and SOLARIS 10.

Performed database Cloning to setup test and development database.

Implemented oracle high availability solution using oracle 10g PHYSICAL STANDBY.

Managed the PHYSICAL STANDBY including Switchover and Failover scenarios.

Conducting sizing & capacity planning for Oracle databases.

Upgradation and Migration of Database from 9i to 10g and applying patches whenever required.

Maintaining schemas and partitioning tables.

Performance tuning of Oracle Database Objects by fixing row chaining.

Worked in cross platform migrations from Windows to Linux, Solaris to Linux

Worked on database upgrades 8i to 9i and 9i to 10g R2.

Rebuilding of Indexes for better performance, maintenance of Oracle Database

Creating and drop users, granting and revoking permissions to users/roles as and when required.

Developed the strategy for external data load in to Data Warehouse

Moved nearly 1 gigabyte of data per day from the source system to the data warehouse.

Created custom extraction system that populated a data warehouse star schema.

Client : Citi Group, Dallas, Texas

Role : ORACLE DBA

Environment : ORACLE 10g, 9i, RHEL 4.x, SUN SOLARIS 9, HP-UX 11

Period : Jun 2007 – July 2008

Involved in 24x7 support for both production and development databases with on-call pager

Installation and creation of 9i and 10g databases for Testing, Development and Production.

Performed database Cloning to setup test and development database.

Conducting sizing & capacity planning for Oracle databases.

Upgrade and Migrate database from 9.2.0.6 to 10.2.0.2 and apply patches whenever required.

Complete system designing, data model conceptual/physical defining tables, relationship between tables, general domains, and screen design/functionality behind the screen.

Worked on Entity Relationship Diagram in Models. Reverse and Forward Engineering on Database Models.

Experienced in dealing with Web based OLTP systems.

Involved in Database Designing, Logical, Relational Database Diagram, Integrity Constraints and Finally Physical Data Modeling and Normalization.

Installed and Implemented Backup & Recovery procedures.

Automation of backup by creating scripts.

Tested different recovery scenarios.

Experienced in using 10g feature Flashback option.

Contact this candidate