We provide IT Staff Augmentation Services!

Sr. Oracle & Netezza Dba Resume

SUMMARY

  • 15 + years of IT experience in different technologies with multiple domains.
  • Excellent experience in Telecom, Retail and Finance & Banking domains.
  • Extensive experience in database architecture designing, implementation and administration including installation, upgradation, backup and recovery, testing, implementation, QA, performance tuning, migration and support.
  • Strong experiance in Installing / configuring / maintaining RAC, Datagaurd, Physical / Logical Standby environments.
  • Experience with large databases up to 23TB and large crucial financial Databases.
  • Strong configuration and troubleshooting skills in ASM/RAC.
  • Good experience in Performance Tuning reading statspack/awr/adm reports, analyzing the Execution Plans.
  • Expertise in Unix/OS level monitoring such as Memory usage, CPU and I/O usage and Shell scripting.
  • Experience in working with Production and Development environments.
  • Strong experience in Database migration and up - gradation in various platforms. Done several Database patch-set installations as well in one-off patch installation using opatch.
  • Expertise in SQL (DDL and DML), PL/SQL, functions, triggers and packages.
  • Expertise in database backup and recovery using Recovery Manager (RMAN).
  • Experience in setting up Confidential LDAP(OID) and configuration.
  • Experience with data loading/extraction using Confidential utilities such as export/import, Data Pump, SQL*Loader
  • Configure Confidential Enterprise Management Agent (MA) to be accessible via OEM Grid Control.
  • Support application teams/customers for any issues with Confidential database systems.
  • Analyzing the logs (alert) and trace (process/user) files to diagnose the problem.
  • Cloning/Refreshing databases from production for development, testing purpose.
  • Expertise in OEM grid control for monitoring database systems and configuring new rules.
  • Experience in, Confidential Development, Teradata, Remedy, Siebel, Ab Initio and other tools.
  • Experience with Full Project Life cycles with Onshore/Offshore Model.
  • Excellent Business Requirements gathering and analyzing skills.
  • Experience working with major clients Harris Teeter, Confidential Cable, Confidential, Confidential, Confidential amp;T wireless, Cingular wireless, Qwest communications, Confidential, Oman Telecommunications and New World Mobility.
  • Assist & Train different User groups with new deployments.
  • Strong experience in DR Exercise.
  • Experience in a 24X7 production environment.
  • Experience with Enterprise Security Management (ESM) installation and audit remediation.
  • Experience with Dataguardian and Enterprise Security Audit remediation.
  • Experience with PCI data and SOX compliance.

TECHNICAL SKILLS

Primary Relational Databases Administration: Confidential 8.x, 9.x, 10g, 11g, 12c and Netezza Mustang, Twinfin & PureData Netezza Systems

Secondary Relational Databases Administration: MS SQL Server 2005, MYSQL, Informix and DB2

Tools: and Utilities: OEM 10g, OEM 12C, OID, ODSM, Confidential Forms 4.5 and 6i, Confidential Reports 6i, SQL*Loader, SQL*Plus, TOAD, Enterprise Architect, Query Builder, Ab Initio,BMC, Patrol, Autosys, BMC Service Desk Express, PVCS, ERWIN, Control M, VSS, Clear Case and Clear Quest.

Operating Systems: Sco UNIX, HP UNIX, Sun Solaris, IBM AIX, Linux, z/Linux and Windows

Programming Languages and Web Technologies: PL/SQL, Shell Scripting, C, C++, Java, Pro *C, XML, DHTML, HTML

PROFESSIONAL EXPERIENCE

Confidential

Sr. Confidential & Netezza DBA

Responsibilities:

  • Migration of Confidential databases from 9i & 10g to 11gR2.
  • Upgrading of Confidential databases from 9i & 10g, 11gR2 to 12C
  • Database upgrade planning and providing estimates.
  • Installation of Confidential OEM 12c and migration of OEM 10g to 12C.
  • Confidential Fusion middleware installation and converting non-LDAP to LDAP.
  • Storage, Hardware and Capacity planning.
  • Installation and configuration of ASM.
  • Converting databases from non-ASM to ASM.
  • Adding/Deleting disks/disk groups to/from ASM.
  • Day to Day Database Maintenance Activities.
  • Backup, recovery maintenance and cloning of databases using RMAN.
  • Troubleshooting and tuning DB & SQL performance issues.
  • Creating SRs and follow up with Confidential corporation.
  • Supporting Developers & SAs with new requirements.
  • Supporting and resolving day to day production issues.
  • Supporting Change Requests and implementations.
  • Provide DB technical support and guidance on new projects.
  • Planning and supporting DB Disaster Recovery exercises.
  • 24x7 Database production support.
  • Creating new datamarts and Netezza server hosting and planning.
  • Netezza support and database administration.
  • Netezza DB migration, space reclaim/groom, backup, data roll off, Security roles, SPU replacement, etc
  • Netezza setting up new events, performance tuning, load balancing.
  • Experience with PCI, Dataguardian and SOX compliances.

Environment: : SQL, PL/SQL, Confidential 9i/10g/11g, 12C, Confidential Fusion, RAC, PureData Netezza, Linux, Solaris & AIX

Confidential

Sr. Netezza & Confidential DBA

Responsibilities:

  • Netezza support and database administration.
  • Migration of data among Netezza appliances.
  • Creating new datamarts and Netezza server hosting and planning.
  • Netezza support and database administration.
  • Perform Netezza DB migration, space reclaim/groom and data roll off.
  • Creating NZ Security roles and setting up access levels, WLM and GRAs.
  • Coordinate with IBM on NZ SPU/disk replacements and h/w issues etc.
  • Performing NZ backup and restore.
  • Setting up new NZ events, performance tuning, load balancing.
  • Upgrading s/w from one patch level to another patch level.
  • Support and provide guidance to developers with the queries and performance issues.
  • Perform NZ manual vacuums on need basis.
  • Automate repeated NZ tasks using Shell scripts.
  • Migration of Confidential databases from 9i & 10g to 11gR2.
  • Installation of Confidential 12c and migration of OEM 10g to 12C.
  • Confidential Fusion middleware installation and converting non-LDAP to LDAP.
  • Storage, Hardware and Capacity planning.
  • Installation and configuration of ASM.
  • Converting databases from non-ASM to ASM.
  • Adding/Deleting disks/disk groups to/from ASM.
  • Day to Day Database Maintenance Activities.
  • Backup, recovery maintenance and cloning of databases using RMAN.
  • Troubleshooting and tuning DB & SQL performance issues.
  • Creating SRs and follow up with Confidential corporation.
  • Supporting Developers & SAs with new requirements.
  • Supporting and resolving day to day production issues.
  • Supporting Change Requests and implementations.
  • Provide DB technical support and guidance on new projects.
  • Planning and supporting DB DR exercises.
  • Experience with PCI, Dataguardian and SOX compliances.

Environment: Netezza TwinFin 120, 72, 36, 24, 12, N1001 and Mustang, SQL, PL/SQL, Confidential 9i/10g/11g, 12C, Confidential Fusion, RAC, Linux, Solaris & AIX

Confidential

Sr. Confidential & Netezza DBA

Responsibilities:

  • Planning of Confidential merchant services databases merger process with First Data
  • Storage, Hardware and Capacity planning
  • Migrating data from Confidential to FirstData
  • Providing inputs for setting up environment & hardware.
  • Installing Confidential 10.2.0.5 and 11g on Solaris and AIXs.
  • Setting up Dataguard for RAC & Non-RAC databases.
  • Installing OEM on RAC & Non-RAC databases
  • Rehosting databases and database servers from Bank to FirstData
  • Adding/Deleting disks/disk groups to/from ASM
  • Setting up Databases as per FirstData standards.
  • Automating DBA activities using shell scripts
  • Day to Day Database Maintenance Activities
  • Backup maintenance using RMAN & BCV
  • BCP Failover exercises using Dataguard
  • Disaster recovery exercise
  • Database server maintenance activities
  • Creating SRs and follow up with Confidential
  • Carrying out data migration activities
  • Supporting Developers & SAs with new requirements
  • Supporting and resolving day to day production issues
  • Supporting Change Requests and implementations
  • Provide technical support and guidance moving databases from Bank to FirstData
  • Netezza support and database administration
  • Netezza DB migration, space reclaim, backup, data roll off, Security roles, SPU replacement, etc
  • Remediating ESM violations on Bank side and setting up FirstData standards on new DBs.
  • Remediating DB Audits and adhere to Bank & FirstData standards
  • Experience with PCI, Dataguardian and SOX compliances.

Environment: : SQL, PL/SQL, Confidential 9i/10g/11g, RAC, Netezza, Linux, z/Linux, Solaris & AIX

Confidential

Sr. Confidential & Netezza DBA

Responsibilities:

  • Upgrading Confidential databases from 10.2.4. to 11gR2
  • Upgrading Confidential databases from 10.2.0. to 10.2.0.5
  • Upgrading RAC database from 10.2.0. to 10.2.0.4
  • Setting up Dataguard for RAC databases.
  • Upgrading OEM on RAC databases
  • Adding nodes to RAC environment
  • Rehosting databases and database servers
  • Adding/Deleting disks/disk groups to/from ASM
  • Automating dba activities using shell scripts
  • Day to Day Maintenance Activities
  • Dataguard Maintenance
  • Backup maintenance using RMAN & BCV
  • Experienced in large database recovery
  • BCP Failover exercises using Dataguard
  • Disaster recovery exercise
  • Database server maintenance activities
  • Creating SR&TAR and follow up with Confidential
  • Carrying out data migration activities
  • Supporting Developers with new requirements
  • Supporting and resolving production issues
  • Supporting Change Requests and implementations
  • Provide technical support and guidance moving databases from non-secure zone to DMZ zones
  • Netezza support and database administration
  • Netezza DB migration, space reclaim, backup, data roll off, Security roles, SPU replacement, etc
  • Database design and architectural solution
  • Remediating ESM violations
  • Remediating DB Audits and adhere to Bank standards
  • Experience with PCI, Dataguardian and SOX compliances..

Environment: : SQL, PL/SQL, Confidential 9i/10g/11g, RAC, Netezza, MYSQL, Linux, z/Linux, Solaris & AIX

Confidential

Sr. Confidential DBA

Responsibilities:

  • Created and implemented the new databases.
  • Responsible for daily database monitoring, troubleshooting, backup and recovery, installation of Confidential (8.x,9.x) and database creation.
  • Created Confidential backup scripts and scheduling them through crontab.
  • Creation of new databases depending on the customer requirements
  • Troubleshooting Database crashes
  • Troubleshooting Backup & Recovery
  • Performance Tuning
  • Scheduling & Automating new jobs
  • Monitoring of scheduled jobs
  • Creation of users and maintenance of profiles and roles
  • Assisting developers in writing complex sql queries
  • Troubleshooting performance issues
  • Performing data architectural design

Environment: : SQL, PL/SQL, Confidential 9i/10g, RAC, Solaris & AIX

Confidential, Atlanta GA

Confidential DBA

Responsibilities:

  • Responsible for daily database monitoring, troubleshooting, backup and recovery, installation of Confidential (8.x, 9.x) and database creation.
  • Monitor/Load/Restore backups using export/import (Development and Test databases), hot backups (Production database), hot standby (on Production database for disaster recovery) and Rman backups (Production Database).
  • Created Confidential backup scripts and scheduling them through crontab.
  • Creation of new databases depending on the customer requirements
  • Troubleshooting Database crashes
  • Scheduling & Automating new jobs
  • Monitoring of scheduled jobs
  • Creation of users and maintenance of profiles and roles
  • Performing data flow and architectural design

Environment: : SQL, PL/SQL, Confidential 9i/10g, DB2, HP-UX & AIX

Confidential

Business/Functional Analyst

Responsibilities:

  • Analysis of the Business Requirements provided by business users.
  • Involved in requirement gatherings and user meetings.
  • Involved in Confidential amp;T, Cingular merger process for the applications’ merging and customer moving.
  • Preparing the Impact analysis document and High-level test Cases for new requirements.
  • Identifying and documenting the technical issues and the approach to resolve the same.
  • Conduct workshops and review meetings to discuss the requirements and development activities.
  • Reviewing Test Plan.
  • Setting up the Environment for development and test beds for Unit Testing.
  • Resolving Architectural and Technical issues while developing the system.
  • Defect management involving discussion with Test Designers, Developers.
  • Appraising the project status to project manager on regular and need basis.
  • Validate all Boundary Systems like NumeriTrack (NuT), Atlys (Billing system), and Switch Activation Manager (SMS), eBPP (ePayments), IVR, ORBIT, MMS Vitria, Portal and EDW
  • Conduct Down Time Testing for NumeriTrack (NuT), Atlys (Billing system), and Switch Activation Manager (SMS), eBPP (ePayments), IVR, ORBIT, MMS Vitria, Portal and EDW
  • Reviewing the Code and Unit Test Result at the completion of the requirement.

Environment: Siebel Sales, ATLYS telecom billing system, Vitria, NuT, eBPP, Orbit, Confidential 9i, Shell Scripting, SQL,PL/SQL, Sql*Plus, TOAD and Rational Tools (Clear Case and Clear Quest).

Confidential

Confidential DBA & Developer

Responsibilities:

  • Analysis of existing system and mapping the data to various data sources in Billing System.
  • Development of PL/SQL procedures, functions and Packages.
  • Development of new forms and System Maintenance and Enhancement.
  • Maintenance of the live system and carrying out future enhancements as per client requirements.

Environment: : Confidential 8.0.4, Confidential Forms 4.5, SQL, PL/SQL, C, Pro* C

Confidential

Developer

Responsibilities:

  • Change Requirements / Field Trouble Reports - Fixes, Testing and Releases for various components.
  • Maintenance of the live system and carrying out future enhancements as per client requirements.
  • Production Support
  • Business induction to new team members

Environment: Confidential, SQL, Remedy, Clarify and Citrix.

Hire Now