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.