SUMMARY:

• Over 20 years of IT experience which includes technical leadership, project management, database administration, on call operation support, design, tuning, shell scripting, development and coding, client interaction, testing and implementation of application software using ORACLE, INFORMIX, MS SQL under UNIX and WINDOWS platforms.
• Experience in leading operation support (database) team.
• On call 24 x 7 support for over 100 databases across the sites.
• Experience with Oracle 9i/10g/11g R1/11g R2/EM12 c/Oracle GRID Control Install, Administration, Monitoring, Performance Tuning, Database Backup and Recovery.
• Implementation and Administration of High Availability solutions with Oracle 10g/11G RAC & ASM, Physical and Logical Standby Databases (Data Guard) and Oracle Fail Safe (windows).
• Installed Oracle Cluster ware to provide infrastructure for RAC and configured 4 to 8 nodes Oracle 10g, 11g RAC.
• Implementation of Oracle Streams to replicate data across the databases.
• Implementation and Configuration of Oracle Grid Control to set up RMAN backup jobs and monitoring databases.
• Experience in migrating database from Oracle 9i, Oracle 10g to Oracle 10g, Oracle 11g.
• Experience of working in EXADATA environment.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Experience in maintaining and managing MS SQL Server databases.
• Troubleshoot day to day issues in high - volume/time critical production service environments.
• Manage (Leading) Factory Down Time by Containing, De-Containing about 15 databases (RAC, Data Guard, Oracle Fail safe) per site.
• Experience in leading Escalation Manager role that facilitates the process of analyzing and resolving an incident.
• Experience in performing Design Integrator role that ensures a quality product is delivered from an operations/support perspective.
• Experience in Leading the effort of Event Management, Incident Management and Problem Management.
• Porting SQR report, Informix codes to Oracle.
• Performance tuning database and procedures/SQL queries for maximum efficiency in various databases.

TECHNICAL SKILLS:

Business Skills: Solution Development, Client Interaction, Project Management, Data Modeling, Database Design and Maintenance.

Programming Languages: PL/SQL (Oracle), SQL PLUS, ESQL/C, Unix Shell Scripting, VB script, Informix 4GL AND XML.

Operating Systems: HP-UX, IBM-AIX, SUN SOLARIS, WINDOWS Server (2003, 2008)

DBMS: ORACLE (7.x, 8i, 9i, 10g, 11g), INFORMIX 4.0, INFORMIX-Online 7.x, SQL SERVER (7.0,2000, 2008, 2012).

Tools: Toad, PL/SQL Developer, FactoryWorks 2.5, Oracle Forms, SQL LOADER, RMAN, DTS, OEM, PVCS.

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

Sr. Database Administrator

• Experience in leading operation support database team.
• Reviewing incident/Problem tickets status with the operation team.
• 12 x 7 on call operation support for over 100 databases.
• Implemented 4 to 8 nodes of Oracle RAC systems for high availability and scalability purpose.
• Implemented DATAGUARD (Physical and Logical Standby Databases) for high availability/disaster recovery purpose.
• Implemented Oracle Stream for data replication/information sharing.
• Experience in migrating databases from 10g to 11g.
• Implementing patches over 200 servers - current 11.2.0.4.
• Manage Factory Down Time by Containing, De-Containing about 15 applications/databases (RAC, Data Guard, Oracle Fail safe) per site.
• Coaching, Developing and Delivering training to group and individual for workforce development. It helps to reduce outside vendor training cost.
• Automated deployment of home grown Oracle tools over 200 servers saved considerable amount of resource time.
• Build and configured 10 Oracle Grid Control severs (OEM) across the sites for monitoring databases and running backup jobs.
• Installation and configuration of Oracle Enterprise Manager Cloud Control 12c.
• Design and implemented database backup and recovery strategy using RMAN. Troubleshoot RMAN backup and recovery issues.
• Frequent database audits to make sure no configuration gaps.
• Responsible for bringing inputs from the operations team to the development/design team to influence product design and ensure a quality product was delivered from an operations/support perspective.
• Lead the effort of transitioning database L2 support of two factories to a single support group that saved cost of a number of DBAS.
• Maintain SQL Server database - creating database, Backup, Restore, security management and Jobs.

Confidential,Chandler, AZ

Database Administrator

• Supporting Production database (24/7), QA and Development databases.
• Backup and recovery strategy (RMAN).
• Wrote stored procedures, package, functions and triggers part of application development.
• Implemented production releases.
• Worked on the proposed database design, development, and creation of all file system layouts, database environments, referential integrity relationships/constraints, security environment roles, etc.
• Shell scripting.
• Job Scheduling using crontab.
• Performance tuning of the existing PL/SQL and SQL scripts.
• DB load from same legacy systems to the Oracle 9i environment.
• Designing and Data modeling for new business requirements.

Confidential

Database Administrator

• Oracle 9i installations and Migration from 8i.
• Creating and maintaining Oracle databases.
• Data Export, import to build production like development environment.
• Created indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Proactively monitored performance, diagnosed problems and tuned queries and database.
• Developed and modified triggers, packages, functions and stored procedures part of SQR report conversion.
• Analyzing and detecting performance issue using STATSPACK, Explain Plan and TKPROF.
• Wrote database Procedures/Functions and Packages in oracle to populate as well as update data in multiple tables on daily process running in the CRON Job.

Confidential,Phoenix, AZ

Sr. Programmer Analyst

• Managing Application development team per SDLC.
• Porting Informix Codes (procedures, functions, triggers) to Oracle.
• Creating and maintaining development databases.
• Data modeling based on the design document.
• Migrating database from oracle 8i to 9i.
• Oracle Export, Import to refresh schema for development database.
• Coding, testing, Code releasing, troubleshooting procedure, functions. client interaction.
• SQL * Loader to loads data from external files originated form SQL Server.
• Installing software at client’s place.
• Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
• Created and maintained documentations such as Functional design documents, detailed design documents, data flow diagrams, data entity relationships documents for all the internal projects.
• Porting Transact SQL to Oracle equivalent and testing their functionality.
• Application Design and data modeling based on Customer requirement.

Confidential

System Administrator

• System Analysis & Design.
• Data Modeling.
• Application development using Oracle Forms and implementation.
• User Training.
• High quality documentation of functional and technical requirements.

Confidential

Programmer

• System Analysis & Design.
• Actively involved in studying existing manual System.
• Actively participated to design and modeling computerized system based on manual specification study.
• Detail documentation of approved design.
• Application development and implementation.
• Code modification based on the requirement change.
• Software installation at the client’s site.