SUMMARY

• 12+ years of Oracle EBS, Oracle, SQL Server and Security DBA experience
• Installed IBM Guardium for DAM (Data Activity Monitoring) and VA (Vulnerability Assessment). Configured S - TAP and collectors for CRM and HR applications.
• Experience in working with different environments/versions and server administration including LINUX, Windows, SOLARIS, AIX, HP-UX, Exadata, Exalogic, Supercluster
• Supported IBM Guardium installations by coordinating with IBM Security team and configured Guardium Central Manager.
• As an Oracle Apps DBA key responsibilities include Patching, Maintenance, Performance Tuning, Refreshing/Cloning and Backup/Recovery of Oracle Database and Application Tiers.
• Responsible for Data center migration planning and defining strategies to minimize downtime
• Experience as Oracle Applications DBA providing support to many Production, Development, Test, CRP instances (Large and VLDB databases) comprising some of the more complex and challenging environments from versions 11.5.2 through R12.
• Good working experience in designing of database in SQL Server 2000/2005/2008. Hands on experience in writing SQL queries, Stored Procedures, Functions and Triggers.
• Good at developing Unix shell and Windows power shell script for automating common DBA tasks.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using STATSPACK, TKPROF, ADDM, AWR, ASH and Explain Plan.
• Reviewing existing architecture diagrams and making suggestions to the proposed architecture
• Worked with application teams to gather requirements and submit build documents to server team.
• Provided capacity planning and storage recommendations.
• Installed and maintained 2 node SQL Server Active/Active failover cluster.
• Worked with data architects and application team leads to understand app dependencies.
• Good knowledge of SSRS and SSIS
• Have programming skills in C#, VB.NET, ASP.NET, ASP, AJAX and Windows Services.
• Administered a portal developed using SharePoint Portal Server 2007/2003. Thorough knowledge of Microsoft Office SharePoint Server 2007 (MOSS) and Windows SharePoint Services (WSS).
• Provided support for ISV’s of Microsoft in SQL Server 2005.
• Familiarity with object-oriented concepts, component based architecture and database systems.
• Complete project life cycle involvement from end-user requirements gathering to production support.
• Worked with offshore team to coordinate migration activities
• Good understanding of CoreID for implementing identity and access management in an organization.

TECHNICAL SKILLS

OS: Windows 7/Vista/XP/2003/2000, RedHat Linux

Databases: SQL Server /2008/2012, Oracle 10G, 11gR2

Programming Languages: C#, VB.NET, Visual Basic 6.0, C, C++, JavaWeb Technologies.NET Framework (4.0/3.5/2.0/1.1/1.0 ), ASP.NET, ASP, ADO.NET, WCF, HTML, XML, XSLT, Java Script, Cascading Style Sheets (CSS), IIS, Silverlight and AJAX.

Frameworks: Silverlight, WCF.

Windows programming: WPF, Windows services

Tools: Visual Studio .NET, InfoPath for creating workflow, Visual Source Safe (VSS), SQL- Server reporting services, Cognos, Subversion (SVN). Rational Team Concert

Portal Technologies: SharePoint Portal Server administration and development. PlumTree portal

Reporting tools: SSRS, Cognos, Crystal reports

Integration tools: Biztalk server, SSIS

PROFESSIONAL EXPERIENCE

Confidential, Duluth, GA

Oracle EBS security DBA

Responsibilities:

• 24x7 Oracle Applications and databases support in Development, Test and Production environments
• Participated in the critical data encryption using transparent data encryption and Oracle data vault.
• Responsible for Installation, Patching, Cloning, Maintenance, and Administration of Oracle Applications and Databases
• Responsible for creating copies of production environment using RAPID CLONE (PATCH, DEV, TEST, SAT, UAT, PROD)
• Upgraded Oracle Applications from 11.5.10.2 to Release 12.1.3 on Solaris 10 and database 11.1.0.7 to 11.2.0.3 and did OATM conversion
• Monitored performance and availability of Oracle Applications through Grid Control & OAM.
• Installed Oracle Application Server 10AS 10.2.0.4, Oracle Demantra 7.2 and configured. Setup war file for configuration between Demantra server and Application server.
• Providing assistance with DBA related activities on Demantra 7.3 project, including but not limited to installation of Demantra 7.3, and applying patches.
• Managed all aspects of the Company Tier 2+ global data center centers.
• Development support including cloning, patching, SQL tuning of customizations and project support
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Monitored Net-backups of applications & databases binaries and automated with Shell scripts and Control-M tool
• Performance tuning of Oracle Database, applications and queries.
• Creating the database, tables, tablespaces, data objects, setting privileges, indexes, user logins, and passwords.
• Created a Real Application Clusters (RAC) environment for E-Business Suite.
• Worked on Workflow, Oracle Application manager (OAM).
• Installed oracle agents and monitored servers, databases and applications on a common grid (OEM).
• Migrated databases from Solaris to Linux using export/import of E-business Applications.
• Implemented SHARED APPL TOP to reduce patching downtime.
• Performed Performance testing and capacity planning for adding additional users and new programs to existing E-business suite database and applications.
• Worked on Exadata with 4 to 6 nodes running on RHEL 6
• Proficient in migrating and cloning of databases on Exadata machines.
• Registered customized applications, created and assigned responsibilities to users, customized menus, attached menus to responsibilities and finally this to users.
• Worked on vertex updates for HRMS and Payroll modules
• Implemented Oracle Data Guard for HA and remote DR site.
• Installed and configured Single-Sign On (SSO) with OID and Implemented SSL Security.
• Monitoring of database for growth and performance.
• Wrote custom PL/SQL packages for DBA related jobs such as purging custom tables, loading data into custom tables etc.
• Provided application support to users and created a log of all the problems with solutions for future reference.
• Documented operational procedures and support tips for Oracle databases and applications

Confidential, Kennesaw, GA

SQL Server DBA

Responsibilities:

• Installed and maintained MS SQL Server 2005/2008 on Windows 2008 Server. Worked on SQL Server 2005 failover clustering which is built on top of a Windows 2008 server cluster.
• Upgraded SQL Server 2005 to SQL 2008 server for high volume processing databases on a clustered environment.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQLServer.
• Designed and developed SSIS packages using different control flow tasks.
• Configuring, tuning and optimizing SQL Server 2005.
• Responsible for Stored Procedures optimization, Performance tuning & index tuning.
• Administrator tasks like managing users, roles and permissions. Extensively worked on Log shipping for synchronization of databases for SQL Server High Availability.
• Implemented new features in SQL Server 2008 like Table Compression, Backup Compression, SQL Server Auditing.
• Performed data partitioning for efficient management of database tables and indexes
• Involved in complete database design including conceptual, logical and physical models.
• Experienced in working with SQL server PowerShell provider.
• Participated in the designing and development of software using agile development practices.
• Providing support for storage operations for EMCDatadomain, Net backup and other storage products. Based on the EMC requirement, updated the drivers (HBA etc.)/patches (Operating System) on all systems involved in the data migration.
• Implemented Tivoli Alerting for the SAN Infrastructure devices to alert the command Center and workedclosely with Tivoli team to create log adapters and carefully planned out the severity levels.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers DatabaseIntegrity Checks, Update Database Statistics and Re-indexing.
• Maintained high availability of databases using Database Mirroring and Log Shipping.

Environment: Windows 2008, MS SQL Server 2005/2008, Perl, UNIX, Power shell, EMC Data domain, SAN, Oracle 9i, T-SQL, Visual Studio, SQL Loader, IIS, Red Gate, MS Access, DTS, SSIS, SSAS, SSRS, SQL Profiler

Confidential, Kennesaw, GA

SQL Server DBA and SharePoint 2003/2007 Administrator

Responsibilities:

• Installation and configuration of SQLServer 2003 on Window Server.
• Managed database objects like Tables, views, stored procedures, indexes etc.
• Written stored procedures and functions according to business requirements.
• Implemented Backups and restoring when necessary.
• Creation and management of Database maintenance plan for various database consistency checks.
• Extensively working on performance issues like update statistics, Auto Stats.
• Creating monthly transaction report for all sections.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Involved in planning, designing, configuring and implementing SAN fabric.
• Worked on monitoring and tuning of SQL scripts. Created scripts for production database and supported it.
• Managing of users including creation/alteration, grant of system/db.Roles and permission on various database objects.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Used third party tool Red Gate to speed up backup operations.
• Created and maintained logical/physical data structures.
• Created views and stored procedures as required by front-end developers for easierimplementation on web pages.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation and data extraction.
• Used functions to create predefined conditions and prompts to filter the data and dynamic user selection.
• Involved in creating Cubes using SQL Server Analysis Services.