ACCREDIATED SCRUM CERTIFIED

Pravalik Medi

Email : acgj2s@r.postjobfree.com

ORACLE DBA & Developer Mobile: +1-857-***-****

Career Objective:

Looking forward for an opportunity in a challenging DBA environment, where I can

utilize my experience and skills and contribute effectively to the success of the organization

along with my personal growth.

Profile Summary:

Having 6+ years of experience as an Oracle Core Database Administrator

Provide support 24/7 in ORACLE DBA Production Environment.

Experience in Oracle performance tuning.

Coordinate and implement changes to development, test and production environments.

Flexible to adopt new environment and willing to learn new technology.

Good understanding of Oracle Database architecture and has worked on 9i, 10g and 11g.

Performed periodic testing of the database backup and recovery plan.

Configured, Created and Maintained Databases, Table Spaces, Rollback Segments, Redo

Logs, Users, Tables, Indexes, Roles, Profiles, Partitions and Other Schema Objects.

Manage the large databases.

Excellent Troubleshooting, Problem Solving, Organization and Communication Skills.

Experience Details:

Working Syntel Inc, US as Oracle DBA from July 2010 to till date.

Professional certifications:

Scrum Certified.

Educational Qualification:

Breech from JNTU, Hyderabad.

EXPERIENCE DETAILS:

Project #1

Project : SWIFT

Project Type : Support

Project Duration : JAN 2014 - Till date

Client : Wells Fargo

Environment : UNIX

Role : Product Support Analyst

ACCREDIATED SCRUM CERTIFIED

Description:

Wells Fargo & Company (NYSE: WFC) is a nationwide, diversified financial services company.

Wells Fargo provides banking, insurance, investments, mortgage, and consumer and commercial

finance through more than 9,000 locations headquartered in San Francisco. Wells Fargo has

more than 265,000 team members in 36 countries.

SWIFT Support:

The Financial Transactions will be handled by the Swift network. The servers involved in the

transactions process will be handled by the SWIFT Wells Fargo Team.

Responsibilities:

Level 1 and Level 2 Unix Support

Preparing the reports daily on the status of server health check.

Communicating with Business users on the issues

Conducted training sessions on the servers and the applications.

Coordinating with Application Admin and Application Support teams for the issue

resolution

Involved in patching the servers and the application updates

Daily working on the incidents (SEV 1, SEV 2, SEV 3, SEV 4).

Project #2

Project : Stack and Cloud Management

Project Type : Testing

: Oct 2013 – Dec 2013

Period

Environment : Oracle 9i, 10g, 11g

Client : State Street Corporation

Role : Test Lead

Description:

All Applications across the SS will be loaded into a private cloud and after loading for the

quality assurance we need to test applications with different type’s data inputs.

Responsibilities:

Need to coordinate with offshore and clients.

Regular monitoring for the application testing

Collect the data from the application owners. Need to understand the requirements of the

testing.

ACCREDIATED SCRUM CERTIFIED

Provided data should be transferred to the offshore team for testing.

Need to prepare the reports for each application tested.

Provide the test results to the client.

Identify the key areas for better application performance.

Project #3

Project : Right Price (RP)

: Jan 2013 – Sep 2013

Period

Environment : SQL Server 2008, Export, Import and SQL Server Management Studio

Client : Syntel

Role : SQL Server DBA

Description:

This Application maintains all the details of all the resource management, billing of onsite and

offshore status. This application provides full online portal for the organization for the resources

in India, and the onsite opportunities, cost, CTC’s and the revenue to the organization.

Responsibilities:

Installing and configuring the SQL Server.

Creating the database and objects (Tables, Procedures, Scripts)

Working under the environment of 24*7 DBA Support.

Taking care of all the other daily routine DBA tasks like creating users.

Monitoring the user sessions.

Maintaining all the Database Servers.

Provided different schemas for the developers with different privileges.

Assisted the client with Database issues.

Created and maintained the Database on Dev/QA/Prod instances.

Project #4:

Project : Enterprise Capability Planning (ECP)

Project Type : Maintenance

: Aug 2012 – Jan 2013

Period

Environment : SQL Server 2005, Export and Import and SQL Developer, SSMS

Client : American Express

Role : DBA

ACCREDIATED SCRUM CERTIFIED

Description:

This application maintains all the details of all the applications used by American Express

Globally. The details are like the cost assigned to the application, SVP of the application,

Durations, servers, and technologies of all the applications will be placed in SQL Server.

Whenever the respective users or the owners of the respective applications, requests the data foe

a particular period will be provided.

Responsibilities:

Installing and configuring the SQL Server

Creating the database and objects (Tables, Procedures, Scripts)

Working under the environment of 24*7 DBA Support

Taking care of all the other daily routine DBA tasks like creating users

Monitoring the users sessions

Maintaining all the database servers on offshore

Provided different schemas for the developers with different privileges.

Assisted the clients with database issues

Created and maintained the database on Dev/QA/Prod instances.

Project #5

Project : Generic Reporting Framework

Project Type : Development

: July 2010 – July 2012

Period

Environment : Java / J2EE 6.0, Oracle 11, Spring 3.0, JMS, Web Services, XML, GWT, Jasper,

Apache Tomcat 6.0.26, Apache ant 1.6.5, Apache activemq 5.1.0, IBM Websphere

Client : Syntel

Role : DBA

Description:

Generic reporting framework that supports different application reports for the back office

functionalities of the bank. The core conceot of the framework was to remove the cost

attachment to the existing tool named ‘ Actuate’. As a solution to that the generic reporting

framework was developed using the Java, J2 EE platform with reports designed using the

Jaspersoft. This leads the application completely free to use across the organization.

Responsibilities (Java):

Developed a POC on Quarts Scheduler for job scheduling

Building the WAR files using Apache ant 1.6.5

Deploying the application using Apache Tomcat Server

Installing, uninstalling the clusters and WAR files and configuring on WAS Admin

Console

ACCREDIATED SCRUM CERTIFIED

Core DBA activities

Role (DBA):

Created users & privileges with appropriate roles and levels of security.

Database Re-organization (Database, Tablespaces, Tables etc Re-Org is done from

time to time for the primary storage objects like Tables, Indexes.

Creates a number of Dev/Stg and prod Database instances.

Performing logical backups using export utility and recovering specific object or schema

using import utility.

Monitoring and performing daily incremental backups, weekly backups.

Troubleshooting performance issues reported by the application team.

Backup of the production and Development Database, based on business requirements.

Schema, Table, Database refreshes on demand for dev teams.

Interaction with client/users on various issues.

Experience in supporting production and development environments.

Working under the environment of 24*7 DBA support.

Taking care of all other daily routine DBA tasks like creating users, roles, tablespace.

Monitoring the user sessions.

Analyzing GUI problems.

Locking and unlocking transaction codes.

Monitoring Database growth, backup logs, archives directory status.

Table space monitoring.

Maintaining all the database servers on offshore.

Provided different schemas for the developers with different privileges.

Developed the Exception handling utility in all the procedures.

Assisted the client with database issues.

Supported the team by deploying the application.

Created and maintained the database on Dev/QA/Prod instances.

Implementing troubleshoot techniques for the issues that are going to occur.

Reviewed all the procedures and allowed the developers to maintain the standards

suggested by the client.

General Administration:

Solved day-to-day user problems and troubleshooting.

Dump analysis and tuned performance of several resources.

Daly administrative tasks include frequently monitoring systems logs, Background

processes, lock entries, Updates.

User Administration:

Performed user administration.

Created Authorization and profiles based on the Job Profiles.

Performed the maintenance of user Master records.

ACCREDIATED SCRUM CERTIFIED

Security:

Created and modified customized profiles using roles.

Created users and assigned relevant profiles.

Technical Expertise:

Oracle Products : RDBMS 10g, Oracle Security Manager (User and Role Admin),

Import/Export, Conceptual Design, PL/SQL

Operating System : Windows 2000, XP, 7

Database : Oracle 10g, 11g

Tools and utilities : Apex, Export, Import and SQL Developer

Rewards:

Received Syntel Value Award for the SPEED work.

Received best scout of the year 2002 from President of India

Received best scout of the year 2001 from Governor of Andhra Pradesh

Personal Details:

Name : Pravalik Medi

Sex : Male

Visa Status : H1- B

Marital Status : Married

Languages Known : English, Hindi, Telugu

Declaration:

I hereby declare that the information in this document is true and accurate to the best of my

knowledge.

Pravalik Medi

Contact this candidate