OBJECTIVE:

To add value to IT enabled organizations by supporting backend IT infrastructure, database support, software development, self service automation, project/team management by using the best of my technical skills and varied experiences accumulated through the years. Looking for a career in senior profiles like Database Manager, IT Infra Manager, Project Manager, DB Architect/Solution Architect.

PROFESSIONAL SUMMARY:

Professional with 15 years of IT experience as Oracle DBA (9 yrs), SQL Server DBA (5 years), software developer, trainer (1 years). Having exposure to other databases like mySQL and DB2. Certified Oracle database professional. Worked as individual contributor, team lead and people manager.

TECHNICAL SKILLS:

Core Skill Area: Database Administration (Oracle, SQL Server)

RDMBS: Oracle 9i, 10g, 11g, 12c, Microsoft SQL Server 7, 2000, MsAccess

Oracle Tools: 12c Cloud Control, Data pump export/import, RMAN, ASMCMD, CRSCTL, SRVCTL, RAC, DATAGUARD, Golden Gate

Languages: SQL/PLSql, Visual Basic 6, ASP, PHP, HTML

Operating Systems: Windows NT/2000/XP/2008, Redhat Linux, Oracle Linux

Other Tools Used: 10g Dev Suite, D2K, Toad, SQL Developer, Secure CRT, Putty

Virtualization Exposure: vmWare Workstation, Virtual Box, vSphere

PROFESSIONAL EXPERIENCE:

Confidential

Environment: Oracle 8i, Oracle 9i, 10g, 11g, 12c on Linux/Solaris/AIX Platforms

Sr. Oracle DBA

Responsibilities:

• Working environment housing a few thousands multi terabyte Oracle databases running on Unix/Linux platform using physical servers and VMs.
• Daily work intake using ITIL based ITG ticketing tool for client's works like User Administration, Role grants, DDL/DCL Script Execution, Database Refresh, Schema Refresh, RMAN Database Backup, exports/imports.
• Worked as people manager Tracking work intake, assigning tasks, monitoring progress for Junior DBAs (5) and providing technical guidance whenever required.
• Supporting production changes, incidents, problems through HPSM ticketing tool (A product of HP)
• Worked on DBA On call support in weekdays and weekends by rotation.
• Monitoring of Oracle Grid Alerts, Down Events, Space Warning, standby database out of sync alerts.
• Pro - active table space monitoring and space provisioning to avoid space alerts.
• Database migration between different data centers, database consolidation within data centers.
• Taken part in data center disaster recovery testing as part of oracle team.
• Worked on patching/upgrade activities of databases, CRS/ASM.
• Daily and weekly backup monitoring and failure remediation.
• Real Application Cluster (RAC) setup, RAC node addition, database installation, oracle client software installation, data guard implementation using physical standby database, golden gate replication implementations.
• Undertaken hiring activities by taking telephonic and face-to-face technical interviews.
• Mentoring new hires, arranging Knowledge transfer sessions, grooming junior DBAs.
• Preparation of process documentations (SOP), guidelines for various DBA activities
• Creation of shell scripts for supporting self service database management automations.
• Diagnosing of database performance glitches using AWR reports, top command, tkprof and query tuning by using explain plan.

Confidential

Responsibilities:

• Database Backups, User management, session management, object lockouts, jobs execution and monitoring, updating functions and procedures when business logic changes, monitoring of serving queues and take action for failed servicing queues.

Confidential

Application support DBA

Responsibilities:

• I was the production support DBA, Database Architect for this 10g database in Windows environment.
• Supporting Java Developers, MIS portals developers by creating Stored procedures, Tables, Indexes, Users and grants, database designs, query tuning.
• I was the point of contact for all database related activities. Backup, restore, schema refresh, data move using db links, creation of shell scripts etc were major responsibilities.

Confidential

Principal DBA and development lead

Responsibilities:

• Mentored a group of Junior DBAs, D2K forms/reports developers and PHP developers.
• Creation of RAC cluster, RMAN Backup, Recovery, export/import, shell Scripting, Performance tuning, database designing, user administration, table-space management, client installations, database process monitoring, database migrations were major activities.
• Got chance to work in several internal projects in the capacity of a project lead and reporting to project managers/edp managers.
• Linux server administration, Windows AD administration, Oracle Application Server (10g) administration, Firewall administration and intranet network administration were the responsibilities of my team. This was a varied experience altogether.

Confidential

Responsibilities:

• This was a software for integrated production resource management system designed for custom production scenarios like an ERP with VB6 as frontend and SQL 2K as backend database.
• My activity was to lead the dev team for development of additional forms and modules as required and providing necessary development DBA support apart from core SQL DBA activities. Client configuration, Confidential connections setup, software provisioning, database backup, restore, active-passive MS SQL database cluster monitoring and failover etc were major activities along with Active Directory administration.
• This was a training assignment aimed to enhance the IT skill set of the people of the Confidential .
• Many people participated in these training sessions in multiple sessions. I was part of the faculty providing training on windows administration, software development using VB6, SQL Server, MS Access, ASP, PHP and basic networking concepts.