SUMMARY

• Over 7 years’ experience in IT industry.
• 5 years production experience installing, configuring, migrating, cloning, upgrading, patching and tuning oracle/MS SQL server database on windows and UNIX operating systems.
• Proficiency with database backup and recovery for disaster recovery.
• Experience with implementing DR solution, High Availability of database servers using Database mirroring and replications and Log Shipping.
• Experience with Real Application Clusters (RAC) and grid control architecture.
• Provided 24x7 on call production support.
• Experience troubleshooting configuration and installation issues with high availability options.
• Experience troubleshooting SQL issues by using various SQL Tools like SQL execution plans, SQL Trace, statistics, index tuning.
• Experience in Optimization, Security and Storage Management.
• Experience creating and configuring standby databases using oracle data guard.
• Experience with database performance diagnosis and tuning.
• Experience with Analysis Services, Reporting Services, and SQL Server Clustering.
• A team player, result oriented, self - motivated and ability to work independently.

TECHNICAL SKILLS

RDBMS: Oracle 11g RAC, Oracle 10g, 11g, SQL Server, MySQL

Operating System: Microsoft Windows 2003/2008/2012 , UNIX, LINUX

Programming Languages: PL/SQL, T-SQL, C#, UNIX Shell Script, PHP

Web Technology: HTML, CSS, JavaScript

Backup and Recovery tools: RMAN, Datapump Utilities(expdp/impdp), import/export, DataGuard

Database Management and tuning tools: SQL Plus, ASM, DGMGRL, ASSM, SQL LOADER, Oracle SQL Developer, TOAD, LSNRCTL, SRVCTL, CRSCTL, ADDM, OEM, AWR, Query Analyzer, SQL Profiler, Performance Monitor, Microsoft Clustering Services (MSCS), SSIS, SSRS, SSMS

PROFESSIONAL EXPERIENCE

DATABASE SPECIALIST II

Confidential

Responsibilities:

• 24x7 Production database support
• Involve in disaster recovery planning and a member of the security team
• Responsible for installing, upgrading and configuring oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented a new Oracle database backup & recovery strategy using RMAN and windows batch script
• Moving data between databases using Data Pump. Responsible for test and development database refresh.
• Develop and maintain PL/SQL code for Medicaid claim and remittance processing.
• Responsible for creating user accounts, Roles and granting required access permissions and privileges to the database users
• Written PL/SQL Stored Procedures, Packages, Functions and Triggers as need for problem solving purposes.
• Tuning production database environments for better performance and availability.
• Plan, coordinate and implement security measures to safeguard information against accidental or unauthorized damage, modification or disclosure.
• Troubleshooting database issues and raising service requests with Oracle support as needed.
• Tuning SQL queries and PL/SQL code for better performance.
• Developed Data scrambling procedure to refresh test DB for training and development purposes.

Environment: Oracle 10g, 11g, UNIX, windows server, OEM (Cloud control), RMAN, AWR, ADDM, DataPump, SQL*LOADER, DataGuard

DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Performed day-to-day tasks such as monitoring the production database, security and schema management, audit trails monitoring, space usage monitoring etc.
• Performed database cloning/refreshes development database and support the development team.
• Performed DR planning, backups and recovery (RMAN).
• Wrote PL/SQL stored procedures, functions, packages, triggers and SQL queries.
• Tuning SQL queries and PL/SQL code for better performance.
• Developed data dictionary and ER diagram for the production database
• Monitors database system details within the database, including stored procedures and execution time, and implements efficiency improvements.
• Monitored Health Check of database by background processes and by using OEM
• Installed Oracle patches using OPTACH.
• Analyzed trace and log files to determine and resolve potential problem areas.
• Designed and implemented redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets for Atlas Insurance
• Worked using WINDOWS and LINUX based systems and their scripting languages such as batch, shell scripts.
• Performed database transaction and security audits.

Environment: Oracle 10g, 11g RAC, windows server, Linux, ASM, OEM (grid control), RMAN, AWR, ADDM, DataPump, SQL*LOADER

WEB APPLICATION AND SQL DEVELOPER

Confidential

Responsibilities:

• Responsible for writing technical documents outlining project objectives, logic and code specifications
• Performed installation of SQL Server Service Packs.
• Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata).
• Worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Collaborated with other team members to review and update the disaster recovery plan
• Provided support for existing applications.
• Provided client training on Website's functionality and creating content.
• Identifying solutions and improving SQL Server queries to the optimal state for fast access and data retrieval.
• Created maintenance plans to perform index de-fragmentation, re-indexing and update the index statistics.

Environment: ASP.NET, SQL Server 2005, Windows 2003 Server, T-SQL, JavaScript, CSS, HTML, Joomla, C#, Wordpress, Crystal Report