CAREER SUMMARY:

An accomplished information technology with over 12 years expertise in designing, developing, and maintaining Oracle and SQL Server databases for the healthcare, finance, publishing and manufacturing industries. Working experience with Oracle’s high availability features like RAC and Oracle Streams. Experience in Oracle database migration, cloning, cross - platform migration, RMAN backup & recovery. Demonstrated experience in installing and administering Microsoft SQL Server 2000, 2005 and 2008. Extensive on-hands experience with Microsoft SQL Server versions 2000, 2005 and 2008. Extensive on-hands experience with Red Hat Linux, IBM-AIX, Sun-Solaris and Microsoft operating systems. Experience in administering Weblogic application servers as well as support and maintain large and small scale databases.

PROFESSIONAL EXPERIENCE:

Confidential, West Des Moines, IA

Sr. Database Administrator

Responsibilities:

• Facilitated as Oracle Database Administrator (DBA) on Federal Government contracts .
• Provide on-call support on one CMS contract in development and quality assurance environments, enterprise monitoring of databases and application servers on all CMS contracts in development and quality assurance environments.
• Troubleshooting and coordinating with system administrators, network engineers and backup team members during escalations for Oracle 11g and 10g databases, and application Server 10gR3.
• Communicate and partner with internal customers to decide deliverables and timeline on various mission critical projects.
• Daily Database Backup checks, alert log checks archive log destination checks, troubleshoot developer issues, and develop deployment scripts in different environments.
• Setup scripts for database backup and monitoring for oracle databases. Set up Auditing on database users.
• Time to time Database schema refreshes.
• Load data into different databases in different environments from Production requests.
• Reorganize tablespace as part of reorganization of databases.
• Lead DBA in various projects - Team members in different projects across the CMS contract. Worked on a major project which covered 11 products for CMS as a DBA. The challenge was to coordinate and compile all the 11 product deployments.
• The end result being all the 11 product deployments went well.
• Converted single instance database to RAC database for high availability.
• Implemented backup strategy for Microsoft SQL Servers of Confidential corporate contracts.
• Coordinated with System Administrators on SAN environment space requests and reclaims.
• Performed ‘On-Demand’ refreshes of schemas requested by teams from production environment to other environments.
• Performed Disaster recovery testing as per the Confidential corporate standards setup both for Oracle and SQL server databases as part of the monthly routine.
• Coordinated with the security team to resolve all security issues related to the databases on all environments based on their findings which comply the rules set by the Federal Government security standards.
• Implemented version control software (tortoise SVN a third party tool) to maintain versions of the database application code.
• Migrated Windows based Oracle database to Linux version of oracle database.
• Upgraded Oracle databases version 10.2.0.3 running on Sun Solaris platform to 11.2.0.2 for CMS contracts and Oracle databases version 10.2.0.3 running on Linux platforms to 11.2.0.2 version for private contracts.

Confidential, Greensboro, NC

Database Administrator

Responsibilities:

• Supported client databases and provided consulting services to clients who specialize in Distribution, Publication and Financial industries at the client sites.
• Planned, organized, coordinated and implemented database deployments, security, version upgrades, backup & recovery strategies, hardware resources, human resources and routine administration required to support more than 40 Oracle 8i/9i/10g databases.
• Provided technical direction, planning, security, and 24x7 support to application team and end users.
• Installed Oracle RDBMS software, performed Oracle migration, Oracle version upgrade and Oracle critical patch updates (security/vulnerability) on Unix and Windows server.
• Designed, implemented and maintained RMAN backups with Veritas NetBackup (Cold and Hot).
• Created databases on multi operating system environment, Tuned databases queries using STATSPACK, SQL Trace/TKPROF, EXPLAIN PLAN utilities.
• Corrected segment and tablespace level fragmentation.
• Performed tablespace transport.

Confidential, Chicago, IL

Remote Database Administrator

Responsibilities:

• Coordinated and implemented database design, implementation, database deployments, security, backup & recovery strategies as a remote Oracle and SQL Server DBA from Hyderabad, India.

Confidential, Greensboro, NC

Database Administrator

Responsibilities:

• Planned, organized, coordinated and implemented database deployments, security, backup & recovery strategies, and routine administration required to support four Oracle 7.3 databases and 15 SQL Server 7 databases for several clients.