| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
M. PHONE NUMBER AVAILABLE
Email: EMAIL AVAILABLE;
EMAIL AVAILABLE
SUMMARY OF QUALIFICATIONS
1. More than twenty years of professional IT experience out of which more
than THREE years as Sr LEAD DBA, THIRTEEN years as a Sr. Oracle Database
Administrator (DBA), FIVE years as Data Architect / Data Modeller and ONE
year as ORACLE GOLDENGATE ADMINISTRATOR on Multi-OS such as LINUX, Sun
Solaris, HP-UX, IBM AIX, COMPAQ UNIX and Windows Server on a 24x7 basis
for Production, Development and Test Environments on RAID level and
involved in different roles viz. Production/Development/Application DBA.
2. Involved in SDLC process, going thru Waterfall model using Agile
software development. Promoting database application environments going
thru a Change Management process.
3. Installation and Configuration of Oracle Server 11gR2/R1, 10gR2/R1, 9iR2
in different operating systems for VLDB in OLTP & Data Warehouse
environments. Implementation of Oracle 11gR1/10gR2 New Features such as
Segment Advisor, SQL Tuning Advisor, SQL Access Advisor, MTTR Advisor,
Flash Recovery Area, Automatic Database Diagnostic Monitor (ADDM) and
export/import Data Pump utilities of various type of Data Loads and
enhanced securities for HA database. Data loading using SQL*Loader direct
and parallel options.
4. Configuration and Administration of GOLDENGATE v10.4 and GG Director for
UNI/BI-DIRECTIONAL replication. Configuration of GG Veridata v3.x for
comparison between Source and Target after replicating the processes for
online Transaction Logs form Source DB to Target DB.. Configuration of
Oracle Replication Server for Advanced Multi-Master & Basic replication
type in Oracle 9i/8i.
5. Experience working on Oracle 11gR1 OEM Grid Control and OEM Console for
the effective DB administration. Administration of Oracle files using
Automatic Storage Management (ASM) in a Storage Area Network (SAN).
6. RMAN configuration using Recovery Catalog/no-catalog running on
ARCHIVE/NOARCHIVE and managing more than 100 plus instances. Restore and
DB Cloning from RMAN new features.
7. Monitoring and optimising the Database Performances through Database
Tuning such as AWR and ADDM, Tuning of SGA and Memory, System Tuning,
Application Tuning and SQL query plan using Explain Plan, Tkprof and
prefstat.
8. Configuration and Administration of Oracle 11gR2 and 10gR2 Real
Application Cluster (RAC) environments for multi-nodes based database by
configuring Oracle registry, Oracle Clusterware and RAC. Working on
Cluster Verification Utility (CVU). Administering Oracle listener and
server to & from cluster monitoring. Starting and stopping cluster
monitoring of the instance and listener thereby checking the status of
Oracle cluster resources.
9. Implemented hot standby database (Data Guard) for production database.
Setup and successfully performed active fail over in the event of
production failure. Creating, Maintaining and Supporting Physical and
logical standby databases. Monitoring Redo Transport services, Log apply
services and Role transitions. Handing issues with Network tuning for
Redo Data Transmission.
10. Configured Oracle Transparent Gateway between SQL Server and Oracle.
Experience with Oracle Apps Server DBA responsibilities such as
supporting on 24X7, applying patches and troubleshooting etc.
11. Effective ways of writing stored procedures, functions, triggers and
packages using PL/SQL. Writing UNIX Ksh shell scripts for scheduling of
jobs in Crontab for Database monitoring and PERL Scripting. Worked on
Autosys for scheduling and monitoring jobs. Used packages such as
DBMS_JOB, UTL_FILE, DBMS_STATS, DBMS_SQL, DBMS_REORG and DBMS_SCHEDULER.
12. Performed DB patching, cloning, troubleshooting issues/errors;
collaborate with Oracle support for bugs and creating TAR in METALINK.
Designed SOPs, responsible for 21 CFR Part 11, SOX regulatory compliance
audits.
13. Experience on Logical & Physical Designing of Databases using tools
such as ErWin for effective Data Modelling for DWH and OLAP systems
satisfying Database Normalization. Experience in building Data warehouse
environments with Star Schema and SnowFlake Architecture.
14. Installations and Configurations of SQL Server v2K/2K5. Installations
and Configurations of Sybase Adaptive Server Enterprise (ASE) v12.5/11.x
on UNIX and Windows. Performance tuning, client/server connectivity,
query optimization, back-up/recovery, running Database Consistency Checks
and troubleshooting.
15. Worked on EMC Symetrix DMX, EMC CLARiON NAS devices, Hitachi, IBM, DMX
SAN storage devices.
16. Maximum Database Sizes handle up to 50 TB. Mentoring Mid and Sr Level
DBAs including Off-shore.
TRAINING & CERTIFICATION:
. Certificate of completed Training in TERADATA v14 Database Design and
Architecture.
. Certificate of Completed training in Project Management Professional
(PMP).
. Certificate of Completed training in Oracle GOLDENGATE Training from
Oracle University. Supporting Oracle Corp customers for effective
implementation of GOLDENGATE replication.
. Certificate of Completed training in Oracle 11gR2 Real Application
Cluster installation, configuration and new features.
. Trained on 21 CFR Part 11, HIPPA regulation regulatory compliance audits
to support Pharmaceutical and Insurance companies. SOX standards for
security purposes.
EDUCATION
. Bachelors of Engineering (B.E.) in Computer Science and Engineering.
. Management in Business Administration (MBA).
PROFESSIONAL EXPERIENCES
Oct '11 - Current Geisinger Healthcare, PA
LEAD DBA/Data Architect
. Lead a team of DBA's on a large complex database design and delivery
projects. Managed database administrators and operations teams on
different database environments across multiple sites and offshore team.
. Participated in quarterly meetings with Senior Management to discuss
technical infrastructure. Managed change control meetings ensuring that
changes to production environments are validated and thoroughly tested.
. Lead database compliance effort in accordance with 21 CFR 11, SOX, HIPAA
regulations and participate with internal and external audits resulting
in fulfilment of FDA regulations and requirements.
. Oracle 11gR2 Real Application Cluster (RAC) installation for Multi-node,
configuration and support on Oracle/Red Hat Linux and Solaris OS for
Production, Development and QA environment. Implemented Oracle 11gR2 new
features for advanced compression and column level expression, Concurrent
statistics gathering, parallel query management, Oracle Flash Cache,
Automated SQL Tuning, Automatic Memory Management, and Adaptive Cursor
Sharing etc. Patching of Oracle RAC Databases, Oracle datapump and RMAN
advanced ZLIB algorithm various environment including Mainframe.
. Installation and configuration of Oracle 11gR1 Oracle Enterprise Manager
Grid Control to administer RAC and non-RAC databases, Data Guard High
Availability Databases. Administration and support of EPIC Systems,
AMISYS database environments in 24X7. Upgraded to 12cR2 OEM for Prod
Servers.
. Implemented a strong DR policy for all the critical applications servers
which have been appreciated by the management. Implemented RMAN new
features including compression algorithm minimize database backup and
restore size and time effectively. New procedure for faster database
duplicate/cloning process by implementing Oracle 11gR2 new feature.
Implemented RMAN hot backup using 11gR2 new features for several database
instances to minimize restore database time.
. Tutoring and mentoring DBAs and developers. Effective SQL and PL/SQL
coding and scripting including ksh, csh for effective DBA management
scripts, Implemented SOP, DBA best practices, Industry best practices for
effective database management in a global environment.. Recommending
server configurations, disk capacity, RAID groups and LUNs setup. Duties
included a combination of infrastructure and technical support, build
implementation, capacity and monitoring planning and setup from database
admin capacity. Present status in EDW meetings.
. Data Architect responsibilities includes logical and physical data
modelling, data analysis and definitions, database design and
engineering, database architecture/set-up, security, standards
development and implementation, data modelling tools evaluation, logical
modelling consultation and advanced SQL and SQL constructs consultation
and use,. Designing and implementing DW logical data model.
. Supported overall IT control practices, remediation, action plan
execution, QA, Production and systems certification as part of SDLC
process. Directed and provided guidance in solutions for deployments,
integration, testing, remediation and re-engineering efforts in
Production.
. Teradata Database v14/13.10 Design training from Teradata University.
Database creation, table/views creation, effective way in choosing
indexes for efficient database administration
. Tutoring and mentoring DBAs and developers. Conducted performance
reviews, goal settings, attracting and retaining the best talent.
Environment: Epic Systems, Oracle 11gR2/10gR2 Server on Oracle/Red Hat
Linux, IBM AIX, TOAD v10/9 & ErWin for data model design, MS Visio, SQL
Developer, JAVA, OEM Grid Control, Tivoli etc.
Oct '10 - Oct '11 IDEXX Lab, ME
LEAD DBA/Data Architect
. Implemented Oracle 11gR2 New Features in Automatic Storage Management
(ASM) for storage and administration of Oracle files under SAN.
Administered ASM Disk Groups and backed up ASM managed files. Other
features such as Case Sensitive Passwords, Data Recovery Advisor,
Database Replay, Query Result Cache, Secure Files, SQL Access Advisor,
SQL Performance Analyzer, SQL Plan Management, Statistics Collection
Enhancements, Table Compression Enhancements, Tablespace Encryption and
Temporary Tablespace Enhancements etc.
. Configuration of Oracle Advanced Queues for effective security measures
to ensure Customer data protection. Implemented Secure Shell (SSH)
tunnelling as a way of Oracle Network traffic. Implementation of Fine
Grain Access Control (FGAC) for Oracle Data Encryption and Oracle Data
Masking.
. Configured and Administered multi-nodes Oracle RAC databases for
different environments. Implementing SOX standards to meet the customer
requirements. Using cloning and replication procedures, backup and
recovery procedures, export/import scripts, datapump scripts, and RMAN
scripts. Setup RMAN scripts for backup/recovery for all environments.
Maintained and support DataGuard for production instances. Configured
Oracle Enterprise Grid Control for centralized monitoring, executing
scripts, patches, status reports, backup reports, log reports, statistics
reports. Planning and installing Oracle patches (quarterly) across the
Business.
. Meeting project managers to discuss projects, implementations, impacts on
the Business systems, updates, plan maintenance windows, plan
installations. Understanding Business Needs, implementing new products
that will help save money and improving on time and effort throughout the
Business.
|
