SUMMARY:

• Over 10 years of IT experience with Database Administration in Oracle in a 24x7 environment
• Database administration experience in Oracle 8i, 9i,10G, 11G and 12c
• Experience with Golden Gate replication
• Expertise in administration, backup and recovery using RMAN, ETL, database loading for Sybase and Oracle using Unix, Perl, SQL, BCP and SQL Loader
• Experience in performance tuning of Oracle databases using OEM, AWR reports and ADDM
• Has finished projects from specification to finished stage including relational schema design, creating - databases, tables, indexes, triggers, procedures, coding of programs for processing/cleansing of data, data loading, extracting, testing and automation
• Extensive working experience in Unix environment
• Technical expertise in Perl, Unix shell scripting, TSQL, SQL Plus, PL/SQL, HTML
• Initiated and finished number of automation projects for database maintenance, database applications and custom applications
• Expertise in migration of Oracle database and shell scripting
• Experience working in Pharmaceutical industry with FDA regulated environment and with GLP and ITIL methodologies
• Extensive experience working in a team environment

TECHNICAL SKILLS SUMMARY:

DATABASES: Oracle, Sybase, PostgreSQL, mySQL, SQL Server

LANGUAGES: Perl, SybPerl, Unix shell scripts, C, SQL, TSQL, PL/SQL, CGI and HTML

OPERATING SYSTEMS: Sun Solaris, AIX, Unix, Irix, Linux, Windows

OTHERS: Data modeling, Systems analysis and project management, Unix tools, OEM Grid Control, IntermediaTEXT, SQL Loader, Toad/SQL developer, Apache web server, Golden Gate and documentation

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responsibilities:

• Working in a team of dbas for managing Oracle databases
• Responsible for installing, upgrading, patching, configuring and maintaining Oracle databases ranging from Gigs to 4T sizes
• Installed Oracle 10, 11g and 12c software - created templates and documentation for other team members for their installs
• Created production databases with corresponding dev/test environments while confirming to Oracle licensing requirements
• Followed up with Oracle patches, coordinated with vendors, evaluated, tested, patched the databases, created documentation and checklists for the team
• Setup alerts, monitoring, backups, restores and documentation
• Responsible for backups and restores of databases for development, test and production environments using RMAN, NetBackup and shell scirpts
• Installed and configured rman, rman catalog database for backups
• Created rman configuration, scripts, backup schedule to make use of optimum scheduling window with optimum archivelog backups
• Configured restore parameters, tested, scripted for team members
• Tested various restore channels, methods and documented for future use
• Created report using OEM to access database schedule, status of backup and completion times
• Created monitoring, alerts and solution for excessive backup times going beyond SLAs
• With development team coordinated security between production and development teams - created auditing and security for off-shore development teams
• Experience in restores, duplication and recovery of Oracle databases using RMAN
• Evaluated methods for restores with backup and without backups
• Automated some of the restores for application team reporting and testing
• Responsible for database upgrades
• Upgraded databases from 10 to, Windows to Unix, between various versions of AIX and created templates, documentation, checklist for team members to follow
• Worked with development teams in evaluating upgrades for moving onto the next version of Oracle/patch sets
• Identified issues/work arounds for any patches/bugs
• Configured/setup backups and restores after the upgrades
• Responsible for installing and maintaining replication (Golden Gate) for BI reporting
• Installed, configured, created parameter files for 11G Golden Gate replication for one way replication for BI reporting needs
• Setup monitoring for lag time, rejected records and running of Golden Gate environment
• Setup automated replication for development/test needs
• Researched, configured and tested various customized replication for DWH and BI reporting needs
• Streamlined and automated replication re-instantiations
• Created scripts, reports, web access to replication needs like access to reject records, syncing of data, real time lag time
• Experience working performance tuning, trouble shooting in 10g and 11g and 12c environments
• Supported development in creating profiles, outlines for performance needs
• Worked with development teams to identify required indexes and their storage needs
• Helped dev team to backup/restore their schemas during refreshes
• Helped dev teams in optimizing the queries including tuning, tracing, suggesting hints, partitions, statistics
• Responsible for OEM environment
• Installed OEM 11g grid control for monitoring and control of the environment
• Upgrade 11g to 12c cloud control
• Setup databases for monitoring, alerting, set up rules and schedules
• Trained the team members in using OEM including tuning, AWR reports and routine monitoring, use OEM for dba activities and creating reports
• Created management reports for database health, uptimes, backup schedules, actual backup times and replication real time lag
• Created many OS jobs through OEM in dealing with archivelog backups and replication tools
• Evaluated OEM upgrade to 13c
• Experience working with Oracle support and other external vendors
• Experience in 24x7 support during on call period
• Participated in Disaster Recovery process
• Responsible for automation
• Automated alerting, backups, restores, replication, refreshes

Confidential, Mattawan, MI

Oracle DBA

Responsibilities:

• Manage/administer 8i,9i and 10G databases in Unix and Windows environments
• Responsible for installing, configuring 9i,10G databases on Sun Solaris using ASM and RAC
• Administering OS resources for number of development and production databases
• Worked in a dba team to manage the databases on 24x7 basis
• Setup GRID control to manage databases including customized maintenance jobs
• Created customized reports in GRID control for management reports and requirements
• Configured GRID control to monitor and alert for all critical and non-critical issues
• Set up auditing and application and data security
• Set up number of development databases for development, and testing including capacity planning, resource planning, creating databases, configuration, backups, restores and checkin/checkout procedures
• Carried out upgrades and patch maintenance
• Carried out Service Request (SR) activities with Oracle Support
• Provide backup dba support for SQL Server databases
• Worked in conformance with FDA regulation including GLP and ITIL standards and maintaining documentation conforming to 21 CFR part 11 standards for installation, configuration and change management
• Migration activities
• Carried out Windows to UNIX migration of Oracle databases
• Carried out migration from 9i to 10G and application migrations
• Migration to ASM disks
• Formulated steps/plans to refresh/reloading various development databases for development,, testing and validation activities including imp/exp, datapump and flashback utility
• Evaluate and document migration to 11G
• Backup and recovery
• Configured databases for regular backups using Galaxy CommVault system
• Created reports for daily backups
• Responsible for documenting restore procedures
• Expertise using RMAN for backup/recovery
• Automated logical backups of production databases using export and datapump
• Disaster recovery and high availability
• Member of a team to implement RAC and Data Guard to ensure high availability
• Member of a team to provide 24x7 support for database issues and availability
• Tested and documented cloning steps for easy duplicating activities
• Participated in quarterly DR test activities of production databases including DR, functional testing and documentation
• Automation
• Automated database activities including alerts, backups, migration, reporting and maintenance
• Authored shell scripts, PL/SQL scripts for various activities and setup cron jobs
• Setup Oracle jobs in GRID control and in databases for maintenance and performance

Confidential, Dearborn, MI

Oracle DBA

Responsibilities:

• Performed Oracle upgrade from 8i to 9i
• Participated in discussions with client for upgrade options, project planning, problem resolutions and capacity planning
• Performance tuning after migration including statspack and init parameters
• Created a repository for all the statspack reports from various databases around the globe for reporting and corrective actions
• Participated in trouble shooting and other database activities including cloning
• Provided on-call support with application tuning issues for the upgraded database

Confidential

DBA/Database developer

Responsibilities:

• Performed administration of Oracle and Sybase databases in 24x7 setup
• Installation and configuration of Sybase on Sun Solaris, AIX, Linux and Windows
• Administering physical resources including new devices, segments and log disks
• Assisted in user administration for database access
• Administration of resource allocation
• Loading database with dumps and with BCP
• Installed and configured a test server for testing and automated dbcc checks
• Participated in database upgrade and patch administration
• Regular DBCC check of the database
• Maintained secondary Oracle databases
• Participated in schema design and normalization
• Created databases and database objects including procedures and triggers
• Database loading with SQL loader and shell scripts
• Setup automatic updating of Oracle Databases
• Administered and maintained Sybase Replication
• Administered replication of Sybase data to nodes world wide
• Responsible for daily replication of data
• Responsible for providing extracted datasets for nodes for loading
• Administered and maintained 24x7 website for the database
• Installed and configured Apache web server
• Maintain user stats and usage
• Monitor middle layer performance
• Performed ETL developer work for Sybase and Oracle databases
• Completed data modeling, normalization/de-normalization, sub-project planning, scripting for the project
• Extracting data from Sybase and Oracle databases using bcp, sql queries, sybPerl and shell scripts
• Processing/cleansing extracted data using perl, shell scripts, unix tools into flat files
• Transfer flat files through tar, zip, ftp, scp and rcp to different nodes
• Loaded flat files into Oracle databases using shell scripts, SQL and SQL loader
• Web presentation of the loaded data through Oracle’s WebDB, Apache, PL/SQL and intermediaText