SUMMARY

• Master of Computer Applications, Oracle Certified Professional Database Administrator having expertise in Oracle Database Installation, Administration, Performance Tuning on Linux Servers with 9 Years of experience.
• Experienced in Oracle 12c, 11g, 10g, 9i and SQL Server 2005/2008 Database Administration.
• Experienced in Implementing Database Logical/Physical Design.
• Worked on Various Linux Distributions RHEL, Ubuntu, Suse Linux, Cent OS, Debian etc.
• Proficient in Oracle Software Installation, Managing Database structures, Performance Tuning & capacity monitoring, Data security, RMAN backup and recovery, Standby/Failover administration, SQL tuning, Export/Import & Datapump, Managing ASM instance & files, Database networking, OEM, Grid Control.
• Hands on experience with tools like SQL*Plus, Datapump, ETL, SQL Loader, Dataguard, Statspack/AWR etc.
• Experienced in SQL statement Tuning, Query Optimization and Database performance tuning.
• Experienced in Developing System & Database Health Check Shell Scripts.
• Experienced in preparing Database Servers from scratch, Monitoring logs during transition to production environment while attending bridge calls with client and other stakeholders from different geographic regions, sending up - to-the-point reports to the client and other team members.
• Proficient in Linux Commands & Experienced in Linux Administration (Redhat Servers) with expertise in Troubleshooting & Configuration of Various Servers & Services (DNS, DHCP, RAID, LVM, Apache, NIS, Squid, Sendmail, Postfix, Dovecot, SVN), Network File Sharing (NFS, Samba, FTP), Shell Script.
• Experienced in Implementing and Documenting new and existing processes.
• Proactively monitored and administered production and development database servers for clients like Centre for Medicare and Medicaid Services (CMS), COX communications, Time Warner Cable, Charter communications, Videotron etc.. Involved in Oracle Installation, Troubleshooting Database issues, performance tuning, backup & recovery, Grid Control, Dataguard configuration.
• Good communication, interpersonal, team skills with the ability to grasp new concepts quickly & utilize them in a productive manner.

TECHNICAL SKILLS

Databases: Oracle 12c, 11g, 10g, 9i, SQL Server 2005/2008, Mysql, Postgres

Tools: /Utilities: SQL, Import/Export, Data-pump, RMAN, ETL, SQL LOADER, AWR, Oracle RAC, STATSPACK, iSQL*PLUS, SQL*PLUS, Enterprise Manager Grid Control, Dataguard, ASM, ADDM, lsnrctl, tkprof, SQL trace, Explain plan

Cluster: SQL Server 2005/2008 Clusters, Oracle RAC

Data Modeling: ERWIN

Operating Systems/ System Administration: RHEL, Suse Linux, Ubuntu, Debian, CentOS, Windows 2003/2008Solaris

Backend Scripting: PL/SQL, Unix Shell Script, php

Network and Connectivity: Windows TCP/IP, VPN Connectivity, Oracle Net Manager, Router configuration, iptables, tcpdump

Web Servers: Apache, Tomcat

PROFESSIONAL EXPERIENCE

Confidential, Elkridge MD

Database Administrator

Responsibilities:

• Involved in Setting up different Environments DEV,TEST,QA from scratch for the modernization project. Proactively Organised Database Model Sessions, Created Database Physical Model as per CMS standards using ERWIN Data Modeller tool and Implemented Database Model changes in Database.
• Worked in Agile development environment in the modernization project, guiding development team in successful implementation.
• Involved in Oracle 11g/12c Database/Grid Infrastructure Software Installation over RHEL6/RHEL7, ASM Configuration and Creation of Oracle RAC Databases in DEV, TEST and DEBUG Environments as per CMS Standards/Guidelines. Worked on creation and management of Pluggable and Container Databases, OEM Grid Control Installation & Configuration.
• Involved in Troubleshooting networking issues, database performance issues reported by end users. Worked with different stakeholders to resolve the issues reported.
• SQL Server Database Administration in Production environment - Maintaining Cluster Databases configured in Active/Passive mode, Monitoring, Performance Tuning, Scheduling Database backups, creation of new jobs, Databases, new Database objects, granting permissions to users etc. Performed maintenance tasks for PROD databases during Weekly Maintenance Window.
• Identified gaps in current system policies, Suggested New Backup policies. Implemented new backup policies and monitored backup logs. Coordinated with Security Officer to discuss about best security practices and configure servers in accordance with CMS Security policies. Performed backups to Tapes using CA Arcserve.
• Handled deployment of Development releases in Production - implementation and release of database changes as submitted by the development team.
• Determined the cause of problems both in terms of functionality and performance. Resolved issues by performing root cause analysis.
• Created users, tablespaces, tables, indexes, views, triggers, synonyms and sequences. Managed Users, Roles and privileges in Database to maintain database security, keeping track of all the database changes and storing DDL Scripts in GIT.
• Cloned Database in different environments and performed database refresh.
• Created Database Physical Model as per CMS Standards, maintaining Logical Model using ERWIN Data Modeller. Implemented new changes to database after making modifications to Physical Model. Generated Scripts from ERWIN using complete compare for Database Changes implementation.
• Explaining database physical model to development team for application development. Gathered the application requirements from team members, developed understanding of the application functionality using System Design document & User Guides, organized Database Model Sessions and suggested the solution to the development team.
• Performed Database Monitoring and Performance Tuning. Created indexes to enhance database performance and rebuilding indexes. SQL tuning by using various tools like Oracle Enterprise Manager, TKPROF, Explain Plan, AWR report and by using customized scripts.
• Applied patches to oracle Databases. Worked with Oracle Support to resolve technical issues.
• Performed Database backups using RMAN, Export/Import of the data using datapump. Also performed database recovery using backups as needed.
• Worked on task automation via creating Shell Scripts and PL/SQL.
• Created Database Design Document for the new product. Documented other procedures for team members.
• Involved in creation of SR with oracle support or other vendors and keeping track of the requests.
• Worked on Setting up Solarwinds SAM and NPM from scratch to enable monitoring of all Servers, VMware Hosts, Citrix Servers and applications. Monitored Components and application health using solarwinds. Monitored Database Health using "appinsight for SQL". Proactively plan server capacity to meet future resource requirements.
• Worked on SIEM tool to configure Audit Reports required by CMS.

Environment: Oracle 12c/11g, RMAN, SQL*Plus, SQL, Oracle OEM/Grid Control, Import/Export, Datapump, Dataguard, ASM, Oracle RAC, ERWIN, Cent OS, RHEL7, Apache, ERWIN, SQL Server 2005/2008, CA Arcserve

Confidential, Gaithersburg, MD

Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g databases on CentOS platform.
• Configured Grid Control and OEM for monitoring databases.
• Apply patch set and interim patches whenever required to make the database software up to date and troubleshoot issues.
• Preparing Oracle Database Servers from scratch.
• Performing Backups using RMAN.
• Monitoring Day-to-Day Backup logs to ensure backup reliability.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Installation and configuration of Java applications and Creating Database for those applications.
• Providing Application Support for performance and database related issues. Resolving Connectivity issues or application enhancement issues like SQL statement tuning after changes in Database objects.
• Writing Shell Scripts for Database Servers Health check and Troubleshooting the issues if found any.
• Involvement in day to day activities like Space management - adding datafiles or tablespaces, managing quotas on tablespaces, Creating User accounts, Roles and granting required access permissions and privileges to the database users based on the applications they are accessing.
• Gathering Statistics for database objects or store execution plan for fast execution of SQL statements.
• Performance Tuning for the SQL queries which are Running slow and consuming high resources
• Monitoring AWR reports on regular intervals to ensure high Database performance.
• Document all the new processes to be used by other people in future assignments.

Environment: Oracle 9i, 10g, 11g, RMAN, SQL*Plus, SQL, Oracle OEM/Grid Control, Import/Export, Datapump, Dataguard, ASM, Oracle RAC, Cent OS, RHEL6, Apache

Confidential, Seattle, WA

Oracle DBA

Responsibilities:

• Installation of Servers from scratch. Install RHEL6 and Oracle 10g and 11g software.
• Creation of database using existing scripts.
• Creating tablespaces and assigning quotas.
• Creating and managing users, roles, privileges, profiles. Import data to testing databases.
• Create indexes to enhance database performance and rebuilding indexes.
• Provide support to developers for their queries.
• Writing Shell Scripts to automate tasks like database creation.
• Gathering Statistics for schema objects.
• Monitor Database performance during peak testing periods.

Environment: RHEL6, Oracle 10g, 11g, Datapump, Statspack, Shell Scripting, SQL

Confidential

Sr. Technical Support Engineer

Responsibilities:

• Oracle Database and Linux server Administration in IPTV Domain. Worked for various client projects e.g. Charter communications, Time Warner Cable, Mediacom, COX communications, Navic/ Videotron, Bright House Networks etc.
• Installation of Oracle Software components, Install Java based applications, configure applications, creating listener & tns entries to provide connectivity between oracle database and applications.
• General Administration of Unix/Linux - Installation, Perform problem diagnosis and troubleshooting.
• Maintenance of production & development databases which include tablespace management, user creation, privileges & roles, index organization etc.
• Perform database tuning & performance monitoring, reporting, etc. using tuning and diagnostics tools like Statspack reports, AWR etc
• Run daily maintenance scripts to identify issues with database and perform technical troubleshooting.
• Writing PL/SQL blocks to automate tasks in database or writing shell scripts.
• Support Database backup & Export/Import.
• Standby database configuration with Dataguard.
• Helping Application Developers with their queries related to Oracle Database.
• Monitoring, analyzing, and optimizing system performance, including making recommendations for improving performance.
• EBIF Applications installation & Administration over Linux Platform.
• Tomcat & Apache based VOD (Video on Demand) Monitoring Applications deployment at Linux Servers, Linking applications to Oracle. Worked on ECS application for COX.
• Monitoring of COX ECS Oracle Databases and Troubleshooting issues.
• Supporting Lab Setup of Navic Oracle Databases and providing support to Navic for Database related issues.
• Configuration & Monitoring for Linux EBIF App servers. Command, 2WC, Webdav, CAMR and other components. Proactive Monitoring using tcpdump and logs to analyse the issue and providing solution. Coordinated with stakeholders from different geographic regions to identify, discuss and resolve issues.
• Interactive TV (IPTV) application deployment. Installation of TVworks solution which consists of different component in it, including Admin (Command and DMS),CAMR(The centerline Postgresql Database),AMR(The Geographic region wise Postgresql database), 2Way Conduit (Which manages the communication between Head-End devices and Servers), Etv-Settings-Server(Generate the settings files for the STBs) and Packager(Which converts the JAVA or XML files to EBIF).
• Development of Shell Scripts to perform various tasks.
• Proactive monitoring of Logs to identify issues during transition of servers in production and sending status reports to client and other team members during transition.
• Tomcat & apache Web applications deployment and troubleshooting.

Environment: Oracle 9i, 10g, 11g, Postgres database, RMAN, SQL*Plus, SQL, PL/SQL, Oracle OEM/Grid Control, Import/Export, Cent OS, RHEL6, Tomcat, Apache, EBIF, tcpdump

Confidential

Database & Linux Administrator

Responsibilities:

• Administration of Oracle Database Servers, Mysql servers, Linux Servers, Solaris Backup server.
• Administration of Mysql & Oracle database. Creation of new databases, tables, indexes, users, roles etc as per requirement. Making modifications in existing database objects. Import & Export. Linking database to applications. Performing Database Backup (RMAN and mysqldump).
• Mysql database sync from development server to production servers.
• Writing SQL queries to be used in applications developed by Software developers.
• Monitoring alertSID.log file and other trace files for any errors.
• Configure Standby Database.
• Apache Web Server Administration. Configuration, monitoring, troubleshooting and support of web applications primarily in a Linux/UNIX environment. Maintaining sites with Joomla interface.
• Loading Data into database using import/export.
• Intensive testing on oracle apex 10g.
• Using and maintaining SVN server. Granting access for svn server repositories to users. Creating new repositories.
• Scheduling and Checking Backups. Monitoring of applications and IT systems. Nagios Monitoring and Configuration.
• Production Support, analysis of logs usage patterns and proactive troubleshooting.
• Implement new security policies.
• Configuration of Various Servers & Services (DNS, DHCP, RAID, Apache, LDAP, NIS, Squid, Sendmail, Dovecot, SSH, Yum), Network File Sharing (NFS, Samba, FTP). LDAP Server - Creation of users on domain with samba pdc and ldap authentication.
• Writing scripts and scheduling the same for performing various tasks.
• Implementing Firewall rules using iptables.
• Administration of various applications like Bugzilla, Timesheet, Dot Project, Twiki, Openvpn etc.
• Okapi router configuration and Administration.

Environment: Oracle 9i, 10g apex, mysql, SQL, RHEL5, Suse Linux, Ubuntu, Solaris, Apache, Joomla, LAMP, iptables, VPN, Nagios, Twiki, SVN, php, C++, HTML

Confidential

Oracle DBA

Responsibilities:

• Managing physical and logical structure of database.
• Developing and implementing Backup and Recovery strategies using RMAN.
• Loading data into Database.
• Assess current and future storage requirements.
• Maintain user connectivity.
• Patch installation.
• Security management - users, roles and privileges.
• Managing & Installing Oracle on Linux & Windows Platform.

Environment: Oracle 9i, RHEL5, ETL, SQL Loader, RMAN, lsnrctl

Confidential

Oracle DBA

Responsibilities:

• Installation of Oracle over Linux and Windows platform.
• Providing support for day to day operations related to user management and SQL queries.
• Export/Import of database.
• Controlling User Access to database.
• Provide oracle training.

Environment: Oracle 9i, RHEL5, SQL Loader, SQL