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.