We provide IT Staff Augmentation Services!

Program Analyst Resume Profile

Summary of Qualifications:

  • About 10 years of experience in Database Administration and Software Development including analysis, design, development, maintenance, testing, documentation, implementation and user training/support.
  • Expert in Install, Upgrade and Configure on Oracle Enterprise Edition 11g/10g/9i,8i/8 databases on Sun Solaris, Red hat Linux, AIX, HP-UX True 64/ Itanium/ PA-RISC and Windows NT/2000 platforms.
  • Expertise in setting up 11G and 10G Grid, ASM, ACFS configuration and management of different client nodes.
  • Sound Implementation, configuration and maintenance of off-site Disaster Recovery planning using Standby Database Setup RAC.
  • Fulfill DBA daily activities, including user management creating users, synonyms, privileges, roles, quotas, table, index, sequence etc. space management tablespace, rollback segment , monitoring alert log, memory, disk I/O, CPU, database network connectivity .
  • Expertise in installation and maintenance of RAC, ASM, Data Guard, OEM Grid Control 10g and11g, SQL Plus, Datapump Export/Import and SQL Loader as well as traditional UNIX utilities.
  • Technical knowledge of SAP Basis Database design, implementation support.
  • Work closely with developers provide Oracle DBA support and technical support for multiple applications in development, test, QA, UAT and production environments.
  • Experienced in Tuning: Used BRTOOLS, Explain plan and TKPROF, DBMS Profiler, AWR, ADDM, TOAD for SQL/PLSQL Tuning Performance tuning i.e. tuning SGA, I/O distribution using STATSPACK. Troubleshooting locks, network connection etc and documented database problems as they arise.
  • Project experience includes handle multiple tasks, Project Management, customer and user interactions, and leadership responsibilities.
  • Ability to concentrate and pay close attention to detail and think broadly with a system orientation.
  • A go-getter with Strong analytical, technical, research, interpersonal and organizational skills. Comfortable speaking to large groups, preparing written communication and developing presentation material.
  • Technical Competencies:
  • Operating Systems: SUN Solaris, HP-UX PA-RISC ITANIUM , IBM AIX, Oracle Linux, Redhat Linux and Windows.
  • RDBMS: Oracle 8/8i/9i/10g/11g , MS SQL 7/2000 and MS Access
  • Oracle Tools/Utilities: OEM Grid Control 12C, 11G and 10G, Tuning Advisory, ASM, ACFS, Data Guard,RMAN, DBverify, Exp/Imp, expdp/impdp, Server Manager, TKPROF, Erwin Tools , TOAD, PL/SQL, Data Guard, OS Watcher, RDA for RAC.
  • Languages: SQL, PL/SQL, UNIX Shell Scripting, C ,XML, Java, .Net, VB.

Professional Experience:

Confidential

Role: Oracle DBA

Roles and responsibilities:

  • As a part of Primary DBA role provided 24 7 production support for critical SAP Retail Application DBs and non-SAP Oracle Restart and RAC DBs.
  • Lead efforts includes supporting SAP RAC DB for BI, ECC and PI modules
  • Maintained and supported In-house retail application MARS- which is used at over 1500 stores and WMS ware house management system DBs.
  • Supported People Soft DBs along with OEM Grid DB and HP Open View monitoring system DB.
  • DB support includes 100 Production databases, 100 QA, DEV TEST databases sizing 50G to 20 Terabytes.
  • Installed and maintained 11GR2 RAC Grid Infrastructure and DB.
  • Upgraded 11GR1 SAP and other application DBs to 11GR2.
  • Used BRTOOLS for the maintenance of SAP RAC Databases.
  • Successfully implemented the procedure to refresh SAP QA environment from Production SAP environment using RMAN.
  • Installed and Implemented OEM 12CR3 for monitoring of Oracle systems.
  • Migration of Standalone WMS DB systems to RAC DB system has successfully been achieved.
  • Actively designed and implemented the Disaster Recovery DR strategy using RMAN backups for SAP DBs and Non-SAP DBs.
  • Implemented Active Data guard 11GR2 setup for reporting and DR purpose.
  • Experienced in implementation and maintenance of ACFS and ASM core part of Oracle Grid Infrastructure.
  • Have setup RMAN Catalog and designed the backup strategy for various DBs.
  • Actively addressed the performance tuning issues in SAP DB environment.
  • Working closely with Oracle Support for the several Bugs found in ACFS 11GR2.
  • Closely monitoring SAP DB backup jobs and Statistics Collection Job which has major impact on the business.
  • Using Grid Control 12C, 11g and 10G for various day to day oracle DBA tasks.
  • Involved in capacity planning and maintenance of oracle DB storage using ASM.
  • Maintained and Patched the SAP DBs following SAP guideline and procedures.
  • Keeping oracle DBs updated by regularly applying the Oracle Patch Set Update PSU and Critical Patch Set Update CPU .
  • Co-ordinate with SAP support for any DB issues related to SAP environment.
  • Have successfully setup the documentation management procedure for DBA roles and responsibilities.
  • Communicated with Oracle Support for bugs issues resolutions and personal research.
  • Actively monitoring the database performance and providing valuable inputs for various performance tuning issues using Various advisors like SQL Advisor, Memory advisors, MTTR Advisor, ADDM etc .
  • Heavily used crontab and OEM to schedule and manage various DB jobs Backup job, DB statstics collection, alert log monitoring etc. Housekeeping Job,
  • Follow change control norms, company's Information Security and IT audit standards and procedures for any DBA activity.
  • A team Player - Co-ordinates with System Admins, Developers, Application DBAs, and Support group to maintain life cycle of oracle DBs.

Environment: Oracle 11g,SAP BRTOOLS, ASM, ACFS, OEM12c, 11g, RMAN, Unix shell script, Grid Control, Data Guard, Oracle Linux, SQL Plus, Various 12C and 11g Advisories, AWR Reports, EXPDP/IMPDP,EXP/IMP, PL/SQL, RMAN, Crontab, OEM and HP Openview, Toad,Patrol for DB monitoring.

Confidential

Role: Oracle Infrastructure DBA

Roles and responsibilities:

  • Primary role at Constellation Brands Inc is of an Oracle Infrastructure DBA along with 24 7 production support.
  • Major responsibility includes the installation, testing and implementation of various Oracle Db Features, DB related products such as Server Pool, Audit Vault, Active Data guard, OEM 12C, Oracle Data Integrator ODI .
  • Responsible for support of 100 Production databases, 100 UAT, DEV TEST databases sizing 100G to Terabytes.
  • Installed and maintained 11GR2 RAC Grid Infrastructure and DB.
  • Patched the Grid Infrastructure and Database Home using OEM Out-Place-Patching feature.
  • Tested and implemented Server Pool concept of 11gR2 RAC DB using.
  • Testing Oracle out-of-place patching concept of 12C1 to apply the patches online to Grid and DB Homes.
  • Testing and Implementing various plug-ins in OEM 12C1 Audit Vault Plug-in, JDE E1 Application Management Plug-in.
  • Actively designed and implemented the Disaster Recovery DR strategy using RMAN backups.
  • Implemented Active Data guard 11GR2 setup for reporting and DR purpose.
  • Designed the backup strategy for various DBs.
  • Installed and maintained Audit Vault 10.3,10.2.2 and 10.2.3. Oracle Audit Vault automates the consolidation of audit data into a secure repository, enabling efficient monitoring and reporting.
  • Trouble shooting production issues and Working closely with Oracle Support for the several Bugs found in Audit Vault and other Database infrastructure related issues.
  • Using Grid Control 12C1, 11g and 10G for various day to day oracle DBA tasks.
  • Maintain oracle DB storage using ASM and OCFS2.
  • Keeping oracle DBs updated by regularly applying the Oracle Patch Set Update PSU and Critical Patch Set Update CPU .
  • Used Oracle Content Management for various tasks like managing and sharing database documents.
  • Co-ordinate with Oracle Support for bugs issues resolutions and personal research.
  • Actively monitoring the database performance and providing valuable inputs for various performance tuning issues using Various advisors like SQL Advisor, Memory advisors, MTTR Advisor, ADDM etc .
  • Using crontab and OEM to schedule and manage various DB jobs Backup job, Housekeeping Job, Audit files purge job etc.
  • Installed and maintaining Oracle Data Integrator client for Data warehouse Team.
  • Follow change control norms, company's Information Security and IT audit standards and procedures for any DBA activity.

Environment: Oracle 10g, 11g,Oracle Audit Vault, ASM,Unix shell script, Grid Control, Active Data Guard, Oracle Linux, SQL Plus,Various 10g and 11g Advisories, AWR Reports, EXPDP/IMPDP,EXP/IMP, PL/SQL, RMAN, Crontab, OEM and BMC Patrol for DB monitoring.

Confidential

Role: Oracle DBA

Roles and responsibilities:

  • At PNC I was part of Oracle Support team so primary focus was to provide 24 7 production support.
  • Maintain and Support Oracle databases 11g R1/11g R2/10gR2/10gR1/9iR1/9iR2 in Solaris, AIX, Oracle Linux platform.
  • Patched and upgraded the oracle databases.
  • Responsible for support of 1000 Production databases of Terabytes in size, 2500 UAT, DEV TEST databases sizing 100G to Terabytes.
  • Active member of Conversion team PNC acquired National City Corp NCC almost 2 yrs ago. As a part of this team, I have migrated Legacy NCC databases to PNC standards. This includes setting up backup strategy, oracle database environment, disaster recovery setup, monitoring setup etc.
  • Complete range of Oracle DBA activities including day-to-day production database monitoring, Backup and recovery using RMAN, Trouble Shooting production issues, Physical Database design.
  • Managed the databases in Sun Virtual Environment. Also maintained the database which had O/S cluster for failure scenario.
  • Worked with Grid Control for various day to day oracle DBA tasks.
  • Resolve Incident and Service Requests in the tickets queue and proactively resolve database related problems, based on alerts triggered by OEM or BMC Patrol Monitoring Tool.
  • Support and monitor databases to ensure Service Level Agreements on uptime, capacity, health and functionality.
  • Used Oracle Apex for various tasks like managing database inventory etc.
  • Actively maintained Exadata Database Project, this has 4 production RAC databases sizes 20 TB with each 8 nodes, 15 DEV/TEST/QA/Break FIX 8 node RAC environment.
  • Collaborate with Oracle Support for bugs issues resolutions and personal research.
  • Provided valuable inputs for various performance tuning issues.
  • Worked with crontab to manage, schedule various database jobs for backup, maintenance, password change etc.
  • Refreshed non-production environments from production database backup for developers.
  • Followed change control, Information Security and IT audit standards and procedures for any DBA activity.
  • Analyzed, planned, managed and evaluated processes that determine database quality, design and functionality per SAS standards.
  • Worked collaboratively with developers and management to establish Oracle development and production standards.
  • Developed task definition and execution strategies.

Environment: Oracle 9i, 10g, 11g,Exadata V2, Oracle Apex, Unix shell script, Grid Control, Data Guard, IBM AIX, Sun Solaris, Oracle Linux, SQL Plus, Toad, Various 10g and 11g Advisories, AWR and Statspack Reports, EXPDP/IMPDP,EXP/IMP, PL/SQL, RMAN, Crontab, Basel2 for Exadata Virtual Tape Backup, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring.

Confidential

Role: Oracle DBA

Roles and responsibilities:

  • Installed configured Oracle 9i, 10g and 11g databases.
  • Upgraded, migrated patched 9i and 10g databases.
  • Installed Oracle 10g Agent and set up Grid Control for selected servers.
  • Provided 24 7 support for 25 Production databases of Terabytes in size, 45 UAT, DEV TEST databases > 100GBs
  • Monitored databases during testing using OEM Grid Control for 10g DBs, OS Watcher, Stats Pack, TKPROF and AWR reports and provided proactive solutions for tuning of instance, SQL and I/O.
  • Active member of Strategic planning team Developed backup and recovery strategy, database tuning strategies, capacity planning etc.
  • Set up off-site 10g Data Guard on HPUX-Itanium servers and implemented physical standby for data guard for disaster recovery and Oracle Stream for data transfer.
  • Interface with Oracle Corporation and created TAR in case of ORA 600 errors.
  • Performed code migration, database change management and data management through the various releases of the application.
  • Managed warehouse database tables/partitions using Oracle 10g COMPRESSION Technique.
  • Set up of databases by using company's standard Instance Creation Checklist policy.
  • Reorganized Data, Partitioning tables, Managing Indexes, Materialized Views.
  • Created various PL/SQL, triggers and procedures based on the requirement of application when needed.
  • Analyzed tables and indexes to generate statistics used for tuning.
  • Implemented The Department of Defense Information Certification and Accreditation Process- DIACAP compliance for new existing Oracle 10g databases.
  • Implemented database security by creating managing users, roles, profiles, password protected listener etc.
  • Co-ordinated with other developers in tuning long running SQL queries to enhance system performance.
  • Written Shell scripts and automated these scripts through cron jobs for backups. Recovered database in case of crashes from the backup taken.
  • Monitored/Tuned databases using Symantec I3 Application.

Environment: Oracle 9i, 10g, 11g, Unix shell script, Grid Control, Data Guard, HP UX PA RISC/ ITANIUM , SQL Plus, Toad, Various 10g Advisories, AWR and Statspack Reports, SQL Loader, EXPDP/IMPDP,EXP/IMP, PL/SQL, RMAN, HP Data Protector, TIDAL Scheduler.

Confidential

Role: Oracle DBA

Responsibilities:

  • Provided 24 7 support and Installed Managed large partitioned databases 40 Production DBs of at least 500GB in size, 30 Dev and QA DBs, 15 UAT DBs on Oracle 9i on Sun Solaris platform.
  • Installed Oracle 9i on Sun Solaris 9 Oracle 8i on Windows 2003.Created 9i 8i database and configured Enterprise Manager Database Control feature.
  • Managed Oracle 10g RAC running on 2 nodes on RHEL 4 platforms.
  • Managed data file system using asmcmd tool for RAC database's.
  • Managed RAC database instances using srvctl utility.
  • Used Transparent Application Failover with RAC
  • Responsible for databases whose total size is over 1 tera-bytes.
  • Ensured databases adhere to corporate standards and policies including database auditing to SOX SAS70 requirements.
  • Coordinated with developers and changed management team to ensure smooth life cycle
  • Implemented a database Multi Master Replication Standby Database Setup.
  • Setup and monitored database thresholds using Nagios alert monitoring tools.

Environment: Oracle 9i, 10g RAC, Unix shell script, Grid Control, Data Guard, IBM AIX, Red Hat Linux, SQL Plus, Toad, EXPDP/IMPDP,EXP/IMP, PL/SQL, RMAN, SAN Storage, NAGIOS Monitor, Crontab Scheduler.

Confidential

Environment : Oracle 8i, Windows 2000

Responsibilities:

  • Installed and Migrated Oracle 9i and 10g Software.
  • Created Primary Database Storage Structure in co-ordination with AD Team.
  • Allocated system storage and planned future storage requirements for the database system.
  • Managed Change Request CR for DBA related activities using Remedy.
  • Used Erwin Data Modeling Tool for DB designing.
  • Created of new databases, Unix shell scripts RMAN Repositories.
  • Applied new patches on database upgrading 9i databases to 10g R2.
  • Created maintained Physical Standby Databases and configured dataguard for Physical Standby Databases.
  • Created users, roles maintained system security.
  • Cloned production database to the test environment using Recovery Manager RMAN .
  • Controlled monitored user access to databases.
  • Optimized the database performance.
  • Created database backup strategies database exports.
  • Performed daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
  • Configured regular backups using RMAN on tape using Tivoli Storage Manager TSM Veritas.
  • Health check reports verification for Production, Development, and QA DR Databases.
  • Automated database activities using shell scripts.
  • Provided on call support 24x7.

Environment: Oracle 9i, 10g, Unix shell script, Grid Control, Data Guard, Sun Solaris, Red Hat Linux, SQL Plus, Toad, SQL Loader, EXPDP/IMPDP,EXP/IMP, PL/SQL, RMAN, NAGIOS Monitor, Crontab Scheduler, Oracle O/S Watcher, Tivoli Storage Manager.

Confidential

Role: System Analyst

Project Details:

Environment : VB 6.0, Oracle 8i,9i, XML, Windows 2000

Responsibilities:

  • Upgraded Oracle 8i databases to 9i and applied the latest patch sets to all test, QA, UAT, Dev and production database.
  • Created of the new Development and Test Oracle databases.
  • Provided 24 7 support and Performed DBA activities including creation, management, startup and shutdown of databases, management of data files, redo log files, control files, tablespaces, segments, extents and data blocks physical storage, creation, monitoring and management of database users, granting/revoking of system/object privileges, management of roles resources and setting of init.ora parameters
  • Wrote database SQL queries with deeply nested inline views, triggers, procedures, functions in PL/SQL using T-SQL on MS SQL2000 and incorporated business rules and constraints.
  • Performed export and Import of database objects to copy from one database to another database
  • Performed routine reorganization of databases, disaster hot backup recovery exercises.
  • Created new tables, constraints for all the modules and Tuning of SQL queries to improve the response time.
  • Worked closely with the Administrator for proper backup and recovery plans using RMAN.
  • Extensively worked in the performance tuning of programs and processes.
  • Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques.

Environment: Oracle 8i, 9i, MS Windows 2000 Server, MS-SQL Server 7/2000, SQL Plus, Imp/Exp, TKPROF, Explain Plan, Statspack Reports.

Confidential

Role: Program Analyst

Responsibilities

  • Designed databases using Oracle 9i
  • Wrote database triggers, procedures, functions in Informix-SQL and incorporated business rules and constraints.
  • Wrote complex SQL queries with deeply nested inline views to populate data from different tables and which can be used for reports.
  • Created new tables, constraints for all the modules.
  • Performed Tuning of SQL queries to improve the response time.
  • Worked closely with the Administrator for proper backup and recovery plans.
  • Extensively worked in the performance tuning of programs and processes.
  • Monitored performance and changing performance requirements through application of Database tuning and performance optimization techniques.

Hire Now