Sri Janaki Anoosha Jakka Hari Phone: [phone]

Sri Janaki Anoosha Jakka

Hari

Phone:[phone]

Email: [e-mail]
SUMMARY:
Around 8 years of experience as an Oracle Database Administrator and performed different tasks like database administration, installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security.

• 
  Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g on a variety of operating systems including UNIX/LINUX, Solaris and Windows environment.
  
• 
  Experience in Migration Projects. Hands on experience in-migrating from Oracle 9i to 10g (10.2.0), 10g to 11g and applied oracle patches.
  
• 
  Installed Oracle 10g RAC software with ASM & OCFS2 File systems.
  
• 
  Implemented strategy for partitioning and management of historical data tables in RAC.
  
• 
  Oracle RAC Database Administration including Installation, configuration, Analysis, Design, Backup and Recovery (RMAN).
  
• 
  Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
  
• 
  Co-ordinate with UNIX administrators for space managements on various servers.
  
• 
  Proficienct in Disk management and problem resolving techniques with a good understanding of Capacity planning and efficient usage of the disk space.
  
• 
  Installed, Configure and troubleshoot Oracle GoldenGate.
  
• 
  Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
  
• 
  Monitoring and management of various database components (logical & physical) like table- spaces, segments and data files.
  
• 
  Experience on Data Replication using Snapshot, Materialized views, import/export.
  
• 
  Extensive performance tuning activities like Operating System Tuning, SQL Tuning, Database/Instance Tuning.
  
• 
  Experience on Data Replication using Golden gate, Materialized views, import/export.
  
• 
  Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.
  
• 
  Good experience in SQL, MSQL, PL/SQL, Shell Scripting, Partitioning, Logical and Physical Database Design, Backup and Recovery procedures.
  
• 
  Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
  
• 
  Created many common components of UNIX and PERL Scripts.
  
• 
  Experience in working with IBM OPTIM tool.
  
• 
  Implement and configured the IBM Tivoli Identity Manager software.
  
• 
   Knowledge on various ETL, Reporting, and Database development tools like IBM Optim, SQL Server, and Oracle with strong SQL coding skills.
  
• 
  Implemented flashback technology.
  
• 
  Tune the Database, for Linux, UNIX, and windows using OPTIM QUERY TUNER.
  
• 
  Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan IBM OPTIM.
  
• 
  Setup, Configured and Maintained Oracle Data Guard to control Primary and Standby Databases and also to ensure disaster recovery using various data protection modes.
  
• 
  Used to transparently integrate SQL from an oracle environment using Database Gateway.
  
• 
  Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM.
  

• 
  Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments.
  

TECHNICAL SKILLS:

Operating Systems	HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3 Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.
RDBMS	Oracle 11g/10g/9i/10gRAC.
Languages	SQL, PL/SQL, MySQL, C, C++, Perl, C#, VB.NET, JAVA, XML, UNIX Shell Scripting, Siebel CRM.
DB Management	TOAD, OPTIM, OEM, DB Artisan, OEM Grid Control.
Tools/Utilities	RMAN, OEM, Oracle Management Server, SQL*Loader, Export/Import, Golden Gate, TOAD, Data pump, MS Access, Data Guard, Oracle Gateway, ETL tools - IBM Optim.
Tuning Tools	TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDR.
Hardware Platforms	Sun Fire 15K, Sun Fire 6800, Sun V480, V240, Sun Enterprise 6500 / 450, HP XP256 / XP512, IBM X series Server, and various PC desktop and servers.

EDUCATIONAL QUALIFICATIONS:

• 
  Bachelor of Technology in Electronics and Communication Engineering, JNTU, India in 2006.
  

PROFESSIONAL EXPERIENCE:
Wells Fargo, Minneapolis, MN Sept 2013-Till date

Role: Sr. Oracle DBA
Responsibilities:

• 
  Experience in Installation and configuration of Oracle 11g/10g/9i/8i
  
• 
  Experience in planning, implementing backup/recovery strategies using RMAN and without RMAN
  
• 
  Expertise in installation and configuration of Oracle and large databases on Unix Operating System.
  
• 
  Expertise in handling Very Large Database (VLDB) and OLTP environment.
  
• 
  Expertise in Performance tuning the production database towards optimal performance based on the changes in the database storage structures due to application change requirements.
  
• 
  Monitoring and optimizing the performance of the Database through Database Tuning – Tuning Applications, Tuning Memory, Tuning Disk Usage, Tuning OS
  
• 
  Maintenance of production database and development and testing database which includes tablespace management, user creation, privileges, roles etc.
  
• 
  Implemented and maintained Oracle 10g Data Guard/standby databases for fail-over purposes.
  
• 
  Implementing and maintaining database security (create and maintain users, roles and assign privileges)
  
• 
  Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.
  
• 
  Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
  
• 
  Propagation from primary to standby via automated scripts, and sometimes uses standby databases to immediately restore primary database.
  
• 
  Automated hot backups using a combination of incremental, differential and full rman backups.
  
• 
  Experience in Installing and configuring IBM Optim.
  
• 
  Experience in test data management process design and working on IBM Optim.
  
• 
  Good understanding of test data management concepts such as Data Masking, Data Sub setting and Data Manufacture. Ability to independently write, maintain complex SQL queries, stored procedures) for one or more databases. Oracle, DB2, SQL Server, etc.
  
• 
  Identifying and securing sensitive data records using data masking or data de-identification methods.
  
• 
  Expertise in Oracle Enterprise Manager (OEM), TOAD, Sql Developer.
  

New York State Department of Health (NYSDOH), Albany, NY Dec 2012- Aug 2013

Role: Sr. Oracle DBA

Responsibilities:

• 
  Oracle Clusterware installed to provide infrastructure for RAC and configured 2 node Oracle 10g/11g RAC with ASM.
  
• 
  Configuration, maintenance and tuning of Oracle 11g/10g/9i RAC.
  
• 
  Performing various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
  
• 
  Responsible for maintaining ORACLE RAC using OEM, maintaining Oracle Clusterware using CRSCTL.
  
• 
  Responsible for taking regular backups including Cold / Hot backups, Export / Import, Data Pump of database, using RMAN, and recovery in case of disasters.
  
• 
  Upgrading development and production databases to Oracle 10g.
  
• 
  Applying Security patches and Patch set on Oracle Databases.
  
• 
  Configured ASM and handled issues and suggested feasible workarounds for ASM Metadata corruption.
  
• 
  Created and implemented disaster recovery plans and procedures for Data Center, including hot sites for mission critical applications.
  
• 
  Performing Cross platform migration using transportable table spaces and RMAN.
  
• 
  Extensively used AWR, ADDM, TKPROF, SQL and MySQL Trace for database performance statistics.
  
• 
  Using OPTIM Configuration manager track configuration changes, resolve problems by working with current and historical configuration data, and manage client configurations.
  
• 
  Tuning the Database, for linux, unix, and windows using OPTIM QUERY TUNER.
  
• 
  Creating and managing users, roles and profiles, implementing security, assigning tablespaces to the users, granting roles and privileges etc.
  
• 
  Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
  
• 
  Knowledge of the Oracle GoldenGate installation, configuration, troubleshooting GG issue.
  
• 
  Integration of systems using Oracle Database Gateway in heterogeneous environment.
  
• 
  Development of application using Database Gateway for both Oracle and SQL Standards.
  
• 
  Utilized ERWIN Ver. 4.2 to create physical and logical data models.
  
• 
  Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis
  
• 
   Monitoring the scheduled Backups to ensure success or take remedial action for failures
  
• 
  Considerable knowledge of design, Administration, and performance tuning of MySQL.
  
• 
  Responsible for network configuration and involved in a Client–Server environment using TNS, LISTNER, Net Configuration Assistant and other configuration files.
  
• 
  Troubleshooting user related and database related issues using Oracle Support Services.
  

Environment: Oracle 9i/10g/11g, Sun Solaris, Red Hat Linux, AIX, OEM GC, ASM, RMAN, STATSPACK, AWR, ADDM, VERITAS Net backup, TOAD, SQL Developer, AppWave, Perl scripting, Shell scripting, SQL*Loader, MySQL, Data guard, Stored Procedures, Grid Control.
Unilever, Trumbull, CT Dec 2011-Dec 2012

Role: Sr. Oracle DBA

Responsibilities:

• 
  Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces Provided 24x7 on call DBA support for over 250 Oracle 9i/10g/11g production, QA, DEV databases on RHEL, HP-UX, IBM-AIX.
  
• 
  Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g RAC with ASM.
  
• 
  Architect for the cross platform database migration comprising of VLDB multi-terabyte databases from Sun Solaris, HP-UX to RHEL using Cross platform Transportable Tablespaces (XTTS), Datapump.
  
• 
  Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4 to 11g/11g RAC.
  
• 
  Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
  
• 
  Setup, reconfigured and monitored single instance and multimode RAC.
  
• 
  Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
  
• 
  Created new databases/ instances on 11g/10g RAC and single instances using customized scripts, DBCA.
  
• 
  Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
  
• 
  Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
  
• 
  Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
  
• 
  Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, vmstat, etc.
  
• 
  Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
  
• 
  Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
  
• 
  Working with replication technologies of Golden Gate to sync the data real time from source to target. Providing connectivity and troubleshooting of connectivity problems between different databases and client computers.
  
• 
  Worked in ETL Architecture, Development, enhancement, maintenance, Production support, Data Modeling, Data profiling, Reporting including Business requirement, system requirement gathering.
  
• 
  Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
  

Environment: Oracle 9i/10g/11g, Sun Solaris, Red Hat Linux, AIX, OEM GC, ASM, RMAN, STATSPACK, AWR, ADDM, VERITAS Net backup, TOAD, Perl scripting, Shell scripting, SQL*Loader, MySQL, Data guard, Stored Procedures, Data Vault, Grid Control, SFTP.

Velocity, Brooklyn, NY Sep 2010 - Nov 2011

Role: Oracle DBA
Responsibilities:

• 
  Performing all the Database Administration activity like space management in database, User and Roles administration, Schema management, checking alert log of all the databases using OEM.
  
• 
  Installed RAC on Oracle 10g and worked on ASM feature of Oracle.
  
• 
  Expertise in setting up Siebel servers, Siebel Web Servers, Database Servers, Actuate Report servers, Remote, Anywhere, migration, Server administration.
  
• 
  Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  

• 
  Performance Tuning i.e. tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
  
• 
  Created database design according to the requirement of Application Software, Monitored and Configured databases.
  
• 
  Performance tuning of Queries by maintaining Aggregates, Compression, Partition, indexing and use of Hints, Stored outlines, Statistics for the same.
  
• 
  Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
  
• 
  Estimate the size of the Database and its Objects (in large database of 1 to 2 Terabyte).
  
• 
  Devised & Implemented backup strategies using Hot, Cold, and Exports based on the business requirements.
  
• 
  Implemented Backup-using RMAN (Recovery Manager) as a media management layer.
  
• 
  Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
  

• 
  Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, MySQL, Database design, database tables, indexes, Instance, memory, operating system and java calls.
  

• 
  Developed UNIX shell scripts to perform the above tasks efficiently.
  

Environment: Oracle 10g with RAC, ORACLE 9i, Java, J2EE, SQL, MySQL, PL/SQL, Toad, Erwin, And O/S: RHEL 4.2, HPUX, Windows 2003, And OEM.


Bank of America, Tampa, FL Jan 2009 – Aug 2010

Role: Oracle DBA
Responsibilities:

• 
  Installation and creation of Oracle 9i databases on Production and Test Linux servers. Responsible for Upgrade & Migrating databases from 9i to 10g, applying patches.
  
• 
  Performed various tasks like administering RAC using SRVCTL, adding nodes and instances, administering storage components, parameter management, configuring high availability features for RAC.
  
• 
  Installed RAC on Oracle 10g and worked on ASM feature of oracle.
  
• 
  Refresh test database from production using Recovery Manager (RMAN).
  
• 
  Troubleshoot databases, provide reports on the database health check, follow up and recommendations.
  
• 
  Great experience in using FTP utility program for copying files on Unix and Windows systems.
  
• 
  Managing database instances for Production and test environments to ensure strong testing environment and smooth transition to production.
  
• 
  Responsible for Monitoring and Estimating the size of the database & growth, and configuring the database accordingly.
  
• 
  Responsible configuring listeners for Network Connectivity and Security.
  
• 
  Diagnose and Resolve Performance, Connectivity, Security and Database corruption issues in a critical production environment.
  
• 
  Responsible for taking regular backups including Cold / Hot backups, Export / Import of database, using RMAN, and recovery in case of disasters.
  
• 
  Creation and Maintenance of stand by database by using oracle high availability method Oracle Data Guard.
  
• 
  Interacted with Data modelers, Developers, Application owners for gathering the required information and resolving various issues.
  

Environment:

Oracle 9i / 10g, OEM, RMAN, DBCA, Data Guard, Putty, XML, FTP, TOAD, UNIX, Solaris, Windows XP

Infosys, Bangalore, India. April 2006 – Oct 2008

Role: Oracle DBA
Responsibilities:

• 
  Installation, Implementation and Maintenance of the Oracle database.
  
• 
  Created  and managed the database objects such as tables, indexes  and views.
  
• 
  Responsible for installing, upgrading and configuring the Oracle server.
  
• 
  Creating databases, objects, roles and privileges.
  
• 
  Created and managing the database storage structures which includes data table spaces, index table spaces ,rollback table spaces and rollback segments.
  
• 
  To improve the performance by Using the Hints, Indexes, Explain Plan, Sql Trace and TKPROF for effective retrieval  and processing of queries used for retrieving the data.
  
• 
  Database maintaining including backups, recovery, imports/exports.
  
• 
  Monitoring the database daily activities.
  

Environment:

Oracle 9i, SQL,PL/SQL, TOAD, Oracle Enterprise Manager, SQL*Loader, Sun Solaris, Red Hat Linux.