SUMMARY:

• Confidential has a Master’s degree in Computer Science and comes from a very strong technical background having developed, maintained and managed systems using both Oracle (11g,10g,9i,8i/ 8.0/7.3/7.0/6.0 ) and Microsoft technologies. He has over 13 years of experience in the industry, including database administration, design, application development, testing, implementation and Quality control procedures.
• He is an Oracle Certified Professional DBA (OCP - DBA), Bloomberg (TOMS Administrator), i2 (Demand Planner) and a Microsoft Certified Professional for System Administration SQL Server database.

PRODUCT/TECHNICAL EXPERIENCE:

• Oracle 11g,10g,9i, 8i, 8.x, 7.x,6.0 (SQL, PL/SQL), MS SQL Server, OLAP
• .NET, Business Objects, Crystal Reports, Micro strategy, Oracle Developer (Forms 6i, 6.0,5.0, 4.5, 3.0, Reports 6i, 6.0,3.0, 2.5, 1.1), WEB DB, Visual Basic 6.0, MS Access2000, MicroFocus NetExpress 2.0 (COBOL)
• Oracle Designer, Oracle BI, Warehouse Builder, OEM, RAC, Grid Control, Data Guard, ERWIN, TOAD, Bindview,Veritas Net Backup,ARC Serv
• C#, C++, C, Java, JSP, ODBC, JDBC, OIL, PERL, PVCS 7.0, Perforce, Data Junction 7.0, CASE 4.0, Winbatch, HTML, XML, Object COBOL, JavaScript
• UNIX, AIX, Solaris, MS-DOS, Novell NetWare, Banyan Vines, Windows 95 and NT
• Reuters Triarch, Dealing (TCSS), Matching, RDF, Bloomberg (TOMS Administration)
• SUMMIT, FNX, Bloomberg, Money Fund Financial system.

WORK EXPERIENCE:

Confidential

Software Consultant/ Sr. DBA

Environment: Oracle 9i, 8i (SQL,PL/SQL), Developer6i(Forms 6i,Reports 6i), ERWIN, PVCS, Data Junction 7.3, SQL Loader, OEM, ODBC,ARC Serv, UNIX, Windows 2000 Server, Win 2000 Professional, Web DB,WinBatch,Wang,PACE,MS Access 2000.

Responsibilities:

• Designing & Developing Data warehouse, Internet and Time series Applications.
• Lead the team of developers and managed the projects.
• Assisting Developers at different stages of Software development Life cycle
• Expertise in writing libraries, complex functions, stored procedures, Ad-hoc queries and database triggers
• Migrated and Cloned oracle enterprise databases
• Strong analytical & logical skills
• Designed & Developed user friendly front end(GUI) applications
• Determining and implementing best practices for Oracle database setup, monitoring, backup and recovery, installation, auditing, performance tuning of instances and SQL queries, storage and memory management, setting up of High-Availability (RAC) and Disaster Recovery solutions.
• Diagnosing and debugging complicated performance, connectivity, and security issues involving critical real-time financial applications.
• Supporting large Oracle database environments.
• Proficiency in support duties such as performance and tuning, monitoring, backup, recovery, auditing, etc.
• Performing Logical and Physical Database Design
• Oracle administration of both development, and high-availability production systems.
• Assist in the ongoing architecture of a scalable, reliable, high performance production systems/web sites.
• Develop and maintain disaster recovery preparedness for real-time financial systems.
• Develop and maintain system security policies and procedures.
• Develop documented information such as procedural policies and configuration records.
• Take part in a rotating 7x24 on-call technical support.
• Responsible for maintaining the large Enterprise Database systems.
• Administer, maintain, develop and implement data models and database designs, data access, and table maintenance for databases using Oracle 7.x,8i, 9i, 10g/11g Database.
• Perform upgrades and patch management of company's relational database management systems.
• Define and implement policies and procedures for ensuring the security and integrity of company databases.
• Resolve database performance, capacity issues, replication, and other distributed data issues during business and after hours as they arise.
• Develop scripts and programs using PL/SQL, MS DOS Batch, UNIX commands, and shell scripts to perform periodic data conversions of historical data, or support efficient operation of database systems.
• Develop and manage complex database backup and recovery procedures.
• Work with application developers and Report writers to review and design new database structures and schemas as needed.
• Created views, tables and wrote complex PL/SQL Database triggers to implement the business rules and maintain the data integrity.
• Act as an internal consultant from a database and application design standpoint to assist in review of the company's product development projects.
• Identify, learn and share knowledge about new technologies that will contribute to innovative solutions.
• Develop and maintain appropriate technical documentation of database environment.
• Provide written and verbal feedback on status of work efforts as well as status reporting of day-to-day production operations, overall systems/data issues, and system performance.
• Ensures that the company's databases are created and delivered toward the company's core purpose, consistently with its core values, and in support of planned business growth and objectives.
• Provide DBA support for Linux, Solaris and windows databases which includes installing and upgrading, instance creation, application database setup and database monitoring and tuning.
• Responsible for Development, Test, Staging, DR, failover and Production environments and provided technical support and guidance to project teams.
• Experience using RAC & DataGaurd technologies.
• Extensive experience developing disaster recovery plans to protect the reliability and integrity of corporate databases
• Extensive experience using SQL & PL/SQL Language and be able to write stored procedures, triggers, functions, libraries and scripts for enhancing application performance and experience using database support utilities
• Consulting Experience for application clients for connectivity via database API's or other middleware products
• Set up and design business objects, Oracle forms and reports.
• Perform database tuning and optimization.
• Resolved business related data processing issues for Oracle & SQL applications.
• Install, configures and tuned middleware real-time financial Applications.
• Create user accounts and grants and enforces security policies. Analyzes user requirements, procedures and problems to automate or improve existing systems and reviews computer systems capabilities, workflow and scheduling limitations.
• Analyzed and defined opportunities for new or improved business process solutions.
• Performed quality assurance tests for new and improved information systems.
• Experience in cloning the database and applications to support development and test instances.
• Ability to manage backup and scheduling of support jobs via crontab or OEM/10g Grid Control.
• Experience in applying and managing quarterly Critical Patch Updates.
• Create UNIX/Linux/Batch scripts in support of Oracle tasks. Manage alerts via a combination of OS scripts, Oracle Apps alerts facility, and OEM/Grid Control.
• Performed ETL Operations for large Enterprise Databases.
• Responsible for providing full support, coaching, and mentoring to team members
• Working closely with the project team members, team leads and Business unit users.
• Responsible for providing estimates for the database growth and suggesting hardware needs for the database server.
• Performs design/code reviews to make sure that the design/code adheres to sovereign standards and meets industry’s best practices
• Responsible for coordinating resources needed to quickly resolve operational problems
• Responsible for following project management / lifecycle development processes, procedures and database standards to achieve quality assurance.

Confidential

Sr. Oracle DBA

Environment: Oracle 11g,10g, 9i, 8i(SQL, PL/SQL), VB.NET, SQL Loader, OEM, Oracle Grid Control, Data Guard, RAC, BI, Warehouse Builder, ODBC, JDBC, Triarch, RDF, Erwin,Real Time Matching, TCSS, SUMMIT, Money Fund, Bloomberg, MKS, Business Objects, TOAD, VERITAS NET BACKUP, Bindview, Crystal Reports, Micro strategy, Unix, Solaris, Linux, Windows 2000, Windows2003

Responsibilities:

• Installed, configured and maintained OEM grid control and Oracle 10g database on multi platforms
• Upgraded Oracle 8i,9i to Oracle10g.
• Installed, configured and maintained Oracle RAC, DATAGUARD and Disaster Recovery environment.
• Tuned the clustered databases.
• Used Data pump, Export/Import and RMAN Utilities to perform database backups.
• Performed the database recovery from instance and media failure.
• Performed the advance Point in time database and Tablespace recovery.
• Improved the database performance by partitioning the very large database objects.
• Used Oracle utilities like Stats Pack, Tkprof for addressing performance bottlenecks.
• Performed database tuning by using various tools, like Oracle OEM Grid control, ADDM/AWR and SQL Tuning advisor tools
• Implemented the database security and access control using profiles, roles and privileges.
• Perform daily monitoring of Oracle instances using OEM grid control, TOAD, users, tablespaces, memory structures, rollback segments, logs, and alert.
• Applied critical patches on Oracle 9i and 10g databases using Opatch utility.
• Setup and support of Oracle replication
• Developed shell/Batch scripts to supplement the database monitoring jobs.
• Performed the Database Auditing.
• Applied the changes in the production environment after submitting the Change control.
• Performed capacity planning and sizing of databases
• Implemented the Oracle Replication to enable database fail over incases of disaster.
• Database activities include allocation and maintenance of Rollback Segments, Automatic Undo Management, table spaces, data files, redo log files, mirroring of redo log files across multiple disks.
• Performed the ETL operation and also used SQL LOADER utility to load CSV and flat files
• Performed logical and physical database design using Erwin tool.
• Configured and maintained the summit financial system by integrating with Reuter and Bloomberg system.
• Assist the technical director, and Capital Market team members with design, development, and administration of related financial tasks
• Experience using Metalink for research and resolution of Oracle exception.
• Extensive experience performing in a 24x7 real-time financial environment.
• Provide technical leadership in designing, modifying, developing, writing and implementing complex code and database architecture
• Develop and manage complex database backup and recovery procedures.
• Extensive experience using SQL & PL/SQL Language and be able to write stored procedures, triggers, functions, libraries and scripts for enhancing application performance and experience using database support utilities
• Take part in a rotating 7x24 on-call technical production support.
• Utilized UNIX/Solaris top,sar,vmstat commands to resolve disk I/O issues.
• Installed, configured and created an Oracle 11g TEST database environment
• Managed and Maintained PRODUCTION, TEST, DEVELOPMENT, STAGGING and DR environments.

Confidential

Software Consultant/ Sr. Application DBA

Environment: Oracle 9i, 8i(SQL, PL/SQL), Developer 2000(Forms, Reports), Designer 2000, PVCS, MS Access 2000,Data Junction 7.0, SQL Loader, OEM, ODBC, TOAD, XML, Windows 2000, 98,WinBatch

Responsibilities:

• Installed, Managed, configured and maintained oracle Databases.
• Managed and Maintained PRODUCTION, TEST, DEVELOPMENT, STAGGING and DR environments.
• Utilized RMAN for backup and recovery strategy
• Provided all kinds of DBA support to development teams as well as production support to various applications.
• Resolved users problems, recovered database on demand. Created and managed database objects.
• Partitioned large tables to improve the database performance.
• Reorganized the tables and indexes to remove data fragmentation.
• Used Statspack, tkprof and explain plan to tune SQL Statements.
• Used windows performance monitoring tool to identify the database I/O issues.

Confidential

Software Consultant/ Sr. DBA

Environment: Oracle 8i, 8.0.5(SQL, PL/SQL), Developer 2000(Forms, Reports), Designer 2000, PVCS, Data Junction 7.0, SQL Loader, OEM, ODBC,ARC Serv, UNIX, Windows NT/ 95,WinBatch

Confidential

Programmer Analyst/ Software Consultant

Environment: Oracle 8i,8.0 (SQL, PL/SQL),Developer 2000(Forms 5,Reports),ERWIN, SQL Loader, OEM,Solaris,Win 95/98

Confidential

Programmer Analyst/ Software Consultant

Environment: Oracle 8.0.5, Developer 2000(Forms 4.5,Reports), Designer 2000, PVCS, SQL Loader, OEM, ODBC, ARC Serv, UNIX, Windows NT/ 95

Confidential

Programmer Analyst / Software Consultant

Environment: Oracle 7.3 (SQL, PL/SQL), Developer 2000(Forms 4.5, Reports 2.5) UNIX, Windows NT.

Confidential

Programmer/Analyst

Environment: Oracle 7.3 (SQL, PL/SQL), Developer 2000(Forms 4.5, Reports 2.5), Windows NT and AIX