SUMMARY OF QUALIFICATIONS:

Oracle Certified Professional with Around 10 years of IT experience in managing Oracle 11g/10g/9i and its products in a variety of platforms like UNIX, AIX ,Linux, Solaris and Windows.

Excellent exposure with clients like Unilever, BNP Paribas, PepsiCo, Delphi, Cadbury, Onsemi, Arkema, Agilent, Neuland, Henkel, etc to ensure data integrity, capacity planning and disaster recovery needs.

Microsoft Certified Solutions Associate on data platform with TSQL knowledge.

Expertise in all aspects of the system development life cycle SDLC .

Experienced in SQL Loader, Export/Import, Data Pump and enforcing security by managing system and object level privileges.

Experience in RMAN duplication.

Experience in Data Guard as a disaster recovery solution. Cutting off and rebuilding standby database when there is maintenance on primary database.

Experience in Oracle ASM.

Experience in Oracle Real Application Cluster

Creating Standard Operating Procedure SOP Manuals and documentations.

Database upgrade from Oracle 9i to 10g and Oracle 10g to 11i

Patching the databases with quarterly CPU and One-off patches

Performance tuning using AWR/ASH reports, ADDM and advisory.

Database index maintenance with Rebuild/Reorganize.

Expertise in complete and point-in-time recovery scenarios

Experience in Oracle Enterprise Manager

Experience in analyzing execution plans and making queries faster

Experience in coordinating with vendor Oracle metalink for reporting bugs and work on resolution.

Knowledge of ETL using SSIS

Proficiency in performance tuning.

Performing backup and recovery of database.

Knowledge of shell scripting and vi editor

Knowledge of ITIL processes.

TECHNICAL SKILLS:

Operating Systems : Windows 2003/2000/NT, Linux, UNIX, Sun Solaris, AIX

Databases : Oracle 11g/10g/9i/8i, MSSQL server 2008R2 and 2012 , My SQL

Languages/APIs/Tools : SQL, PL/SQL, TSQL, SQL Plus, Legato, HP Monitoring tools, Statspack,

RMAN, AWR, ADDM, TKPROF, SQL profiler, Confio

Schedulers : Crontab, DBMS jobs, SQL server agent

Oracle Utilities : Datapump, EXP/IMP, SQL Loader, RMAN

PROFESSIONAL EXPERIENCE:

Confidential

SQL DBA

Responsibilities:

• Creating SSIS packages and setting up ETL using OLE DB Source, OLE DB Destination, Derived Column, Data Conversion, OLE DB command, SQL Task, Flat file Source, Flat file Destination, Conditional Split.
• Tuning stored procedures and TSQL scripts on VLDB 4TB size on MSSQL 2008R2
• Writing/refactoring Stored Procedures, triggers, cursors, user defined functions, tables, views and SQL joins and statements for applications.
• Writing Index rebuild and reorganize scripts to minimize fragmentation
• Setting up Linked servers to enable remote database queries.
• Using SQL profiler and execution plans to trouble shoot performance issue and suggesting alternate logics to improve the response time and throughput.
• Using performance monitoring software such as Solarwinds Confio to monitor and troubleshoot SQL server instance wide performance issues.
• Advising the client on appropriate replication strategy depending on the requirement.
• Writing weekly maintenance scripts for archiving large tables on weekly basis and scheduling through SQL server agent or through UC4
• Working with remote DBAs to ensure availability and backup of the databases.

Environment: MS SQL 2005/2008/2008R2/2012, Linux, AIX, Windows Server 2008/2008R2/2012, Windows 2008

Confidential

Responsibilities:

• Incident management, Problem management and Change management of relational databases as per ITIL standards and ensuring SLAs of database availability are met.
• Manage oracle data files and tablespaces and perform housekeeping if there is space crunch.
• Storage management through oracle ASM and different storage options like disk and SAN.
• Setting up and monitoring Dataguard Physical/Logical/Active as disaster recovery solution on 10g and 11g
• Monitoring and ensuring the availability of 11g RAC databases. Troubleshooting RAC issues such as node eviction and performance.
• Troubleshooting performance issues using statspack, AWR/ADDM/ASH reports and using oracle advisories.
• Performing object level refreshes using logical backups as per Application team's requirements.
• Logical backup of schemas, tables and full database through Datapump and conventional export, import utility.
• Troubleshooting ORA-600/ORA-7445 and other critical database related errors faced by application developers and end users. And reporting the bugs in Metalink by raising TAR and work on resolution.
• Implementing database RMAN online and offline backups with backup solutions like Legato and HP Data protector.
• Configuring automatic database monitoring using HP's management tool called DBSPI and through OEM
• Installing oracle binaries , creating new databases and setting up listeners as per client requirement
• Extensively done RMAN duplication/cloning from production to staging/integration/QA environment.
• Complete and point in time recovery Incomplete of databases from hot and cold backups as per end user requirement.
• Monitoring and managing databases/listeners through OEM.
• Working with cost based and rule based optimizers and adjusting optimizer modes to for best response time / throughput.
• Transportable tablespace cloning to save time if the required data is in few data files that belong to a particular table space.
• Responsible for Sarbanes Oxley Audit controls for the database environment, and working with client-side Audit team to fulfill any audit requirements.
• Deploying SQL code/packages into UAT, QA and Production environments during release. Used 'Release Me' web interface for the client BNP Paribas.
• Scheduling SQL Loader job to read input .CSV files and write them into a particular oracle table for analysis.
• Tracking and fixing invalid database objects.
• Enhancing performance through reorganizing and rebuild of indexes and creation of views.
• Experience in Unix shell script programming.
• Scheduling SQL scripts to track the growth of databases for capacity planning.
• Performed fish-bone analysis and pareto charts to identify the main root causes of outages and did Service Improvement Projects SIP to improve overall availability and productivity of the client environment.

Environment: Oracle 11g, 10g, RAC, Oracle Data guard, ASM Red hat Linux, AIX, UNIX, Solaris, HP UNIX, Windows 2003, and Windows 2008.