Oracle DBA Sample Resume

Oracle DBA 5+ Tears Experienced Resume

Joseph Emmanuel
F4, Sree DurgaParameshwara Apartments
7th Cross, Lady hill, Mangalore
Karnataka - 575003
Phone:  xxxxxxxx
Email:xxxxx@gmail.com
                                                      

Career Objective:

To pursue my career in an organization, which caters to my core competencies, where I can instigate my skills, knowledge & experience to achieve organizational goals through continuous learning & self-development, while being innovative and enduring and to Lead a team and attain the goals and visions set by the organization.


PROFILE SUMMARY :

•Nearly 4 years of experience in Database Administration in production Support domain on VAS services.
•Proficient in RMAN , backup recovery, user management , performance tuning , dataguard , upgrade , patching , cloning , datapump , sql loader , ASM , flashback.
•Gained proficiency in Linux commands , shell scripting in bash and writing complex SQL queries.
•Experience of end-to-end implementation of service delivery platform ,including finalization of specifications, design, development, implementation and quality assurance.
•Conversant with configuration handling within SLA.
•Exposure in database administration with complete understanding of oracle architecture.
•Possesses strong coordination with global teams, planning, interpersonal, communication, presentation and decision making skills.
•Recognised with Best Performer Award in 2012 & Role Model Award for Behavioural Skills in 2013
•Performing schema refreshes from prod to non-prod environments.
•Creating profiles and attaching them with users and monitoring the users.
•Resolving Listener issues, Network issues.
•Generating AWR, ADDM Reports for the better performance.
•Having knowledge in Dataguard Configuration and DR Monitoring, gap resolutions
•Flexible with 24*7 environment including oncall support as per requirement
•Extensive Knowledge on Oracle Architecture
•Familiar with Table space level issues and User level issues.

Technical Skills:

Relational Database     :Oracle 9i, 10g & 11g
Operating Systems       :Linux RHEL 4.x & 5.x, Sun Solaris 10, Windows XP
Database Tools/Utilities:SQL*Plus, SQL*Loader, OEM, RMAN, DBCA, DBUA, NETCA, NID, ASMCMD, Expdp & Impdp, DGMGRL
Tuning Tools            :TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
Languages               :SQL, PL/SQL, Shell Scripting, D2K, forms & reports 6i

CERTIFICATIONS:

•Oracle Database SQL Expert (1Z0-047)
•OCA(Oracle certified associate) – 1Z0-052
•OCP(Oracle certified professional) - persuing

EMPLOYMENT DETAILS:

July’10-present with Ericsson India Global Services as Engineer (2nd Level Assurance) / Oracle DBA

Project Undertaken:

Title:    Netsize IPX

Description:Internet Payment Exchange (IPX) is an Ericsson solution which serves as a content gateway/Aggregator between the Mobile Operators and service Providers. The service providers can deliver their services to subscribers and get paid by connecting to IPX using an easily implemented application programming interface and IPX handles all interaction with the Operators.At present IPX has integrations with 220 worldwide operators in 26 countries and 3400 service providers delivering their services to 5 billion(approx.) subscribers.

Services Supported:SMS, MMS, Mobile Purchase, Subscription, Web-Opt in, Charging & consumer information

Tools & Servers Used:
•Application Servers:- Red Hat Enterprise Linux Server release 6.3 (Santiago) running on jboss7
•Messaging Servers:- Red Hat Enterprise Linux Server release 5.9 (Tikanga)
•SMPP Servers: Red Hat Enterprise Linux Server release 5.9 (Tikanga)
•SMSC Server: Red Hat Enterprise Linux Server release 5.9 (Tikanga)
•Database: Oracle 11g
•Application Manager: Tool used for traffic monitoring and server monitoring
•SQL Developer: used for executing DML,DDL and DCL commands as SQL queries
•Enterprise Manager: For database administration

Highlights:

Database specific Responsibilities (Oracle 11g):
•Essayed a key role in:

    o Complete understanding of oracle architecute
    o Creating & managing user account, granting & revoking privileges from users as per business requirements
    o Managing tablespaces and quotas.
    o Creating database as per business requirement using DBCA and command line.
    o Writing  SQL queries
    o Cleaning database on regular basis to ameliorate performance of database
    o Configuration of new listener and registering required database with listener
    o Reading alert log file for performance point of view
    o Taking the backup of database on scheduled basis and performing the recovery if required including user managed and RMAN method as per requirement.
    o Configuring RMAN parameters
    o Writing RMAN scripts
    o Cloning method to create a duplicate database for testing purpose
    o Configuration of recovery catalog from scratch
    o Data export and import using datapump
    o Performing flashback operations
    o Proactively performing the database maintenance
    o Performance and tuning
    o Creating and maintaining the physical standby database using dataguard
    o Setting Metric threshold values.
    o Performing the upgrades and patching.
    o Configuration of ASM.
    o Loading the data through sql loader.

•Additional responsibilities on service delivery platform:
  
    o The prime responsibility is to keep the services and servers up and running of IPX, if any glitch then  to restore the services as soon as             possible.
    o End to end migration of services from old to new platform in close coordination with Operators & Integration Team.
    o Configuration of dedicated and shared short codes for service providers, auto reply SMS for MO SMS sent by subscribers, cron jobs and XML             parameters for all the services
    o Detailed analysis of transaction logs to find the glitch in transactions
    o Creating and maintaining binds with operator including SMPP, HTTP ,UCP which is used to submit traffic to operator's platform
    o Reporting and prirotizing Bugs towards Integrations and R&D and deploying the fix of Bugs in production environment.
    o Deployment of application server to new version on weekly basis with keeping close watch on traffic
    o Managing disk space and CPU utilization on Linux based servers
    o Handling configuration in production system as per requirement from customers
    o Establishing SFTP connectivity with operators for transfer of CDR and other files
    o Writing shell scripts in bash shell
    o Setting up of automatic login with operators by creating and synchronizing public and private keys
    o Capturing & analyzing snoop for analysis of traffic flow

Project  2:

Title          : Santander
Client         : Santander Bank (UK)
Role           :  Data Base Administrator
Skills used    : Oracle 9i/10g/11g ,Linux, windows
Duration       : Nov-2009 to March-2010

Responsibilities:

•Creating Users with Quota Management.
•Adding / Resizing data files if needed.
•Logical Backup Using Export & Import
•Export of important tables as regular intervals.
•Worked on archive gap issues between production and stand by databases.
•Applied CPU patches on 10g and 11g databases.
•Worked with development teams for code deployments
•Creating user Profiles
•Granting specific privileges and roles to the users
•Taking cold and hot backups.
•Worked on User account issues like lock, passwords expire etc.
•Worked on Invalid Objec

Project  3:

Project    name        :  Infrastructure
Operating Systems    :  IBM AIX, Sun Solaris, Linux.
RDBMS                 :  Oracle 10g/9i
Role            :  Database Administrator   
Duration        :  May 2008 to June 2009.


Roles & Responsibilities:

•Planning & Managing of Database Backups
•Database Recovery.
•Analyzing schema objects.
•Monitoring of alert logs for the database performance.
•Managing tablespaces, tables, indexes and views.
•Creating and managing Pfile & Spfile.
•Managing online redo log files.
•Multiplexing control files.
•Recreating the control files using the trace files.
•Logical backup using export, import & data pump
•Worked on transportable table space.
•Using SQL *Loader, converted data from Unified system to Oracle Database.
•Create and maintain the physical & logical Backups.
•Database Cloning using RMAN & Manual.
•Troubleshooting Oracle Databases using SQL trace utilities.
•Monitoring the different memory structures.
•Monitored and diagnosed database performance through monitoring of alert files and trace files.
•Optimized and tuned databases for peak performance using Oracle Enterprise Manager, Tkprof and other utilities.
•Used Explain plan statement and Oracle Optimizer hints to enhance performance of SQL statements.
•Configured memory & disk resources to optimize sort operations..
•Used log miner to monitor log activity.

ACADEMIC QUALIFICATIONS:

•Bachelor of Technology from Shaheed Bhagat Singh College of Engineering and Technology, Ferozepur, PTU in 2008 with 78%
•XII from Model School, Naya Nangal, CBSE in 2004 with 74.3%
•X from Model School, Naya Nangal, CBSE in 2002 with 77.1%

Personal Details:

Date of Birth        :18th May 1988
Gender            :Male
Nationality        :India
Permanent Address    :Puthenthara (House)
                         Ezhupunna South P.O
                         Cherthala   
                         Alappuzha        
                         Kerala-688550
                         ph:xxxxxxx

0 comments:

Post a Comment