SUMMARY

• Over 15 Years of experience as Oracle DBA with 8i,9i,10g,11g on different Unix environments like HP - UX, IBM AIX, Sun Solaris, Linux and Windows servers.
• Over 2 years of IT Professional experience in Administration, Database Design and Support using SQL Server 2005/2008.
• Have experience of multiple database technologies Oracle, SQL Server and IBM Informix.
• Designed and developed plans to achieve high availability, scalability, performance of the Oracle RDBMS servers.
• Experience in setting up and managing 10g/11g Data Guard Physical/Logical standby.
• Experienced in Setting up and administering both Oracle 10g and 11g RAC instances.
• Administered databases using OEM (Oracle Enterprise Manager) and Grid Control.
• Experience installing and setting up grid control management service and management agents on target hosts.
• Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using RMAN Recovery Manager, on VERITAS Net Backup and TSM.
• Expertise in Configuring RMAN with Catalog /No catalog and worked on Point-In-Time Recovery and flashback.
• Disk Space Management involving managing archives, trace files and log files, space allocation to various table spaces and also capacity planning for new applications.
• Collecting performance statistics using Stats pack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor.
• Used TKPROF utility and Explain Plan for tuning SQL queries.
• Extensive Experience in Oracle Architecture, Optimization, Memory Tuning, Performance Tuning and troubleshooting.
• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
• Rebuilding of Indexes for better performance, User Management, Table space
• Expertise in Database Administration on Production Servers with Server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Extensive experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005 and 2008 on both Cluster and Stand-alone Environment.
• Database Design in Full, Bulk Logged, Simple Recovery Modes, Restoring Databases with Point in Time Recovery.
• Experience with configuring high availability and Disaster recovery scenarios like clustered environments, Setting up different topologies in replication (Transactional Replication, Snapshot Replication)
• Experience in Log Shipping (Configuration of source, Target and Monitor) Servers in SQL Server 2005
• Good understanding of High availability techniques Database Mirroring and Clustering
• Experience in working with Linked Servers, Distributed Transactions.
• Hands-on working experience with analyzing query plans, query optimization, performance tuning, managing indexes and locks, troubleshooting deadlocks.
• Running of Traces using the SQL Profiler tool, Performance Monitoring & Tuning using the Performance Monitoring Tool, Query Optimization, Client / Server Connectivity
• Experienced in configuring SQL Mail
• Creating and Maintaining Databases, Adding Users, Roles and Groups and assigning privileges according to the project needs.
• Used Indexes for improving query performance, lower storage and maintenance cost.
• Extensive experience in Data Center Migration projects.
• Excellent communication skills. Proactive, independent and easy-going.

TECHNICAL SKILLS

Languages: PL/SQL, T-SQL.

Databases: Oracle 10g &11G, MS SQL Server 2008r2/ 2008/2005, Informix

Operating System: Unix (HPUX, Solaris, AIX), Linux, Windows 2003, 2008.

Oracle Tools: RMAN, Datapump, AWR, ADDM, Enterprise Manager, Grid Control, WinScp

SQL Server Tools: SQL Server Management Studio, SQL Server Query Analyzer, SQL Server mail service, DBCC, SQL Server profiler

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Oracle DBA

Responsibilities:

• Installation of Oracle 10g and 11g oracle binaries and patching them with appropriate required patches.
• Installation of grid control agents and configuring databases on OMS.
• Setting up Oracle Dataguard standby for production databases.
• Worked on opening Dataguard standby database in Read/Write mode during day and back to standby recovery during night time to sync up with production using Flashback and creation of restore point technique.
• Have successfully used RMAN SCN based backup to recover standby database that was out of sync with production.
• Database conversion from RAC to non-RAC and moving them from ASM to filesystem for creation of non-prod environments.
• Changes to LDAP TNS connection entries for migrated databases.
• Administering and setting up of 11G R2 RAC and 10G R2 RAC cluster instances.
• Database Services creation for distributing the applications across multiple nodes in RAC.
• Defining Local Listener and Service names to create multiple services as per application team’s requirement.
• Extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,
• Database and application tuning, using EXPLAINPLAN, STATSPACK, AWR, ADDM, Partitioning, and re-building of indexes.
• Prepared the documentation for production loads and prepared the test cases.
• Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN database duplication.
• Worked on Backup Recovery Solutions using RMAN.
• Experience with Logical backups EXPDP/IMPDP, and also using them for non-prod schema refreshes from production.

Confidential, GA

Lead Oracle DBA

Responsibilities:

• Performed Oracle 10g & 11g Installations and configurations.
• Duplicated databases using RMAN 10g/11g.
• Have used RMAN duplication from PROD to a recovery environment for subset of user tablespaces as per application team’s requirements.
• Extensively managed and configured RMAN Catalog database for various RMAN backups.
• Administered 10G RAC, 11G RAC databases and experienced with ASM (Automatic storage management).
• Implemented physical Data guard for active Disaster Recovery.
• Involved in installations, upgrades, patchsets, critical patch updates.
• Performed performance tuning related jobs like general health checks and maintenance of databases using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports by finding wait events.
• Created and managed users, roles and profiles, audited and monitored databases and user access.
• Gathering of Oracle Database statistics.
• Used import/export utility and Data Pump utility to transfer data.
• Coordinated and communicated with Oracle Support for major database issues/ problems
• Managed and coordinated weekly team meetings to discuss past week issues, solutions and upcoming tasks and readiness of team to support.

Confidential, VA

SQL Server DBA

Responsibilities:

• Performed SQL software installations and created standalone and cluster instances as required.
• Simulate a copy of production databases into test databases for application upgrade testing.
• Involved in developing LOGICAL and PHYSICAL model of the database.
• Implemented logical backup plans for faster recovery of database objects in the testing environments.
• Developed procedures for doing regular jobs like truncating schemas and for moving day to day data to the Production environments.
• 24/7 support for the production environment.
• Created, scheduled and managed all the database maintenance plans using SSIS packages in all the SQL servers across the environment
• Identified, tested, and resolve database performance issues (monitoring and tuning)
• Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder
• Deployed SSIS packages on to the Production Database servers and scheduled them using SQL Agent.
• Maintained high availability of databases using Log Shipping.
• Worked in Clustered environment (Active/Passive) for high availability of servers.
• Managed security, logins, roles and permissions on different database objects..

Environment: MS SQL Server 2005/2008, SSMS

Confidential - Dow Jones, NJ

Sr. Oracle DBA

Responsibilities:

• Managing multiple RAC databases on Oracle 10g/11g.
• Responsible for administration and supporting Oracle 10g/11g databases.
• Managed database security by creating and assigning appropriate roles and privileges to the user.
• Upgraded the database from 10g to 11g.
• Deploying agents and configuring the targets for the Enterprise Manager.
• Experience with OEM for database administration.
• Developed procedures for doing regular jobs like truncating schemas and for moving day to day data to the Production environments.
• Extensively worked on SQL Performance tuning using Explain plan and AWR report.
• As most of the applications were built in-house, there was always interaction with the Application and the data architect team to tune the queries or the database.
• Refresh of database and schema, clone database as per the requests.
• Monitor the backup logs for any error and reschedule them.
• 24/7 support for the production environment.

Confidential America - Direct Brands, Inc., NY

Sr. Oracle DBA

Data Center Migration

Responsibilities:

• Planned and executed migration of 15 Oracle databases from sizes ranging from 20 GB to 2.5 TB.
• Handled critical issues which arrived during database migrations.
• Worked on both 32 bit Solaris & 64 bit AIX environments.
• Activities involved transferring data from original location SAN to destination datacenter SAN.
• Planned recovery in case of failure during data transfers.
• Responsible for the security, integrity, and availability of critical data.
• Successful configured database RMAN backup to IBM Tivoli Storage Manager.
• Worked on solving communication issues between different database servers after migration.
• Automated instance monitoring using cron jobs and shell scripts.
• Worked with Confidential offshore team to transfer knowledge to offshore DBAs and also setting up BMC patrol database monitoring tool.

Confidential, NY

Informix DBA / Oracle DBA

Responsibilities:

• Production support of Oracle and Informix database instances.
• Install and configured the Oracle software and patches.
• Setup database backup and recovery using RMAN.
• Tuning the database and the sql's for the quick output to the users by analyzing the AWR reports.
• Administering the database for the better space utilization, database security.
• Interacting with the client to better understand their needs.
• Monitoring and managing Informix database instances using ONSTAT commands and automating database alerts.
• Setting up database backup using ONBAR and ONTAPE utilities.
• Managing Dbspaces and chunks to make sure database has adequate space for the growing data.

Confidential, DE

IT Systems Developer

Responsibilities:

• Creating databases for development.
• Creating and maintaining database, objects under change management.
• Writing and tuning stored procedures, triggers, queries using I-SQL & SPL for all database related changes. Gather query plans and check that correct indexes are used for the best performance.
• Analyzing Monitor server reports to identify frequently used tables/procedures and provide improvements.
• Redesign the system to improving overall throughput by moving business users to a reporting database. Providing stored procedure replication to generate only relevant data for reporting databases.
• Write stored procedures and 4GL programs to generate repetitive reports for business users.
• Evolving and implementing best practices for existing and future databases.
• Analyze impact to database due to new business requirements.

Environment: HP-UX, Informix Dynamic Server 7.3, Informix 4GL, ESQL-C.

Confidential

Informix DBA

Responsibilities:

• Formulation, Implementation and Review of Backup and Recovery Strategy.
• Configure existing backup procedures.
• Maintaining Database and Server Security using user permissions and roles.
• Updating database statistics for improving performance.
• Checking Consistency of Database.
• Managing database Dbspaces and Log storage spaces.
• Setting/changing database configuration parameters.
• Setup warm standby and enterprise replication server.
• Monitor replication standby server and stable queues in replication environment.
• Support Application Release Management. Suggest and recommend options for various global data transfer for online tracking system.
• Troubleshooting of Server and Database related problems.
• Troubleshooting in Replication System Warm Standby setup
• Resource allocation and planning.
• On Call 24/7 on weekly basis.
• Checked and updated all the database servers for Y2K compliancy.
• Scripted in shell scripting for automating database monitoring and message log.

Confidential

INFORMIX Database Developer

Responsibilities:

• This was bank automation project for developing software for non-computerized banks.
• Got involved in the initial stages of a project with understanding need of a non-automated banks day to day work by sitting with bank user groups during the Conceptual Function, Technical Design and Construction of the project.
• Was part of a team responsible for analysis, system design, writing specification, data entry screen designs with complete bank automation as project goal.
• Was also responsible in finding and coding project wide common functions for checking customer accounts, limits, currency conversion, account balance etc. that can be called by other programs as needed.
• Created Informix 4GL screens and ESQL/C routines for various day to day transactions that are carried out at bank front desk.
• Also was part of development team to automate bank’s loaning functions.
• Helped juniors in development team with their problems.
• Assisted project lead in extensive testing of all modules and suggested meaningful changes in some of the processes.
• Was also part of initial implementation team to help bank branches to become computerized.