.SUMMARY

• More than Ten (12) years of IT experience with expertise in Database administration of Oracle 11g/10g/9i/8i and MS - SQL 7.0/ 2000/ 2005/2008/2012 , and Oracle RAC on UNIX, HP-UX, RHEL, Sun Solaris, AIX and Windows environment for Production/STG, Development/UAT and test databases.
• Hands on experience in installation, configuration, performance tuning, backup, recovery, up gradation, database design (logical and physical design), migration and support of database
• Installed and configured MS-SQL 2000/ 2005/2008/2012 on windows servers.
• Migration of MS-SQL production DB’s from and R2.
• Provided 24x7 production supports to ensure smooth functioning of client business.
• Proven high-level expertise in design, configuration, implementation, maintenance and migration of Oracle databases.
• Sound working knowledge in Windows, Solaris, AIX, HP-UX and RHEL.
• Experience in full (SDLC) software development life cycle.
• Implemented Oracle 11g/10g RAC (Four nodes with ASM) for HA.
• Implemented various replication solutions using MS-SQL log shipping, Oracle Data Guard and Oracle Streams for High Availability.
• Extensively used Backup/Restore, RMAN, Sql Loader, Data Pump, export and import utility.
• Working experience on reorg/reindex of database objects.
• Has used Shell Scripting and T-SQL for automatic moving and purging of archive files based on time.
• Consulting in Functional as well as Technical aspects of ERP & Financial software’s (Lawson, Cost point). Implementation for Client and Custom Software Development.
• System Requirement Analysis & Needs Assessment based on User Interaction.
• System Architecture Design and Application Design based on Business Logics.
• Possess strong fundamentals and understanding of RDBMS, Client-Server Systems, T-SQL and PL/SQL.
• Extensive experience in writing and debugging complicated SQL’s
• Worked on CITRIX for remote server connectivity
• Worked in SOX compliance DB environment.
• Ability to analyze Oracle diagnostic reports, trace files and alert logs and SQL ogs.
• Experience working on Logical & Physical Design of Databases.
• Implemented ITIL process.
• Good Experience in working under tight deadlines and also providing round the clock support.
• Extremely motivated individual with excellent communication/Interpersonal skills.

TECHNICAL SKILLS

Platforms: Windows-2003 EE, Win-08/Vista/XP/NT/2000, Server RHEL 3.0/4.0/5.0/6.0 , Sun Solaris9.0/10.0, HP-UX (Itanium/PARISK) 11.11/11.23/11.31 , AIX 6.0

Databases: Oracle 12c/11g/10g/9i/8i, MS-SQL Server 2005/2008R2/2012, MS-Access /2007/2010, Teradata 12/13/14

RDBMS Tools: Oracle 12c/11g/10g RAC, Data guard 11g/10g, Oracle Enterprise Manager Grid 10g/11g, SQL*Loader, Oracle Schema Manager, RMAN, SQL Trace, TKPROF, Import/Export, DBA studio, Oracle Streams, Clusterware, Oracle Expert, SQL Analyze, ADR, Oracle DG 10g/11g, Wan Sync, NetApp, Grid Infrastructure.

Software/Languages/GUI: T-SQL, C#, Perl, pl/sql, XML, HTML, DHTML, VB Script, TOAD, Visual Basic 6.0, Visual Interdev 6.0, FrontPage 2000, E-commerce fundamentals, E.D.P, Data Mining (Concepts), marketing on Net, ExNextGeneration1.5 (TCS-EX), Cost Point, Citrix, Cognos, Lawson ERP, IIS, BEA Web Logic, DB Artesian

Reporting Tools: Crystal report 8.0, SSRS

MS-Office: Word, Excel, Access, Outlook, Outlook Express and Power point.

Data migration: DTS, SSIS, BCP, SQL Loader, Import/Export Wizard.

OLAP and ETL Tools: SQL Server Analysis Services (SSAS)

Monitoring Tools: SQL Server Profiler, Performance Monitoring and Oracle OEM Grid 11g/12c, Quest Fog Light, HP-BSM

Key Domains worked on: Financial, Insurance, Healthcare, Education.

PROFESSIONAL EXPERIENCE

Confidential - NYC

Sr. Oracle / Ms-Sql DBA

Responsibilities:

• Supported environment with more than 3000 Ms-Sql databases and 500 plus Oracle instances ranging from 100 GB to multi terabytes.
• Installed and configured Oracle 12c/11g/10g on AIX / RHEL environment.
• Implemented 10g/11g/12c Grid control on Windows/Unix platform and created customized UDM’s.
• Implemented two nodes RAC 11gR1/R2 on AIX (Multiple life cycles).
• Implemented four nodes RAC 11g R2 on RHEL 6.0
• Implemented 11gR2 Data Guard between 11g RAC nodes.
• Implemented backup strategy using RMAN (Incremental), HOT and Logical for different databases as per need.
• Implemented 11g Grid Control on Windows/Unix OS and configured multiple targets
• Performed annual DR drill using 11g Snapshot Standby method.
• Written shell scripts to automate most of daily DB monitoring jobs.
• Configured VM with oracle tools for all clients.
• Created service request to vendor in case of any bugs in database.
• Upgraded from 11.1.1.0.6 to 11.2.0.3 and applied related GI patches.
• Upgraded (CRS/ASM/DB) from 11.1.0.7 to 11.2.0.3 and applied PSU patches.
• Used Opatch Auto to apply PSU patches on all RAC components.
• Provided all data required for SOX/HIPPA compliance DB auditing.
• Installed and configured MS-SQL 2000/ 2005/2008/2012 on windows servers.
• Migration of MS-SQL production DB’s from R2.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible for all routine DBA jobs like Backups/Restores.

Environment: Oracle12c/11gR2/10g, 11R2-Grid-Infrastructure, ASM, MS-SQL 2005/2008/2012 , Grid Control 11g/12c, RMAN, TOAD, PL/SQL Developer, EXP/IMP, Data Pump, Oracle Enterprise Manager, Explain plan, TKPROF, DBA studio, SQL*Loader, SQL*Plus, IBM-AIX, Windows /2012, SQL*Net, AWR, ADDM, Citrix Meta frame, Idera SQL Safe Idera, Service Now, In Touch, Quest Fog Light, HP Monitoring tools, MS-Sql Replication / Mirroring

Confidential, Bridgewater - NJ

Lead Oracle / MS-SQL - DBA

Responsibilities:

• Installing and configuring Oracle 11g/10g/9i on HP-UX / RHEL /Windows environment.
• Monitored and modified Performance using execution plans and Index tuning.
• Responsible routine DBA jobs like Backups and Restores.
• Implemented two nodes RAC 11gR1/R2 on HP UNIX Itanium 11.31 (Multiple life cycles).
• Implemented 11g Data Guard between 11g RAC nodes.
• Implemented backup strategy using RMAN (Incremental), HOT and Logical for different databases as per need.
• Implemented 11g Grid Control on Windows/Unix OS and configured more than 60 target
• Performed annual DR drill using 11g Snapshot Standby method.
• Written shell scripts to automate most of daily DB monitoring jobs.
• Configured VM for all clients.
• Created service request to vendor in case of any bug in database.
• Implemented failover/switchover for Oracle database using third party tool WAN SYNC and post maintenance of same.
• Implemented 10g/11g/12c Grid control on Windows platform and created customized UDM’s.
• Installed and configured MS-SQL 2000/ 2005/2008/2012 on windows servers.
• Migration of MS-SQL production DB’s from and R2.
• Downgraded database from MS-SQL for some projects.
• Checking Database Health by using DBCC Commands and DMVS
• Individually handling multiple Oracle 8i/9i/10g/11g and MS-SQL 2000/2005/2008 databases approx 50 (Prod, Dev, Standby and test) with size ranging from 1 TB to 100GB.
• Writing shell scripts to automate most of daily DB monitoring jobs.
• User administration - roles, privileges, security, backup and restoration activities.
• Managing primary and standby databases.
• Query Optimization using SQL Tuning Advisor.
• Monthly Maintenance Week for reorganizing database and Clearing/Purging.
• Implemented DB securities by creating a customized verify function and setting other security parameters as per customer need.
• User administration - roles, privileges, security, backup and restoration activities
• Hosted all database on Citrix to access from any location.
• Implemented failover/switchover for Oracle database using third party tool WAN SYNC and post maintenance of same.
• Keeping track of processes, memory, paging, block IO, traps, and cpu using command like VMSTAT, IOSTAT, NESTAT, WATCH and PS.
• Also responsible for selecting the best UNIX box for client’s application, with respect to number of CPUs, the load balancing and also setting the environment variables and do the capacity planning for these boxes

Environment: Oracle 11g/10g/9i/8i, MS-SQL 2005/2008/2012 , 10g/11g Grid Control, RMAN, TOAD, PL/SQL Developer, EXPORT, IMPORT, Data Pump, Oracle Enterprise Manager, Explain plan, TKPROF, DBA studio, SQL*Loader, SQL*Plus, HP-UX, Windows, SQL*Net, AWR, ADDM, Citrix Meta frame, WAN Sync, LAWSON ERP, Teradata 12/13/14, Lawson 9.0

Confidential

Oracle / MS-SQL DBA

Responsibilities:

• Defined new database structures, data conversion strategy, specifications and routines in co-ordination with application development team.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Responsible to Monitor and troubleshooting Log Shipping.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Maintaining the database consistency with DBCC at regular intervals.
• Installed, configured 10g RAC environment with ASM on windows 2003 for testing, development and production environment. Also created standby for same using RMAN duplicate.
• Understanding the existing setup and implementing standard database concepts, practices, and procedures.
• Carried out Optimizing performance and Query tuning using ADDM, AWR, DBMS scheduler, tkprof, Explain plan, Oracle Expert, OEM.
• Database design and support, Performance tuning and security Management, Capacity planning (Identify the usage pattern and suggest improvement in performance) and Change Management.
• Manage and maintain database and user security.
• Database design/architecture experience using both logical and physical modeling.
• Developed monitoring/health check scripts to alert team of database uptime/downtime status, sizing issues, which ensured availability 99.98% of the time.
• Using Oracle Enterprise Manager (OEM) for database scheduling activities
• Keeping track of system performance using commands like SAR in Sun Solaris
• Trained and mentored other Jr. DBA in team.

Environment: Oracle 10g/9i/8i, PL/SQL, RMAN, Data guard, TOAD, PL/SQL Developer, Exp/Imp, OEM, SQL*Loader, SQL*Plus, SUN Solaris 9.0, Shell scripting, MS-SQL 2000/2005, Oracle 10g RAC, Data Pump, Oracle Enterprise Manager, Explain plan, TKPROF, DBA studio, Windows NT/, Oracle warehouse builder, Automatic Storage Management (ASM), SQL*Net, AWR, ADDM, Cognos, Cirix.

Confidential

Oracle DBA

Responsibilities:

• Administration of NCDEX Surveillance System developed on Oracle 9i and Linux.
• Installation, Configuration and maintenance of Oracle 9i Database on Windows and Linux platform.
• Relocation of Databases from one server to another server using attach and detach databases.
• Involved in up gradation of Confidential Database.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Performance monitoring/tuning/troubleshooting on Oracle with Linux.
• Generating reports as per user requirements using Business Objects 6.0
• Performing daily checklist for smooth functioning of system.
• Performing Database and application Cloning esp. before the PROD Patch
• Troubleshooting technical and functional issues related to surveillance system
• Automating monitoring jobs by cronjobs and writing shell scripts.
• Applying Database patch sets. Extensive Usage of Oracle OEM for patching.

Environment: Oracle 9i/10g, MS-SQL 2000/2005, PL/SQL, RMAN, Data guard, TOAD, PL/SQL Developer, EXPORT, IMPORT, Oracle Enterprise Manager, SQL*Loader, SQL*Plus, RHEL, Pro C, Unix, Shell scripting.

Confidential

Oracle / MS-SQL DBA

Responsibilities:

• Establishing the needs of users.
• Monitoring MS SQL Server performance and managing the use of disk space, memory and connections.
• Running DBCC consistency checks, fixing data corruption on application databases.
• Creating & identifying various databases.
• Commissioning and installation of database application.
• Upgrade of the application & Databases
• Troubleshooting database & application related issues
• Controlling access permission and privileges.
• Testing the system.
• Writing process documentations.
• Implemented manual standby at UK for DR plan.
• Meeting users new access requirements and resolving their queries.
• Ensuring that storage, archiving, backup & recovery (Using RMAN, Export/Import, EBU) procedure are functioning correctly for the database /application servers.
• Working closely with IT team.
• Providing support to local & international users.
• Used Cognos as an ETL tool.
• Coordinating with respective software vendor for latest patch release and fixing bugs if any.

Environment: Oracle 8x / 9x, MS-SQL 7.0/ 2000, PL/SQL, RMAN, TOAD, PL/SQL Developer, EXPORT, IMPORT, Oracle Enterprise Manager, DBA studio, SQL*Loader, SQL*Plus, Windows NT 4.0 /, Oracle warehouse builder, Cognos, CITRIX, EBU, Veirtas backup utility, Cost Point.

Confidential

Oracle / MS-SQL - DBA

Responsibilities:

• Installing and configuring MS-SQL Server / Oracle Database and creation of Company database.
• Scheduling auto backup of company database through SQL server.
• Solving data corruption by passing SQL queries.
• Migration of data from different Apps version like Multi user (MS-SQL 7.0/ 2000) - Single user (MS-ACCESS 98/ 2000) and vice versa.
• Modifying vouchers as per client’s requirement Using Document Designer.
• Troubleshooting Functional and Technical problems related to ExNgn and MS-SQL 7.0 database on site at client place.
• Backup and recovery, database performance monitoring and tuning, general troubleshooting from failures
• Creating Users at different levels and providing rights accordingly.
• Migrating data from Access to SQL and vice versa.
• Performing Year ending and closing of books through SQL server.
• Implementing TCS-EX on site in multi user and single user environment and providing post implementation support.

Environment: Oracle 8i/9i, MS-SQL 7.0/ 2000, MS-ACCESS 97/98/2000, Windows NT 4.0 /, VB 6.0, Crystal report, VC++, Doc designer, TATA-EX, CITRIX.