SUMMARY:

• Database Administrator (DBA) with 7+ years of experience in designing, coding, testing and supporting Oracle Applications next - generation database solutions in Oracle enterprise, MS SQL Server, SAP HANA, Sybase ASE and Sybase IQ environments.
• Possesses a Masters in Computer Science and looking to leverage my knowledge and expertise into a role as database administrator.

TECHNICAL SKILLS:

RDBMS:: Oracle Database 10g/11g, SAP HANA, Sybase IQ and Sybase ASE, SQL Server

Operating Systems: Sun Solaris, Red Hat Linux, AIX, HP-UX, Windows 95/98/NT, Windows NT 4.0 Server.

Programming Languages: SQL/ PL/SQL, UNIX Shell Programming, C, Java, HTML, JavaScript, Java Server Pages (JSP).

Development Tools/ GUI: Oracle Enterprise Manager (OEM), SQL*Plus, TOAD for Oracle, Toad for Sybase, SAP HANA Studio and Sybase Control Center, Microsoft Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, Southborough, MA

Database Administrator

Responsiblities:

• 24x7 Production Oracle Database Administration.
• Maintaining production, development & test databases.
• Experience in shell scripting.
• Support Oracle Database systems on HP, AIX, Sun Solaris & Linux Platforms
• Specialized in all aspects of database design and programming with Sybase Adaptive Server Enterprise, Replication server and Sybase IQ Server and Oracle
• Experienced in data analysis of very large databases and data ware houses varying from a few GB to TB.
• Involved in upgrading the oracle production database from 10g to 11g.
• Successfully installed cluster ware for Oracle ASM usage.
• Applied patches on RDBMS to resolve bugs.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Worked on shareplex replication tool.
• Experience in backups and restores using RMAN and Tivoli, EMC and other storage manager, scheduling database jobs using crontab and DBMS SCHEDULER
• Monitor and maintain Oracle Server Health to optimize throughput and minimal resource contention.
• Ensure high customer service
• Implemented various backup and recovery strategies using RMAN
• Experience in setting up Active Data Guard.
• Proficient in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Databases.
• Implemented database refresh with the oracle hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Installed Oracle 10g in the development environment, applied all current patches, migrated copy of production data into development environment, provided documentation of all installation and patch steps.
• Installed Oracle 10.2 in the development environment, applied all current patches, migrated copy of production data into development environment, provided documentation of all installation and patch steps. Performance tuned & setup backup & recovery schemes.
• Applied quarterly CPU patches using opatch utility
• Used cloning and replication procedures, backup and recovery procedures, export/import scripts, data pump scripts, and RMAN scripts.
• Experience in installing, patching and upgrading SAP HANA scale out and scale up, Sybase ASE/IQ databases using command line and Life Cycle Manager
• Experience in performance monitoring of SAP HANA, Sybase IQ and Sybase ASE databases
• Strong knowledge of SAP Basis and Oracle EBS application suite.
• Installing SCS/ASCS, PAS and Dialog instances.
• Experience in installing ABAP and JAVA applications.
• Installed NW 7.4 ABAP and JAVA applications with Sybase ASE databases.
• SAP HANA Data Provisioning and using SAP LT Replication Server ( SLT )
• Enforce security policies and access controls
• Developing SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Experience working on SAP Net viewer 7.4, troubleshooting and using brspace utilities
• Experience in data replication into SAP BIW with SAP LT replication
• Experience in working on SAP HANA database backup and recovery using HANA studio and third party backup tools like EMC Networker, DDBoost etc.
• Expertise with SAP HANA Studio with Modeling and Administration Perspectives
• Experience in SAP HANA security and performance tuning.
• Implemented Sybase ASE and IQ backup and recovery strategies.
• Opened high priority incidents with SAP support and worked with them on issues
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Experience in Data replication using Sybase ASE databases
• Proficient in using Toad for Sybase and Sybase Control Center for administration purposes.
• Experience in Database performance tuning and troubleshooting both at server level and query level.
• Good understanding of SaaS and PaaS clouds.

Confidential, Carbondale, IL

Teaching Assistant / Oracle DBA

• Experienced in Planning, Implementing, Physical and Logical Database Design, Backup and Recovery, Cloning, Refreshing Databases.
• Maintain Oracle server in complex environments such as Solaris Servers.
• Providing support (24*7) and troubleshooting user issues
• Performing daily database operations, maintenance and support
• Administration of databases- Physical and logical structures
• Performed Database Cloning from production to Test, Development instance to test & simulate few technical challenges, coordinate with testing and development teams.
• Expertise in Database Backup strategies & recovery scenarios (Hot and Cold).
• Transferring the bulk data from text file into Oracle Database using SQL * Loader and export & Import utility for backup purpose and distributing the tables in multiple environments.
• Identifying and resolving resource contention issues and monitoring database performance
• Finding the inactive sessions and terminating them for better performance
• Troubleshooting based on Alert logs
• Maintaining of Space requirements on the Table space by adding/re-sizing data files based upon the space available on the file systems and existing volumes
• Creating and Managing Users, Granting, Revoking privileges for the users in order to ensure the Database security

Confidential

Systems Engineer

• Upgraded 9i database to 10g (10.2.0.3) database.
• Maintenance of 10g databases and other non-ERP Databases.
• Cloning DEV and UAT instances from Production for testing.
• Migrated the Production database from Old servers to new servers.
• Implemented maintenance plans, scheduled scripts for concurrent request details, table space growth, archive log monitoring and many other maintenance activities.
• Successfully implemented 2-node RAC setup and made the environment stable.
• Applied the patchsets, one off patches, Opatch to the Development and production servers.
• Monitored databases using 10g OEM grid control.
• Experience in export and import utilities and data pump.
• Experience in working with transportable tablespaces.
• Managed and resolved design issues during development stage. Worked closely with developers.
• Moved database Schema changes to stage or production.
• Developed Oracle backup and recovery strategy and scripts.
• Responsible for Cloning of Database and Applications as per functional requirements.
• Prepared analysis for resolving system errors, disk space problems, and huge file sizes errors.
• Worked with End Users and Functional Analysts on issue resolution (concurrent manager problems, one off patches, etc.)
• Developing UNIX and SQL scripts for the smooth functioning of database and applications related issues.
• Gathered database/Objects statistics using DBMS UTILITY, DBMS STATS packages and analyze command.
• Troubleshooting throughout the project phases and TAR Management.
• Capacity Planning/Management (space/machine load/network).
• Prepare and implement system management and maintenance procedures.