Resume

Sign in

Data Oracle

Location:
Yakhutpura, Telangana, India
Salary:
90K
Posted:
January 22, 2019

Contact this candidate

Resume:

Oracle DBA/Developer

Name: VijayaKumar Mallela E-mail: ac79mg@r.postjobfree.com

Mobile No: +1-803-***-****

Professional Summary:

Having 12Years of experience in Information technology with a strong success record in Database Administration, System Analysis & Design, SDLC, Software Development and Expert in Trouble shooting of Oracle Applications Patching and Performance issues. Good experience in writing PL/SQL code, Performance tuning of PL/SQL and good experience inAWS EC2, RDS Instances,S3 BucketandCloud Berry andData Modelingand Golden Gate

Involved with installation and maintenance of Oracle 12c RAC/Oracle11gRAC/Oracle 10g RAC and standby database for High Availability and Disaster Recovery purpose.

Wide experience in infrastructure layout, provisioning. Extensive experience in Amazon AWS cloud infrastructure with RDS, EC2 Instances and particular reference to provisioning, security, and management.

Experience in managing Oracle databases running on MS-Windows, NT Server, UNIX/Linux, Sun Solaris, HP-UX & AIX and RHEL.

Hands on experiencein Oracle 12c/11g/10g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation).

Good experience RAC Clusterware administration, Configuration and Patching.

Extensive experience in Dataguard configuration, implementing and maintaining standby databases.

Hands on experience in Grid control, Streams, GoldenGate Replication.

Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWRand ADDM.

Setup Oracle Enterprise Manager (OEM) 10g &Grid Control (11g) for database monitoring/performance/diagnostics.

Experience in software architecture, analyzing, design, development, research, implementation, Migration of (Non Oracle to Oracle) and Support. And experience with Oracle 11g/10g/9i/8i/8.x/7.x RDBMS on UNIX/Linux/Windows environment and 8 months experience on 12c database

Installation, up gradation and maintenances of Oracle RDBMS on UNIX/Linux and Windows platforms.

Backup of database Logical and Physical (hot and Cold) Procedures and also using RMAN

Recovery of database in case of database crash, disk /media failure etc.

Database design and Implementation and maintain database security (create and maintain users and roles, assign privileges).

Perform database tuning, application tuning and performance monitoring using STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ASH, ADDM report.

Capacity planning, capacity monitoring and management.

Perform general technical troubleshooting and give consultation to development teams and User requirement study

Creating libraries for standard reusable procedures & functions.

Prototype development based on the design specification, Installation and setting up the software for run time environment.

Training the end users and System support modifications according to the user request.

Integrated testing of application, Implementing and Managing RAC.

Having good experience with TOAD and SQL * Loader to load data from flat files Creation of Tables, and Control files, PL/SQL Stored Procedures, SQL*Plus and Experience on Using Benthic Software Tools.

Experience on Migrations from Non-Oracle to Oracle Databases using SQL Developer migration tool (SQL Server 2005 and 2008 to Oracle database 11g and Understanding Sybase Code.

Excellent knowledge using Oracle Forms Developer 6/6i and Reports 6/6i.

Experience on Database architects, designers developers to translate data requirements into the physical schema definitions for Oracle.

Perform detailed analysis of the database for areas of optimization (e.g. tablespace, flashback log, undo, redo and archive log management, compression and partitioning techniques).

Evaluate database for performance (latency, throughput, SQL) and makes/recommends changes where appropriate

Act as a primary point person to support both development and operation concerns. Assist with implementation by working closely with developers, resolving questions and issues around business/functional requirements

Provide critical production support, resolve production problems. Enforce appropriate database standards are adhered to by development team. Encourage and train development personnel on database concepts and Oracle technologies

Adhere to corporate and department standards, policies and procedures. Contribute to the development and refinement of department standards, processes and procedures.

Expertise in development, care, and maintenance of logical and physical ERWin data models, along with corresponding metadata.Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.

Facilitateddatarequirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.

Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.

Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.

Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.

Experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developersunderstanding of views, Synonyms, Indexes, Joins and Partitioning.

Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.

Established and maintained comprehensivedatamodel documentation including detailed descriptions of business entities, attributes, anddatarelationships.

Developed mapping spreadsheets for (ETL) team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, and corporate meta-datadefinitions.

Good Experience in writing Cursors, Function, Procedures, Packages, Triggers and PL/SQL Performance Tuning, Fixing the Bugs in PLSql Code.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Strong experience in Data warehouse concepts, ETL.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Experience in Oracle supplied packages,Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Partitioned large Tables using range partition technique.

Experience with Oracle Supplied Packages such as DBMS_SQL,DBMS_JOB and UTL_FILE.

Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.

Worked extensively on Ref Cursor, External Tables and Collections.

Expertise in Dynamic SQL, Collections and Exception handling.

Education

Masters in Computers from Sri KrishnaDevaraya University, Anantapur.During 2001 to Nov 2003 with 73.8%

TECHINICAL SKILLS:

RDBMS: Oracle 12c, Oracle 11g RAC, Oracle 10g RAC, oracle 9i, SQL Server, Operating Systems:Solaris 9/10, Linux RHAT 4/5,6, HP-UX 10.x/11.x, AIX 5.2/5.3, Microsoft Windows 2003/2005. High Availability, Tuning& Monitoring Products: Oracle 10g RAC, Oracle 11g RAC, Tools &Utilities:ASM, Data Guard, Grid Control (OEM), Tkprof, Statspack, AWR, ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, DataPump (expdp/impdp), SQL Loader. ETL & Reporting Tools:Informatica, Power Center 8.5/8.0,Data Stage6.0,1.0, Business Objects Xi R26.1, Oracle Data Integrator, SAS Backup Tools:Veritas NetBackup, NetApp, HP Programming Languages: SQL, PL/SQL,C,C++, XML, Java. ERP: Oracle Apps 11i & R12

Project Name#1

Client : BCBS, MA, USA Aug ’18 – Till date.

Company :BCBS

Environment: Oracle 12C /11g/10g RAC, SunSolaries, Redhat Linux, IBM AUX, Oracle Linux, ASM,OEM (Grid Control), RMAN,DataGuard Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate, AWS EC2, RDS, S3 Bucket, SQL Server 2013 and SSRS

BCBS MA Insurance Health Center, goal is to help consumers find the right combination of price and coverage when shopping for health insurance

Designing Mobile app for BCBS MA

Responsibilities:

Created, implemented and managed custom Oracle databases on Linux

Provided Oracle database administrative support to various user groups (application developers, data managers etc); created and maintained Oracle database objects (schemas, tables, indexes etc)

Analyzed and tuned voluminous SQL code

Performed capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance

Performed backup and recovery tasks on Oracle database using RMAN and cold back -ups using shell scripts

Installed and configured Oracle 12C databases

Using RMAN to restore and recover control and data files respectively

Performed a flashback and point in time recovery

Creating a database recovery catalog and registering databases to the recovery catalog database

Scheduling backups using the crontab utility

Supported system administration groups with maintaining oracle database servers and in pre-production, test, training, and development environments

Tuned database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing

Database design, database systems design, architects the full SDLC complaint database infrastructure.

Control and monitor user access to the database using roles, and profiles

Strong knowledge in Database Monitoring and Performance Tuning by using AWR Statspack, ASH Report and Explain Plan.

Strong knowledge in Database Security and User Management through Authentication, Auditing, Encryption and Enterprise Security for availability, liability and integrity for the organization.

Performed data migration from a database in one server to a database housed on another server using database link

Migrated data using the data pump export (expdp) and import (impdp)

Have dealt with both Agile and Waterfall applications

Extracted data from internal data warehouse system to SSRS

Tracked trouble ticket request for request made by end users

Created ad-hoc reports

Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization

Analyzed data models, data relationships, and dependencies for greatest optimization

Designed and developed stored procedures, queries and views necessary to support SSRS reports

Performed functional and performance QA testing

Provide DBA implementation and support for Oracle migrations and upgrades, including environments using OracleDataGuard.

Provide Oracle Application Server and Oracle APEX implementation and support.

Provide support for Oracle Enterprise Manager Grid Control and Agents.

Provide 3rd level support for Oracle RAC, including applying patches, performance tuning, backup and recovery issues with RMAN/Data Protector, trace analysis, service creation, and cluster and system management.

Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions

Designed logical and physical data model using Erwin interfaces.

Designed Application user access security including security schema data model and Pl/sql packages.

Developed a Conceptual model using Erwin based on requirements analysis

Developed normalized Logical and Physical database models to design OLTP system for insurance applications

Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin

Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information

Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Project Name#2

Client : Trimble, MA, USA Mar ’17 – July ‘18.

Company :Trimble

Environment: Oracle 12C /11g RAC, Redhat Linux, Oracle Linux, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate, AWS EC2, RDS, S3 Bucket, Cloud Berry,SQL Server 2012 and SSRS

Trimble is a global leader in technology solutions that help businesses significantly improve efficiency and productivity. Trimble Real Estate & Workplace Solutions, a segment of Trimble’s Buildings group, is committed to transforming the way real estate, people and facilities are managed and optimized, wherever they are located.

As a specialist in the real estate industry, we deliver advanced, intuitive technologies and scalable enterprise software solutions that provide deep functionality and help streamline communication and collaboration throughout the real estate management lifecycle. Our Manhattan, CenterStone and Space Scheduling software applications assist in reducing costs, increasing performance, enabling visibility and maximizing utilization. Solutions include Integrated Workplace Management, Lease Administration & Accounting, Space Planning & Management, Operations & Maintenance Management, Room & Desk Booking, and Real Estate Investment Management.

Responsibilities:

Created, implemented and managed custom Oracle databases on Linux and windows platforms

Provided Oracle database administrative support to various user groups (application developers, data managers etc); created and maintained Oracle database objects (schemas, tables, indexes etc)

Analyzed and tuned voluminous SQL code

Performed capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance

Performed backup and recovery tasks on Oracle database using RMAN and cold back -ups using shell scripts

Installed and configured Oracle 12C databases

Using RMAN to restore and recover control and data files respectively

Performed a flashback and point in time recovery

Creating a database recovery catalog and registering databases to the recovery catalog database

Scheduling backups using the crontab utility

Supported system administration groups with maintaining oracle database servers and in pre-production, test, training, and development environments

Tuned database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing

Database design, database systems design, architects the full SDLC complaint database infrastructure.

Designed AWS infrastructure to move our local applications to hybrid cloud, as an intermediate stage and then it will all public cloud.

Provisioned servers, involved in setting up VPNs, VPCs, and provisioned database servers include RDS instances.

Established Standards of Operating Procedures to migrate, and manage applications to cloud.

Established security policies in the AWS cloud.

Provided disaster recovery processes in the hybrid and public cloud.

Also quite involved with other cloud architectures not just AWS. Actively participate in development efforts, application design, and QA activities.

Provided Development and operations lead role for Oracle based applications.

Provisioned EC2 instances in the AWS cloud, Patching EC2 servers and databases in AWS cloud

Allocate S3 buckets and create databases on AWS cloud

Create roles, groups, multi user authentication with (IAM) AWS services

Control and monitor user access to the database using roles, and profiles

Strong knowledge in Database Monitoring and Performance Tuning by using AWR Statspack, ASH Report and Explain Plan.

Strong knowledge in Database Security and User Management through Authentication, Auditing, Encryption and Enterprise Security for availability, liability and integrity for the organization.

24hrs on call rotation

Performed data migration from a database in one server to a database housed on another server using database link

Migrated data using the data pump export (expdp) and import (impdp)

Have dealt with both Agile and Waterfall applications

Installation, Administration and Maintenance of SQL Server Instances.

Setup Test, Dev, Staging and Production Environments.

Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)

Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))

Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning. (Creating and maintaining those Indexes, not performing database shrinking, memory settings, monitoring CPU usage and Disk I/O activity etc)

Documenting major changes to the SQL Servers. (General)

Extracted data from internal data warehouse system to SSRS

Tracked trouble ticket request for request made by end users

Created ad-hoc reports

Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization

Analyzed data models, data relationships, and dependencies for greatest optimization

Designed and developed stored procedures, queries and views necessary to support SSRS reports

Performed functional and performance QA testing

Project Name#2

Client : Tracfone,FL, USA Nov ’16 – Feb 17.

Company :Tracfone

Environment: Oracle 11g RAC/10g RAC, HP-UX, Redhat Linux, Sun Solaris, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader

Tracfone offers least expensive way to own and use a cell phone in America. No contracts, credit checks, activation charges or cancellation fees and no surprises! Brand name phones from leading manufacturers like Motorola, LG, and Samsung. Choose from simple "Candy Bar" phones, to Bluetooth® enabled Phones. Airtime is purchased online, from your phone or from 90,000 retailers throughout the country.

Responsibilities:

Installation & configuration Oracle Grid Software 11g database/software on Windows boxes.

Involved with installation and maintenance of ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Production support, upgrades, patching software and performance monitor production DBs.

Support to Application development team (SDLC) for new application releases. Design database schema structure for database objects (Table, View, Synonyms, and Sequence), writing database code (procedure/function and packages), and Reference tables for XML and application access user.

Design and implement database standards like Table/Column/Seq/Proc/Func/Package naming convention and pl/sql coding standards. Design/Develop application release deployment playbook/steps and perform production go live.

Monitoring Production database for ORA error, locks, wait events, Latches, scattered read, locks, blockers.

Responsible for SQL and PL/SQL tuning and full support to development/application team (More than 100 developers) for various tasks. Monitoring load testing, capture CPU stats, high execution/time taking queries and perform performance improvement task. Support conversion process from legacy system to OLTP systems.

Responsible for writing ksh shell scripts and setting cronjobs for space alerts, CPU idle, long running SQL and locks.

Index monitoring (usage), designed new Indexes by monitoring performance of existing code and new development code before deployment on production db.

Responsible for regular O/S Administration like CPU load, IDLE CPU %, time taking session/processes, Disk and Memory usage, and File system monitoring.

Responsible for backup and restore process for all the environments. Configured RMAN backup process for production database. Configured export backup for lower environment database backups.

Refresh database/schema using old baseline database snapshot timely basis. Actively interfaced with other internal organizations to anticipate the support needs of the application areas.

Assisted in developing the Disaster Recovery and backup procedures along with the system administrators.

Performed Oracle upgrades, creation of standby database and database tuning. Established and implemented policies, standard operation procedures pertaining to database security, maintenance and use.

Assisted in Planning & Design of the Hardware & Technology Architecture & Layout.

Code review and looking into the Performance Tuning possibilities of SQL and PL/SQL code

Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions

Designed logical and physical data model using Erwin 8.2.05 includes 11 interfaces.

Designed Application user access security including security schema data model and Pl/sql packages.

Developed a Conceptual model using Erwin based on requirements analysis

Developed normalized Logical and Physical database models to design OLTP system for insurance applications

Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin

Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information

Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*Loader calling UNIX scripts to download and manipulate files.

Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.

Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.

Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.

Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.

Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.

Project Name#3

Client : Department Human Services, PA, USA April ’12 – Oct‘16.

Company:Deloitte

Environment: Oracle 11g RAC/10g RAC, HP-UX, Redhat Linux, Sun Solaris, IBM AIX, ASM,OEM (Grid Control), RMAN, Explain Plan, AWR, ADDM, Data Pump, SQL*Loader, GoldenGate

The Pennsylvania Department of Human Service's seven program offices administer services that provide care and support to Pennsylvania's most vulnerable citizens.

Deloitte's ITSS team is a specialized group of IT resources, designed to assist you in completing the successful design, architecture, promotion, implementation and maintenance of any application. ITSS assist in a large number of areas as imitative progresses from requirements through go-live. ITSS resources have deep architectural knowledge of the underlying technology landscape that supports the applications, as well as maintains the relationships with the client IT staff, to facilitate and manage change.

As part of ITSS Data domain, we provide DBA support, including query analysis, performance monitoring, data refreshes, and database design services. Also, provides enterprise coordination around standards, baselined products and vision for overall solution design. Apart from these, we manage on-going operational aspects, including availability reporting, problem reporting, performance analysis, and capacity planning. We support enterprise-wide quality checks and adherence to standards and best practices. The ITSS team provides specific support throughout the SDLC for the application teams

Responsibilities:

Installation & configuration Oracle Grid Software 12c and Oracle 11g database/software on Windows boxes (DHS – Pennsylvania application).

Involved with installation and maintenance of ORACLE 11g RAC and Standby Databases (Oracle DataGuard) for High Availability and Disaster Recovery purpose.

Restoration and Recovery of databases at the times of occurrence of critical failures.

Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.

Production support, upgrades, patching software and performance monitor production DBs.

Support to Application development team (SDLC) for new application releases. Design database schema structure for database objects (Table, View, Synonyms, and Sequence), writing database code (procedure/function and packages), and Reference tables for XML and application access user.

Design and implement database standards like Table/Column/Seq/Proc/Func/Package naming convention and pl/sql coding standards.Design/Develop application release deployment playbook/steps and perform production go live.

Monitoring Production database for ora error, locks, wait events, Latches, scattered read, locks, blockers.

Responsible for SQL and PL/SQL tuning and full support to development/application team (More than 100 developers) for various tasks.Monitoring load testing, capture CPU stats, high execution/time taking queries and perform performance improvement task.Support conversion process from legacy system to OLTP systems.

Responsible for writing ksh shell scripts and setting cronjobs for space alerts, CPU idle, long running SQL and locks.

Index monitoring (usage), designed new Indexes by monitoring performance of existing code and new development code before deployment on production db.

Responsible for regular O/S Administration like CPU load, IDLE CPU %, time taking session/processes, Disk and Memory usage, and File system monitoring.

Responsible for backup and restore process for all the environments.Configured RMAN backup process for production database.Configured export backup for lower environment database backups.

Refresh database/schema using old baseline database snapshot timely basis.Actively interfaced with other internal organizations to anticipate the support needs of the application areas.

Assisted in developing the Disaster Recovery and backup procedures along with the system administrators.

Performed Oracle upgrades, creation of standby database and database tuning.Established and implemented policies, standard operation procedures pertaining to database security, maintenance and use.

Assisted in Planning & Design of the Hardware & Technology Architecture & Layout.

Uploading the Data through OWB using Admin Tool

Resolved replication issues in Goldengateand Implemented flatfile load into HBase using Goldengate and Flume

Code review and looking into the Performance Tuning possibilities of SQL and PL/SQL code

Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions

Designed logical and physical data model using Erwin 8.2.05 includes 11 interfaces.

Designed Application user access security including security schema data model and Pl/sql packages.

Developed a Conceptual model using Erwin based on requirements analysis

Developed normalized Logical and Physical database models to design OLTP system for insurance applications

Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin

Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model

Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information

Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges

Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement

Developed PL/SQL triggers and master tables for automatic creation of primary keys.

Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.

Created scripts to create new tables, views, queries for new enhancement in the application using TOAD.

Created indexes on the tables for faster retrieval of the data to enhance database performance.

Involved in data loading using PL/SQL and SQL*



Contact this candidate