Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
PROFESSIONAL SUMMARY
Technical Skills
Professional
Experience
Education
Download Resume Format
Brady Patlolla
E-mail:
brady@gmail.com
Cell: 618-303-9876.
PROFESSIONAL SUMMARY
·
Over
8 years of Information Technology experience includes Oracle Database
Administration (11g/10g/9i/8i) on different operating system environments like
Sun Solaris, Linux Advance Server, IBM AIX, HP UX and Windows 2000/NT.
·
Over
3 years of MS SQL Server database
Administration and Development.
Ø Oracle DBA Experience:
·
Implementation
of Oracle Backup and Recovery strategies using RMAN with Data Guard in RAC
environment.
·
Involved
in configuring and maintaining Real Application Clusters (RAC) on 2 nodes for
high scalability and availability.
·
Experience
in Real Application Cluster (RAC) Setup & Administration.
·
Expert
skills on Oracle Dataguard implementation by the log shipping process between
primary and standby.
·
Good
experience in configuration of Replication setup and maintenance of Replication
process.
·
Experience
in Install, Upgrade and Configure Oracle Enterprise Editions 8i/9i/10g/11g
databases on Sun Clone/Refresh of Production databases for testing and training
environments using Recovery Manager (RMAN).
·
Setup
Oracle Enterprise Manager (OEM) 9i and Grid Control 10g/11g for database
monitoring/performance/diagnostics.
·
Experience
in Performance tuning using various aspects of the database utilities like
TKProf, Explain Plan, and Stats pack/AWR/ADDM.
·
Experience
in installing, configuring and patching Oracle Application Express (APEX).
·
Experience
in transparent data encryption setup (TDE).
·
In
depth knowledge in configuring Oracle Exadata Storage Servers.
·
Solaris,
Red hat Linux, and Windows NT/2000.
·
Knowledge
of key metrics and reports included in the packaged applications and the data
fields supported by OBIEE and
source system(s).
·
Ability
to communicate about topics such as ETL, migration and synchronization, master
data management.
·
Extensive
working experience in various RDBMS, OLAP and OLTP databases.
·
Complete
range of Oracle DBA activities including day-to-day production database
monitoring includes alert log, trace file, and achieve files, Troubleshooting
production issues and Performance Tuning issues.
·
Experience
in recommendations/suggestions on Physical Database design.
·
Experience with data management, data processing and data
modeling.
·
Experience
in writing Shell scripts to backup, restore database and automate daily
activities.
·
Creation
of Standby Databases using RMAN strategy.
·
Experience
in working with SAP BASIS Team and in using SAP BR tools.
·
Use of
oracle statspack for carrying out performance monitoring and tuning.
·
Extensive
experience with Database Cloning and Refreshing pre-prod/dev databases with
prod/pre-production databases.
·
Experience
in create and initialize Database Security roles.
·
Experience in maintaining Database Security
and processing security related requests.
·
Experience
in implementing Oracle Wait Interface (OWI) to troubleshoot I/O issues.
·
Good
experience in SQL skills and PL/SQL programming.
·
Designed
and implemented Backup and Recovery strategies by taking cold backup and hot
backup.
·
Testing
and implementing different physical and logical backup and Recovery methods
like point in time, media recovery, full/partial and export/import.
·
Experience in writing Shell scripts to
backup, restore database and automate daily activities.
·
Experience using tools like TOAD, Putty,
Attunity for Oracle CDC, FogLight for SQL/Oracle performance, SQL Developer.
·
Good
knowledge in Sun Solaris and Linux Administration.
·
Good
knowledge in installation of Database associated products and tools.
·
Good Knowledge on VERITAS Netbackup, EMC and
Netapps storage practices.
·
Good
knowledge on ETL Tool like Informatica 7.1/8.0.
·
Versatile
team player with excellent analytical, communication and inter personal skills.
·
Provided
24 x 7 support and flexible to work beyond regular hours.
Ø SQL DBA Experience:
·
Experience
on MS SQL Server Installation, Configuration, Performance Monitoring, Security
Administration and Replication, Database mirroring & Clustering.
·
Experience in Query Optimization,
performance tuning and in using SQL profiler and SQL Trace to debug any issues
·
Expert in creating and maintaining SQL
Replication – Snapshot and Transactional. Worked on SQL to SQL, SQL to MySQL
and SQL to Oracle Replication.
·
Extensive Knowledge on creating SSIS and DTS
packages.
·
Performed several migrations from SQL 2000
to SQL2005.Currently involved in SQL 2005 to SQL 2008 migrations.
·
Extensive Knowledge in estimating Disk
storage requirements for Database Administration needs.
·
Developed, tested and implemented a robust
SQL backup and recovery strategy with Client assistance.
·
Actively processed developers restore or
Refresh requests to facilitate in-house projects.
·
Participated in designing, testing and
implementing an enterprise Disaster Recovery Plan.
·
Experience in applying SQL latest Patches as
per Vendor-Client License agreement.
·
Involved in Planning Software Licenses for
both SQL and Oracle.
·
Proven ability to handle Databases of more
than a TB in size.
·
Expertise in handling all Major Day-to-day
SQLServer Database administration.
·
Set up Log shipping, MSSQL Mail and SMTP
Configuration.
·
Created, Administered and maintained SQL
server databases (Production, Development, Staging and Preproduction) and
ensured Database availability 24x7.
·
Worked with Lead developers to solve
performance issues and suggested changes such as Data partitioning, SP changes,
Indexing etc.
·
Managed Security by defining roles and
rights.
·
Handled Fine Tuning Operating System
in-coordination with Server and Network Administrator to utilize the maximum
resources for Database and Applications.
·
Experience in configuring Inter Information
Services.
·
Extensive Knowledge on creating and
Maintaining SSRS reports.
·
Good Team player with excellent Analytical,
Communication and inter personal skills.
·
Ready to stretch hours to support any
crucial IT needs.
Technical Skills
Operating System: Windows 2003, Windows 2000, XP,
Windows 95, DOS, Sun Solaris 10/9/8/7, Linux, UNIX, IBM-AIX 5.x/4.3.3/3.2, HP-UX.
Databases: ORACLE 8/9i/10g/11g, MS SQL Server 2000/2005/2008,
MySql & MS Access
Application
Servers: Oracle 10g/9iAS, Internet Information Server,
Weblogic
Web Servers: Apache Webserver
Languages: C, C++, Java, SQL, PL/SQL,
Unix Shell Scripting
Networking: TCP/IP, Internet, sqlnet, Net8
Storage
& Clusters: EMC,
Veritas & Sun clusters
Tools/Utilities/ETLs: Erwin
3.x, Oracle OEM, Oracle 10g Database control/Grid Control, statspack, Attunity
for Oracle-CDC, TKProf, SQLLoader, RMAN, Export/Import, Data pump, Oracle
Dataguard, TOAD & PL/SQL Developer,Primavera, Informatica & Cold
Fusion.
Professional
Experience
BABSON CAPITAL MANAGEMENT, SPRINGFIELD , MA
Sr. Oracle DBA & MS
SQL DBA
Responsibilities:
·
24X7
production support for different Oracle databases on UNIX and Windows environments.
·
Installing,
Configuring, Monitoring, and Troubleshooting 10gR RAC, 11g RAC databases on ASM
and OCFS2.
·
Worked
as Senior Database Consultant for Oracle and SQL Server.
·
Readdressing
IP’s for the RAC database servers and Standby Server when shifted to different
data centers.
·
Proactively
identified issues/bottlenecks
that are potential problems, Involved necessary support teams Application, Unix, Network, Storage
etc. and took a corrective action to rectify the issues.
·
Responsible
for building the Oracle Transparent Gateways to allow integration of Oracle
databases with non-Oracle databases (MS SQL).
·
Responsible
for creating and managing db links which enables developers to access objects
on another database.
·
Implemented backups using RMAN, Oracle Utilities (Export/Import
& DataPump) and OS methods.
·
Configuring
Data Guard to ensure high availability, data protection and disaster recovery
for enterprise data.
·
Configured
RMAN for scheduling backup directly to tape using VERITAS NetBackup.
·
Designed
Backup and Recovery strategies using RMAN both on standalone and cluster
environments.
·
Refresh/Cloning of Database from production
environment to test environment using RMAN Duplicate.
·
Identified and fixed the logical block
corruption using RMAN.
·
Responsible for Oracle database migration
using Oracle datapump utility.
·
Involved in Disaster Recovery team and
responsible for smooth completion of annual DR testing.
·
Responsible for managing
database design, creation and maintenance of MS SQL Server. Created
and configured Linked Servers on MS SQL servers to execute commands against OLE
DB data sources on remote servers.
·
Providing assistance to immediate manager on
Cost and storage estimations for the next IT Budgeting.
·
Implemented Attunity Oracle-CDC for
integrating continually changing Oracle data into SSIS.
·
Responsible for configuring MS SQL server
database Backup and Recovery using LiteSpeed for SQL Server from Quest which is
a fast and flexible backup and recovery solution that uses patent-pending Fast
Compression technology to significantly speed backup time, reduce backup cost,
and improve database recovery.
·
Intensively used 10g 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.
·
Used SQL Tuning advisor in OEM to get the
recommendations for poor performing queries and assisted the developers.
·
Responsible for SQL query tuning, optimization
using tools such as Tkprof, STATSPACK, Explain plan and SQL*Trace.
·
Performed Operating system tuning to address performance issues.
·
Supported Developers and Testing Team with
connection related issues and structural changes in the database.
·
Scheduled and Monitored OEM Grid and Cron
Jobs for RMAN and exports on Unix Platforms. Configuring Data Guard to ensure high
availability, data protection and disaster recovery for enterprise data.
·
Responsible for implementing year end mock
DR testing. Implementing Database Security, Management of role-based security.
·
Applied required
security patches on oracle databases using Opatch utility.
·
Monitoring
Scheduled jobs of the daily activities for the performance of all the
databases.
·
Strong
knowledge on OVM and VMWare.
·
Developed
Unix shell scripts and automated nightly jobs using Cron to schedule the Backups,
Refresh tables in test databases from production, cleanup trace files, analyze
non-system tables, analyze non-system indexes, delete old backup files etc.,
·
Assisted
developers in testing PL/SQL procedures (stored procedure, triggers, function,
cursors and packages) for
maintaining tables, retrieving data from tables and managing users using
different oracle tools.
·
Regular
Coordination with DBA teams in India
·
Prepare
the documents of the process and knowledge transferring about the project to
the new team members and responsible for mentoring Junior DBAs and documented
all DBA duties to be performed.
·
Intensively
used Toad for Oracle Database Administration.
Technologies: Oracle 11g/10g/9i RAC,
ASM, OEM Grid Control 10g, Solaris 10, HP-UX, MS SQL Server, Window 2003, Datagaurd, Performance Tuning, AWR/ADDM, Shell
Scripting, RMAN, Veritas NetBackup, RDBMS,PL/SQL, TOAD .
State
Government Of North Carolina
Sr.
Oracle DBA/Engineer
·
Responsible to provide 24 x 7 database administrative activities
over different database servers.
·
Supported different Databases like Production, Development,
Testing, UAT and Training.
·
Responsible for Oracle 11g RAC EE installation and configuration
on RHEL5 X86_64.
·
Responsible for upgrade and migration of data from 10g RAC to 11g
RAC environment SE using ASM on RHEL4.
·
Responsible for data migration of various OLTP and OLAP databases.
·
Responsible for Data Guard setup with one Primary and two Standby
databases and scheduled cron job to monitor the replication between primary and
standby every 15mins.
·
Responsible for planning, testing and implementing different
backup and recovery strategies.
·
Performed Database Cloning
to create testing and development instances from production.
·
Responsible for installation and configuration of MS SQL Server
2005.
·
Responsible for managing database design, creation and maintenance
of MS SQL Server 2005.
·
Designed and Created MS SQL Server databases,
tables, views, stored procedures and triggers.
·
Involved
in scheduling and maintaining batch jobs thru SQL Server Agent and thru various Shell scripts, VB script, and .bat files.
·
Installed Oracle on VMware ESX Server Virtual Consoles (VC) and
created an ODBC connection to the database.
·
Applied
latest releases of the RDBMS patches from Oracle to the Production and test
instances to resolve few technical challenges & issues.
·
Contacted
Oracle for Technical Assistance Request to track the problems in the database
and resolved accordingly.
·
Created and enhanced DB utilities needed for automation of system
and unit tests and investigation of production issues, troubleshooting.
·
Configured Oracle APEX for J2EE applications.
·
Involved in Oracle advance security setup using transparent data
encryption (TDE), created Oracle wallet to store TDE master encryption key, and
implemented tablespace level encryption.
·
Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle
Enterprise Manager and monitoring the statspack report, generated from
snapshots taken at the peak business hours.
·
Daily Monitoring of alert log files for errors, trace files and
archive log destination files.
·
Designed and implemented hot backups using a
combination of incremental, differential and full backups using RMAN.
·
Installed Oracle Enterprise manager grid control agent on all
production databases using agent download script on different platforms
(windows, linux, solaris,).
·
Responsible for network configuration and involved in a
Client–Server environment using TNS, LISTNER, Net Configuration Assistant and
other configuration files.
·
Planned, tested and implemented backup strategy using RMAN, Oracle
Utilities (Export/Import) and OS methods.
·
Upgraded database and migrated data from 10.2.0.3 to 11.1.0.6.
·
Responsible for working closely with SAP BASIS Team, and involved
in multiple database restores and recoveries using SAP BR tools.
·
Responsible for applying patches and hot fix for MS SQL SERVER
2005.
·
Monitored and tuned long running jobs by working closely with the
application development team and analyzing objects, created or rebuilt indexes,
query tuning using SQL TRACE, TKPROF, Explain Plan and provided the ADDM
reports per request.
·
Scheduled and monitored OEM job scripts for exports, hot backup,
analyze schema, rebuild indexes.
Technologies: Oracle
9i/10.2.0.3/11.1.0.6/11.1.0.7, RHEL4,RHEL5,Solaris 10,Window 2003, MS SQL Server 2000/2005/2008,
Oracle Enterprise Manager Grid Control, AWR/ADDM/Statspack, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, Dataguard.
Computer
Science Corp.
Jun 06 – Dec 07
Sr.
Oracle DBA
·
Responsible
for creating Production, Test and Development Databases, setting proper
initialization tuning parameters, Installing & implementing Oracle 9i and
10g for various customers on various operating system platforms as part of the
implementation team
·
Responsible for Data load on different databases using SQL*Loader
·
Recovered critical databases from failures with minimum downtime.
·
Responsible for planning, testing and implementing different
backup and recovery strategies.
·
Conducted daily routine checks on alert logs and trace files.
·
Performed fine SQL tuning on the application.
·
Installed and Configured MS SQL SERVER 2000.
·
Coordinated research, planning and implementation of new database
installations, upgrades and patches of MS SQL Server 2005.
·
Designed
and Configured RAC environment on Two Node architecture.
·
Experience
in working with Oracle Application express (APEX) formerly known as HTML-DB.
·
Performed
database system level space management and monitoring.
·
Real
Application Clusters monitoring, tuning, load balanced using OEM (Oracle
Enterprise Manager).
·
Utilize,
managing and monitoring hot Standby Database using Data Guard as well as monitoring standby for latency issues.
·
Involved
in replication setup, configuration and maintenance of replication process
·
Created and enhanced DB utilities needed for automation of system
and unit tests and investigation of production issues, troubleshooting.
·
Responsible for entity relationship data modeling using Erwin data
modeler.
·
Configured Oracle 10g Application server with Oracle Forms &
Report Server on AIX environment.
·
Responsible for network configuration and involved in a Client
–Server environment using TNS, LISTNER, Net Configuration Assistant and other
configuration files.
·
Created and configured database manually & using Oracle
Database Configuration Assistant.
·
Planned, tested and implemented backup strategy using RMAN, Oracle
Utilities (Export/Import) and OS methods.
·
Monitored and tuned long running jobs by working closely with the
application development team and analyzing objects, created or rebuilt indexes,
query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software
(DB Tuning).
·
Responsible to identify the specific bottleneck areas implementing
Oracle Wait Interface and improvements has been targeted to those areas.
·
Scheduled and monitored OEM job scripts for exports, hot backup,
analyze schema, rebuild indexes.
·
Provided
24x7 support. Willingness and flexibility to work beyond
regular hours based on business demands.
Technologies: Oracle 10.2.0.2,
AIX, Linux, Window 2003, Oracle
Enterprise Manager, RDBMS, SQLDBA,
PL/SQL, TOAD 8.0, Shell Scripting, Stored
Procedures
DEPARTMENT
OF HEALTH AND SENIOR SERVICES, Jefferson
City , MO
Oracle DBA
·
Responsible to provide 24 x 7 database administrative activities
over different database servers, representing various RDBMS as Oracle 10g and
Oracle 9i on operating AIX.
·
Managed backups for Oracle Transactional and Data warehouse databases.
·
Supported different Databases like Production, Testing, Staging
and Training
·
Responsible for Data load on different databases using SQL*Loader
different schemas
·
Developed different scripts for migrating schemas
·
Responsible for planning, testing and implementing different
backup and recovery strategies.
·
Responsible for the performance tuning of database and
application.
·
Conducted daily routine checks on alert logs and trace files.
·
Performed fine SQL tuning on the application.
·
Scheduled and monitored OEM job scripts for exports, hot backup,
analyze schema, rebuild indexes.
·
Upgraded databases from Oracle 8.1.7 to Oracle 9.2.0.
Technologies: Oracle 9.2.0,AIX,
Window 2003,HP-UX 11.11,Oracle Enterprise Manager, RDBMS, Oracle 10g SQLDBA,
PL/SQL, TOAD7.5
PSINet
Consulting Solutions, Alexandria ,
VA
Oracle
DBA
·
Responsible to provide 24 x 7 database administrative
activities over different database
servers, representing various RDBMS as Oracle 9i RAC on Solaris.
·
Managed backups for Oracle RAC databases.
·
Supported different Oracle 10g and Oracle 9i Databases of
Production, Testing, Staging and Training
·
Responsible for Data load on different databases using SQL*Loader
·
Provided Citrix Administration, supported CITRIX users.
·
Managed the Veritas Netbackup software for managing the IBM LTO
tape device.
·
Recovered critical databases from failures with minimum downtime.
·
Responsible for planning, testing and implementing different
backup and recovery strategies.
·
Conducted daily routine checks on alert logs and trace files.
·
Performed fine SQL tuning on the application.
·
Used
data guard created, maintained, managed and monitored
databases to protect enterprise data from failures, disasters, errors and
corruptions.
·
Used Database Configuration Assistant (DBCA), Database Upgrade
Assistant (DBUA) for migrating Oracle 8i to 9i versions.
·
Experienced in several programming languages including Shell
scripting, SQL, java, XML, XSLT, HTML and ASP in support of DBA activities such
as scripting for scheduled jobs, created stored procedures and triggers and
integrated front-end web pages with back-end database engines.
·
Responsible for planning, testing and implementing different
backup and recovery strategies.
·
Implemented advanced replication and standby databases.
·
Responsible for the performance tuning of database and
application.
·
Scheduled and monitored OEM job scripts for exports, hot backup,
analyze schema, rebuild indexes.
·
Used Database Configuration Assistant (DBCA), Database Upgrade
Assistant (DBUA) for migrating Oracle 9i versions in RAC.
Technologies: Oracle 9.2.0.7 RAC,
Oracle Advance Replication, Window NT/2000/2003, Oracle Enterprise Manager, MS
SQL Server 7/2000,RDBMS, Veritas Netbackup, SQLDBA, AIX 5L 5.3, PL/SQL,
TOAD7.5, Shell Scripting,
L, ASP,
DBA, Stored Procedures, Triggers
Satyam Computer Services Ltd. India
Oracle
DBA
·
Installed different versions of Oracle (7.x / 8 / 8i /9i) on
different operating systems (Windows, Sun Solaris 7/8, patches and fixes to
upgrade RDBMS.
·
Monitored DB growth and provide DB capacity planning for apps
expansion.
·
Created and enhanced DB utilities needed for automation of system
and unit tests and investigation of production issues, troubleshooting.
·
Responsible for network configuration and involved in a Client
–Server environment using TNS, LISTNER, Net Configuration Assistant and other
configuration files.
·
Created and configured database manually using Oracle Database
Configuration Assistant.
·
Planned, tested and implemented backup strategy using RMAN, Oracle
Utilities (Export/Import) and OS methods.
·
Created and enhanced DB utilities needed for automation of system
and unit tests and investigation of production issues, troubleshooting.
·
Monitored and tuned long running jobs by working closely with the
application development team and analyzing objects, created or rebuilt indexes,
query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software
(DB Tuning).
Technologies: Oracle DBA, Solaris
7/8, RDBMS, Unit Testing, Client/Server, RMAN, SQL, TOAD, Oracle 7.x/8/8i/9i,
PL/SQL, SQL Server 7.0, AIX 4.3.3, Window NT,Open VMS V7.31, HTML, ASP, Java.
Education
·
MS in Computer &
Electroincs Engineering.
Note: References will
be provided on request.
Download Resume Format
.JPG)
.JPG)
0 comments:
Post a Comment