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
TECHNICAL SKILLS:
Operating Systems: UNIX (Sun Solaris 7/8/9, HPUX, AIX 5.x), Linux (Red Hat Enterprise Linux 3.0/4.0, SLES/SUSE), Windows 2000/2003/NT Server, Windows 98/XP.
Database tools: RMAN, TOAD, ERWIN, SQL Developer.
High Availability: Oracle 9i/10g RAC, Data Guard/Standby Replication, Oracle Streams, Symmetric Replication, Oracle Golden Gate, VERITAS Cluster.
Utilities: Oracle Import/export utility, SQL * Loader, SVRMGRL and SQL*PLUS, OEM, TKPROF, SQL Trace, EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBCA, SQL Adviser, Oracle Data Pump, SQL diagnostics, AUTOTRACE, Grid Control, Opatch, SVRCTL, CRSCTL, UTLBSTAT/UTLESTAT.
Network: SQL*Net 2.0, Net 8 and Oracle Net.
Virtual Technology: VMware Server, VM Player.
Languages: C, C++, SQL, PL/SQL, UNIX Shell Scripting.
MS components: MS Office 2003/2007, MS FrontPage.
PROFESSIONAL EXPERIENCE:
State of Maine, Department of Health- Augusta, ME Aug ‘10 - Present
Sr. Oracle DB Architect
Department of Health and Human services at 442 civic center drive, Augusta provides technical database support to the state of Maine business users and Eligibility Specialists that determine Medicaid eligibility of prospective applicants. The oit team is responsible for maintenance, administration and enhancement of the prod and dev databases maintaining critical data of applicants including applicant details, application details, budget summaries, health aid records and client personal information.
Responsibilities:
Environment: Sun Solaris, Windows xp, Oracle10gdb, Grid, OEM, AWR, Forms, SQL*Plus, OLTP, OLAP, Grid Control, Oracle TOAD 10.6, Toad data modeler, PL/SQL, Oracle designer and developer suite 10g.
Verizon, Dallas, TX Oct '07 - Sep ‘10
Sr. Oracle DB Architect/Administrator
Verizon Solutions center near Dallas Forth Worth International airport provides Database support to 5 of its data centers including Maryland and New York. Maintenance and critical support is provided to 5 production databases, 11 development databases and 9 test databases that maintain client critical information including data usage details, client contracting details, client personal details and client payment and income details.
Responsibilities:
Environment: Red Hat Enterprise Linux 4.0, Windows 2003, Sun Solaris, AIX, Oracle 9i/10g RAC, Grid, OEM, AWR, ASM, Streams, SQL*Plus, OLTP, OLAP, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning.
Countrywide Financial, Plano, TX Nov '06 - Sep '07
Database Architect/Developer
Responsibilities:
Environment: Windows NT / 2000, HP-UX, AIX and Linux, Oracle 9i and 10g, TOAD 9.0.1, Erwin, Oracle Enterprise Manager, RMAN, RAC, ASM, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, OLTP, OLAP.
Teacher Retirement System of Texas, Austin, TX Sep '05 - Oct '06
Oracle DBA/Developer
Responsibilities:
Environment: RHEL 3.0, Windows XP/NT/2000/2003, Sun Solaris 8.0/9.0/10.0, Oracle 8i/9i/10gR1, OEM, Data Guard, RMAN, SQL* Plus, SQL*Loader, Oracle Toad, Oracle Replication, MS Office.
General Motors Corporation Oct '04 - Aug '05
Oracle Developer/ DBA
Responsibilities:
Environment: UNIX, Windows NT/2000, Sun Solaris 8, Oracle 8i/9i, utlbstat/utlestat, OEM, RMAN, OLAP, OLTP, Shell Scripts, Erwin and Designer 2000, Export & Import, SQL*LOADER.
Directorate of Standardization, India Apr '03 - July '04
System/Database Administrator
The Directorate of Standardization is responsible for the Standardization of all products related to the supply of the Defense Services. It includes all equipment related to clothing, food, electronics equipment, hardware related to vehicles, ships, aircraft based on the NATO guidelines.
Responsibilities:
Environment: UNIX AIX 5.1, Windows NT, ORACLE 8i/9i, Import/Export, SQL, PL/SQL, Toad, SQL*Loader, SQL*Net, UTLBSTAT/UTLESTAT, Cronjob, Erwin.
HSBC, Noida, India May '02 - Apr '03
Oracle Developer/ DBA
HSBC Bank provides a full range of commercial banking products and services to individuals, corporations, institutions and governments, through its personal financial services, private banking, commercial banking and corporate investment banking and markets segments. This project is developed as a process of automation for insurance policy management by using centralized data warehouse and Data Mart.
Responsibilities:
Environment: Windows 98/XP/NT, UNIX, Oracle 7.1/8i, SQL*Net, RMAN, Data Guard, CRONJOB, UTLBSTAT/UTLESTAT, TKPROF, EXPLAIN PLAN, MS Access, MS Office.
EDUCATION:
BS in Engineering.
Download Resume Format
Sunita Kochar
Sr. Oracle DB
Architect, State of Maine, Department of Health
309 Gantry
Creek Road
Garden City, NY 11001
Garden City, NY 11001
Home: 908-643-9876
Mobile: -
sunita@gmail.com
Resume
Sunita Kochar
SUMMARY OF
QUALIFICATIONS:
- Over 8+
years of IT experience in Database Management, Architecture and
Administration.
- Experience
in Oracle 8i/9i/10g/11g Database management on Production, Development and
Test Databases including Disaster Recovery, High Availability Solutions
(RAC & Data Guard) and Backup & Recovery (RMAN).
- Preparing
Clustered Environment including hardware and software installation,
configuration of RHEL 3.0/4.0 & Windows 2003 Server for Oracle 9i/10g
RAC (Real application clusters).
- Expert
level SQL, stored procedure programming and Performance tuning expertise.
- Expertise
in Installing, Configuring, Creating & Cloning Oracle 8i/9i/10g
databases on Sun Solaris, Linux, UNIX and Windows platforms.
- Expertise
in upgrading, migrating & patching Oracle 8i/9i/10g database using
Oracle migration utilities.
- Created
development, testing, staging, production, RAC and standby databases for
OLTP, DSS (Data Warehousing) using customized shell scripts and stepwise.
- Involved
in different scenarios of OLTP as well as DSS (DATA WAREHOUSE) Databases.
- 24x7 production
database support to developers & end-users.
- Have
implemented ORACLE STREAMS and DATAGUARD (logical standby and physical
standby databases).
- Worked on
Automatic Storage Management (ASM) for managing data in SAN.
- Having
hands on experience in Hot/Cold Backup, Recovery and Cloning of databases
using RMAN with VERITAS Net Backup.
- Have
worked on large-scale databases with size of more than 5TB in large system
environments.
- Expertise
in Designing, implementing and managing Backup strategy using Oracle Utilities
RMAN, Export/Import and Data Pump.
- Implemented
automated backup strategy using the UNIX shell script CRON UTILITY.
- Data
loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
- Expertise
in Operating System, Database and Application (SQL, PL/SQL) tuning.
- Performance
tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK,
TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, Distribution of disk
I/O, Sizing of tables and indexes.
- Installation
and Configuration of Oracle Grid Control.
- Administering
& Managing Oracle Users, roles, privileges & creating Database
objects.
- Performed
database modeling, design, sizing, tuning, capacity planning.
- Database
replication using snapshots, materialized views and advanced replication
methods.
- Management
of schemas, objects, tables & indexes partitioning.
- Worked
with third party tools like TOAD, ERWIN for quick diagnosis and end
results.
- Worked on
different types of storage structures (SAN/NAS).
- Experience
as On-Call 24x7 production DBA support and development DBA.
- Excellent
communication and interpersonal skills together with a positive approach
to undertaking challenges.
- Trained
Jr. Staff and developers regarding database structure and connectivity.
- Good
co-ordination and communication with system administrators, business data
analysts and development teams.
TECHNICAL SKILLS:
Operating Systems: UNIX (Sun Solaris 7/8/9, HPUX, AIX 5.x), Linux (Red Hat Enterprise Linux 3.0/4.0, SLES/SUSE), Windows 2000/2003/NT Server, Windows 98/XP.
Database tools: RMAN, TOAD, ERWIN, SQL Developer.
High Availability: Oracle 9i/10g RAC, Data Guard/Standby Replication, Oracle Streams, Symmetric Replication, Oracle Golden Gate, VERITAS Cluster.
Utilities: Oracle Import/export utility, SQL * Loader, SVRMGRL and SQL*PLUS, OEM, TKPROF, SQL Trace, EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBCA, SQL Adviser, Oracle Data Pump, SQL diagnostics, AUTOTRACE, Grid Control, Opatch, SVRCTL, CRSCTL, UTLBSTAT/UTLESTAT.
Network: SQL*Net 2.0, Net 8 and Oracle Net.
Virtual Technology: VMware Server, VM Player.
Languages: C, C++, SQL, PL/SQL, UNIX Shell Scripting.
MS components: MS Office 2003/2007, MS FrontPage.
PROFESSIONAL EXPERIENCE:
State of Maine, Department of Health- Augusta, ME Aug ‘10 - Present
Sr. Oracle DB Architect
Department of Health and Human services at 442 civic center drive, Augusta provides technical database support to the state of Maine business users and Eligibility Specialists that determine Medicaid eligibility of prospective applicants. The oit team is responsible for maintenance, administration and enhancement of the prod and dev databases maintaining critical data of applicants including applicant details, application details, budget summaries, health aid records and client personal information.
Responsibilities:
- Worked on
maintenance, monitoring and application level redesigning of production,
test and development databases including performance monitoring, error
troubleshooting, instance analysis and query modifications in an OLTP
environment.
- Identified
critical instances day-to-day basis and interpreted issues using ADDM and
AWR reports and performed hang analysis. Also opened tickets with DHHS
Oracle customer team (CTS) to kill sessions if needed in case of any
low-priority session causing longer than usual hangs.
- Used DDL
and DML for generating PL/SQL codes. Validated PL/SQL codes and used tools
like Oracle SQL developer/loader to generate related PL/SQL queries.
- Configured
Oracle Enterprise Manager and grid control and generated graphical
snapshots and top sessions history in the event of instance trouble
shooting for analytical purposes.
- Performed
SQL tuning by using tools like STATSPACK, EXPLAIN PLAN, AWR, ADDM and SQL
optimizer hints.
- Performed
fine tuning by creating indexes, triggers, foreign key constraints based
on explain plan to improve query efficiency and reduce cost and runtime
with same cardinality.
- Redefined
table structures, rollback segments, undo tablespaces and other parameters
minimising ora errors.
- Redesigned
database objects such as tables, tablespaces, indexes, triggers and
optimizer statistics to improve overall efficiency.
- Extensively
Involved in query optimization and using rule based optimizers and cost
based optimizers to reduce user i/o load and cpu usage.
- Increased
performance by using the hints, Explain Plan utility, SQL Trace and TKPROF
for improving query efficiency in extracting transforming and loading
production data.
- Partitioned
large tables to limit/increase growth of tables and involved in
re-organization of database.
- Extracted
critical data from flat files into prod Database using SQL*Loader. Also
used SQL*loader and data pump import to load data into tables.
- Migrated
database schemas from dev to test to prod databases and related movements
back and forth.
- Worked on
Oracle Data Pump (data export/import) and managing databases across
multiple environments.
- Performed
High priority data fixes, data bug removals that were opened as tickets by
business users and eligibility specialists which they were not able to do
at the db front end. Developed related SQL's validated them on dev and
committed on prod.
- Closed
high priority tickets on daily basis committing data on production after
due validation.
- Performed
expert level SQL tuning and targeted PL/SQL packages that are high on
resources.
- Worked
hands-in-hands with business users that use to run queries on daily basis to
fetch critical data from prod. Identified the report queries and high
impacting queries and tuned them increasing query performance.
- Improved
query performance as high as 32 times its original on a particular query
that ran in prod every two hours to generate notice of decision and
letters to be sent out to the health program applicants that were critical
and had to be performed regularly thus boosting system performance.
- Tuned
PL/SQL packages that ran as batch jobs daily reducing impact time and cpu
loads.
- Performed
capacity planning for DHHS production database.
- Troubleshooted
4-5 application failures including row lock contentions, instance peaking
and data hangs.
- Provided
expert analysis of DB with its total Storage, fault tolerance and memory
parameters.
- Worked on
the latest version of TOAD 10.6 extensively including using toad
functionalities like schema browser, session browser, optimizer, data
migration tools, database partioning, database links, Explain plan utility
and database sga and memory parameters inspection.
- Worked
extensively on Oracle Enterprise manager grid control.
- Worked on
Oracle developer suite 10g including Oracle forms, Oracle reports, Oracle
designer and Oracle jdeveloper suite.
- Worked on
Toad data modeler to generate data models and identify relationships
between various objects and entities.
- Ran SQL
advisors and SQL repair advisors in grid control and implied positive
results.
- Accomplished
quality improvements in overall system efficiency of the database across
the projects by undertaking initiation and coming up with several
proposals and expert analytical skills that lead DB to an enhanced level
of application functionality.
Environment: Sun Solaris, Windows xp, Oracle10gdb, Grid, OEM, AWR, Forms, SQL*Plus, OLTP, OLAP, Grid Control, Oracle TOAD 10.6, Toad data modeler, PL/SQL, Oracle designer and developer suite 10g.
Verizon, Dallas, TX Oct '07 - Sep ‘10
Sr. Oracle DB Architect/Administrator
Verizon Solutions center near Dallas Forth Worth International airport provides Database support to 5 of its data centers including Maryland and New York. Maintenance and critical support is provided to 5 production databases, 11 development databases and 9 test databases that maintain client critical information including data usage details, client contracting details, client personal details and client payment and income details.
Responsibilities:
- Responsible
for 24 X 7 Production database Administration, support and monitoring.
- Performed Performance
tuning for Oracle 11g to provide Real time Query capability of physical
standby database.
- Performed
Performance Tuning in Oracle 11g using database design methodology
consisting of selective Denormalization, Selecting the right data access
path and proper data partitioning.
- Using
Oracle 11g provided fast start failover for maximum performance mode in
data guard configuration.
- Experience
in Development, QA and Production environment and database design,
development and support.
- Used Toad
from for development and administration of various relational databases
using SQL Toad on 32-bit Windows platforms including Windows 95, 98, NT,
2000, XP, and Vista.
- Configured
and installed Oracle 10g with two nodes RAC in ASM storage with normal
redundancy on Linux (RHEL4).
- Experience
on OLTP (On Line Transaction Processing) in an Oracle RAC environment.
- Migrated
Oracle databases from Windows to Linux and vice versa.
- Extensive
experience with PL/SQL programming and scripts development that can be
read into the database using the Oracle SQL*Plus tool.
- Used DDL
(Data definition language) and DML (Data manipulation language) for
generating PL/SQL codes.
- Used Java
and J2EE to develop database web deployed applications in web logic
environments for server as well as end user uses.
- Used
Oracle Enterprise Pack for Eclipse for WebLogic development to support
Java EE and Web Service standards as a preferred Integrated Development
Environment (IDE) within an organization.
- Extensively
involved in data warehousing and managing DW processes including staging,
integration and access.
- Involved
extensively in ETL processes to facilitate raw data processing and loading
in homogeneous and non-homogeneous environments.
- Involved
in data mining procedures and managing data dictionaries.
- Worked on
ETL tools including cognos and business intelligence tool including BI
publisher for data reporting and warehousing purposes.
- Extensive
experience wth ASM for managing storage for Oracle datafiles, control
files and logfiles.
- Managed
and administered SAP applications for increasing overall business
efficiency.
- Worked on
ms SQL 2005, express and 2008 and administered related database design as
well.
- Supported
different OLTP/OLAP Databases like Production, Development, Testing, and
Training.
- Used Oracle
Enterprise Pack for Eclipse with technologies including Database, Java SE,
Java EE, Web Services, XML, and the Spring Framework.
- Experience
with Oracle Data Pump (data export/import) and managing databases across
multiple environments.
- Experience
in Oracle Designer, Oracle Developer and Oracle Enterprise Management
(OEM) including Oracle Enterprise Manager Database Control. Oracle
Enterprise Manager Application Server Control and Oracle Enterprise
Manager Grid Control.
- Experience
with Database performance tuning including application tuning, memory
tuning, I/O tuning and operating system tuning.
- Used
Oracle E-Business suite (EBS) including but not limited to Oracle customer
relationship management (CRM), Oracle financials, Oracle project portfolio
management as well as Oracle mobile supply chain applications.
- Worked on
DB engines including Teradata and Netezza.
- Involved
with installation and upgrades of RDBMS in clustered and non-clustered
environments.
- Involved
in database security management and data security procedures including but
not limited to data masking, data encryption and data integration.
- Worked on
ADDM and AWR (Automatic workload repository).
- Experience
with Sybase and PeopleSoft.
- Performed
Data load on different databases using SQL*Loader.
- Experience
with Data Modeling and worked with DB Artisan, ER Studio, Erwin, TOAD,
Power Designer.
- Involved
in logical and physical databases design.
- Proactive
database monitoring and management using 10g grid control tool.
- Made
performance improvements to the database by building Partitioned tables,
Index Organized Tables, Materialized Views and Bitmap Indexes.
- Used
dataguard for establishing and maintaining secondary physical and logical
standby databases for high availability of the database as well as
disaster-recovery ("failover") purposes.
- Performed
database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN
PLAN, OPTIMIZER, AWR and SQL tuning advisor.
- Performed
database cloning to setup test and development database.
- Conducted
sizing & capacity planning for Oracle databases.
- Upgraded
development and production databases to Oracle 10g.
- Applied
patches to Oracle Databases.
- Provided
support to Application Database Administrators in designing the database.
- Planned,
tested and implemented backup strategies using RMAN, Oracle Utilities
(Export/Import) and OS methods.
- Used RMAN
for backup and restore purposes to facilitate block-level corruption
detection and file multiplexing during backups.
- Implemented
Hot, Cold and Logical backup plans.
- Recovered
critical databases from failures with minimum downtime.
- Responsible
for setting and managing user accounts, Granting required privileges to
users.
- Responsible
for network configuration and involved in a Client Server environment
using TNS, LISTNER, Net Configuration Assistant and other configuration
files.
- Worked on
Automatic Storage Management (ASM) for managing data in SAN.
- Involved
in Design and implementation of Oracle 10g Data Guard both physical/logical
standby databases.
- Performed
other regular DBA activities including space management and performance
monitoring.
- Involved
in process improvement, Oracle Server Installations/Upgrade/Patches, Space
Management, Capacity Planning, Backup & Recovery, Disaster Recovery,
Database Performance Tuning, Memory Tuning, Application Tuning, Security
Administration, Data Warehousing, Data Guard, Oracle Advanced Replication,
Real Application Clusters, Oracle Standby.
- Developed
UNIX shell scripts to perform the above tasks efficiently.
Environment: Red Hat Enterprise Linux 4.0, Windows 2003, Sun Solaris, AIX, Oracle 9i/10g RAC, Grid, OEM, AWR, ASM, Streams, SQL*Plus, OLTP, OLAP, Grid Control, Data Guard, RMAN, Oracle TOAD 9.4, Database Cloning.
Countrywide Financial, Plano, TX Nov '06 - Sep '07
Database Architect/Developer
Responsibilities:
- Responsible
for management and supporting Oracle 10g and 11g databases.
- 24 x 7
production support for several mission critical systems which utilize
multiple Oracle databases.
- Work with
developers and management team to ensure smooth life cycle progress from
development through testing and production implementation.
- Used Java
and J2EE to develop database web deployed applications in web logic
environments for server as well as end user uses.
- Extensive
experience with PL/SQL programming and scripts development that can be
read into the database using the Oracle SQL*Plus tool.
- Used DDL
(Data definition language) and DML (Data manipulation language) for
generating PL/SQL codes.
- Troubleshooting
application failures including performance and database connectivity
problems and job failures.
- Involved
in performing migration from Oracle 9i and10g to Oracle 11gR2 RAC
database.
- Upgrade
databases and apply security patches both server and Client.
- Migrated
database schemas from Development to Integration Test and Production
environments.
- Database
Cloning from Production to test database to identify the problems.
- Set up
backup and recovery procedure using RMAN for both OLTP/OLAP databases.
- Installed
and Implemented Backup & Recovery procedures. Implemented Hot, Cold
and Logical backup plans.
- Created
duplicate databases using RMAN duplicate.
- Worked on
import/export, import/export Data Pump and SQL- loader.
- Configuration
of Oracle OEM (Oracle Enterprise Manager) to monitor database and report
on events as defined by the DBA group.
- Set up,
configured and maintained Oracle Data Guard (primary and standby
databases) to ensure disaster recovery, high availability and data
protection.
- Worked on
Automatic Storage Management (ASM) for managing data in SAN.
- Installation
of Grid Control Server and Management Server.
- Unix Shell
scripting for automating startup/shutdown of databases, getting system
alerts etc.
- Managed
users, privileges, profiles, schemas using Grid Control of Oracle
Enterprise Manager (OEM).
- Performed
Database and SQL tuning by using various Tools like STATSPACK, TKPROF, and
EXPLAIN PLAN, AWR, and optimizer hints.
- Created
custom Stats pack scripts and implementation documentation for
corporate-wide roll-out to all databases for automatic periodic statistics
gathering and reporting.
- Performed
production system problem analysis and recommend corrective measures in a
timely manner.
- Worked
with other vendors to support their applications.
Environment: Windows NT / 2000, HP-UX, AIX and Linux, Oracle 9i and 10g, TOAD 9.0.1, Erwin, Oracle Enterprise Manager, RMAN, RAC, ASM, Data Guard, SQL*Plus, PL/SQL, SQL*Loader, OLTP, OLAP.
Teacher Retirement System of Texas, Austin, TX Sep '05 - Oct '06
Oracle DBA/Developer
Responsibilities:
- Provided
24 x 7 support to maintain all Databases up and running in Production
environment.
- Regular
Instance Level Performance Tuning for the critical Production database
servers.
- Worked
with the SQL Developers, to create logical and physical database design.
- Analysis
and Design of Oracle DB with its total Storage and fault tolerance.
- Creation
and migration of Database and other related Objects.
- Implementing
Database Security, Management of role-based security and database
auditing.
- Managed
Data Guard Database and Staging Database.
- Participated
in disaster recovery testing.
- Data
Migration as part of enterprise data warehouse project.
- Database
Restore using RMAN, Cold Backup and Export.
- Applied
Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
- Extensive
Performance Tuning, Memory (SGA) Tuning, RAC tuning, NetBackup, EMC (Time
finder and SRDF), RAID, RAW Devices.
- Cloned
databases using scripts as well as RMAN. Installation, setup and
configuration of Data Guard.
- Managing
and configuring database user accounts and permissions.
- Identifying
and implementing standard operating procedures for large size db files.
- Performed
fine tuning by creating indexes, TKPROF, EXPLAIN PLAN and TRACE events.
- Setting
and troubleshooting of Oracle listener, network connection, user security
and administration. Tuning for optimum performance.
- Analyzing,
designing and implementing fault tolerance system and automated error
tracking system, which sends any error, occurred to concerned personnel by
email. Actions to Critical Alerts.
- Defining
the strategies for Backup and Recovery at physical level using RMAN and
Export/ Import utilities.
- Used
PL/SQL, SQL Loader as part of ETL process to populate the operational data
store.
Environment: RHEL 3.0, Windows XP/NT/2000/2003, Sun Solaris 8.0/9.0/10.0, Oracle 8i/9i/10gR1, OEM, Data Guard, RMAN, SQL* Plus, SQL*Loader, Oracle Toad, Oracle Replication, MS Office.
General Motors Corporation Oct '04 - Aug '05
Oracle Developer/ DBA
Responsibilities:
- Responsible
for installing, maintaining, performance tuning and monitoring of Oracle
databases version 8i/9i in different Environments like development and
production.
- Responsible
for testing and debugging the applications.
- Logical
and Physical Modeling using ERWIN Data Modeler.
- Management
of tablespaces for different users by granting quota on Default &
Temporary tablespaces.
- Analyze
tables to detect those affected by row migration or chained rows. Checks
storage for objects growth to detect those close to their max extent limit
and reorganize them as necessary.
- Estimated
Storage capacity for database objects.
- Monitored
the growth of the database objects UNIX Shell scripting. Implemented
capacity planning.
- Created
UNIX shell scripts to automate batch jobs through Cron.
- Extraction
of data from different flat files into Oracle Database using SQL*Loader.
Utilized SQL*loader and data pump import to load data into tables.
- Utilized
Oracle Enterprise Manager (OEM) to manage users, privileges, profiles,
schemas.
- Database
Administration and Planning including logical design, physical design,
backup & recovery.
- Oracle MTS
Configuration, Password management, Disaster recovery using Data Guard.
- Ensuring
security of the data in the database by monitoring environment to identify
improper access.
- Accomplished
quality, stability and efficiency of the database across the projects by
undertaking initiation and coming up with several proposals.
- Design and
implement backup and recovery system. Responsible for backups and recovery
of the database using RMAN.
- Implementing
security of the database by creating profiles for each user.
- Extensively
involved with the Export and Import utilities to backup and recover the
database.
- Constantly
checking the availability of the database 24x7.
- Supported
in migration of Oracle applications by applying security patches.
- Developed
UNIX Shell Scripts for monitoring Oracle database and to gather
performance statistics.
Environment: UNIX, Windows NT/2000, Sun Solaris 8, Oracle 8i/9i, utlbstat/utlestat, OEM, RMAN, OLAP, OLTP, Shell Scripts, Erwin and Designer 2000, Export & Import, SQL*LOADER.
Directorate of Standardization, India Apr '03 - July '04
System/Database Administrator
The Directorate of Standardization is responsible for the Standardization of all products related to the supply of the Defense Services. It includes all equipment related to clothing, food, electronics equipment, hardware related to vehicles, ships, aircraft based on the NATO guidelines.
Responsibilities:
- Involved
in production support activities 24/7 during on call and resolved database
issues.
- Installation,
Implementation and maintenance the Oracle database.
- Created
and managing the database objects such as tables, indexes and views.
- Involved
in user creation, user access control, Schema creation and management.
- Created
and managing the database storage structures which include data table
spaces, index table spaces, rollback table spaces and rollback segments.
- Implemented
Oracle security features and audit mechanisms for Fine grained access
control.
- Maintained
the RMAN repository and customized recovery catalog.
- Customized
Data Guard as a tool for Disaster Planning and implementation.
- Created
Logical and Physical standby Databases to ascertain high availability of
database during system crashes using Data Guard.
- Involved
in session management and monitored the critical wait events in the
database.
- Loading
the data into database with SQL*Loader.
- Wrote the
control files for SQL*Loader to load the files in database tables.
- Improved
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.
- Involved
in query optimization and using rule based optimizers and cost based
optimizers.
- Performed
the logical and physical structures for tables, indexes, modeling,
normalization and foreign key constraints.
- Database
maintaining including backups, recovery, imports/exports.
- Monitored
the database daily activities.
- Used
Triggers for database activities, like delete and update.
Environment: UNIX AIX 5.1, Windows NT, ORACLE 8i/9i, Import/Export, SQL, PL/SQL, Toad, SQL*Loader, SQL*Net, UTLBSTAT/UTLESTAT, Cronjob, Erwin.
HSBC, Noida, India May '02 - Apr '03
Oracle Developer/ DBA
HSBC Bank provides a full range of commercial banking products and services to individuals, corporations, institutions and governments, through its personal financial services, private banking, commercial banking and corporate investment banking and markets segments. This project is developed as a process of automation for insurance policy management by using centralized data warehouse and Data Mart.
Responsibilities:
- Installed
and configured Oracle RDBMS on UNIX and Windows environments.
- Responsible
for administering and supporting production and development Oracle 7.1/8i
Databases.
- Responsible
for installing, upgrade and configuring the Oracle Server, Creating
Databases, Storage Structures and Objects, Database Backup and Recovery.
- Involvement
in all phases of the project life cycle.
- Responsible
for troubleshooting hardware and software issues.
- Responsible
for Operating System Installation and updates.
- Responsible
for updating the database with the information received from various
vendors.
- Analyzed
the structures using Analyze command.
- Created
primary database storage structures (tablespaces, rollback segments, etc).
- Monitoring
Growth of tables and undertaking necessary re-organization of database as
and when required.
- Developed
hot, cold and logical backup scripts to automate the backup procedures.
- Took
Backups on scheduled time and Monitoring Scheduled Backups.
- Ensured
proper online and offline backup. Periodical reading and checking of
backups taken.
- Planned
for storage spaces requirements and placing them for optimum I/O
performance.
- Cloned
Environments to create Patch Test, Development and QA Environments.
- Partitioned
large tables to increase the performance.
- Participated
in Disaster Recovery Drills, documented database and application
validation steps.
- Performed
all daily Maintenance tasks. Interacted with Oracle Customer service as
and when required.
- Creating
and dropping of users, granting and revoking rights as and when required.
- Used
TKPROF, EXPLAIN PLAN for the Better performance.
- Monitored
Growth of tables and undertaking necessary re-organization of database as
and when required.
- Resolved
technical issues and Troubleshooting.
Environment: Windows 98/XP/NT, UNIX, Oracle 7.1/8i, SQL*Net, RMAN, Data Guard, CRONJOB, UTLBSTAT/UTLESTAT, TKPROF, EXPLAIN PLAN, MS Access, MS Office.
EDUCATION:
BS in Engineering.
Additional Info
Career Information
Most recent
employer
State of Maine,
Department of Health
Relevant work
experience
7+ to 10 Years
Highest
Education
Bachelor's
Degree
Career Level
Experienced
(Non-Manager)
Availability
Immediately
Location
US-NY-Garden
City
Relocate
Will Relocate
Travel
Up to 25%
travel
Willing to work
weekends
-
Active security
clearance
No
Willing to work
shifts
-
Target Job
Company size
-
Desired status
Full Time
Job type
Employee
Salary
60.00 - 60.00 USD/Per
Hour
Locations
US NY Long
Island
Work
authorization
US - I am
authorized to work in this country for any employer.
Job titles
Oracle
DBA/Architect
Industry
-
Occupation
-
Download Resume Format
0 comments:
Post a Comment