Objective

To work as Sr. Oracle and SQL Server DBA/Developer/Architect on Information Technology projects.

Summary

• 24 years of experience in database administration and architecture, design, data modeling, software architecture and development related to client server and web applications, systems integrations.
• Experience in leading a team of professionals including DBA and Software Engineers, project management, project analysis, project integration, project estimation and budgeting, project implementation, documentation, user communication.
• Experience in Database Administration, SQL Performance Tuning, UNIX Administration, generating Performance and DB growth Reports.
• Strong skills in Oracle and SQL Server as DBA, RAC, ASM, RMAN, Data Guard, PL/SQL, Stored Procedure, Package, Trigger, Oracle AQ, Pro C, SQL PLUS, SQL Loader, Data Pump, SQL Server 2005/2008, Sybase, SQL Server, DB2, Informix, Unix, Shell scripts.
• Setup of Oracle database and ASM file system for RAC Standalone databases.
• Involved in designing, executing DR plans and DB switchovers to support resiliency for high availability applications.
• Experience in applying vendor-provided software upgrades and patches to the database management systems and applications software, where database-specific expertise is required.
• Supported several large OLTP, DSS and DW database systems up to 10 TB in size.
• Experience in Installation, upgrade and maintenance of Oracle software and other applications.
• Experience in .Net, C , Power Builder, Java, XML, RUP, Rational Robot, Web Sphere, MQ, Tuxedo Administration, J2EE, Servlets, Applets, JDBC, JSP, Java Beans, RMI
• Extensive knowledge of business processes in Power Generation, Health Care, Finance, Rail road industries.

Computer Skills

• DBMS Oracle 11g, 10g, 9i, 8i, 8.0.x, 7.x, SQL Server 2000/05/08/12, RAC, ASM, Stored Procedure, Package, Trigger, Oracle AQ, Pro C, SSIS, SSRS, T-SQL, SQL Lab, Sybase 10, MS SQL, Watcom SQL, DB2, Ingres, Informix
• Tools SQL PLUS, SQL Loader, Data Pump, SQL, PL/SQL, ERWIN, SQL Developer, OEM GRID Control, TOAD, RMAN, SQL CRT
• Languages C, Shell, Pascal, COBOL and Assembly
• O/S HP-UX 9/10/11i, TRU64 5.1, Digital VMS 7.1/7.2, Solaris 5.9/5.10, AIX 4.2/4.3/5.2, RHEL 3/5 Linux , Windows 98/NT/2000/2003/XP
• GUI .NET 2005, ASP.net, C .net, VB.net, Power Builder 9.0, Java 2, Servlets, JDBC, Access, PVCS, CMVC, Team Connect, Exceed, Kea-X, Clear Case, Clear Quest, XML, Oracle WebLogic 10.2, IBM WebSphere MQ v6.0, RUP, Rational Robot
• Others UNIX Internals and Administration, Novell NetWare, Tuxedo, MQ Series

Projects

Confidential

Environment : SQL Server 2000/2005/2008/2012, T-SQL, Performance tuning, Windows XP, SSIS/SSAS/SSRS, Idera Diagnostic Manager,TortoiseSVN

Working as SQL Server DBA:

• Installing, upgrading, and patching database software
• Configure Always on high availability groups, log shipping, mirroring, replications
• Setup maintenance plans and SQL Agent jobs for backup, update statistics and index rebuild
• Database architecture work to define memory size, CPU requirement, Hard Disk configuration
• Migrate databases, code changes, ticket and change request implementation
• Install and Migrate SSIS/SSAS/SSRS packages, used TortoiseSVN to manage source code
• Setup SSRS reports on reporting server including security, data sources and subscriptions
• Monitor executions and performance of SSIS packages using Pragmatic workbench
• Troubleshoot Performance issues and deadlocks using Idera Diagnostic Manager, review database reports, SQL and database tuning
• Support database related production issues, reporting and SSIS packages, storage issues
• Setup logon triggers, SQL Server profiler for tracing, login security and AD groups, data encryption, auditing

Confidential

Environment : Oracle DB 10g/11g, RAC, TOAD, PL/SQL, T-SQL, SQL Server 2005/2008, Performance tuning, Windows XP, GIS, AEI

Working as Sr. Oracle developer/DBA on following projects:

• Installing, upgrading, and patching database software
• Troubleshoot Performance issues, review database reports and recommend and implement solutions, which include queries tuning, indexes, database design changes
• Supported application team to design database objects and tables and develop database procedures and triggers to meet their requirement
• Work with Data Architect to meet their standards for database object definitions and code migration
• Support database related production issues, data locking, storage, client connection issues
• Train ID Identification: Worked on train id identification project using train passing time, HBD device id and direction , dispatch data p29 , GIS engineering mile post data and GPS ping data.

Confidential

Environment : Oracle DB RAC 10g/11gR2, Oracle ASM 11G, TOAD, PL/SQL, SQL, RMAN, EM GRID 10g, Data Pump, Streams, DataGuard, SQL Server 2005/2008, Sun OS 5.10, RHEL 5, Shell scripts, Windows XP, PLSQL Developer, .Net

Working as Sr. Development Oracle DBA on following projects:

• Create and maintain test database environments on standalone, VMware and RAC.
• Migrate 10g DB to 11gr2 DB and file system storage to ASM.
• Setup and manage Oracle streams, DataGuard for data replication.
• Support application performance tests and monitor resources, EM Grid control, alerts and logs.
• Troubleshoot Performance issues, review AWR and ADDM reports Oracle Diagnostic Pack and recommend solutions to Apps teams, which include queries tuning, indexes, database design changes
• Performance tune OLTP system queries and ETL batch jobs, review application screens DML operations, production top 100 queries, execution plans using gather statistics, tkprof, SQL tuning advisor and database views info
• Supported apps teams in PL/SQL code development with best database practices
• Design and implement ETL solution using PL/SQL scripts

Confidential

Environment : Oracle DB 10g/11g, RAC 10g/11gR2, Oracle ASM 11G, TOAD, PL/SQL, SQL, RMAN, EM GRID 10g, Data Pump, Streams, DataGuard, Sun OS 5.10, RHEL 5, Shell scripts, Autosys job scheduler, Oracle Weblogic 10.2, Windows XP, PLSQL Developer,

Working as Oracle DBA technical lead on following projects:

• Managing a team of 8 Oracle DBAs to support OLTP database, data warehouse and repository databases.
• Create and maintain test database environments on standalone, VMware and RAC.
• Setup Oracle 11G ASM file system for RAC standalone DB.
• Migrate 10g DB to 11gr2 DB and file system storage to ASM.
• Setup and manage Oracle streams, DataGuard for data replication.
• Support application performance tests and monitor resources, EM Grid control, alerts and logs.
• Troubleshoot Performance issues, review AWR and ADDM reports Oracle Diagnostic Pack and recommend solutions to Apps teams, which include queries tuning, indexes, database design changes
• Provide solutions for data archiving and performance issues with DDL operations for high transactions OLTP modules using table partitions and different tablespaces
• Developed automated rman scripts for backup, restore and duplicating. Used Data Pump for data backup also during testing.
• Performance tune OLTP system queries and ETL batch jobs, review application screens DML operations, production top 100 queries, execution plans using gather statistics, tkprof, SQL tuning advisor and database views info
• Analyze other data replication tools like goldengate instead of streams.
• Supported apps teams in migrating their data from 10g to 11g Databases and resolved application issues with DB.

Confidential

Environment : Oracle DB 9i/10g/11g, RAC 10g/11g, Oracle ASM 11G, PL/SQL, SQL, Java, RMAN, EM GRID 10g, Data Pump, Dataguard, Sun OS 5.10, RHEL 5, Shell scripts, Oracle Weblogic 10.2, IBM WebSphere MQ v6.0, Windows xp, PL/SQL Developer, Rational CC CQ

Worked as Sr. Oracle DBA/Team Lead on following projects:

• Create and maintain test database environments on standalone and RAC.
• Install, configure and maintain RAC in production for BI Wells and eMSP databases
• Participate in DR activities to configure servers, data files and restore databases
• Perform storage capacity planning and coordinate and maintain database space
• Setup Oracle 11G ASM filesystem for RAC standalone DB.
• Migrate 10g DB on filesystem to 11g DB on ASM.
• Did set up of EM Grid to monitor all preprod environments and alert through emails.
• Troubleshoot Performance issues and recommend solutions to Apps teams.
• Worked on Shell scripting to fix the bugs in their existing scripts and developing new scripts for Linux environments.
• Developed automated rman scripts for backup, restore and duplicating. Used Data Pump for data backup also during testing.
• Document the problems noticed in scripts and Databases, recommended solutions and the details of implementing the solutions.
• Applied data compression on BI DW database with 4TB size to reduce the size to 1TB, processed ETL load scripts, Setup services for OLTP RAC database
• Support applications running Oracle WebLogic app servers.
• Supported apps teams in migrating their data from 9i to 10g/11g Databases and resolved application issues with DB.

Confidential

Environment : Oracle 8i/9i/10g, 10g RAC , PL/SQL, SQL, Dataguard, RMAN, HP-UX 11i, Sun OS 5.10, RHEL 5, Windows XP / 2003, SQL Plus, SQL Loader, Grid Control, SQL Server, DB2, AQ, MQ, SOA, Java, XML, Web Sphere, RUP, Shell Scripts, SSIS, SSRS, .Net, Tuxedo, PVCS, Clear Case

Worked as Sr. Oracle DBA/Enterprise Architect on following projects:

• Create and maintain development and test database environments on standalone and RAC. Did setup of 10gR2 RAC on Linux platforms.
• Applied Oracle patches to databases and upgraded different environments.
• Worked on setup and migration of test data from production to different environments.
• Backup database using different RMAN techniques, like exclude read only and index TS, full and incremental backup, incremental merge backup, data pump
• Troubleshoot Performance issues and recommend solutions to Apps teams. Review AWR, ADDM, index performance and perform load test and database failover tests
• Worked on Shell scripting to fix the bugs in their existing scripts and developing new scripts for Linux, SUN and HP environments.
• Document the problems noticed in scripts and Databases, recommended solutions and the details of implementing the solutions.
• Supported apps teams in migrating their data from 9i to 10g Databases and resolved application issues with DB.
• Worked on EM grid control setup and deploying agents on to Servers.
• Designed and developed database DDL and DML scripts to meet development application requirement for tablespaces, security and roles, SGA and other memory configurations for both OLTP and ETL applications
• Design and development of shell and database scripts for data loads and conversion of DB2 data to Oracle
• Worked with development team to design data model and architect solution for database components
• Worked with SA, Integration Architect, Application Server Admin, Unix Admin to resolve infrastructure and database related issues
• Define Service Oriented Architecture for Java middle ware layer, so services could be published for use by many consumers
• Define interface layer and API between different components of DB2, Java middle ware, GUI and Oracle database stored proc
• Define MQ, AQ and tuxedo queuing interface for transaction processing with load balancing and security consideration
• Architect, design and develop automation and workflow tools for health care business and integrate systems to improve efficiency for claims processing
• Developed SSIS/SSRS packages, reports and stored procedures for data migration and reporting purpose for .Net application.

Confidential

Environment: Window NT, Unix, C, Java, Oracle, PL/SQL, DB2, IMS, Access, Team connection, MQ Series, Shell Scripts

Worked on following projects as Sr. Developer:

COPS Customer Order Processing System

• Design and development of application modules, customer profile and equipment order, global tracing, call routing, bill of lading, imaging, facility management and EDI.
• Senior developer for application development in C, Oracle
• Developed Oracle Stored Procedures, Packages, and triggers
• Performed DBA activities like performance tuning, creating synonyms and indexes
• System analyst and release coordinator for the Build Team
• Provided assistance to develop facility management module in Java.

CSX Purchasing system

• System provides various reports, graphs and queries option to display the company purchase data in different formats. It is implemented in 32bit and 16bit environment.
• Involved in application maintenance and client site Implementation.