Skills

Please use this table to list the skills noted in the Required/Desired section of the requirement. In addition, please respond with the years of experience for each skill and the last time each skill was used. Add or delete rows as necessary.

Employment History

Confidential

Senior Database Administrator

Confidential Department of Social Services is implementing the Confidential Case Management System/Common Help

VACMS/CH to modernize the business operations of its Child Care and common Help Unit. VACMS/CH is a transfer solution that is based on Child Care and Common Help systems implemented by Deloitte in Pennsylvania and Michigan. The Confidential Case Management System and Common Help VACMS/CH is being developed to provide the Virginia Department of Social Services an integrated system for the delivery and management of child care and Common Help services. VACMS/CH allows localities to share common information and significantly reduce duplication and inefficiencies. The implementation of VACMS/CH presents a great opportunity for localities across the commonwealth to streamline operations. Specifically, some of the VACMS/CH benefits include: enhanced case management capabilities, automated eligibility determination, integration with Electronic Child Care Point of Sale ECC POS swipe card devices, and automated encumbrance calculations.

Responsibilities

• Performed switch over and fail over on Standby database.
• Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Maintained the RAC set up, Performance Tuning, coding and Monitoring for Oracle Application Clusters Administrated of oracle 11gR1 RAC database on Linux and ASM on EMC Storage Installed and configured Oracle Enterprise Manager to monitor the Databases. Monitoring the ASM disk groups, add and resize the disk groups. Resolving the tickets by meeting the SLA. Refresh the Database using RMAN and exports/imports Performed and designed backup/recovery strategy, Incremental backup, Hot backup, full back up exp, data-pump , RMAN in disk and TAP ,EMC Avamar
• Creating new environments by Expdp/Impdp utility. Upgrade database from 10G to 11G.
• Involved in regular day to day activities for production databases running on RAC and Non RAC. Installation of Oracle 11G, 10.2.0.1 and upgrading them to 10.2.0.3 and 10.2.0.4 by applying oracle patch sets. Created Quarterly Performance reports for production Databases to find out the bottle necks of performance. Working closely with the developers for resolving locks. Involved in database design. Created Tables/Constraints in the absence of the developer. Creating physical and Logical database structures using Erwin tool.
• Tune the Databases for optimization using Statspack and Explain Plan, Estimating Table Index Size.
• Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Applying PUS patches for both RAC and Non RAC databases.
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
• Applied BUG patches which are caused by Ora 600 and Ora 7445.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
• Resolving the locks on the database.
• Monitoring performance using AWR reports and ADDM Reports.

Confidential

Senior Database Administrator

Confidential accreditation and is one of the country's leading health plans for customer service and satisfaction. Independent Health has become one of the major forces in the provision of employee health care benefits in the northeast, operating health plans in the eight counties.

Responsibilities

• Provide technical support and assistance to all database end-users and Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases
• Performed switch over and fail over on Standby database.
• Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Maintained the RAC set up, Performance Tuning, coding and Monitoring for Oracle Application Clusters Installed and configured Oracle Enterprise Manager to monitor the Databases. Monitoring the ASM disk groups, add and resize the disk groups. Resolving the tickets by meeting the SLA. Refresh the Database using RMAN and exports/imports
• Working as oracle database management professional and support over 400 Oracle database clients running on 9i, 10g, 11g, RAC and ASM Involved in regular day to day activities for production databases running on RAC and Non RAC. Installation of Oracle 11G, 10.2.0.1 and upgrading them to 10.2.0.3 and 10.2.0.4 by applying oracle patch sets. Installed, configured and administration of oracle 11g RAC on ASM and EMC storage Created Quarterly Performance reports for production Databases to find out the bottle necks of performance. Created Quarterly Health check reports for production database. Upgrade database from 10G to 11G.
• Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Applying PUS patches for both RAC and Non RAC databases.
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
• Applied BUG patches which are caused by Ora 600 and Ora 7445.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Monitoring the CPU utilization and troubleshooting if it crosses the threshold value.
• Resolving the locks on the database.
• Monitoring performance using AWR reports and ADDM Reports.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.

Environment

HP UX, Solaris, Linux Oracle 9i, 10g, 11g, RAC, ASM, OCFS2

Confidential

Senior Database Administrator

Confidential is a technology company that operates in more than 170 countries around the world. HP leverages best practices in Leading hardware, software, services, HP's solutions are designed help and manage the control information from Big Data, Social Media, Risk Management, Cloud, and Mobility applications.

Responsibilities

• Audit of the Data/Database objects for auditors.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Involved in taking logical backups using EXPORT, IMPORT and DATA PUMPS.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Monitoring performance using AWR reports and ADDM Reports.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR, OEM.
• Applied BUG patches which are caused by Ora 600 and Ora 7445.
• Designed logical and physical Data Models of database at schema levels using ERWIN.
• Monitoring and maintain the database using Oracle Schedulers, Maestro scheduler and Unix Cron job scripts for package startup/shutdown and backups
• Responsible for RAC Systems Support and maintenance of database sizes of more than 20TB
• Applying patches on 3 nodes and 2 nodes RAC databases.
• Involved in Migration of databases from Windows 2003 to UNIX and UNIX to Windows 2003.
• Upgraded multiple production RAC environments from 10gR1 to 10gR2.
• Installation of RAC with ASM on HP UNIX. Monitoring and Maintenance of database running on RAC and Non RAC. Installation of Oracle 11G, 10.2.0.1 and upgrading them to 10.2.0.3 and 10.2.0.4 by applying oracle patch sets. Created Performance Metrics for production Databases to find out the bottle necks of performance.
• Maintained the RAC set up, Performance Tuning, coding and Monitoring for Oracle Application Clusters Installed and configured Oracle Enterprise Manager to monitor the Databases. Monitoring the ASM disk groups, add and resize the disk groups. Used RAM scripts to take backup of the ASM files and delete the archive logs based on the sysdate.
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Maintain and Monitoring of Oracle 10G DG physical standby databases, manually apply the missing logs to standby from primary.
• Performed switch over and fail over on Standby database.
• Provide technical support and assistance to all database end-users and Creating users, allocation to appropriate tablespace quotas with necessary privileges and roles for all databases
• Extensively used SQL Loader to migrate the legacy data to the new instance
• Created Oracle best practices document, Oracle RUN Book, Database monitoring scripts used for day to day Monitoring

Environment

Oracle 11g, 10g, 9i, Linux, HP Unix, RAC, ASM

Confidential

Senior Database Administrator

• Installed and configured Oracle 10gRAC maintained the RAC set up, Performance Tuning, coding and Monitoring for Oracle Application Clusters, Oracle Management Server, and OEM on Red Hat Linux 4 Advanced Server with 2 nodes server side load balancing using ASM.
• Monitoring and maintain the database using Oracle Schedulers and Unix Cron job scripts for package startup/shutdown and backups
• Confidential Medicaid Management Information System which is being done at CNSI for which the Confidential is the client, It is a web based Medicaid system for the Department of Social and Health Services DSHS of the State of Washington. It is a claims processing web application that has complex numerous subsystems that are interfaced together to work coherently. For example the WA MMIS system has a whole has Provider, Claims, Financials, Payroll, Drug Rebate, Reference, Prior Authorization, etc subsystems. Responsibilities RAC Installations with ASM and Storage Allocations on EMC cx3-80 storage RAC Systems Support and Maintenance Upgraded multiple production RAC environments from 10gR1 to 10gR2 Responsible for maintenance of RAC environments with database sizes of more than 1TB
• Installed and configured Oracle Enterprise Manager to monitor the Databases.
• Maintenance of Oracle 10G DG physical standby databases. Configuring Data Protector using RMAN to take DB backups.
• Experience in High availability design with VERITAS Cluster and Volume Management.
• Experience in monitoring the VERITAS Net Backups.
• Performance, Monitoring, determines the size SGA/PGA, Hit Ration, estimate the number of users, CPU, and Disk space management, ADDM, AWR and OEM.
• Involved in Physical and Logical design of Data MODEL using ERWIN.
• Designed, Implemented and Tested Backup Recovery strategies for database using Data Pump and RMAN Utilities.
• Used Recovery Manager RMAN and Enterprise Manager for various maintenance tasks like backing up of database, restoration and recovery of database.
• Experience in maintaining Oracle Data Guard Standby Database and providing critical solution with strategic disaster recovery plans with different recovery
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Experience with ecommerce applications in Java/tomcat.
• Communicated with Oracle to get the necessary patches required to fix up the database changes needed using TAR Support and coordinating the patches and implementing the necessary changes.
• Documentation of Data Base Setup and administration of Server Environment.
• Provided 24x7 on-call supports. Worked beyond regular hours based on business demands.
• Created and Maintained Users and Roles with Appropriate Privileges and Profiles
• Audit of the Data/Database objects for auditors
• Involved in evaluation and capacity planning process of deciding the central storage hardware for the new RAC environment.
• Attending meetings with developers, managers and the users to discuss the change or enhancements to the legacy system
• Implemented database refreshes using RMAN scripts for QA and Staging environments Worked closely with Teradata DBA's.
• Involved in DB Upgrade from 8i to 9i for Oracle Applications
• Extensively used SQL Loader to migrate the legacy data to the new instance
• Created Oracle best practices document. Identify, recommend, and implement all new database technologies

Environment

Oracle 10gR1/2, 9i, 8i, Linux, AIX, Sun OS, Egenera Blade Frame, Java, DMS, PL/SQL, BEA Weblogic Platform

Confidential

Sr. Database Administrator

Delphi is a leading global supplier of transportation systems including power train, steering, thermal, controls and security systems, electrical/electronic architecture, and in-car entertainment technologies. Engineered to meet and exceed the rigorous standards of the automotive industry. Delphi technology is also found in computing, communications, consumer electronics, energy and medical applications

Responsibilities

• Checks for Oracle database.
• Installation, creation, configuration and Performance tuning of database.
• Performance tuning for Oracle Day-To-Day Maintenance and management of the several different databases in development, test, and production environments.
• Understanding the existing Database Structure and suggesting the database reorganization.
• Oracle 10g Installation and Configuration.
• Upgraded databases from 9.2.0.1 to 10gR2 and applied critical patches update CPU for latest versions.
• Actively involved in installation and configuration of Real Application Clusters RAC running on 2 node clusters.
• Involved in project of upgradation of standalone databases to 10g RAC environment.
• Worked on SAN
• Maintained and Monitored the VERITAS Net backups.
• Configured Bigfile Tablespace for Very Large Scale Database VLSD .
• Tune the Databases for optimization using Statspack and Explain Plan, Estimating Table Index Size.
• Wrote shell script, which generate Statspack Report at regular interval.
• Resolved performance issues by Automated Workload Repository AWR and Automatic Database Diagnostics Monitor ADDM .
• Automated the Database refresh process from Production to TEST environment.
• Data loading using Oracle SQL Loader and also developed SQL Loader script to load data with fine tune setting for optimum performance of the SQL loader.
• Extensively used new features of 10g like Import, Export and Data Pump logical backup.
• Wrote a shell script for taking backup using Export/Import.
• Involved in Physical and Logical design of Data MODEL using ERWIN.
• Automation of lot of process to keep the systems up to date and to reduce manual errors by developing shell scripts and using CRONTAB in UNIX.
• Created Database link to access the object on remote database and scrip to check the connectivity among all the databases.
• Audit of the Data/Database objects for auditors.
• Monitored and tuned Rollback Segment, Temporary Tablespace, Redo Log Buffer, Sort Area Size, and Flash Recovery Area.
• Storage Management, Managing Space, Tablespaces, Segments and Extents, Rollback Segments Data Dictionary.
• Granted and Revoked privileges and roles to the users on different objects depending on their work requirement and provided the necessary security to the database.
• Supported test and development environments to ensure smooth transition of applications into production.
• Served as Oracle DBA in a 24x7 Production environment managing several Database instances.

Environment

HP UX 11.00, Linux, AIX, Oracle 8i, 9i,10g and SQL server, My SQL

Confidential

Database Administrator

• Confidential outsourced the level 2 support for 21 of its internal production databases to Accenture. The Project involves providing technical support - Database monitoring, Resolving Database related issues, Escalation of issues to concerned teams, Adhering to SLAs, OVSD tickets management etc.
• My role involves providing DBA support for the Production Databases, my day to day DBA activities and other

Responsibilities

• Supported Oracle RMAN backups and VERITAS Net Backup
• Backup and Recovery issues, also included RMAN
• Handling Tuning Related issues.
• Resolving ORA errors
• Move to Production activities
• Space Management Issues
• Handling Replication related Issues.
• User, Roles and Privilege management
• Provide support for code movement to production
• Proactive monitoring and managing the 21 instances involved
• Responsible for monitoring and maintain the SQL servers.
• Documentation of the dataflow and system design.
• Database administration, database design and database development work with Oracle 8i, Installation and maintaining Oracle server 8i on LINUX.
• Database administration, managing table spaces, objects and disk space.
• Worked on database performance monitoring using OEM.
• Creation of oracle users, Oracle roles, granting privileges etc.
• Query Optimization using Explain plan and SQL trace with TKPROF Assist Sr.Oracle DBA in day-to-day Administration.
• Involve in Data Maintenance, using Explain plan, SQL Hints, Table and Index Partitioning to improve the Performance.
• Database performance and SQL tuning
• Developed procedures to load data using SQL loader with direct/conventional parallel modes.
• Installation of Oracle severs on various operating systems.
• Creation and maintaining the databases as per OFA standards.
• Participate with application development team to design Oracle database.
• Creating tables, indexes, sequences, constraints, triggers and procedures.
• Control user access to resource and information.
• Security Management by allocating proper privileges.
• Monitoring alert logs

Environment

HP UX 11.00, Oracle 9.2.0, SQL server

Confidential

Database Administrator

• As an Oracle Database Administrator, following were the activities performed in Confidential. This is an infrastructure support project where we provide services to multiple Clients in the United Kingdom.
• These are varied services which include UNIX, Solaris and AIX System Administration, Oracle Database Administration, Windows Administration, Network support and Basis support.
• This is an infrastructure support project where I provided services to multiple clients in the United Kingdom as Oracle Database Administration in all different types of Operating systems like UNIX, Solaris, and AIX with different versions from 7.1, 8.1, 9.1, 10g.

Responsibilities

• Performing daily checks like log monitoring, health checks, tablespace depletion
• checks for Oracle database
• Backup validation checks.
• Tablespace standard checks.
• Installation of oracle database software 8 and 9i.
• Cloned the Database from production to development environment.
• Migration of database 9.1.0.5 from SunOS 5.6 to SunOS 5.9.
• Upgraded database from 9.2.1.0 to 9.8.0.8 on SUN Solaris using Database Upgrade Assistance DBUA and manual upgrade method.
• Upgraded and patched Oracle software, Setup brand new machines including Oracle
• Software installation.
• Converted tablespaces to locally managed tablespaces to eliminate fragmentation,
• Better performance and reduced maintenance.
• Wrote the SQL Loader scripts to load the external files into the Oracle Database.
• Configured Oracle Enterprise Manager OEM and monitored production databases.
• Extensively used Explain Plan to identify the poorly performing query.
• Utilized Crontab and DBMS JOBS to automate the monitoring jobs.
• Created and Maintained Users and Roles with Appropriate Privileges and Profiles. Granted
• and Revoked privileges and roles to the users on different objects depending on their work
• requirement and provided the necessary security to the database
• Implemented database refresh with the hot backup using DUPLICATE or full export.
• Designed and implemented of Backup Strategy for the production databases.
• Extensively Used RMAN for hot backup as well as Developed or modified some
• Oracle Backup and Recovery Scripts.
• Design, deployment, monitoring and troubleshooting of rollback segments.
• Supported the development team and supporting production Environment.
• Performance tuning by doing Partitions of large table and Created Indexes by
• Analyzing and rebuilding of Indexes for better performance.
• Performing code release and Refresh as change release
• Performance tuning, monitoring system health, applying patches.
• Query performance using better joins and used Hints appropriately.
• Performed SQL tuning by using Explain Plan
• Resolving incidents and implementing change request
• Documentation of procedures/process wherever required.
• Worked on mount points free space monitoring.
• Worked on database setup and monitored the database growth on daily basis
• Developed oracle reports as per the user requirement
• Used SQL Plus to access the Procedures and Functions

Environment

HP UX 11.00, Linux, Solaris, AIX Oracle 7, 8, 9i